Undefined function mysql connect

Question

I have ran aptitude install php5-mysql  and restarted MySQL Apache 2   but I am still getting this error      Fatal error  Call to undefined function mysql connect   in  home validate php on line 21    phpinfo   says the  etc php5 apache2 conf d pdo mysql ini file has been parsed

User · Answer

I was also stuck with the same problem of undefined MySQL_connect().I tried to make changes in PHP.ini file but it was giving me the same error. Then I came to this solution where I changed my code from depreciated php functions to new functions.

$con=mysqli_connect($host,$user,$password);

mysqli_select_db($con,dbname); 
//To select the database

session_start(); //To start the session

$query=mysqli_query($con,your query); 
//made query after establishing connection with database.

I hope this will help you . This solution is correctly working for me .

EDIT:

If you upgrade form old php you need to apt-get install php7.0-mysql

User · Answer

Well  this is your chance  It looks like PDO is ready  use that instead   Try checking to see if the PHP MySQL extension module is being loaded    lt  php     phpinfo      gt    If it s not there  add the following to the php ini file   extension php mysql dll

User · Answer

Try    lt  php   phpinfo      gt    Run the page and search for mysql  If not found  run the following in the shell and restart the Apache server   sudo apt-get install mysql-server mysql-client php5-mysql   Also make sure you have all the following lines uncommented somewhere in your apache2 conf  or in your conf d php ini  file  from   extension php mysql so   to  extension php mysql so

User · Answer

I was getting this error because the project I was working on was developed on php 5 6 and after install  the project was unable to run on php7 1   Just for anyone that uses Vagrant with ubuntu nginx  in the nginx directory  etc nginx    there is a directory named  sites-available  which contains a file named like the url configured for the vagrant maschine  In my case was homestead app  Within this file there is a line that says something like       fastcgi pass unix  var run php php7 1-fpm sock    There you can change the php version to the desired for that particular site   Googled this but wasnt really able to find a simple answer that said where to look and what to change   Hope that this helps anyone  Thanks

User · Answer

In case  you are using PHP7 already  the formerly deprecated functions mysql   were removed entirely  so you should update your code using the PDO-functions or mysqli   functions instead   If that s not possible  as a workaround  I created a small PHP include file  that recreates the old mysql   functions with mysqli    -functions  fix mysql inc php

User · Answer

In php ini file  change this    extension php mysql dll   into  extension php mysql dll

User · Answer

If someone came here with the problem of docker php official images  type below command inside the docker container     docker-php-ext-install mysql mysqli pdo pdo mysql   For more information  please refer to the link above How to install more PHP extensions section But it s a bit difficult for me       Or this doc may help you      https   docs docker com samples library php

User · Answer

I see that you tagged this with Ubuntu  Most likely the MySQL driver  and possibly MySQL  is not installed  Assuming you have SSH or terminal access and sudo permissions  log into the server and run this  sudo apt-get install mysql-server mysql-client php5-mysql  If the MySQL packages or the php5-mysql package are already installed  this will update them   UPDATE Since this answer still gets the occasional click I am going to update it to include PHP 7  PHP 7 requires a different package for MySQL so you will want to use a different argument for the apt-get command    Replace 7 4 with your version of PHP sudo apt-get install mysql-server mysql-common php7 4 php7 4-mysql  And importantly  mysql connect   has been deprecated since PHP v5 5 0  Refer the official documentation here  PHP  mysql connect

User · Answer

For CentOS 7 8  amp  PHP 7 3 yum install rh-php73-php-mysqlnd  And then restart apache php

User · Answer

The question is tagged with ubuntu  but the solution of un-commenting the extension mysqli dll is specific to windows  I am confused here    anyways  first thing run  lt   php phpinfo   gt  and search for mysql  under Configuration heading  If you don t see such a thing implies you have not installed or enabled php-mysql  So first install php-mysql   sudo apt get install php-mysql  This command will install php-mysql depending on the php you have already installed  so no worries about the version     Then comes the unix specific solution  in the php ini file un-comment the line  extension msql so   verify that msql so is present in  usr lib php  lt timestamp folder gt   ELSE  extension path to msql so   Then finally restart the apache and mysql services  and you should now see the mysql section under Configrations heading in phpinfo page

User · Answer

My guess is your PHP installation wasn t compiled with MySQL support    Check your configure command  php -i   grep mysql   You should see something like  --with-mysql shared  usr    You can check for complete instructions at http   php net manual en mysql installation php  Although  I would rather go with the solution proposed by  wanovak   Still  I think you need MySQL support in order to use PDO

User · Answer

If you are getting the error as      Fatal error  Call to undefined function mysql connect     Kindly login to the cPanel    Click on Select Php version    select the extension MYSQL

User · Answer

There must be some syntax error  Copy paste this code and see if it works    lt  php      link   mysql connect  localhost    root            if    link            die  Could not connect     mysql error               echo  Connected successfully           I had the same error message  It turns out I was using the msql connect   function instead of mysql connect

User · Answer

Windows mysql config   Step 1   Go To Apache Control Panel   Apache   Config   PHP ini   Step 2   Search in Notepad  Ctrl F  For   extension dir       could be commented with a     Replace this line with  extension dir    C  php ext   please do not you need to remove the   on the beginning of the sentence    Step 3   Search For  extension php mysql dll and remove the   in the beginning    Step 4   Save and Restart You Apache HTTP Server   On Windows this usually done via a UI    That s it      If you get errors about missing php mysql dll you ll probably need to download this file from either the php net site or the pecl php net   Please be causius about where you get it from   More info on PHP  Installation of extensions on Windows - Manual

[php] Undefined function mysql_connect()

Examples related to php

Examples related to mysql

Examples related to ubuntu

Examples related to mysql-connect

Examples related to undefined-function