RES: Class mysqli not found

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

 



Sorry, but it is a class...

C:\php\ext folder has the php_mysql.dll and php_mysqli.dll ?

Alejandro M.S.

-----Mensagem original-----
De: Alejandro Michelin Salomon [mailto:amichelins@xxxxxxxxxxx] 
Enviada em: quarta-feira, 6 de outubro de 2010 17:34
Para: 'sueandant'
Cc: 'php-general@xxxxxxxxxxxxx'
Assunto: RES:  Class mysqli not found

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




[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