我有这个代码:
<?php
$mysql_host='localhost';
$mysql_user='root';
$mysql_password='you cant know mypassword';
mysql_connect($mysql_host,$mysql_user,$mysql_password);
@mysql_select_db('attempt');
?>
<?php
$sql="IF NOT EXISTS ( SELECT person FROM kid WHERE Subs=45 )
BEGIN
echo 'hey'
END"
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
if ($conn->query($sql) === TRUE) {
echo "Done";
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
?>
php 页面应该回显“嘿”,因为不存在这样的记录,但页面本身甚至根本没有加载,而是返回 HTTP localhost 500 错误,说 localhost 无法处理请求。
我知道我做错了什么,但我不确定到底是什么。请帮忙
好的,所以删除所有并像这样使用:
<?php
$mysqli_host = 'localhost';
$mysqli_user = 'root';
$mysqli_password = 'yourPassword';
$mysqli_database = 'yourDatabase';
$mysqli = new mysqli($mysqli_host, $mysqli_user, $mysqli_password, $mysqli_database);
if ($mysqli->connect_errno) {
die("Connection failed: " . $conn->connect_error);
}
$query = mysqli_query($mysqli, "SELECT person FROM kid WHERE Subs=45");
$result = mysqli_num_rows($query);
if($result > 0) {
echo("Exist");
} else {
echo("Doesn't exist");
}
?>
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句