Deleting a row from a table in a database

netpants · December 18, 2006

I have a display from a database, I want to add another column at the end that has a link called delete, when they click on delete it will just delete that row from the database. How can I do this. Here is my code.

[code]mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM Winners";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

?>

<table border="0" cellspacing="2" cellpadding="2">
<tr>
<th><a href="<? $orderby = 'id' ?>">ID</a></th>
<th>Date</th>
<th><a href="<? $orderby = 'name' ?>">Name</a></th>
<th>Birthday</th>
<th>Phone</th>
<th>Street Number</th>
<th>Street Name</th>
<th>City</th>
<th>State</th>
<th>Zip</th>
<th>Prize</th>
</tr>

<?
$i=0;
while ($i < $num) {
$id=mysql_result($result,$i,"id");
$date=mysql_result($result,$i,"loggedDate");
$first=mysql_result($result,$i,"firstName");
$last=mysql_result($result,$i,"lastName");
$birth=mysql_result($result,$i,"birth");
$phone=mysql_result($result,$i,"phone");
$streetnumber=mysql_result($result,$i,"streetNumber");
$streetname=mysql_result($result,$i,"streetName");
$city=mysql_result($result,$i,"city");
$state=mysql_result($result,$i,"state");
$zip=mysql_result($result,$i,"zip");
$prize=mysql_result($result,$i,"prize");
?>

<tr>
<td bgcolor="#333333"><? echo "$id"; ?></td>
<td bgcolor="#202020"><? echo "$date"; ?></td>
<td bgcolor="#333333"><? echo "$first $last"; ?></td>
<td bgcolor="#202020"><? echo "$birth"; ?></td>
<td bgcolor="#333333"><? echo "$phone"; ?></td>
<td bgcolor="#202020"><? echo "$streetnumber"; ?></td>
<td bgcolor="#333333"><? echo "$streetname"; ?></td>
<td bgcolor="#202020"><? echo "$city"; ?></td>
<td bgcolor="#333333"><? echo "$state"; ?></td>
<td bgcolor="#202020"><? echo "$zip"; ?></td>
<td bgcolor="#333333"><? echo "$prize"; ?></td>
</tr>
<?
++$i;
}
echo "</table>";

?>
</td>
</tr>
</table>


</body>

</html>

</html>[/code]

Here is what it looks like http://www.freegamespot.net/dancefactory/display.php

Thank you

craygo · December 18, 2006

You would have to make your output in a form then add a checkbox at the end and put a delete button in.

netpants · December 18, 2006

Thanks, but I am a noob with php and dont quite understand what your talking about.

netpants · December 18, 2006

Well I understand, but why am I having to put this output into a form? Can I just put a place to say delete ID 1 or whatever?

craygo · December 18, 2006

Yes you can just make it a link to the delete page with the id in the url.

Ray

netpants · December 18, 2006

Can you show me an example?

craygo · December 18, 2006

Continue this area like so
[code]<tr>
<th><a href="<? $orderby = 'id' ?>">ID</a></th>
<th>Date</th>
<th><a href="<? $orderby = 'name' ?>">Name</a></th>
<th>Birthday</th>
<th>Phone</th>
<th>Street Number</th>
<th>Street Name</th>
<th>City</th>
<th>State</th>
<th>Zip</th>
<th>Prize</th>
<th>DELETE??</th>
</tr>[/code]

And this area here
[code]<tr>
<td bgcolor="#333333"><? echo "$id"; ?></td>
<td bgcolor="#202020"><? echo "$date"; ?></td>
<td bgcolor="#333333"><? echo "$first $last"; ?></td>
<td bgcolor="#202020"><? echo "$birth"; ?></td>
<td bgcolor="#333333"><? echo "$phone"; ?></td>
<td bgcolor="#202020"><? echo "$streetnumber"; ?></td>
<td bgcolor="#333333"><? echo "$streetname"; ?></td>
<td bgcolor="#202020"><? echo "$city"; ?></td>
<td bgcolor="#333333"><? echo "$state"; ?></td>
<td bgcolor="#202020"><? echo "$zip"; ?></td>
<td bgcolor="#333333"><? echo "$prize"; ?></td>
<td bgcolor="#333333"><a href="delete.php?id=<?=$id?>"<? echo "$prize"; ?></a></td>
</tr>[/code]

Now the link will go to a page called delete.php and you can run your query there
[code]<?php
$id = $_GET['id'];
$sql = DELETE FROM Winners WHERE id = '$id'";
$res = mysql_query($sql);
if(!$res){
echo "Could not delete record SQL: ".$sql." ERROR: ".$mysql_error();
} else {
echo "Row $id deleted";
}
?>[/code]

Ray

Sign In

Deleting a row from a table in a database

Recommended Posts

netpants

Link to comment

Share on other sites

craygo

Link to comment

Share on other sites

netpants

Link to comment

Share on other sites

netpants

Link to comment

Share on other sites

craygo

Link to comment

Share on other sites

netpants

Link to comment

Share on other sites

craygo

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information