PHP Fatal error : Call to undefined function mysql_connect()

Question

I have recently installed PHP 7.0.8 (ZTS) on CentOS 7 with the following configuration:

--prefix=/usr/local/php7 \
--with-config-file-scan-dir=/usr/local/php7/etc/conf.d \
--enable-bcmath \
--enable-calendar \
--enable-exif \
--enable-opcache
--enable-dba \
--enable-ftp \
--with-gettext \
--with-gd \
--with-jpeg-dir \
--enable-mbstring \
--with-mcrypt \
--with-mhash \
--enable-mysqlnd \
--with-mysql=mysqlnd \
--with-mysqli=mysqlnd \
--with-pdo-mysql=mysqlnd \
--with-mysql-sock=/var/run/mysqld/mysqld.sock \
--with-openssl \
--enable-pcntl \
--enable-soap \
--enable-sockets \
--enable-sysvmsg \
--enable-sysvsem \
--enable-sysvshm \
--with-zlib \
--enable-zip \
--with-readline \
--with-curl \
--enable-shmop \
--enable-fpm \
--enable-maintainer-zts \
--enable-pthreads=shared \
--with-tsrm-pthreads \
--enable-fastcgi \
--with-fpm-user=www-data \
 --with-fpm-group=www-data"

I can't go on my website because I have the following nginx log error when I try to go on my website:

[error] 20609#20609: *8 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /adodb/drivers/adodb-mysql.inc.php:461

This website is ok on an another server configured with Debian8, PHP7 (same configuration like here).

I have installed MySQL 5.7 and Nginx 1.10. How I can correct this error?

mysql_* functions have been removed from PHP7. You'll need to translate your code to use PDO or mysqli instead. — aynber, Jul 18 '16 at 15:57
http://stackoverflow.com/questions/34289954/compiled-php-7-missing-mysql-extension-in-wordpress — Jacob, Jul 18 '16 at 15:57
**Warning** This extension was deprecated in PHP 5.5.0, and it was removed in PHP 7.0.0. — AbraCadaver, Jul 18 '16 at 15:57
[http://php.net/manual/en/migration70.removed-exts-sapis.php](http://php.net/manual/en/migration70.removed-exts-sapis.php) — spencer7593, Jul 18 '16 at 15:57
Betcha it's not. Use `phpinfo()` on the debian8 server, and you'll most likely see it's pointing to a PHP5 installation. — aynber, Jul 18 '16 at 15:59
I think that the problem is that the version of php is no longer used mysql_ — rad11, Jul 18 '16 at 16:00
http://stackoverflow.com/questions/12859942/why-shouldnt-i-use-mysql-functions-in-php?noredirect=1&lq=1 — h0tw1r3, Jul 18 '16 at 16:01

spencer7593 · Accepted Answer · 2016-07-18T16:17:53.083

To correct the error, you've basically got two choices, either

1) modify the code to remove references to the mysql extension (and use mysqli or PDO instead), or

2) install an older version of PHP (before PHP7) which supports the mysql extension

FOLLOWUP:

If what you claim is true... that mysql_ functions are working under PHP7, then the most likely explanation for that is that someone installed a third party module/library that exports mysql_ functions.

I believe there was some work done to build such a library, to provide backwards compatiblity. The library would interact with the database using using the newer PHP mysqli_ functions, and provide (mostly) compatible mysql_ functions for legacy applications.

But that's not part of PHP7. That would be a third party add on.

If someone evil bastard made `mysql_query` work in PHP 7 they're doing us all a huge disservice. It's dead for a reason and everyone should stop using it. — tadman, Jul 18 '16 at 17:10

score 0 · Answer 2 · answered Jul 18 '16 at 15:58

0

PHP 7 has removed mysql_* completely. Use PDO or mysqli

answered Jul 18 '16 at 15:58

marcozipsp

49
4

score 0 · Answer 3 · edited Jul 18 '16 at 18:32

0

The mysql_connect function was deprecated in version 5.5 and completely removed in 7.0.

You'll need to use mysqli or PDO.

edited Jul 18 '16 at 18:32

kenorb

137,499
74
643
694

answered Jul 18 '16 at 15:59

Stephen Fox

87
1
10

PHP Fatal error : Call to undefined function mysql_connect()

3 Answers3

Linked