我正试图根据用户条目对数据库进行基本搜索,但我无法使其工作,所以我正在进行硬编码搜索,以便使其工作。。。而我做不到。我的代码如下:
<?php
$db_connection = mysqli_connect("HOST", "USERNAME", "PASSWORD", "DATABASE");
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$data = mysql_query($db_connection, "SELECT * FROM card_collection WHERE ID='1207409700'");
while( $card = mysql_fetch_array( $data ) ) {
echo $card['Name'], '<br />';
}
mysql_close();
?>
我已经仔细检查了所有链接到数据库的内容的拼写。我搜索的ID是数据库中的第一个项目。
您使用mysqli_connect
来数据库,然后使用mysql_query
来执行查询,它应该是mysqli_query
您的代码应该是:
$data = mysqli_query($db_connection, "SELECT * FROM card_collection WHERE ID='1207409700'");
while( $card = mysqli_fetch_array( $data ) ) {
echo $card['Name'], '<br />';
}
mysqli_close();
用mysqli
替换mysql
。这可能是你的问题。
我个人使用PDO而不是mysqli,但问题可能是您使用的是mysql_query和mysql_fetch_array,而不是mysqli_query和mysqli_fetch_array吗?注意丢失的i
编辑:dangit,打到穿孔:)
<?php
$db_connect = mysqli_connect("host", "user", "pass", "db");
if($db_connect){
$data = mysqli_query($db_connection, "SELECT * FROM card_collection WHERE ID='1207409700'");}
else {"Not Connected to db";}
while( $card = mysqli_fetch_array( $data ) ) {
echo $card['Name'], '<br />';
}
mysqli_close();
?>