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:hollandsath...@tiscali.co.uk]
> Enviada em: quarta-feira, 6 de outubro de 2010 17:27
> Para: sstap...@mnsi.net
> Cc: PHP
> Assunto: Re: [PHP] 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" <sstap...@mnsi.net>
> To: "sueandant" <hollandsath...@tiscali.co.uk>
> Cc: "PHP" <php-general@lists.php.net>
> Sent: Wednesday, October 06, 2010 9:09 PM
> Subject: Re: [PHP] 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
