此php代码出错 - Error with this php code

Error with this php code

本文关键字：出错代码 php | 更新日期: 2023-09-27

我在我的网站上看到这个错误。

已弃用：mysql_query((：mysql扩展已弃用，将将来删除：在中使用mysqli或PDO/home/u857740002/public_html/dataetch.php第3行

已弃用：mysql_query((：mysql扩展已弃用，将将来删除：在中使用mysqli或PDO/home/u857740002/public_html/dataetch.php，第23行

我正在使用此代码。

有人能纠正这两行吗。

$siteSettings = mysql_query("select * from pu_settings where sid = '1' ");
$siteSoft = mysql_query("select * from pu_softwares where slug = '$slug' ");

MySQL_*已被弃用，并将很快与PHP一起删除。使用MySQLi_*。参见：MySQLi

使用这个替代：

$link = mysqli_connect([dbhost],[dbusername],[dbpass],[dbname]);
$siteSettings = mysqli_query($link,"select * from pu_settings where sid = '1' ");
$siteSoft = mysqli_query($link,"select * from pu_softwares where slug = '$slug' ");

mysql_*已弃用+已删除库，因此请使用mysqli_*或PDO:-

假设您的数据库连接对象是$conn

$siteSettings = mysqli_query($conn,"select * from pu_settings where sid = '1' ")or die(mysqli_error($conn));
$siteSoft = mysql_query($conn,"select * from pu_softwares where slug = '$slug' ")or die(mysqli_error($conn));

使用mysqli_*创建连接的代码是：-

$conn=mysqli_connect("hostname","username","password","databasename");
if (mysqli_connect_errno()){
 echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

在查询中使用mysqli_*而不是mysql_*。

$con=mysqli_connect("localhost","my_user","my_password","my_db");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }
$siteSettings = mysqli_query($con,"select * from pu_settings where sid = '1' ");
$siteSoft = mysqli_query($con,"select * from pu_softwares where slug = '$slug' ");