Delete or Edit a row

[phprooky]

Hi everyone,
I have the following table where I bring many rows from mySql database and when I press the edit buttom I would like to open a new page where I can bring all the values of that row to edit and then save it. Also I want to delete the row I choose as well. Is that possible in PHP?

require("connect_db.php");

$sql="Select * from $tbl_name";
$result=mysql_query($sql);

$count=mysql_num_rows($result);

<form action="<?Php $_SERVER['PHP_SELF'] ?>" method="post" name="form1">
<table width="584" border="1">
<tr>
<td width="39">&nbsp;</td>
<td colspan="4">&nbsp;</td>
</tr>
<tr>
<td><div align="center">#</div></td>
<td width="41"><div align="center">Id</div></td>
<td width="192"><div align="center">Date</div></td>
<td width="149"><div align="center">Title</div></td>
<td width="129"><div align="center">Author</div></td>
</tr>

while($rows=mysql_fetch_array($result)){

<tr>
<td align="center"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="[code=php]echo $rows['id'];

"></td>
<td align="center"><div align="left">

echo $rows['id'];

</div></td>
<td align="center"><div align="left">

echo $rows['date'];

</div></td>
<td align="center"><div align="left">

echo $rows['tittle'];

</div></td>
<td align="center"><div align="left">

echo $rows['author'];

</div></td>
</tr>

}

<tr>
<td colspan="2"><div align="right">Delete:</div></td>
<td><label>
<input type="submit" name="delete" id="delete" value="Delete Line" />
</label></td>
<td><div align="right">Edit</div></td>
<td><label>
<input type="submit" name="edit" id="edit" value="Edit Line" />
</label></td>
</tr>
</table>
</form>[/code]

[jeepin81]

use the id to associate what row you want to delete/update

ie:

$id = $_POST['ID'];

"DELETE * FROM your.table WHERE ID = '".$id."'";


//or

"UPDATE your.table  SET row1 = '".$row1."' , row2 = '".$row2."' WHERE ID = '".$id."'";

[HalfaBee]

Is that possible in PHP
?

Yes.

I suppose the question you are asking is HOW. 🙂

You need to test for the submit button being pressed ( before the previous code ) and do the correct action.

[phprooky]

Yes, you are right HalfaBee, sorry for that.
Ok, I have the delete option working fine, but how can I make the update part? Because right now I'm only showing each row of my database with a check option and 2 buttoms to allow the user to delete or update the choosen row, but when that user check the row and click to update, how can I open a form where I'm going to make the changes and update the database?

[HalfaBee]

You need to setup a form with box's populated from the data for the id selected.

One row for example
<input name='author' value = '<?php echo $rows['author']?>' >