[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2799
  • Last Modified:

Fatal error Class 'mysqli' not found

The remainder of the error message is the path to one of my PHP classes that uses mysqli

I am perplexed by this because I set the foloowing in my php.ini
extension_dir = "C:\PHP\ext"
extension=php_mysqli.dll
The directory C:\PHP\ext does contain the file php_mysqli.dll

If anybody can help I will be very grateful

I have attached php.ini

Thank you for reading this

Cheers John php.ini
0
johnecollins
Asked:
johnecollins
  • 11
  • 9
  • 8
  • +1
1 Solution
 
Mark BradyCommented:
Have you installed MySQLi?  you must install it before you can use it as it is not part of php or mysql as a standard install.
0
 
Mark BradyCommented:
http://php.net/manual/en/mysqli.installation.php

Go to the link above and scroll down a short distance for the windows instructions.
0
Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

 
Dave BaldwinFixer of ProblemsCommented:
I did not know that.  Every single installation of PHP that I have or use came with 'mysqli' installed and it was enabled in most cases.
0
 
Mark BradyCommented:
I think I read somewhere that it is installed in some packages and not in others. I'm not sure about WAMPSERVER but I know in my LAMP installation it is installed and I use it without having to do anything. I could be wrong but it sounds like mysqli is not installed on his machine.
0
 
Dave BaldwinFixer of ProblemsCommented:
It is possible.  On my Ubuntu machines, I may have installed 'mysqli' myself (thru the package manager) because I would normally do that along with 'mysql'.

See if you have 'libmysql.dll' in your path.  I usually have it in the C:\PHP directory.  Like Ray said, more info here: http://us2.php.net/manual/en/mysqli.installation.php
0
 
johnecollinsAuthor Commented:
Hi elvin66,Ray and Dave,

Thank you all very much for your help with this solution waiting to happen - on the upbeat all of the time ;-)

Dave, I'm with you, in my great wealth of experience - 2 download it run it get going no stress at all now a third of my installations have failed on me, sigh sigh with my newly found experience that the next one will be only 1 in 4 - I've always been an optomist

Elvin66, yours is the sort of comment it is good to receive because it sets you off on the great solution trail

Ray, it's been sooooo long since we last talked

I shall have a read of the information you have sent thank you all very much

John
0
 
Dave BaldwinFixer of ProblemsCommented:
I just noticed in your original question that you have Apache and the web root installed in directory with spaces in the path.  That can cause problems with some PHP extensions and possibly some Apache modules.  All-in-0ne installations like WAMP and XAMPP make sure they do not do that.
0
 
johnecollinsAuthor Commented:
Dave,

Cheers for that, C:\Program Files\ is embedded throughout the system,  but I need to make sure I delimit directory references like that, with quotes. But a good point and somethinng to watch for.

on sitepoint.com I got pointed to a typos page for Kevin Yank's book "BUILD YOUR OWN
DATABASE DRIVEN WEB SITE USING PHP & MYSQL"some of it relating to PHP 5.3, so I am reviewing that at the moment and hope it will help thanks for the thought

John
0
 
Mark BradyCommented:
Ahh yes sitepoint has some excellent books. I bought Luke Welling/Laura Thomson's PHP and Mysql Web Development and it is the most excellent book.
0
 
johnecollinsAuthor Commented:
Dear All,

I have tried very hard to try and solve this and searched a lot of places and if you google Class 'mysqli' not found there are or have been many people trying to overcome this problem.
Could i ask one of you to try something for me because I am away from and I don't have access to a windows php/apache/mysql machine that I know worked - the problem appears to be PHP 5.3 not built with mysqli extensions. If you have something that works could you please run phpinfo() in a page and see if there is a reference to mysqli in phpinfo() output.

this may generate some clues about what to do

Thank you very much

Off to bed now need  a rest from it now

Cheers for now

John
0
 
Dave BaldwinFixer of ProblemsCommented:
This is from my XAMPP install with PHP 5.3.5.
XAMPP-phpinfo.jpg
0
 
Dave BaldwinFixer of ProblemsCommented:
More info here: http://dev.mysql.com/downloads/connector/php-mysqlnd/ 

"The MySQL native driver for PHP is an additional, alternative way to connect from PHP 5.3 or newer to the MySQL Server 4.1 or newer. It is a replacement for the libmysql, the MySQL Client Library. As of PHP 5.3 you can use ext/mysql, ext/mysqli and PDO_MYSQL either together with libmysql as you did in the past or with mysqlnd."
0
 
johnecollinsAuthor Commented:
Dave,

Good morning, thank you for running that it has given good clues about what I can expect when it works and some alternatives as well.

Cheers

John
0
 
Dave BaldwinFixer of ProblemsCommented:
Did you install PHP by itself or in one of the all-in-one installations like WAMP or XAMPP?
0
 
johnecollinsAuthor Commented:
Dave,

I have read the doc and it looks very interesting , there's mynext step after breakfast

Once again thanks

John
0
 
johnecollinsAuthor Commented:
Hi All,

I have been trawling the net and not progressed ar all.

I said to myself smile it can't get any worse. I did and it did, netbeans 7.0.1 now won't run the PHP scripts even the one that has no MySQL. Oh dear

I shall have to try another question

John
0
 
Dave BaldwinFixer of ProblemsCommented:
XAMPP is one of the recommended ways to use Netbeans: http://netbeans.org/kb/docs/php/configure-php-environment-windows.html
0
 
Mark BradyCommented:
johncollins - I think it might be getting to that time. You know, the time when you say "buger this!" and uninstall your server after backing it up. Take off the whole WAMP package would be the best bet. Download and install the latest package and you should be able to use mysqli right out of the box.

I recently ugraded to the latest UBUNTU 11.1 and as it was a major upgrade from my old version around 9.0 or somewhere, it was a total rebuild on my system so I downloaded and reinstalled xamp. I can use mysqli in my php scripts and it works perfectly and I did not modify my php.ini like you used to have to do .... uncomment the line mysqli.dll  (something like that).

And, if you a feeling really brave, why not install Ubuntu and get rid of windows altogether! or dual boot windows/ubuntu. Once you go Linux you'll never have those windows problems again.

Seriously, if you download the latest Xamp I'm sure you will be able to use Mysqli extensions.
0
 
johnecollinsAuthor Commented:
elvin66,

I am long past being sensible but I will draw the line before I install Linux  -- er this weekend that is ;-)

I had downloaded Apache, MySQL and PHP so I am admitting defeat and uninstalling those.

You mention XAMP  I can only find WAMP should worry ??

I am on Windows XP btw

John
0
 
Mark BradyCommented:
Absolutely not! WAMP is for windows installation only and XAMP is for MAC installation so I use UBUNTU which uses LAMP or LAMPSERVER. If you are using windows you need to install the WAMP package. that will install Apache server, PHP, MYSQL and PhpmyAdmin all in one install. You should be able to use mysqli straight out of the box once you install this full package.

Settingup
Php, Mysql, and Apache all separately takes a lot of configuration and that could be where you are having problems. The installer for WAMP will install all of these packages for you in one hit and should ask you to set a root password and a couple of other questions. It's very easy to setup and get running. Once installed, it will put Wampserver into your task tray so you can click on it to open the mini-menu. On there it has a link to start all services, you can go to PhpmyAdmin or edit the config settings. You should select the option to start WAMP when windows starts to save you having to select it each time.

So in brief

XAMP = Mac only
MAMP = Mac only - same as XAMP for the most part
LAMP = Linux (Ubuntu and others)
WAMP = Windows only - this is the one you need to download. The link is

http://www.wampserver.com/en/download.php

I would recommend downloading the "alpha" version as it will be very stable with no bugs. If you are feeling lucky and want the absolute latest features then one of the beta versions will be for you but for safety, go with alpha (Wamp Server 2.2a)

If you have any questions installing it just ask. Not that I use windows but I do have a dual boot with Ubuntu and Windows 7 on one laptop and the windows 7 has WAMP server installed. Never have any problems using the server.

Just for fun, and to make some of you MAC users throw up, I also have taken my brand new Mackbook Pro laptop and installed Ubuntu on it on a windows partition so I mainly use Ubuntu for working (developing) and use the Mac for recording (I am a musician/singer/songwriter) so do a lot of recording stuff which the mac is the best in. Just a bit of useless information lol.

Have fun
0
 
Dave BaldwinFixer of ProblemsCommented:
XAMP = Mac only = Wrong.  

http://www.apachefriends.org/en/xampp.html

For Linux, Windows, Mac OS X, and Solaris.  I have XAMPP on Windows XP here and WAMP on another one.  And Ubuntu 8.04 LTS on two other computers... and and and ....

It is also the one recommended by Netbeans.  http://netbeans.org/kb/docs/php/configure-php-environment-windows.html
0
 
Dave BaldwinFixer of ProblemsCommented:
And John, you could look at the Netbeans link I posted (3 times).
0
 
johnecollinsAuthor Commented:
elvin66,

thanks for the explanation most helpful, everything uninstalled, going for wamp now, will report back

sitepoint is an axcellent site and pointed me at css and javascript courses on learnable so one of these I should learn enough to be able to do something ;-)

Liked your comments about MAC perhaps one of these days I'll  have a go at ubuntu

we'll see

thanks

John
0
 
Mark BradyCommented:
I stand corrected about Xamp - one one of the sites I went to it stated it was for MAX OS hence my comment. However I have not used XAMP on any machine only MAMP, WAMP and LAMP
MAMP is installed on my Mac
LAMP on the mac booted into UBUNTU
WAMP on my windows 7 laptop.

All versions run perfectly and there was no setup issues of major confirguration problems. I also use Netbeans on the mac with MAMP server with no problems.

John, Sitepoint is an excellent source for great learning material and if you can go to your library and borrow a book called "PHP and Mysql Web Development" by Luke Welling you will learn how to setup a server properly and it has a crash course in PHP, a course in MYSQL and loads of other very usefull information. I got more from this book than 2 years reading online tutorials.
0
 
johnecollinsAuthor Commented:
Elvin66,

Thanks for the tip on the book when I get back home again I'll search the library.

John
0
 
johnecollinsAuthor Commented:
I have decided with the help and support of all three of you to uninstall PHP Apache and MySql and download and install wamp. Otherwisw I can't see me working again as attractive as that sounds, I won't be able to afford to try and learn golf or sit bars chatting to young ladies so I have to work.

I am awarding the points for this question to elvin66, but the other question I have about netbeans to Dave Baldwin, Ray they also serve, who stand and stare - I suspect that I have the quote completely mangled and now it means the complete opposite sigh sigh

So thank you all three of you

John
0
 
johnecollinsAuthor Commented:
Thanks
0
 
Mark BradyCommented:
You're welcome and good luck with the install.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 11
  • 9
  • 8
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now