PHP Apache PHP Fatal error Call to undefined function mysql connect

Question

I have MySQL  5 5 23 Community Server   Apache  2 2   and PHP  5 3 13  running on a Fedora 15 machine  64-bit   Each works with no problem on their own   I thought that PHP was configured compiled to work with MySQL  but when I try to load any PHP web page which makes a MySQL call then I get the above noted fatal error  in the Apache error log   PHP works okay on its own though  through Apache and at the command line   When I run php -i from the command line then sure enough it shows all the MySQL bits and pieces  but when I load a page displaying phpinfo   then there are no MySQL modules mentioned   I ve also tried un-commenting  extension mysql so  in php ini  but PHP then complains with  PHP Startup  Unable to load dynamic library   usr lib64 php modules mysql so     even though the module does reside there   But then I m not entirely certain whether that line is required to be un-commented or not   correction  the error stated was actually due to a typo  but running from the command line shows that the module is already loaded anyway - there is a warning from PHP that says so    I ve also disabled SELinux  stopped restarted Apache numerous times  yummed MySQL-Devel  in case it made any difference  and  it seems  every other possible thing   If I run a little PHP test script from the command line  to access the MySQL database  then it works with no problem  so PHP does know about MySQL  but when it runs under Apache it seems to have no clue that MySQL even exists   I ve been trying on and off for months to solve this problem  and seem to have tried everything  but nothing seems to work   I don t mind having to re-install PHP if I really have to  if somebody can demonstrate the proper way to configure compile with MySQL support  so that I can get it to work under Apache  although ideally I d simply prefer to get the existing installation working

User · Answer

In case anyone else faces this  it s a case of PHP not having access to the mysql client libraries  Having a MySQL server on the system is not the correct fix  Fix for ubuntu  and PHP 5         sudo apt-get install php5-mysql   After installing the client  the webserver should be restarted  In case you re using apache  the following should work   sudo service apache2 restart

User · Answer

The Apache module PHP version might for some odd reason not be picking up the php ini file as the CLI version I d suggest having a good look at    Any differences in the  ini files that differ between php -i and phpinfo   via a web page  If there are no differences then to look at the permissions of mysql so and the  ini files but I think that Apache parses these as the root user   To be really clear here  don t go searching for php ini files on the file system  have a look at what PHP says that it s looking at

User · Answer

Keep in mind that as of PHP 5 5 0 the mysql connect   function is deprecated  and it is completely removed in PHP 7  More info can be found on the php documentation   Quote      Warning   This extension was deprecated in PHP 5 5 0  and it was removed in PHP 7 0 0  Instead  the MySQLi or PDO MySQL extension should be used  See also MySQL  choosing an API guide and related FAQ for more information  Alternatives to this function include      mysqli connect       PDO    construct

User · Answer

I had this same problem and had to refer to the php manual which told me the mysql and mysqli extensions require libmysql dll to load  I searched for it under C  windows system32  windows 7  and could not find  so I downloaded it here and placed it in my C  windows system32  I restarted Apache and everything worked fine  Took me 3 days to figure out  hope it helps

User · Answer

I had received a similar error message  Think I inadvertently typed  9o  at start of first line of php ini file  Once I removed that  I no longer received the  fatal error  messages  Hope this helps

User · Answer

The mysql deamon should be running   If not try this     etc init d mysql start   Or this    service mysqld start   And if you want to add mysql on boot     chkconfig --add mysqld   chkconfig -- level 235 mysqld on   If yes  and it is still not working try this   Uncomment the following lines in  etc php php ini  extension mysqli so extension mysql so   And please check your post above   usr lib64 php modules msql so   It should be mysql so  if it s mistyped ignore it

User · Answer

How about  sudo yum install php-mysql   or  sudo apt-get install php5-mysql

[php] PHP/Apache: PHP Fatal error: Call to undefined function mysql_connect()

Examples related to php

Examples related to mysql

Examples related to apache