连接MYSQL问题的PHP编码

Question

我正在创建一个数据库来制作我的'PHP‘网站，但我不能这样做。我的网站是与拼车公司相关的cruzapp，并将其更改为php以获取我们用户的详细信息。但是我不能使用下面的PHP代码连接MYSQL：

?php
$username = "name";
$password = "password";
$hostname = "host"; 

//connection to the database
$dbhandle = mysql_connect($hostname, $username, $password) 
 or die("Not connected to MySQL");
echo "Connected to MySQL<br>";

//select a database to work with
$selected = mysql_select_db("examples",$dbhandle) 
  or die("Could not select examples");

//execute the SQL query and return records
$result = mysql_query("SELECT id, model,year FROM cars");

//fetch tha data from the database 
while ($row = mysql_fetch_array($result)) {
   echo "ID:"$row{'id'}." Name:".$row{'model'}."Year: ". //display the results
   $row{'year'}.<br>";
}
//close the connection
mysql_close($dbhandle)
?>

有人能帮我调试这段代码吗？我会非常感谢你的。

Answer 1

试试这个吧。它使用带有错误回显的MySQLi。

<?php

$username = "name";
$password = "password";
$hostname = "host";
$database = "examples";

$con = mysqli_connect($hostname, $username, $password, $database);

if (!$con) {
    exit("Connection failed: " . mysqli_connect_error());
}

$result = mysqli_query($con, "SELECT id, model,year FROM cars");

if (mysqli_error($con)) {
    exit("Error: " . mysqli_error($con));
}

while ($row = mysqli_fetch_array($result)) {
    echo "ID:" . $row['id'] . " Name:" . $row['model'] . "Year: " . $row['year'] . "<br>";
}

mysqli_close($con);

Answer 2

首先，您不应该使用mysql，因为在PHP7中，mysql扩展不再有效。因此，您必须考虑将其更改为mysqli或PDO。建议使用PDO。为了快速修复$selected = mysql_select_db($dbhandle，"examples")，请执行此操作，并检查所有值，如主机名、数据库名、表名，并确保没有错误。