我如何添加数据到一个表单元格使用AJAX, MySQL和PHP在以下情况下: - How do I add data to a table cell using AJAX, MySQL and PHP under the following circumstances:

How do I add data to a table cell using AJAX, MySQL and PHP under the following circumstances:

在一个有两列的html表中，第一列是由php和mysql填充的。我需要使第一列值链接，当单击使AJAX调用填充从MySQL获得的值相邻的单元格。我已经能够使用以下命令获得第一列值:

<html>
<?php 
$db_host = "localhost"; 
$db_name = "db";        
$db_user = "user";
$db_word = "password";

$connect=mysqli_connect($db_host, $db_user, $db_word, $db_name);
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$result = mysqli_query($connect,"SELECT people FROM users");

echo "<table border='1'>
<tr>
<th>People</th>
<th>Ages</th>
</tr>";
while($row = mysqli_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['people'] . "</a></td>";
echo "<td></td>";
echo "</tr>";
}
echo "</table>";
mysqli_close($connect);
?>
</html>

我需要使第一个列值成为使用AJAX单击时从MySQL检索年龄值的链接。有什么建议吗?

修改初始SQL查询:

$result = mysqli_query($connect,"SELECT people, SOME_UNIQUE_ID FROM users");

…

添加唯一的id到你的html表行:

echo "<td id = '". $row['SOME_UNIQUE_ID'] . "'>" . $row['people'] . "</td>";

…

添加jQuery监听器:

 <script>
    $('body').on('click', 'td', function() {
     var myID = $(this).attr('id');
     $.ajax(
       data: myID 
       foo: write your own ajax,
       bar:....
    })
  </script>