我正在向成员表中插入数据,插入数据后,我想获得刚刚插入的信息的userID。做这件事最好的方法是什么?
我的php代码
//Insert info into database
$sql = "INSERT INTO members (type, firstname, lastname, email, password, bio) VALUES ('$usertype', '$firstname', '$lastname', '$emailsighup', '$passwordsighnup', '$bio')";
//Run a query to check if data has been inserted correctly.
$records = mysqli_query($connect, $sql);
我确实尝试过这个SQL,但出现错误
$sql = "INSERT INTO members (type, firstname, lastname, email, password, bio) VALUES ('$usertype', '$firstname', '$lastname', '$emailsighup', '$passwordsighnup', '$bio')"; SELECT SCOPE_IDENTITY(userID);
假设$connect
是保存连接信息的变量,这似乎是合法的,您可以使用获得最后一个id的值
$user_id = mysqli_insert_id($connect);
这是您可以从PHPMySQLi接口完成的事情,而不是直接从SQL!