php变量中的mysql查询结果 [英] mysql query result in php variable

问题描述

有没有办法将mysql结果存储在php变量中?谢谢

Is there any way to store mysql result in php variable? thanks

$query = "SELECT username,userid FROM user WHERE username = 'admin' ";
$result=$conn->query($query);

然后我想从查询中打印选定的用户 ID.

then I want to print selected userid from query.

推荐答案

当然有.如果您使用 MySQL，请查看 mysql_query 和 mysql_fetch_row.
PHP 手册中的示例:>

Of course there is. Check out mysql_query, and mysql_fetch_row if you use MySQL.
Example from PHP manual:

<?php
$result = mysql_query("SELECT id,email FROM people WHERE id = '42'");
if (!$result) {
    echo 'Could not run query: ' . mysql_error();
    exit;
}
$row = mysql_fetch_row($result);

echo $row[0]; // 42
echo $row[1]; // the email value
?>

这篇关于php变量中的mysql查询结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！