Mysql_escape_string () function Usage Analysis, mysqlescapestring

Mysql_escape_string () function Usage Analysis, mysqlescapestring

This example describes the usage of the mysql_escape_string () function. We will share this with you for your reference. The details are as follows:

Use mysql_escape_string () to encode the data in question:

Some data, such:

Char query (1024); sprintf (query, "select * from my_tbl where name = '% S'", name );

If the name contains data such as "0 'Malley, Brian", a query statement is generated: select * from my_tbl where name = '0' Malley, brian.

The process of calling mysql_escape_string () is as follows:

My $ item = "aaa's bbb" my $ escape_item = mysql_escape_string ($ item );

In this case, the content of escape_item is aaa \'s bbb.

PS: this function has been deprecated in PHP5.3. Therefore, you only need to know about this function. It is not recommended.