如何使用过程php从mysql获取user_id？

Question

我是一名android/java开发人员，我正在与php进行斗争。我已经在DB中插入了一个新用户，现在我想获得他们的ID。

我该怎么处理结果？我想把它赋值给一个变量。

$query = "SELECT user_id FROM users WHERE user_email = '" . $user_email . "'";
$result = 

PS:我使用mysql，而不是mysqli。

编辑:以下是我所做的工作：

$query = "SELECT user_id FROM users WHERE user_email = '" . $user_email ."';";
$store_info = mysql_fetch_array(mysql_query($query)); 
$user_id = $store_info['user_id'];
$response["message"] = "User created with id: " . $user_id;
echo json_encode($response);

以及在数据库中插入(成功)用户后的错误消息：

null{"success":3,"message":"User created with id: "}

Answer 1

我假设您正在使用MySQLi API。

$query = "SELECT user_id FROM users WHERE user_email = '$user_email'"; //Your Query

$store_info = mysqli_fetch_array(mysqli_query($connection, $query)); 
//Execute the query, fetch the result, it's just one result so no need for a while loop

echo $store_info['user_id']; //echo id

根据评论，您请求了一个mysql_()版本，所以您可以.

$query = "SELECT user_id FROM users WHERE user_email = '$user_email'"; //Your Query

$store_info = mysql_fetch_array(mysql_query($query)); 
//Execute the query, fetch the result, it's just one result so no need for a while loop

echo $store_info['user_id']; //echo id

仍然可以考虑使用mysqli_()或PDO代替。为什么？因为现在不推荐mysql_()，所以请阅读文档页上的红色框，上面写着.

​

​

参考这答案以获得PDO教程

Answer 2

以下是PDO变体：

<?php
//credentials
$host = 'localhost';
$user = "user";
$password = '';
$db_name = 'test';
$port = 3306;

//connection to the database
try
{
    $connection = new PDO("mysql:host=$host;port=$port;dbname=$db_name", $user, $password);
    $connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch (PDOException $e)
{
    echo 'Connection failed: ' . $e->getMessage();
}

//prepare and execute SELECT statement
$sth = $connection->prepare("SELECT user_id FROM users WHERE user_email = :email");
$sth->execute(array(':email' => $user_email));

$record = $sth->fetch(PDO::FETCH_ASSOC);
print $record["user_id"];

Answer 3

如果使用mysql (但不应该使用mysql，则不推荐它)：

$result = mysql_query("SELECT user_id FROM users WHERE user_email = '$user_email'");
$row = mysql_fetch_row($result);

echo $row[0]; // you result (id)