Re: Call to undefined function mysql_real_escape_string()]

From: Date: Thu, 08 Dec 2005 14:28:43 +0000
Subject: Re: Call to undefined function mysql_real_escape_string()]
References: 1 2 3  Groups: php.general 
Request: Send a blank email to php-general+get-227141@lists.php.net to get a copy of this message
Paul Hickey wrote:
I have PHP compiled with mysqli. The standard answer from the Joomla forums is that I need to have "mysql" vice "mysqli". I was looking for a more global solution than having to modify the code for every component, module, mambot I want to use. I don't understand why I'm getting "undefined function" errors. PHP.ini has no reference to mysqli. I don't know if changing this would enable the functions specific to PHP > 4.x.
In your configuration line (how php was configured then compiled), you have... --with-mysqli=/usr/local/mysql/bin/mysql_config That is why you are getting undefined function errors. Your version of php is using mysqli, not mysql. You have two options: a) Recompile php or b) Change all mysql_* functions to their counterparts in mysqli_* -- John C. Nichel IV Programmer/System Admin (ÜberGeek) Dot Com Holdings of Buffalo 716.856.9675 jnichel@dotcomholdingsofbuffalo.com

« previous php.general (#227141) next »