Shulou(Shulou.com)06/03 Report--

This article is about whether the mysql_query () function is supported in php. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

In php, the mysql_query () function is not supported in version 5.5.0 and above, and is supported in versions below 5.5.0. The mysql_query () function has been deprecated since PHP 5.5.0 and removed since PHP 7.0.0.

Operating environment of this tutorial: windows7 system, PHP7.1 version, DELL G3 computer

The mysql_query () function is not supported by PHP since version 5.5.0.

The mysql_query () function has been deprecated since PHP 5.5.0 and removed since PHP 7.0.0. It should be replaced with a MySQLi or PDO_MySQL extension, and this function is replaced by:

Mysqli_query ()

PDO::query ()

To use the mysql_query () function, you need to use a version below PHP 5.5.0.

Description: mysql_query ()

Mysql_query ()-sends a MySQL query.

Syntax:

Mysql_query (string $query, resource $link_identifier = NULL): resource

Mysql_query () sends a query to the currently active database in the server associated with the specified link_identifier (multiple queries are not supported).

Parameters.

Query:SQL query statement

The query string should not end with a semicolon. The data embedded in the query should be escaped correctly.

Link_identifier:MySQL connection. If you do not specify a connection identity, the connection recently opened by mysql_connect () is used. If the connection is not found, an attempt is made to call mysql_connect () with no arguments to create it. If a connection is not found or cannot be established, an error at the E_WARNING level is generated.

Return value

Mysql_query () returns only one resource for SELECT,SHOW,DESCRIBE, EXPLAIN, and other statements, and false if there is an error in the query.

For other types of SQL statements, such as INSERT, UPDATE, DELETE, DROP, etc., mysql_query () returns true on success and false on error.

The returned result resources should be passed to mysql_fetch_array () and other functions to process the result table and fetch the returned data.

Assuming the query is successful, you can call mysql_num_rows () to see how many rows are returned corresponding to the SELECT statement, or call mysql_affected_rows () to see how many rows are affected by the corresponding DELETE,INSERT,REPLACE or UPDATE statement.

Mysql_query () also returns false if you do not have permission to access the table referenced in the query statement.

Example: mysql_query () returns a resource.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.