1. Php Mysqli Update

Hi,I'm having some problems loading the mysqli extension in my local installation of PHP and am getting the 'Fatal error: Call to undefined function mysqliconnect' error. I've read around a bit on the internet and have tried numerous things. First things first my current set-up is:Windows 7 Home Premium SP1 64 bitIIS is not disabled - but this is mainly because when I went looking for it I could not find it so suspect Win 7 home premium does not come with it.

Php Mysqli Update

In spite of this point I'm connecting to Apache through port 8080 as I could not get it working through the default port (80?)Apache 2.2.21 (Win 32)PHP 5.2.17 (vc6 thread safe version)MySQL 5.5.19My SQL seems to be running fine as I've been in and run stuff using the command line interface. Also my IDE (JetBrains PhpStorm) has a database connector to allow for control and maintenance of the DB within the IDE. Maccas said:Hi,I'm having some problems loading the mysqli extension in my local installation of PHP and am getting the 'Fatal error: Call to undefined function mysqliconnect' error. I've read around a bit on the internet and have tried numerous things. First things first my current set-up is:Check the php.ini file in 'C:PHP'I have the right path to the extensions folder 'C:PHPext'the semi-colon in front of 'extension=phpmysqli.dll' is removedthe semi-colon in front of the similarly titled 'extension=phpmysql.dll' above is not removedMy setup has both extension=phpmysql.dll and extension=phpmysqli.dll uncommented. Please try it. Mysqli is the 'improved' MySQL library but that does not necessarily mean it replaces the mysql library entirely.I also have a copy of libmysql.dll in the Apache /bin folder.

Make sure you copy that DLL file into your Apache /bin folder. Libmysql.dll is in your PHP folder and make sure you leave a copy there as well.It's been a few years since I installed PHP locally and when I couldn't get it to work I had to make sure I had a copy of the mysql.dll in the Apache /bin folder. That solved the problem. Maccas said:Any other thoughts on what to do (or undo) would be gratefully accepted.1) Restore everything like it should be. Use only PHP's DLL files.2) Uncomment both mysql and mysqli lines in php.ini.3) Copy libmysql.dll from your PHP folder and paste it into your Apache /bin folder while leaving the original copy in the PHP folder.Try that. It worked for me when I had problems.

It may or may not work for you.Also, be sure that if you IIS installed that it is disabled. You can search for ways to do that. If Windows 7 has the Services panel in Control Panel, it should be easy to find. Cheesedude,Thanks for the quick response.

The issue is resolved (yay!) so I thought I'd post a quick summary of what happened so others alighting here might get some help.1) I had a more thorough look for IIS.The stuff I'd found previously told me to look in Services. Type services.msc in the Run. Box off the start menu.

Apparently the entry to look for is World Wide Publishing service (I'm pretty sure I was looking for I was looking for IIS or Internet Information Services previously) and then stop it. Anyway I had neither option listed when I went back and looked.However I then found which says that IIS is not installed by default on Windows 7 Home Premium, Basic or Starter but can be switched on in Control Panel - Programs - Turn Windows Features on or off (on the left hand side). I went here and IIS was there and unchecked (as expected) so I definitely do not have IIS switched on2) Uncommented the “extension=phpmysql.dll” line in php.ini and restarted the apache server. No joy.3) Copied back the original libmysql.dll file from the PHP install files and restarted the apache server and it worked!In summary since I previously had the correct original libmysql.dll file in situ the fix that has enabled this to work (from where I was this morning) is to uncomment the “extension=phpmysql.dll” line in php.ini. I did not need to copy any files over to the /bin folder of Apache.Therefore the things I have different to Kevin’s book in my now working set-up are:. Added “C:PHP” to the PATH environment variable.

Additionally uncommented the “extension=phpmysql.dll” line in php.iniHope this helps others facing the same issue.James. Maccas said:Cheesedude,Thanks for the quick response. The issue is resolved (yay!) so I thought I'd post a quick summary of what happened so others alighting here might get some help.1) I had a more thorough look for IIS.The stuff I'd found previously told me to look in Services. Type services.msc in the Run. Box off the start menu.

Apparently the entry to look for is World Wide Publishing service (I'm pretty sure I was looking for I was looking for IIS or Internet Information Services previously) and then stop it. Anyway I had neither option listed when I went back and looked.However I then found which says that IIS is not installed by default on Windows 7 Home Premium, Basic or Starter but can be switched on in Control Panel - Programs - Turn Windows Features on or off (on the left hand side). I went here and IIS was there and unchecked (as expected) so I definitely do not have IIS switched on2) Uncommented the “extension=phpmysql.dll” line in php.ini and restarted the apache server. No joy.3) Copied back the original libmysql.dll file from the PHP install files and restarted the apache server and it worked!In summary since I previously had the correct original libmysql.dll file in situ the fix that has enabled this to work (from where I was this morning) is to uncomment the “extension=phpmysql.dll” line in php.ini. I did not need to copy any files over to the /bin folder of Apache.Therefore the things I have different to Kevin’s book in my now working set-up are:LIST.Added “C:PHP” to the PATH environment variable.Additionally uncommented the “extension=phpmysql.dll” line in php.ini/LISTHope this helps others facing the same issue.JamesFirst, cheesedude you are great and Maccas you are good in following cheesedude's instructions, and I bet it will help a lot of people. You know I use Apache, MySQL, PHP for almost a year now.

Download instagram untuk blackberry z3. I always confused about their configurations. Today, on top of fixing the problem, I learned one thing when cheesedude instruct you not to copy an extension libmysql.dll from MYSQL install folder to Apache/bin folder rather he instruct you to make a copy of that extension from PHP install folder to Apache/bin folder. That makes sense b.c as cheesedude said MYSQL extensions cannot make PHP works, It is the opposite. PHP makes MYSQL to work with PHP. That is why when I made a copy of an extension libmysql.dll from PHP install folder and pasted it to Apache/bin folder all my web connection and phpMyadmin worked great.

I stuck for the last 24 hrs, but now everything resolved, and I thank you both!!