php提示Warning:mysql_fetch_array() expects的解决方法,expects
本文实例讲述了php提示Warning mysql_fetch_array() expects的解决方法,分享给大家供大家参考。具体分析如下:
在mysql数据库连接时碰到Warning: mysql_fetch_array() expects ...错误提示,根据我的经验这个是sql返回的query为空了,我们没有加己判断直接使用了.
mysql_fetch_array()函数导致的,下面我们一起来看问题解决方案,我的代码如下:
复制代码 代码如下:
include("conn.php");
if(!empty($_GET['id'])){
$sql="select * from news where `id`='".$_GET['id']."'";
$query=mysql_query($sql);
$rs = mysql_fetch_array($query);
}
提示错误了:Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in F:xmappmylibrarysearch_result.php on line 32
后来我对代码进行升级,代码如下:
复制代码 代码如下:
if(!empty($_GET['id'])){
$sql="select * from news where `id`='".$_GET['id']."'";
$query=mysql_query($sql);
if( mysql_num_rows( $query )
{
$rs = mysql_fetch_array($query);
}
else
{
mysql_error();
}
}
这样就会看到mysql错误信息了,结果是sql语句有问题了,把sql语句进行修改就可以了.
提示:导致这类错误是我们语法不规范了,如果要处理只有对sql进行一条条输出处理或在mysql_query(sql) or die(mysql_error()) 这样来处理,以便更准确的定位错误。
希望本文所述对大家的PHP程序设计有所帮助。

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

WebStorm Mac version
Useful JavaScript development tools

MantisBT
Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.

ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment

SublimeText3 Chinese version
Chinese version, very easy to use

PhpStorm Mac version
The latest (2018.2.1) professional PHP integrated development tool
