StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POPHP won't delete from MySQL
text
Body
copied!<p>The PHP code won't delete item from database using "$noteid". If I put a number in it's place it will, but when I try using "$noteid". It won't do it. It does everything correct up to the point where it tries to delete.</p> <p>Here's how I get the "$noteid":</p> <pre><code>//javascript function viewnote(noteid) { window.location = "noteview.php?noteid=" + noteid; } //button in body <input type="button" value="Edit" onclick="editnote('<?= $noteid ?>')" /> </code></pre> <p>Here's the code on the linked to page:</p> <pre><code><?php $noteid = $_REQUEST['noteid']; if (isset($_POST['delete'])){ mysql_query("DELETE FROM notes WHERE noteid='$noteid'"); header ('Location: index2.php'); } ?> <body> <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>" style="margin:0px; pading:0px"><input type="submit" name="delete" value="Delete"></form> </body> </code></pre> <hr> <p>** It's Working Now!!! ** What made it work was a hidden form field.</p> <p>Here's the code:</p> <pre><code><?php if (isset($_POST['delete'])){ $nid = $_REQUEST['notenum']; mysql_query("DELETE FROM notes WHERE noteid='$nid'"); header ('Location: index2.php'); } ?> //body cody <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>" style="margin:0px; pading:0px"><input type="text" name="notenum" value="<?php echo $noteid; ?>" style="display:none" /><input type="submit" name="delete" value="Delete"></form> </code></pre> <p>Thanks to everyone for your help!!! This site is my favourite site now.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload