使用MYSQL从数据库设置PHP变量 - Setting PHP variables from Database Using MYSQL

Setting PHP variables from Database Using MYSQL

希望从数据库中选择多个值，并使用PHP进行回显。（新手）

例如：

SELECT sponser, contract, script FROM Copy WHERE day = '11092014' and time = 4
SELECT sponser, contract, script FROM Copy WHERE day = '11092014' and time = 5
SELECT sponser, contract, script FROM Copy WHERE day = '11092014' and time = 6

我该如何设置变量。。对多个变量使用MYSQLi是什么意思？

$sqlStremail = "SELECT subcheckr
                FROM login 
                WHERE username = '$u'";
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);
$variable = $row["subcheckr"];

非常感谢您的帮助。

是。不过，如果您的查询返回多行，则需要使用：

while ($row = mysqli_fetch_assoc($result))
{
//do something here
}

您需要为、foreach或while循环

前

while ($row = mysqli_fetch_assoc($result))
{
}

这样就可以了。首先需要连接，然后构建查询。若查询失败，则显示一个错误，以便您知道出了什么问题。然后构建您的数据阵列并使用它。

$db = mysql_connect("localhost", "mysql_user", "mysql_password");
$sqlStremail = "SELECT `subcheckr`
                FROM `login` 
                WHERE `username` = '".$u."'"; //needs to be concatenated
$result = mysql_query($sqlStremail, $db);
if(!$result) {
    echo "query failed:". mysql_error();
    exit;
}
$data = array();
while ($row = mysql_fetch_assoc($result)) {
    $data = $row;
}
echo $data['sponsor'];
echo $data['contact'];
echo $data['script'];
//etc