php table表格一行的数据如何修改

<?php

// 连接数据库

$conn = mysqli_connect(localhost, root, password, database);

// 查询需要修改的数据

$sql = “SELECT * FROM `users` WHERE `id` = 1”;

$result = mysqli_query($conn, $sql);

// 遍历结果集，并获取需要修改的数据

while ($row = mysqli_fetch_assoc($result)) {

$name = $row[name];

$email = $row[email];

// 对需要修改的数据进行修改

$name = New Name;

$email = newemail@example.com;

// 执行 SQL 语句来保存修改后的数据

$sql = “UPDATE `users` SET `name` = $name, `email` = $email WHERE `id` = 1”;

mysqli_query($conn, $sql);

}

// 关闭数据库连接

mysqli_close($conn);

?>