Table of Contents
php prompt Warning:mysql_fetch_array() expects solution, expects
Home Backend Development PHP Tutorial PHP prompts Warning: mysql_fetch_array() expects solution, expects_PHP tutorial

PHP prompts Warning: mysql_fetch_array() expects solution, expects_PHP tutorial

Jul 13, 2016 am 10:11 AM
mysql php Solution

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:

Copy code The code is as follows:
include("conn.php");
if(!empty($_GET['id'])){
            $sql="select * from news where `id`='".$_GET['id']."'";
            $query=mysql_query($sql);
           $rs = mysql_fetch_array($query);                                          }
The prompt is wrong:
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:


Copy code The code is as follows:
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();

}

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

truehttp: //www.bkjia.com/PHPjc/928214.htmlTechArticlephp prompt Warning: mysql_fetch_array() expects solution, expects This article describes the example of php prompt Warning mysql_fetch_array() expects The solution is shared with everyone for your reference...
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

The page is blank after PHP is connected to MySQL. What is the reason for the invalid die() function? The page is blank after PHP is connected to MySQL. What is the reason for the invalid die() function? Apr 01, 2025 pm 03:03 PM

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...

Why does an error occur when installing an extension using PECL in a Docker environment? How to solve it? Why does an error occur when installing an extension using PECL in a Docker environment? How to solve it? Apr 01, 2025 pm 03:06 PM

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

How to efficiently integrate Node.js or Python services under LAMP architecture? How to efficiently integrate Node.js or Python services under LAMP architecture? Apr 01, 2025 pm 02:48 PM

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: How to completely obtain URL parameters containing special characters such as Chinese? ThinkPHP6 routing: How to completely obtain URL parameters containing special characters such as Chinese? Apr 01, 2025 pm 02:51 PM

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...

How to solve the permissions problem encountered when viewing Python version in Linux terminal? How to solve the permissions problem encountered when viewing Python version in Linux terminal? Apr 01, 2025 pm 05:09 PM

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

When using Django and MySQL to process hundreds of thousands to one or two million pieces of data, what kind of cache solution should a 4-core 8G memory server choose? When using Django and MySQL to process hundreds of thousands to one or two million pieces of data, what kind of cache solution should a 4-core 8G memory server choose? Apr 01, 2025 pm 11:36 PM

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 third-party interfaces returning 403 errors in Node environment? How to avoid third-party interfaces returning 403 errors in Node environment? Apr 01, 2025 pm 02:03 PM

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. �...

What is the reason why pipeline persistent storage files cannot be written when using Scapy crawler? What is the reason why pipeline persistent storage files cannot be written when using Scapy crawler? Apr 01, 2025 pm 04:03 PM

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...

See all articles