Deleting and editing a row

[phprooky]

Hi everyone,
I have a page where I bring multiple rows from my database, but I would like to add 2 options on the right of each row. This options are: Delete and the other one is Edit. So when I click on delete only that row should be deleted or if I click on edit it should open a page bringing all the information of that registry so the user can make any changes.
Can anyone please help me?
This is my code:

session_start();

if (isset($_SESSION['myusername'])) 
{ 
   echo ""; 
} else { 
     header("location:main_login.php"); 
     exit(); 
}

require('connectar_bd.php');

$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);

// Count table rows 
$count=mysql_num_rows($result);

<table width="500" border="0" cellspacing="1" cellpadding="0">
<form name="form1" method="post" action="<?PHP $_SERVER['PHP_SELF']?>">
<tr> 
<td>
<table width="500" border="0" cellspacing="1" cellpadding="0">


<tr>
<td align="center"><strong>Id</strong></td>
<td align="center"><strong>Title</strong></td>
<td align="center"><strong>Author</strong></td>
<td align="center"><strong>Post</strong></td>
<td align="center"><strong>Schedule</strong></td>
</tr>

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

<tr>
<td align="center"><? $id[]=$rows['id']; ?><? echo $rows['id']; ?></td>
<td align="center"><input name="tittle[]" type="text" 
id="name" value="<? echo $rows['tittle']; ?>"></td>
<td align="center"><input name="author[]" type="text" 
id="lastname" value="<? echo $rows['author']; ?>"></td>
<td align="center"><input name="post[]" type="text" 
id="email" value="<? echo $rows['post']; ?>"></td>
<td align="center"><input name="date[]" type="text" 
id="email" value="<? echo $rows['date']; ?>"></td>
</tr>

}

<tr>
<td colspan="4" align="center"><input type="submit" name="Submit" value="Submit"></td>
</tr>
</table>
</td>
</tr>
</form>
</table>

if($Submit){
for($i=0;$i<$count;$i++){
$sql1="UPDATE $tbl_name SET tittle='$tittle[$i]', author='$author[$i]', post='$post[$i]' 
WHERE id='$id[$i]'";
$result1=mysql_query($sql1);
}
}

if($result1){
header("location:prueba1.php");
}
mysql_close();

[bradgrafelman]

Just add edit/delete links and put the ID number in the link for each row. Then you'd have a PHP script that uses the ID passed in the URL to display an edit form or delete the row, depending upon which link the user clicked on.

[djjjozsi]

You have to make indexes into your textfields, like:

email[X] where X is the primary key's value from the recods.

You can add checkboxes with array names ( delete[X] ) to make delete array on your process page.

[the_lynx123]

try to include the following code inside of your loop (when you read from the database):

while($rows=mysql_fetch_array($result)){ 
  echo "<tr>";
  echo "<td align='center'>" . $rows['id'] . "</td>";
  echo "<td align='center'>" . $rows['tittle'] . "</td>";
  echo "<td align='center'>" . $rows['author'] . "</td>";
  echo "<td align='center'>" . $rows['post'] . "</td>";
  echo "<td align='center'>" . $rows['date'] . "</td>";
  echo "<td align='center'><a href='" . $_SERVER['PHP_SELF'] . "?mode=edit&id=" . $rows['id'] . "'> [EDIT] </a></td>"; //you can use another page in href, here i am calling the same page. Receive 'mode' and 'id' using $_REQUEST.
//the same idea for deleting:
  echo "<td align='center'><a href='" . $_SERVER['PHP_SELF'] . "?mode=delete&id=" . $rows['id'] . "'> [DELETE] </a></td>";//
/*
in your target page do: 
id($_REQUEST['mode'] == 'delete'){
    $id = $_REQUEST['id'];
     $execute = mysql_query("DELETE FROM (your table) WHERE id='$id'");//do some validation to make sure ID is not empty,display feedback etc etc, you get the idea
}

*/
  echo "</tr>";

}

[phprooky]

Thanks for replying the_lynx123,
Is it possible to make the delete using the same page without calling a target page and only use a target page to edit a registry?

[the_lynx123]

In the code I posted I am calling the same page for both edit and delete.

   

href='" . $_SERVER['PHP_SELF'] . ' "; //etc 

$SERVER['PHP_SELF'] will make <a> take you to the same page. The IF statement in the comment block in my previous post would go before you 'echo' anything though, I would say after the <body> tag (and obviously after getting your $REQUEST's)

[phprooky]

Hi the_lynx123,
I will make the changes and let you know if is working or not.
Thanks for following my case.
Talk to you later!

[phprooky]

Hi the_lynx123,
I already try the code you sent me and is bringing the information from the database and I can also see the options delete and edit, but I used the delete code you addded in the same php page to see if I can delete directly from the same page without using a target page, but it didn't work. Is deleting all the registries and not the one I'm choosing.
This is what I did:

$id = $rows['id'];
$execute = mysql_query("DELETE FROM $tbl_name WHERE id='$id'");

[djjjozsi]

You can see a little video explanation in about this Delete issue:
Here