php - Delete button for each mysql result -
i beginner in php. trying create password manager using php , mysql. having trouble @ point:
<?php require 'dbconnect.php'; $sql = "select * pmanager"; $result = mysql_query($sql,$con); if (!$result) die ("database access failed: " . mysql_error()); $rows = mysql_num_rows($result); //views results existing rows ($j = 0 ; $j < $rows ; ++$j) { echo 'account: ' . mysql_result($result,$j,'account') . '<br />'; echo 'e-mail: ' . mysql_result($result,$j,'email') . '<br />'; echo 'username: ' . mysql_result($result,$j,'uname') . '<br />'; echo 'password: ' . mysql_result($result,$j,'pword') . '<br />'; ?> <form method="post"> <input type="hidden" name="id" value="<?php echo mysql_result($result, $j, 'id'); ?> " /><input type="submit" name="del" value="delete" /> </form> <?php } if(isset($_post['del'])) { $sql1 = "delete pmanager id = " . $_post['id']; if(mysql_query($sql1,$con)) { echo 'deleted'; } else echo 'error: '.mysql_error(); } mysql_close($con); ?>
suppose there 2 rows in table "pmanager" containing 2 account (e.g. fb, twitter). , after executing code there delete button each of accounts. can button click event desired account can deleted?
this first question in stackoverflow :)
in rudimentary forms can create hidden field in mini form record id. can capture id delete script , execute code delete record.
<form method="post"> <input type="hidden" name="id" value="<?php echo mysql_result($result, $j, 'id'); ?> " /><input type="submit" name="del" value="delete" /> </form>
Comments
Post a Comment