MySQL PHP5 conflict

Question

I upgraded the php on my server. Now when I attempt to connect to the mysql server via php I get the following:

Fatal error: Call to undefined function mysql_connect()

So I ran

sudo yum install php-mysql

This is what I got:

--> Running transaction check
---> Package php-mysql.x86_64 0:5.3.3-40.el6_6 will be installed
 --> Processing Dependency: php-common(x86-64) = 5.3.3-40.el6_6 for package: php-mysql-5.3.3-40.el6_6.x86_64
--> Processing Dependency: php-pdo(x86-64) for package: php-mysql-5.3.3-40.el6_6.x86_64
--> Running transaction check
---> Package php-common.x86_64 0:5.3.3-40.el6_6 will be installed
---> Package php-pdo.x86_64 0:5.3.3-40.el6_6 will be installed
--> Processing Conflict: php56w-common-5.6.17-1.w6.x86_64 conflicts php-common < 5.5.0
--> Finished Dependency Resolution
Error: php56w-common conflicts with php-common-5.3.3-40.el6_6.x86_64
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest

Is there a simple solution to this?

no check your php file, their you're using msql_connect, you should rewrite all places where you see mysql_ . Look for `mysqli` or `pdo` tutorials — davejal, Jan 29 '16 at 18:41
Create a php.ini File On public_html and Type extension=php_mysql.dll; — Rajesh J Nair, Jan 29 '16 at 18:41
As @RajeshJNair already stated, yes there is a simple solution, but it would be moving the problem, to a bigger problem. One you rather not have. — davejal, Jan 29 '16 at 18:46
Not a Bigger Problem at all .... http://stackoverflow.com/questions/1171344/advantages-of-mysqli-over-mysql — Rajesh J Nair, Jan 29 '16 at 18:49

score 0 · Answer 1 · answered Jan 29 '16 at 18:42

0

Create a php.ini File On public_html and Type extension=php_mysql.dll;

and Save

answered Jan 29 '16 at 18:42

Rajesh J Nair

179
10

don't suggest using mysql_ finctions anymore, as it is deprecated and easier for sql injection! – davejal Jan 29 '16 at 18:43
he asked for a quick solution thus why said. @davejal is correct about the security breach – Rajesh J Nair Jan 29 '16 at 18:44
Just because it's a quick solution doesn't mean it's an acceptable solution. – Charlotte Dunois Jan 29 '16 at 18:45
I did this and the mysqli_connect function is still not recognized – user1011332 Jan 29 '16 at 19:05

score 0 · Answer 2 · edited May 23 '17 at 11:52

0

Taken from PHP : Undefined function mysql_connect()

mysql_connect()

has been removed from PHP7, which is used by the newest php version.

Instead, use mysqli_connect() like in this example.

Another method, PDO is also possible (but is coded in a very different way as mysql_connect.)

edited May 23 '17 at 11:52

Community

1
1

answered Jan 29 '16 at 18:42

davejal

6,009
10
39
82

I can see he will just go to mysqli without even using Prepared Statements... – Charlotte Dunois Jan 29 '16 at 18:43
I added the pdo, hopefully he will use that one – davejal Jan 29 '16 at 18:47

MySQL PHP5 conflict

2 Answers2