警告：mysql_fetch_array（）期望参数1是资源，在...中给出布尔值 [英] Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in...
问题描述
所以我一直在研究一个项目并遇到了一个问题，我希望有人可以帮助我。我对这一切都是全新的，似乎无法解决这个问题。我一直在谷歌搜索几个小时尝试解决这个问题，但没有运气。我在加载进一步使用代码的页面时收到此错误消息：
警告：mysql_fetch_array（）期望参数1为resource，boolean给出第27行/XXX/XXX/XXX/XXX/XXX/XXX/myorder.php
您将看到以下代码尝试从中获取所需信息数据库，并在表中显示结果。我哪里错了？
So I have been working on a project and have run into an issue that I am hoping someone here might be able to help me with. I am completely new to all of this, and can't seem to get my head around fixing the problem. I have been googling for hours to try and work out hot to fix this myself, but with no luck. I am getting this error message when loading the page that makes use of the code further down:
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /XXX/XXX/XXX/XXX/XXX/XXX/myorder.php on line 27
The code below as you will see tries to pull the required information from the database, and display the results in a table. Where am I going wrong?
<！DOCTYPE html>
< html>
< head>
< meta http-equiv =Content-Typecontent =text / html ; charset = UTF-8>
< link rel =stylesheettype =text / csshref =../../ gpte / css / cms_style.css> ;
< title>< / title>
< / head>
< body>
$ / b
require_once（dbconfig.php）;
$ user = $ _ GET ['user'];
$ result = mysql_query（SELECT GPTE_Orders.Id，Item_Name，GPTE_Gift_Cards。值，日期，状态来自GPTE_Orders，GPTE_Gift_Cards WHERE GPTE_Orders.Item_Name = GPTE_Gift_Cards.Name AND GPTE_Orders.Username ='$ user'）;
while（$ row = mysql_fetch_array（$ result））
{
echo;
echo;
echo;
echo;
echo;
echo;
echo
| 我的订单 | ||||
| Id | 名称 | 点 | 时间 | 状态 |
|---|---|---|---|---|
| 。$ row ['Id']。 | 。$ row ['Item_Name']。 | $行[ '价值'。 | 。$行[ '日期']。 | 。$行[ '状态'。 |
}
？>
< / body>
< / html>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link rel="stylesheet" type="text/css" href="../../gpte/css/cms_style.css">
<title></title>
</head>
<body>
require_once("dbconfig.php");
$user=$_GET['user'];
$result = mysql_query("SELECT GPTE_Orders.Id,Item_Name,GPTE_Gift_Cards.Value,Date,Status FROM GPTE_Orders,GPTE_Gift_Cards WHERE GPTE_Orders.Item_Name = GPTE_Gift_Cards.Name AND GPTE_Orders.Username='$user'");
while($row = mysql_fetch_array($result))
{
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "
| My Order | ||||
| Id | Name | Points | Time | Status |
|---|---|---|---|---|
| ".$row['Id']." | ".$row['Item_Name']." | ".$row['Value']." | ".$row['Date']." | ".$row['Status']." |
}
?>
</body>
</html>
什么我试过了：
我试过谷歌搜索了几个小时。我似乎无法理解如何解决这个问题。
What I have tried:
I have tried searching through google for hours. I cannot seem to get my head around how to fix this.
推荐答案
user =
_GET ['user'];
_GET['user'];
result = mysql_query（SELECT GPTE_Orders.Id，Item_Name，GPTE_Gift_Cards.Value，Date，Status FROM GPTE_Orders，GPTE_Gift_Cards WHERE GPTE_Orders.Item_Name = GPTE_Gift_Cards.Name AND GPTE_Orders.Username ='
result = mysql_query("SELECT GPTE_Orders.Id,Item_Name,GPTE_Gift_Cards.Value,Date,Status FROM GPTE_Orders,GPTE_Gift_Cards WHERE GPTE_Orders.Item_Name = GPTE_Gift_Cards.Name AND GPTE_Orders.Username='
这篇关于警告：mysql_fetch_array（）期望参数1是资源，在...中给出布尔值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
