javascript - 无法从表内的按钮获取行 ID

Question

嘿，我有以下代码:

<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>

现在，如果我想编辑或删除任何数据并触发查询，那么我应该怎么做才能执行该任务。我尝试使用 Js 使用 onclick 事件和调用函数，但我不知道如何获取 id。

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

Answer 1

您可以这样更改您的代码:

<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>

或通过 javascript 作为:

<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>