Can't Fetch row Id from button inside table

Question

Hey I have following code:

<tbody>
  <?php 
  $connection = mysql_connect("localhost", "root", "") or die("Could Not Connect to DB: ".mysql_error());
  $db = mysql_select_db("DBNAME", $connection) or die("Could Not Connect to DB: ".mysql_error());
  $result = mysql_query("SELECT * FROM product");
  while($row = mysql_fetch_row($result))
  {                          
   echo "<tr class='odd gradeX'>
      <td>{$row[0]}</td>
      <td>{$row[1]}</td>
      <td>{$row[2]}</td>
      <td>{$row[3]} x {$row[4]} x {$row[5]}</td>
      <td>{$row[6]}</td>
      <td>{$row[7]}</td>
      <td>{$row[8]} Rs.</td>
      <td><a href='' onclick=''>Edit</a></td>
      <td><a href='' onclick=''>Delete</a></td>
  </tr>";
  }
  ?>
</tbody>

Now if I want to edit or delete any data and fire query then what should I do to perform that task. I tried using Js using onclick event and calling function but I don't know how to fetch id.

{row[0]} is the ID of table product.

Ketan Solanki · Accepted Answer · 2016-02-10 10:56:11Z

1

You Can change your code like this:

<tbody>
        <?php 
            $connection = mysql_connect("localhost", "root", "") or die("Could Not Connect to DB: ".mysql_error());
            $db = mysql_select_db("DBNAME", $connection) or die("Could Not Connect to DB: ".mysql_error());
            $result = mysql_query("SELECT * FROM product");
            while($row = mysql_fetch_row($result))
            {                          
                echo "<tr class='odd gradeX'>
                <td>{$row[0]}</td>
                <td>{$row[1]}</td>
                <td>{$row[2]}</td>
                <td>{$row[3]} x {$row[4]} x {$row[5]}</td>
                <td>{$row[6]}</td>
                <td>{$row[7]}</td>
                <td>{$row[8]} Rs.</td>
                <td><a href='edit.php?id={$row[0]}'>Edit</a></td>
                <td><a href='delete.php?id={$row[0]}'>Delete</a></td>
                </tr>";
            }
        ?>
    </tbody>

OR Through javascript as :

<tbody>
    <?php 
        $connection = mysql_connect("localhost", "root", "") or die("Could Not Connect to DB: ".mysql_error());
        $db = mysql_select_db("DBNAME", $connection) or die("Could Not Connect to DB: ".mysql_error());
        $result = mysql_query("SELECT * FROM product");
        while($row = mysql_fetch_row($result))
        {                          
            echo "<tr class='odd gradeX'>
            <td>{$row[0]}</td>
            <td>{$row[1]}</td>
            <td>{$row[2]}</td>
            <td>{$row[3]} x {$row[4]} x {$row[5]}</td>
            <td>{$row[6]}</td>
            <td>{$row[7]}</td>
            <td>{$row[8]} Rs.</td>
            <td><a href='#' OnClick='FunctionEdit({$row[0]})'>Edit</a></td>
            <td><a href='#' OnClick='FunctionDelete({$row[0]})' >Delete</a></td>
            </tr>";
        }
    ?>
</tbody>

answered Feb 10, 2016 at 10:56

Ketan Solanki

2911 silver badge6 bronze badges

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

2 Comments

user5214864 Over a year ago

If i am passing to edit.php or delete.php how to catch that id we are passing with it

Nana Partykar Over a year ago

$ID = $_GET['id']; @Jay

Nikunj · Accepted Answer · 2016-02-10 11:02:13Z

<tbody>
  <?php 
  $connection = mysql_connect("localhost", "root", "") or die("Could Not Connect to DB: ".mysql_error());
  $db = mysql_select_db("DBNAME", $connection) or die("Could Not Connect to DB: ".mysql_error());
  $result = mysql_query("SELECT * FROM product");
  while($row = mysql_fetch_row($result))
  {?>                       
     <tr class='odd gradeX'>
        <td><?=$row[0]?></td>
        <td><?=$row[1]?></td>
        <td><?=$row[2]?></td>
        <td><?php $t = $row[3] x $row[4] x $row[5];?><?=$t?></td>
        <td><?=$row[6]?></td>
        <td><?=$row[7]?></td>
        <td><?=$row[8]?> Rs.</td>
        <td><a href='' onclick='functionEdit'>Edit</a></td>
        <td><a href='' onclick='functionDelete'>Delete</a></td>
    </tr>
        <?php }?>
</tbody>

Gomzy · Accepted Answer · 2016-02-10 11:08:27Z

0

add this to your code

        <td><a href='edit.php?id={$row[0]}'>Edit</a></td>
        <td><a href='delete.php?id={$row[0]}'>Delete</a></td>

answered Feb 10, 2016 at 11:08

Gomzy

4314 silver badges14 bronze badges

Collectives™ on Stack Overflow

Can't Fetch row Id from button inside table

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related