#32186 [Opn->Bgs]: mysqli_real_escape_string
| From: | gabriel dot preda at amr dot ro | Date: | Fri, 04 Mar 2005 10:50:19 +0000 |
| Subject: | #32186 [Opn->Bgs]: mysqli_real_escape_string | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-74826@lists.php.net to get a copy of this message | ||
ID: 32186
User updated by: gabriel dot preda at amr dot ro
Reported By: gabriel dot preda at amr dot ro
-Status: Open
+Status: Bogus
Bug Type: MySQLi related
Operating System: Fedora Core 2
PHP Version: 5CVS-2005-03-04 (dev)
New Comment:
Sorry... my mistake...
The problema was because MySQL introduced the ANONYMOUSE account... the
MySQLi returned the object but I had no priviledges to any database !
Sorry ! Me culpa !
Previous Comments:
------------------------------------------------------------------------
[2005-03-04 10:58:34] gabriel dot preda at amr dot ro
Description:
------------
mysqli_real_escape_string is corrupted !
Reproduce code:
---------------
$u = $_POST['uname'];
$p = $_POST['pword'];
echo $u . "-" . $p;
$mysqli = new mysqli($MYSQL['server'], $MYSQL['username'],
$MYSQL['password'], $MYSQL['database']);
$mysqli->query("SET NAMES '".$MYSQL['charset']."'");
print "<br />";
var_dump($mysqli);
$u = $mysqli->real_escape_string($u);
echo "<br />-----".$u."----";
Expected result:
----------------
username-password
object(mysqli)#1 (0) { }
-----username----
Actual result:
--------------
username-password
object(mysqli)#1 (0) { }
---------
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=32186&edit=1