php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Doc Bug #33700 mysql_real_escape_string does NOT require a mysql connection
Submitted: 2005-07-14 17:54 UTC Modified: 2005-07-15 08:02 UTC
From: colder@php.net Assigned:
Status: Not a bug Package: Documentation problem
PHP Version: Irrelevant OS: WinXP
Private report: No CVE-ID: None
View Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem:
18 - 16 = ?
Subscribe to this entry?

 
 [2005-07-14 17:54 UTC] colder@php.net 
Description:
------------
mysql_real_ecape_string does not require a mysql connection.

That makes the first note wrong:
"Note:  A MySQL connection is required before using mysql_real_escape_string() otherwise an error of level E_WARNING is generated, and FALSE is returned. If link_identifier isn't defined, the last MySQL connection is used."

This function doesn't generate a WARNING and doesn't return FALSE when no connexion is available.

I don't know when this behavior changed so I'm unable to provide a patch, sorry.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2005-07-15 08:02 UTC] vrana@php.net 
It's the same as with any other MySQL function. If no link_identifier is provided and no link does exist, connection is tried to establish with default user/password defined in php.ini. If this fails, mysql_real_escape_string() really generates WARNING and returns FALSE.

I documented that in CVS at ref.mysql instead: "Most MySQL functions accept link_identifier as the last optional parameter. If it is not provided, last opened connection is used. If it doesn't exist, connection is tried to establish with default parameters defined in php.ini. If it is not successful, functions return FALSE."
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Sat Jul 12 02:01:35 2025 UTC