感谢您让我在Stackoverflow上,我真的很享受我的住宿。 我决定使用 000webhost 作为我的数据库。我是PHP初学者。 我输入我的 url,后跟/Register.php这是我的 PHP 文件的文件,以便在用户注册时将其上传到数据库。 它过去曾说"连接成功",错误行我已经逐渐修复了。我现在无法修复的一个如下:
这是我的 php 文件:
<?php
$servername = 'localhost';
$username = 'xxx';
$password = 'xxx';
$database = 'xxx';
// Create connection
$conn = mysqli_connect($servername, $username, $password, $database);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";
$query ="INSERT INTO user VALUES (?, ?, ?, ?, ?)";
$statement = mysqli_prepare($conn, $query);
mysqli_stmt_bind_param($statement, "issis" ,$id, $name, $username, $age, $password);
if(isset($_POST['name'])){
$name = $_POST['name'];
}
if(isset($_POST['username'])){
$username = $_POST['username'];
$username = $_POST["username"];
$age = $_POST["age"];
$password = $_POST["password"];
mysqli_stmt_execute($statement);
$response = array();
$response["success"] = true;
print(json_encode($response));
printf("%d Row embed.n", mysqli_stmt_affected_rows($statement));
mysqli_stmt_close($statement);
?>
然而
我在谷歌浏览器中查看时收到此行错误
Parse error: syntax error, unexpected end of file in /storage/ssd1/298/7395298/public_html/Register.php on line 38
和
当我在 000webhost 中查看它时
Syntax Error, Unexpected $EOF
我希望有一个正确的印象,一旦这个问题得到纠正,信息将成功发送到我的数据库。
任何纠正此错误的帮助都将引起深深的感激。非常感谢!
您的最后一个 if 未关闭
if(isset($_POST['name'])){ $name = $_POST['name']; }
if(isset($_POST['username'])){ $username = $_POST['username'];
$username = $_POST["username"];
$age = $_POST["age"];
$password = $_POST["password"];
mysqli_stmt_execute($statement);
$response = array();
$response["success"] = true;
print(json_encode($response));
printf("%d Row embed.n", mysqli_stmt_affected_rows($statement));
mysqli_stmt_close($statement);
}
试试这个
error_reporting(0);
这将在页面上隐藏您的所有错误...
但是存在错误,您也没有关闭带有括号的最后一个if标签
<?php
$servername = 'localhost';
$username = 'xxx';
$password = 'xxx';
$database = 'xxx';
// Create connection
$conn = mysqli_connect($servername, $username, $password, $database);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";
$query ="INSERT INTO user VALUES (?, ?, ?, ?, ?)";
$statement = mysqli_prepare($conn, $query);
mysqli_stmt_bind_param($statement, "issis" ,$id, $name, $username, $age, $password);
if(isset($_POST['name'])){ $name = $_POST['name']; }
if(isset($_POST['username'])){ $username = $_POST['username'];
$username = $_POST["username"];
$age = $_POST["age"];
$password = $_POST["password"];
mysqli_stmt_execute($statement);
$response = array();
$response["success"] = true;
print(json_encode($response));
printf("%d Row embed.n", mysqli_stmt_affected_rows($statement));
mysqli_stmt_close($statement);
}
?>