mysqli_query() 期望参数 3 很长 [英] mysqli_query() expects parameter 3 to be long

问题描述

我想用查询更新 mysql 表，但它显示

I want to update mysql table with query but it shows

错误 - mysqli_query() 期望参数 3 很长

error - mysqli_query() expects parameter 3 to be long

if($money >= 400) {

$query = "UPDATE users SET spam = spam + 1, money = money - 400 WHERE user_id=".$_SESSION['user'];
$query = "UPDATE users SET score = score + 2500 WHERE user_id=".$_SESSION['user'];

$update = mysqli_query($conn,$query,$query);
echo 'Spam.exe Upgraded for $400!!';

} else {

// Prints error
echo 'Not enough Money!!';

}

推荐答案

只需像这样分别调用 2 个查询:

Just call 2 queries separately like this :

if($money >= 400) {

$query1 = "UPDATE users SET spam = spam + 1, money = money - 400 WHERE user_id=".$_SESSION['user'];
$query2 = "UPDATE users SET score = score + 2500 WHERE user_id=".$_SESSION['user'];

$update1 = mysqli_query($conn,$query1); // call 1st query
$update2 = mysqli_query($conn,$query2); // call 2nd query
echo 'Spam.exe Upgraded for $400!!';

} else {

// Prints error
echo 'Not enough Money!!';

}

这篇关于mysqli_query() 期望参数 3 很长的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！