wanted to make my users able to delete an mysql row

Question

I changed the = to =>. Unfortunately I get another error message:

Warning: Invalid argument supplied for foreach() in /home/a9083956/public_html/zundappgroesbeek/beheer/testretrievesql.html on line 31

I am getting a php error message. What am i doing wrong?

Parse error: syntax error, unexpected '=', expecting ')' in /home/a9083956/public_html/zundappgroesbeek/beheer/testretrievesql.html on line 31

My html looks like this:

<html>
    <head>
    <title>Retrieve data from database </title>
    </head>
    <body>

    <?php
    // Connect to database server
    mysql_connect("mysql7.000webhost.com", "a9083956_test", "sesam") or die (mysql_error ());

    // Select database
    mysql_select_db("a9083956_test") or die(mysql_error());

    // SQL query
    $strSQL = "SELECT * FROM forum_question";

    // Execute the query (the recordset $rs contains the result)
    $rs = mysql_query($strSQL);

    // Loop the recordset $rs
    // Each row will be made into an array ($row) using mysql_fetch_array
    while($row = mysql_fetch_array($rs)) {

       // Write the value of the column FirstName (which is now in the array $row)
          echo '<input name="delete['.$row['id'].']" type="checkbox">';
      echo $row['topic']. " " .$row['name']. " " .$row['datetime'] . "<br />";
      }

$delete = $_POST['delete'];

foreach($delete as $id = $value)
{
    $id = mysql_real_escape_string($id);
    mysql_query("DELETE FROM table_name WHERE id = $id");
}

// Close the database connection
mysql_close();
?>
</body>
</html>

possible duplicate of [How to delete rows from a mysql database using php with a form delete button](http://stackoverflow.com/questions/23425147/how-to-delete-rows-from-a-mysql-database-using-php-with-a-form-delete-button) — Unihedron, Oct 25 '14 at 07:35

score 0 · Answer 1 · edited May 23 '17 at 11:49

0

Your issue lies in the foreach loop, where you have $id = $value. I suspect you mean:

foreach($delete as $id => $value)
{
    $id = mysql_real_escape_string($id);
    mysql_query("DELETE FROM table_name WHERE id = $id");
}

Note the changing of = to =>.

For more about the => operator, view the related post here.

edited May 23 '17 at 11:49

Community

1
1

answered Apr 10 '14 at 21:04

Aaron St. Clair

183
1
2
10

Thanks alot i changed it but now i got another error message.Warning: Invalid argument supplied for foreach() in /home/a9083956/public_html/zundappgroesbeek/beheer/testretrievesql.html on line 31 – M Lanser Apr 11 '14 at 09:50

wanted to make my users able to delete an mysql row

1 Answers1