Adding delete button for rows on html table in php

Question

I am trying to make it such that there is a delete button that can be pressed and it deletes the column where you pushed the delete button. I have done extensive research and I can't seem to figure it out.

Here is the PHP and HTML:

<?php


$username="xxx";
$password="xxx";
$database="xxx";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");


$query="SELECT * FROM reservation__date ORDER BY reservation_date DESC";
$result = mysql_query ($query) or die(mysql_error());

$num=mysql_numrows($result);
mysql_close();
?>
            <table width="700" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC" id="myTable" class="tablesorter">
  <thead> 
        <tr valign="bottom" bgcolor="#000000">
          <th width="128"><span class="style1b"><strong>Reservation&nbsp;ID</strong></span></th>
          <th width="829" bgcolor="#2E64FE"><span class="style1b"><strong>Reservation&nbsp;Date</strong></span></th>
          <th width="829"><span class="style1b"></span></th>
          <!--  <th width="90"><span class="style1b"><strong>Agent/client</strong></span></th>-->
          </tr>
        </thead> 
<?php

$i=0;
while ($i < $num) {

$f1=mysql_result($result,$i,"reservation_id");
$f2=mysql_result($result,$i,"reservation_date");
?>

What exactly do you want to do? Delete a row or a column (you mentioned both)? Do you want it only to appear from the output table or do you want to delete it from the database as well? — Butt4cak3
– Butt4cak3, Commented Aug 16, 2013 at 11:54

score 5 · Accepted Answer · 2013-08-16 12:08:16Z

5

<?php    
$i=0;
while ($i < $num) {
    $f1=mysql_result($result,$i,"reservation_id");
    $f2=mysql_result($result,$i,"reservation_date");
?>
   <tr>
     <td><?echo $f1; ?></td>
     <td><?echo $f2; ?></td>
     <td><a href='delete.php?id=<?php echo $f1; ?>'>del</a></td>
   </tr>
<? } ?>

in delete.php

$username="xxx";
$password="xxx";
$database="xxx";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query = "delete from reservation__date where reservation_id=$_GET[id]";
$rs = mysql_query ($query);
if($rs){
  header('Location: yourfile.php');
}

edited Aug 16, 2013 at 12:08

answered Aug 16, 2013 at 11:55

user2393867

Sign up to request clarification or add additional context in comments.

Comments

Rohitashv Singhal · Accepted Answer · 2013-08-16 11:47:49Z

0

You can call a JS function with that you can pass the unique id. And with the help of this id and the basic use of Ajax, you can perform the delete operation .

answered Aug 16, 2013 at 11:47

Rohitashv Singhal

4,56713 gold badges63 silver badges107 bronze badges

Comments

Rohitashv Singhal · Accepted Answer · 2013-08-16 11:52:25Z

0

while ($i < $num) {

$f1=mysql_result($result,$i,"reservation_id");
$f2=mysql_result($result,$i,"reservation_date");

echo  "<a href='#' onclick ='delete($f1);'>Delete</a>";
?>

and You can get this id with script function

<script>
function delete(id){
//Now you can delete the data related to this id form the database using Ajax
}
</script>

answered Aug 16, 2013 at 11:52

Rohitashv Singhal

4,56713 gold badges63 silver badges107 bronze badges

2 Comments

Andrew Rayner Over a year ago

Having issues as where to put echo "<a href='#' onclick ='delete($f1);'>Delete</a>";

Rohitashv Singhal Over a year ago

What issue you are getting with a tag ?

Collectives™ on Stack Overflow

Adding delete button for rows on html table in php

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related