如果有人能帮我找出这个错误会很感激的。在我的第一页,让我们称之为"index.php",我有代码在我的身体开始连接到我的数据库,没有问题。建立连接,并在页面上显示来自数据库的变量。我有另一个页面,它使用完全相同的代码进行连接,但是我在我的页面上收到了这个错误:
警告:在第36行的/var/sites/s/ssangar.com/public_html/PMWebsite/projects.php中,mysql_query() function.mysql-query:无法通过套接字'/var/lib/ MySQL /mysql.sock‘(2)连接到本地mysql服务器 警告:无法在第36行的/var/sites/s/ssangar.com/public_html/PMWebsite/projects.php中建立到服务器的链接: mysql_query() Function.mysql-query 警告: /var/sites/s/ssangar.com/public_html/PMWebsite/projects.php ()希望参数1是资源,在第37行的mysql_numrows中给出布尔值
我的php代码:
<?php session_start(); ?>
<!DOCTYPE html>
<html lang="en">
<head>
...
</head>
<body>
<?php
$connect = mysqli_connect("server", "username", "password", "database");
$user = $_SESSION['username'];
$query="SELECT * FROM Projects";
$result=mysql_query($query);
$num=mysql_numrows($result);
?>
...
<?php
while($row = mysqli_fetch_array($result)){
echo "<div class='col-xs-6 col-sm-3 placeholder'>";
echo "<h4>". $row['title'] . "</h4><br/>";
echo "". $row['description'] ."<br/>";
echo "Due: ". $row['deadline'] ."";
echo "<span class='text-muted'></span>";
echo " </div>";
}
mysqli_close($connect);
?>
</div>
</body>
</html>我还收到底部附近的代码显示数据库内容的错误:
警告: mysqli_fetch_array()期望参数1是mysqli_result,在第83行的mysqli_result中给出布尔值
发布于 2014-04-10 01:29:59
摆脱了$num=..。线,它工作得很好!
新代码:$connect = mysqli_connect("server", "username", "pw", ""); $user = $_SESSION['username']; $query = "SELECT * FROM Projects"; $result = mysqli_query($connect, $query);
https://stackoverflow.com/questions/22976539
复制相似问题