MySQL查询结果在PHP变量 [英] 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_query和mysql_fetch_row(如果使用MySQL).
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
?>

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