Paul Hickey wrote:
Can someone help me overcome this recurring problem? I am using the
Joomla content management system and I keep coming across the following
errors.
Fatal error: Call to undefined function mysql_real_escape_string() in
/usr/local/apache2/htdocs/common.php on line 24
Fatal error: Call to undefined function mysql_real_escape_string() in
/usr/local/apache2/htdocs/class.inputfilter.php on line 344
I notice in my Dynamic Extensions section of php.ini there are no
extensions called for; if that helps. Joomla works fine, but when adding
components or modules the problems start. One component author made a
test for the mysql_real_escape_string and I think avoided using it then
the component worked. I think that's probably not the best solution.
Fedora Core 3
Apache 2.0.55
PHP 5.0.5 (compiled with mysqli vice mysql)
'./configure' '--with-apxs2=/usr/local/apache2/bin/apxs' '--enable-ftp'
'--enable-inline-optimization' '--enable-magic-quotes'
'--enable-mbstring' '--enable-track-vars' '--enable-trans-sid'
'--enable-wddx=shared' '--enable-xml' '--with-dom' '--with-gd'
'--with-gettext' '--with-mysqli=/usr/local/mysql/bin/mysql_config'
'--with-regex=system' '--with-xml' '--with-zlib-dir=/usr/lib'
MySQL 4.1.15
mysql_real_escape_string() is a MySQL function, and you're server is
compiled with the 'improved' MySQL functions. You want
mysqli_real_escape_string()
http://us3.php.net/manual/en/function.mysqli-real-escape-string.php
--
John C. Nichel IV
Programmer/System Admin (ÜberGeek)
Dot Com Holdings of Buffalo
716.856.9675
jnichel@xxxxxxxxxxxxxxxxxxxxxxxxxxx
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
