php - mysqli_query执行抛出http错误500
问题描述
这是我的设置,我已经检查了两次,但一无所获。我目前正在使用 LAMP 堆栈,并且大多数配置都已正确完成。我有两个文件 1.connect.php 2.registration.php
- connect.php的代码如下:
<?php
ini_set('display_errors',1);
error_reporting(E_ALL);
$hostname="localhost"; //local server name
$username="user_name"; //mysql username
$password="my_password"; //mysql password
$database="my_database"; //database name
// Create Connection to DB using an Object
$con= mysqli_connect($hostname,$username,$password); //do i need to pass database name also as an argument to this?
//Check Connection
if(mysqli_connect_errno()){
echo"Failed to connect! due to : " . mysqli_connect_errno();
} else{
echo"Connected!";
}
?>
- registration.php 代码如下:
<?php //start php tag
include("/var/www/calculator/connect.php"); //using absolute path to avoid any confusion
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
} else {
printf("Connected! on Registration Page"); //executes till here with no problems
}
if (mysqli_query($conn, "CREATE table users"))
{
printf("Query Executed!", mysqli_affected_rows($conn))
}
mysqli_close($link);
?>
有些人建议看一下 apache 服务器日志,这里是日志的最后 10 个输出
::1 - - [24/Feb/2020:13:14:41 +0530] "GET /registration.php HTTP/1.1" 500 185 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.116 Safari/537.36"
::1 - - [24/Feb/2020:13:14:43 +0530] "GET /registration.php HTTP/1.1" 500 185 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.116 Safari/537.36"
::1 - - [24/Feb/2020:13:14:44 +0530] "GET /registration.php HTTP/1.1" 500 185 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.116 Safari/537.36"
::1 - - [24/Feb/2020:13:14:45 +0530] "GET /registration.php HTTP/1.1" 500 185 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.116 Safari/537.36"
::1 - - [24/Feb/2020:13:14:45 +0530] "GET /registration.php HTTP/1.1" 500 185 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.116 Safari/537.36"
::1 - - [24/Feb/2020:13:14:45 +0530] "GET /registration.php HTTP/1.1" 500 185 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.116 Safari/537.36"
::1 - - [24/Feb/2020:13:14:45 +0530] "GET /registration.php HTTP/1.1" 500 185 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.116 Safari/537.36"
::1 - - [24/Feb/2020:13:14:45 +0530] "GET /registration.php HTTP/1.1" 500 185 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.116 Safari/537.36"
::1 - - [24/Feb/2020:13:15:37 +0530] "-" 408 0 "-" "-"
::1 - - [24/Feb/2020:13:15:37 +0530] "-" 408 0 "-" "-"
尽管我的代码没有编码错误或查询结构错误,但为什么我的查询没有被执行,我需要帮助。
解决方案
你错过了;
:
if (mysqli_query($conn, "CREATE table users"))
{
printf("Query Executed!", mysqli_affected_rows($conn)) // <---- here
}
另外,请阅读mysqli_connect。您应该使用 4 个参数,但可以在其中一个参数中传递''
值。
推荐阅读
- python - 我无法在 Python (PyCharm) 中输入字母“&”它用空格 {BUG} 替换它
- javascript - 如何将对话框中的用户输入数据保存到隐藏字段中:Jquery 和 HTML
- javascript - 使用 foreach 更新数组的特定列键的每个值
- css - 如何更改字体真棒图标的颜色
- c# - WPF Storyboard 的 DoubleAnimation 行为异常
- ios - RxDataSources `Generic parameter 'Self' could not be inferred`
- c# - 从一个对象列表复制到具有相同结构的另一个对象列表
- visual-studio-code - MSBUILD 从 tasks.json 失败,但从 VS Code 终端运行
- html - Flexbox 内的响应表不起作用
- r - Rate of Growth by Rows in R