http://php.net/manual/en/class.mysqli.php definitely says MySQLi is a class. It looks like PHP was complied without MySQLi support. Does running a phpinfo() show the MySQLi module? On 7/10/2010, at 9:33 AM, Alejandro Michelin Salomon wrote: > Sueandant : > > mysqli is set of functions not a class. The name to connect is mysqli_connect > /** > * > * > * @version $Id$ > * @copyright 2010 > */ > $mysqli = mysqli_connect ("localhost", "root", "woodcote", "testDB"); > > if (mysqli_connect_errno()) { > printf("Connect failed: %s\n", mysqli_connect_error()); > exit(); > } else { > printf("Host information: %s\n", mysqli_get_host_info($mysqli)); > } > > > Try adodb lib for php ( http://adodb.sourceforge.net/ ), is great layer on top of php db functions. > > Alejandro M.S. > > -----Mensagem original----- > De: sueandant [mailto:hollandsathome@xxxxxxxxxxxxx] > Enviada em: quarta-feira, 6 de outubro de 2010 17:27 > Para: sstaples@xxxxxxxx > Cc: PHP > Assunto: Re: Class mysqli not found > > Thanks Steve. Here's the php file: > > <?php > > /** > * > * > * @version $Id$ > * @copyright 2010 > */ > $mysqli = new mysqli("localhost", "root", "woodcote", "testDB"); > > if (mysqli_connect_errno()) { > printf("Connect failed: %s\n", mysqli_connect_error()); > exit(); > } else { > printf("Host information: %s\n", mysqli_get_host_info($mysqli)); > } > > ?> > > When I run this small program I get a Fatal Error: Class mysqli not found > error message. > > > ----- Original Message ----- > From: "Steve Staples" <sstaples@xxxxxxxx> > To: "sueandant" <hollandsathome@xxxxxxxxxxxxx> > Cc: "PHP" <php-general@xxxxxxxxxxxxx> > Sent: Wednesday, October 06, 2010 9:09 PM > Subject: Re: Class mysqli not found > > >> On Wed, 2010-10-06 at 21:00 +0100, sueandant wrote: >>> I'm still fighting a losing battle in my attempts to get PHP speak to >>> mysqli. I can access MySql via the prompt. Apache and PHP are installed >>> and working. In Apache's config file PHPIniDir is set to "C:\php", >>> which is where I unzipped the binary download files, and set LoadModule >>> php5_module C:\php\php5apache2_2.dll. In php.ini I have uncommented the >>> mysql.dll and mysqli.dll extensions and set extension_dir = >>> "C:\php\ext\". I have edited the environment variables to include >>> C:\php and C:php\ext. >>> >>> I am running Vista Home Premium 32 bit with SP2, Apache 2.2, PHP 5.3.3 >>> and MySql Server 5.1. >>> >>> What have I missed? >> >> How are you connecting to the mysql? What does your connection string >> look like from your php file? Can you cut and paste it here for us to >> trouble shoot (if it is the apache->php->mysql connection problem) >> >> >> Steve >> > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > --- Simon Welsh Admin of http://simon.geek.nz/ Who said Microsoft never created a bug-free program? The blue screen never, ever crashes! http://www.thinkgeek.com/brain/gimme.cgi?wid=81d520e5e -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
