Call to undefined function mysql connect

Question

I just installed PHP and Apache on my home PC  When I try to call function mysql connect I get   fatal error  call to undefined function mysql connect    I have loaded php ini where I have uncommented lines extension php mysql dll and  extension php mysqli dll and changed extension directory to extension dir    C  php ext  - which is the directory where files php mysql dll and php mysqli dll are  How can I fix this problem   Output of phpinfo    http   jsfiddle net MMTwA

User · Answer

After change our php ini  make sure to restart Apache web server

User · Answer

Just for future reference  copying all these extension files to Windows System or Windows System32 is unnecessary   All that is required is a copy of the php ini file you edit in the PHP dir to copied to the root Windows dir   phpinfo will clearly explain the below  Configuration File  php ini  Path   C  Windows   Logical sense will explain that php wants to load a config located in the Windows dir   -

User · Answer

Since mysql connect 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   by default xampp does not load it automatically   in your php ini file you should uncomment      extension php mysql dll   to   extension php mysql dll   Then restart your apache you should be fine

User · Answer

Hi I got this error because I left out the ampersand   amp   in    php ini error reporting   E ALL  amp   E DEPRECATED

User · Answer

This same problem drove me nuts  Windows 10  Apache 2 4  MySql 5 7   For some reason  likely PATH related   the  dlls would not load after uncommenting the correct exension dlls and extension dir    ext  in php ini  After trying numerous things  I simply changed  ext  to use the full directory path  For example  extension dir    c  phpinstall ext  and it worked

User · Answer

You have probably forgotten to restart apache wamp xamp whatever webserver you use  you need to do that in order to make it work

User · Answer

I think that you should use mysqli connect instead of mysql connect

User · Answer

Check your php ini  I m using Apache2 2   php 5 3  and I had the same problem and after modify the php ini in order to set the libraries directory of PHP  it worked correctly   The problem is the default extension dir configuration value   The default  and WRONG  value for my work enviroment is     extension dir  ext    without any full path and commented with a semicolon   There are two solution that worked fine for me   1 - Including this line at php ini file  extension dir  X   PathToYourPHPDirectory  ext   Where X  is your drive letter instalation  normally C  or D      2 - You can try to simply uncomment  deleting semicolon  Include the next line at php ini file  extension dir  ext    Both ways worked fine for me but choose yours  Don t forget restart Apache before try again   I hope this help you

User · Answer

After looking at your phpinfo   output  it appears the mysql extensions are not being loaded  I suspect you might be editing the wrong php ini file  there might be multiple copies   Make sure you are editing the php file at C  php php ini  also check to make sure there is no second copy in C  Windows    Also  you should check your Apache logs for errors  should be in the  logs  directory in your Apache install   If you haven t read the below  I would take a look at the comments section  because it seems like a lot of people experience quirks with setting this up  A few commenters offer solutions they used to get it working   http   php net manual en install windows extensions php  Another common solution seems to be to copy libmysql dll and php mysql dll from c  PHP to C  Windows System32

User · Answer

Background about my  similar  problem   I was asked to fix a PHP project  which made use of short tags  My WAMP server s PHP ini had short open tag   off   In order to run the project for the first time  I modified this setting to short open tag   off   PROBLEM Surfaced  Immediately after this change  all my mysql connect   calls failed  It threw an error      fatal error  call to undefined function mysql connect    Solution  Simply set short open tag   off

User · Answer

Be sure you edited php ini in  php folder  I lost all day to detect error and finally I found I edited php ini in wrong location

User · Answer

My PC is running Windows 7  Apache 2 2  amp  PHP 5 2 17  amp  MySQL 5 0 51a   the syntax in the file  httpd conf   C  Program Files  x86  Apache Software Foundation Apache2 2 conf httpd conf  was sensitive to slashes   You can check if  php ini  is read from the right directory  Just type in your browser  localhost index php   The code of index php is the following    lt  php echo phpinfo      gt   There is the row  not far from the top  called  Loaded Configuration File   So  if there is nothing added  then the problem could be that your  php ini  is not read  even you uncommented  extension php mysql dll and extension php mysqli dll   So  in order to make it work I did the following step  I needed to change from  PHPIniDir  c  PHP     to  PHPIniDir  c  PHP   Pay the attention that the last slash disturbed everything   Now the row  Loaded Configuration File  gets  C  PHP php ini  after refreshing  localhost index php   before I restarted Apache2 2  as well as mysql block is there  MySQL and PHP are working together

User · Answer

One time I had a problem while using Off instead of off  And also check the pads one more time    The path has to be exact  Also add the following line to your environmental variable   C  your-apache-path bin  C  your-php-path bin C  your-mysql-path bin   If you are in Windows  right click My Computer  select properties  and navigate to the Advanced tab     is Windows nbsp 7   Click on Advanced system settings first then select the Advanced tab and then Environmental variables  Select PATH and click on Edit  Make a copy of the string in a  txt file for back up  it might be empty --- set your environmental variables    Log out and log back in

[windows] Call to undefined function mysql_connect

Examples related to windows

Examples related to php