PHP Fatal error: Call to undefined function mysql_connect() PHP Fatal error, Call to undefined function mysql_connect()
PHP Fatal error: Call to undefined function mysql_connect()
This error means that the mysql shared extension for php is not installed on your server.
Depending on your platform there are more ways to fix this issue
Fixing Call to undefined function mysql_connect() on FreeBSD
1. Check if php5-mysql port is installed (this example is for PHP5):
$ pkg_info|grep php|grep mysql $
This means that this port is not installed and we have to install it:
$ cd /usr/ports/databases/php5-mysql $ make install clean ===> Extracting for php5-mysql-5.2.5 => MD5 Checksum OK for php-5.2.5.tar.bz2. => SHA256 Checksum OK for php-5.2.5.tar.bz2. ===> Patching for php5-mysql-5.2.5 ===> php5-mysql-5.2.5 depends on executable: phpize - found ===> php5-mysql-5.2.5 depends on file: /usr/local/bin/autoconf-2.61 - found ===> php5-mysql-5.2.5 depends on shared library: mysqlclient.15 - found ===> PHPizing for php5-mysql-5.2.5 Configuring for: PHP Api Version: 20041225 Zend Module Api No: 20060613 Zend Extension Api No: 220060519 ===> Configuring for php5-mysql-5.2.5 ........................................................... Build complete. Don't forget to run 'make test'.
===> Installing for php5-mysql-5.2.5 ===> php5-mysql-5.2.5 depends on file: /usr/local/include/php/main/php.h - found ===> Generating temporary packing list ===> Checking if databases/php5-mysql already installed ===> Warning: your umask is "0027". If this is not desired, set it to an appropriate value and install this port again by ``make reinstall''. ===> Registering installation for php5-mysql-5.2.5 ****************************************************************************
The following line has been added to your /usr/local/etc/php/extensions.ini configuration file to automatically load the installed extension:
extension=mysql.so
**************************************************************************** ===> Cleaning for php5-mysql-5.2.5
$ pkg_info|grep php|grep mysql php5-mysql-5.2.5 The mysql shared extension for php
Now the mysql shared extension for php (php 5 in our case) is installed and php mysql_connect()like functions will be available.
Fixing Call to undefined function mysql_connect() on Linux(Red Hat)
$ rpm -qa |grep php |grep mysql $
Find the php-mysql rpm file for the version of php you are looking for and install it and check:
The procedures for other Unix operating systems are similar. The mysql_* set of functions depends on the mysql shared extension for php, otherwise knows as php4-extensions or php5-extensions.
Designed and developed by Andrei Manescu. Optimized for Mozilla Firefox.
Copyright 2007 Andrei Manescu
All trademarks and copyrights on this page are owned by their respective owners. Comments are owned by those who posted them.
