显示论坛数据时出错
我试图显示来自数据库的数据输出,但显示错误。我想创建论坛,将显示同一页上的消息显示论坛数据时出错
我的错误是:
$ mysqli_query($的SQL);
注意:未定义的变量:mysqli_query
致命错误:函数名称必须是一个字符串
我的编码是
` 如果(修剪($ _ POST [ 'forum_numberUser'])== NULL || TRIM($ _ POST [ 'forum_text'])== NULL)
{ // If the user didn't fill in all fields
echo "<h3>PLEASE COMPLETE THE FORM TO REGISTER</h3>";
}
else {
include('connect.php');
$_SESSION['FILLED'] = TRUE;
// username and password sent from form
$mynumberUser=$_POST['forum_numberUser'];
$mytext=$_POST['forum_text'];
// $mydate=$_POST['forum_date'];
// To protect MySQL injection (more detail about MySQL injection)
$mynumberUser = stripslashes($mynumberUser);
$mytext = stripslashes($mytext);
$mynumberUser = mysql_real_escape_string($mynumberUser);
$mytext = mysql_real_escape_string($mytext);
$mydate=date('Y-m-d H:i:s');
//$mytime=date('H:i:s');
$sql = "INSERT INTO forum VALUES(null, '$mynumberUser', '$mytext', '$mydate')";
$mysqli_query($sql); //HERE IS MY ERROR...
if(mysqli_query($conn, $sql) === TRUE) {
//&['forum_text']
echo "Successfully registered ";
}
else {
echo "<h4>Unable to register.</h4>";
}
}
}`
你有函数调用0123前,这是变量的语法,而不是函数。
我已经删除它。并显示警告:mysqli_query()期望至少2个参数 –
瞧,它确实如此:https://secure.php.net/manual/en/mysqli.query.php RTFM – Jameson
非常感谢ypu。它真的帮助:) –
删除美元之前mysqli_query – amdixon
我不认为你做了足够的研究之前问这个问题.. – MikeWu