用户访问被拒绝''@';localhost';(使用密码:NO)-正在尝试获取数组


Access denied for user ''@'localhost' (using password: NO) - trying to get an array

im试图创建一个从中检索信息的脚本,比如article.php?id=1返回一本书和article.php?id=2返回一台计算机。为了实现这一点,我试图制作一个包含表的数组,我认为我的代码是正确的。我有我的数据库"文章"和表"文章"。这是我的代码:

<?php
$servername = "localhost";
$username = "username";
$password = "password";
// create connection
$conn = new mysqli($servername, $username, $password);
// check connection
if ($conn->connect_error){
    die("connection failed: " . $conn->connect_error);
} 
$query = "SELECT * FROM articles";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result) or die(mysql_error());
echo $row['name'];
?>

混合mysqli_* API和mysql_* API。仅使用mysqli_*

用以下代码更改代码:

<?php
$username="youruser";
$password="yourpassword";
$database="yourdbname";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database)
    or die( "Impossibile selezionare il database.");
?>