我一直在尝试寻找一种变通办法,以解决在访问index.php文件时发现的mysql错误消息,以下代码:
Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /Applications/XAMPP/xamppfiles/htdocs/cms/includes/navigation.php on line 24
Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, null given in /Applications/XAMPP/xamppfiles/htdocs/cms/includes/navigation.php on line 26
对于我一生,我无法弄清楚我在做什么错,因为当我使用静态链接时它可以工作,但是在测试动态链接时它就可以解决。
以下是我用于navigation.php文件的代码,该文件用完了include文件夹:
<nav class="navbar navbar-inverse navbar-fixed-top" role="navigation">
<div class="container">
<!-- Brand and toggle get grouped for better mobile display -->
<div class="navbar-header">
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="#">Start Bootstrap</a>
</div>
<!-- Collect the nav links, forms, and other content for toggling -->
<div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
<ul class="nav navbar-nav">
<?php
$query = "SELECT * FROM categories";
$please_work = mysqli_query($connection, $query);
while($row = mysqli_fetch_assoc($please_work)){
$cat_title = $row['cat_title'];
echo "<li><a href='#'>{$cat_title}</a></li>";
}
?>
</ul>
</div>
<!-- /.navbar-collapse -->
</div>
<!-- /.container -->
</nav>
当然,我的db.php文件也位于我的include文件夹中:
<?php
$db['db_host'] = "localhost";
$db['db_user'] = "root";
$db['db_pass'] = "";
$db['db_name'] = "cms";
foreach($db as $key => $value){
define(strtoupper($key), $value);
}
$connection = mysql_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME);
if($connection){
echo "We are connected";
}
?>
我没有太多需要发布我的index.php的信息,因为我知道该错误不是从那里发出的,因为使用时静态内容正在工作,这意味着include函数正在工作。
请有人可以让我免于长期头痛吗?
谢谢,
认证机构
您正在混合mysql_*
和mysqli_*
运行。您应该始终使用mysqli_*
。
所以,您需要更改此:
$connection = mysql_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME);
对此:
$connection = mysqli_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME);
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句