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

Popular posts from this blog

php - Calling a template part from a post -

Firefox SVG shape not printing when it has stroke -

How to mention the localhost in android -