是否可以从表中提取最高ID(在这种情况下为9),并将其作为变量$Max返回,以后我可以使用它作为整数吗?
试试这个,一定会有用的。
$sql = "SELECT id FROM some_table ORDER BY id DESC LIMIT 1"; $result = $conn->query($sql); $id = 0; if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { $id = $row["id"]; } } echo $id;
您可以尝试使用以下代码段:
$sql = "SELECT * FROM some_table where id = (select max(id) from some_table)"; $result = $conn->query($sql); if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { echo "id = " . $row["id"]; } }
$sql = "SELECT id FROM some_table ORDER BY id DESC LIMIT 1"; $result = $conn->query($sql); if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { echo "id = " . $row["id"]; } }
你可以用 MAX() 功能。可以找到文档 here
MAX()