


PHP prompts Warning: mysql_fetch_array() expects solution, expects_PHP tutorial
php prompt Warning:mysql_fetch_array() expects solution, expects
The example in this article describes the solution to the php prompt Warning mysql_fetch_array() expects, and shares it with everyone for your reference. The specific analysis is as follows:
I encountered Warning when connecting to mysql database: mysql_fetch_array() expects... error message. According to my experience, this is because the query returned by sql is empty, and we used it directly without adding any judgment.
This is caused by the mysql_fetch_array() function. Let’s look at the solution together. My code is as follows:
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 Later I upgraded the code, the code is as follows:
$query=mysql_query($sql);
if( mysql_num_rows( $query )
{
$rs = mysql_fetch_array($query); }
else
{
mysql_error();
}
}
In this way, you will see the mysql error message. The result is that there is a problem with the sql statement. Just modify the sql statement.
Tip:
This type of error is caused by our non-standard grammar. If you want to deal with it, you can only output the sql one by one or process it in mysql_query(sql) or die(mysql_error()). in order to locate errors more accurately. I hope this article will be helpful to everyone’s PHP programming design.
http://www.bkjia.com/PHPjc/928214.html

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

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

The page is blank after PHP connects to MySQL, and the reason why die() function fails. When learning the connection between PHP and MySQL database, you often encounter some confusing things...

Causes and solutions for errors when using PECL to install extensions in Docker environment When using Docker environment, we often encounter some headaches...

Many website developers face the problem of integrating Node.js or Python services under the LAMP architecture: the existing LAMP (Linux Apache MySQL PHP) architecture website needs...

ThinkPHP6 routing parameters are processed in Chinese and complete acquisition. In the ThinkPHP6 framework, URL parameters containing special characters (such as Chinese and punctuation marks) are often processed...

Solution to permission issues when viewing Python version in Linux terminal When you try to view Python version in Linux terminal, enter python...

Using Django and MySQL to process large data volumes When using Django and MySQL databases, if your data volume reaches hundreds of thousands to one or two million...

How to avoid the third-party interface returning 403 error in the Node environment. When calling the third-party website interface using Node.js, you sometimes encounter the problem of returning 403 error. �...

When using Scapy crawler, the reason why pipeline persistent storage files cannot be written? Discussion When learning to use Scapy crawler for data crawler, you often encounter a...
