Re: RES: Class mysqli not found

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



phpinfo() includes mysqli in its detailed output:

mysqli
     MysqlI Support enabled
Client API library version mysqlnd 5.0.7-dev - 091210 - $Revision: 300533 $
     Active Persistent Links  0
     Inactive Persistent Links  0
     Active Links  0

     Directive Local Value Master Value
     mysqli.allow_local_infile On On
     mysqli.allow_persistent On On
     mysqli.default_host no value no value
     mysqli.default_port 3306 3306
     mysqli.default_pw no value no value
     mysqli.default_socket no value no value
     mysqli.default_user no value no value
     mysqli.max_links Unlimited Unlimited
     mysqli.max_persistent Unlimited Unlimited
     mysqli.reconnect Off Off

----- Original Message ----- From: "Simon J Welsh" <simon@xxxxxxxxxxx>
To: "Alejandro Michelin Salomon" <amichelins@xxxxxxxxxxx>
Cc: "'sueandant'" <hollandsathome@xxxxxxxxxxxxx>; <php-general@xxxxxxxxxxxxx>
Sent: Wednesday, October 06, 2010 9:43 PM
Subject: Re: RES:  Class mysqli not found


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


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux