Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

sqldatasource dal, wwwxxxenden, convert raid5 to raid 10 mdadm, apache force chunked, nrao wwwxxx, xxxxxdup, procmail change subject header, wwwXxx not20, Wwwxxx.doks sas, linux raid resync after reboot

Links

XODOX
Impressum

#1: Class mysqli not found

Posted on 2010-10-06 22:00:45 by sueandant

------=_NextPart_000_0027_01CB6599.8B520100
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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 =3D "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?
------=_NextPart_000_0027_01CB6599.8B520100--

Report this message

#2: Re: Class mysqli not found

Posted on 2010-10-06 22:09:48 by Steven Staples

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

Report this message

#3: Re: Class mysqli not found

Posted on 2010-10-06 22:26:49 by sueandant

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@mnsi.net>
To: "sueandant" <hollandsathome@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

Report this message

#4: RE: Class mysqli not found

Posted on 2010-10-06 22:31:50 by Jay Blanchard

[snip]
When I run this small program I get a Fatal Error: Class mysqli not
found=20
error message.
[/snip]

Have you run a simple phpinfo(); to see if you have the mysqli module?

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

Report this message

#5: RES: Class mysqli not found

Posted on 2010-10-06 22:33:57 by Alejandro Michelin Salomon

Sueandant :

mysqli is set of functions not a class. The name to connect is =
mysqli_connect
/**
*
*
* @version $Id$
* @copyright 2010
*/
$mysqli =3D 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@tiscali.co.uk]=20
Enviada em: quarta-feira, 6 de outubro de 2010 17:27
Para: sstaples@mnsi.net
Cc: PHP
Assunto: Re: [PHP] Class mysqli not found

Thanks Steve. Here's the php file:

<?php

/**
*
*
* @version $Id$
* @copyright 2010
*/
$mysqli =3D 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=20
error message.


----- Original Message -----=20
From: "Steve Staples" <sstaples@mnsi.net>
To: "sueandant" <hollandsathome@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=20
>> and working. In Apache's config file PHPIniDir is set to "C:\php",=20
>> which is where I unzipped the binary download files, and set =
LoadModule=20
>> php5_module C:\php\php5apache2_2.dll. In php.ini I have uncommented =
the=20
>> mysql.dll and mysqli.dll extensions and set extension_dir =
>> "C:\php\ext\". I have edited the environment variables to include=20
>> C:\php and C:php\ext.
>>
>> I am running Vista Home Premium 32 bit with SP2, Apache 2.2, PHP =
5.3.3=20
>> 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
>=20


--=20
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

Report this message

#6: RES: Class mysqli not found

Posted on 2010-10-06 22:42:12 by Alejandro Michelin Salomon

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@hotmail.com]=20
Enviada em: quarta-feira, 6 de outubro de 2010 17:34
Para: 'sueandant'
Cc: 'php-general@lists.php.net'
Assunto: RES: [PHP] 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 =3D 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@tiscali.co.uk]=20
Enviada em: quarta-feira, 6 de outubro de 2010 17:27
Para: sstaples@mnsi.net
Cc: PHP
Assunto: Re: [PHP] Class mysqli not found

Thanks Steve. Here's the php file:

<?php

/**
*
*
* @version $Id$
* @copyright 2010
*/
$mysqli =3D 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=20
error message.


----- Original Message -----=20
From: "Steve Staples" <sstaples@mnsi.net>
To: "sueandant" <hollandsathome@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=20
>> and working. In Apache's config file PHPIniDir is set to "C:\php",=20
>> which is where I unzipped the binary download files, and set =
LoadModule=20
>> php5_module C:\php\php5apache2_2.dll. In php.ini I have uncommented =
the=20
>> mysql.dll and mysqli.dll extensions and set extension_dir =
>> "C:\php\ext\". I have edited the environment variables to include=20
>> C:\php and C:php\ext.
>>
>> I am running Vista Home Premium 32 bit with SP2, Apache 2.2, PHP =
5.3.3=20
>> 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
>=20


--=20
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

Report this message

#7: Re: RES: Class mysqli not found

Posted on 2010-10-06 22:43:13 by Simon Welsh

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 :
>=20
> mysqli is set of functions not a class. The name to connect is =
mysqli_connect
> /**
> *
> *
> * @version $Id$
> * @copyright 2010
> */
> $mysqli =3D mysqli_connect ("localhost", "root", "woodcote", =
"testDB");
>=20
> if (mysqli_connect_errno()) {
> printf("Connect failed: %s\n", mysqli_connect_error());
> exit();
> } else {
> printf("Host information: %s\n", mysqli_get_host_info($mysqli));
> }
>=20
>=20
> Try adodb lib for php ( http://adodb.sourceforge.net/ ), is great =
layer on top of php db functions.
>=20
> Alejandro M.S.
>=20
> -----Mensagem original-----
> De: sueandant [mailto:hollandsathome@tiscali.co.uk]=20
> Enviada em: quarta-feira, 6 de outubro de 2010 17:27
> Para: sstaples@mnsi.net
> Cc: PHP
> Assunto: Re: [PHP] Class mysqli not found
>=20
> Thanks Steve. Here's the php file:
>=20
> <?php
>=20
> /**
> *
> *
> * @version $Id$
> * @copyright 2010
> */
> $mysqli =3D new mysqli("localhost", "root", "woodcote", "testDB");
>=20
> if (mysqli_connect_errno()) {
> printf("Connect failed: %s\n", mysqli_connect_error());
> exit();
> } else {
> printf("Host information: %s\n", mysqli_get_host_info($mysqli));
> }
>=20
> ?>
>=20
> When I run this small program I get a Fatal Error: Class mysqli not =
found=20
> error message.
>=20
>=20
> ----- Original Message -----=20
> From: "Steve Staples" <sstaples@mnsi.net>
> To: "sueandant" <hollandsathome@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
>=20
>=20
>> 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=20
>>> mysqli. I can access MySql via the prompt. Apache and PHP are =
installed=20
>>> and working. In Apache's config file PHPIniDir is set to "C:\php",=20=

>>> which is where I unzipped the binary download files, and set =
LoadModule=20
>>> php5_module C:\php\php5apache2_2.dll. In php.ini I have =
uncommented the=20
>>> mysql.dll and mysqli.dll extensions and set extension_dir =
>>> "C:\php\ext\". I have edited the environment variables to include=20=

>>> C:\php and C:php\ext.
>>>=20
>>> I am running Vista Home Premium 32 bit with SP2, Apache 2.2, PHP =
5.3.3=20
>>> and MySql Server 5.1.
>>>=20
>>> What have I missed?
>>=20
>> 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)
>>=20
>>=20
>> Steve
>>=20
>=20
>=20
> --=20
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>=20
>=20
>=20
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>=20

---
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=3D81d520e5e





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

Report this message

#8: Re: Class mysqli not found

Posted on 2010-10-06 22:43:40 by Chris H

--00504501690a271edb0491f8d573
Content-Type: text/plain; charset=ISO-8859-1

mysqli is set of functions not a class. The name to connect is
mysqli_connect


mysqli can be used as either a set of functions ( mysqli_connect(..) ) OR it
can be used an an object ( new mysqli(...) ). When used as an object you
just use the various functions as methods.

http://www.php.net/manual/en/mysqli.connect.php


Chris.


On Wed, Oct 6, 2010 at 4:33 PM, Alejandro Michelin Salomon <
amichelins@hotmail.com> 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@tiscali.co.uk]
> Enviada em: quarta-feira, 6 de outubro de 2010 17:27
> Para: sstaples@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" <sstaples@mnsi.net>
> To: "sueandant" <hollandsathome@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
>
>

--00504501690a271edb0491f8d573--

Report this message

#9: Re: Class mysqli not found

Posted on 2010-10-06 22:48:18 by sueandant

Yes, I've run phpinfo() and mysqli is listed in the detailed output.

----- Original Message -----
From: "Jay Blanchard" <jblanchard@pocket.com>
To: "sueandant" <hollandsathome@tiscali.co.uk>; <sstaples@mnsi.net>
Cc: "PHP" <php-general@lists.php.net>
Sent: Wednesday, October 06, 2010 9:31 PM
Subject: RE: [PHP] Class mysqli not found


[snip]
When I run this small program I get a Fatal Error: Class mysqli not
found
error message.
[/snip]

Have you run a simple phpinfo(); to see if you have the mysqli module?

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

Report this message

#10: Re: Class mysqli not found

Posted on 2010-10-06 22:49:11 by sueandant

I've tried this and get the same error message.
----- Original Message -----
From: "Alejandro Michelin Salomon" <amichelins@hotmail.com>
To: "'sueandant'" <hollandsathome@tiscali.co.uk>
Cc: <php-general@lists.php.net>
Sent: Wednesday, October 06, 2010 9:33 PM
Subject: RES: [PHP] 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@tiscali.co.uk]
Enviada em: quarta-feira, 6 de outubro de 2010 17:27
Para: sstaples@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" <sstaples@mnsi.net>
To: "sueandant" <hollandsathome@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


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

Report this message

#11: Re: RES: Class mysqli not found

Posted on 2010-10-06 22:58:50 by sueandant

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@welsh.co.nz>
To: "Alejandro Michelin Salomon" <amichelins@hotmail.com>
Cc: "'sueandant'" <hollandsathome@tiscali.co.uk>;
<php-general@lists.php.net>
Sent: Wednesday, October 06, 2010 9:43 PM
Subject: Re: RES: [PHP] 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@tiscali.co.uk]
> Enviada em: quarta-feira, 6 de outubro de 2010 17:27
> Para: sstaples@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" <sstaples@mnsi.net>
> To: "sueandant" <hollandsathome@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


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

Report this message

#12: Re: RES: Class mysqli not found

Posted on 2010-10-06 23:12:12 by Chris H

--0016e64ca94e2999700491f93bb2
Content-Type: text/plain; charset=ISO-8859-1

Are you doing phpinfo() off the CLI or via apache mod? Is it the same way
you are running the actual script that's calling on mysqli?

On Wed, Oct 6, 2010 at 4:58 PM, sueandant <hollandsathome@tiscali.co.uk>wrote:

> 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@welsh.co.nz>
> To: "Alejandro Michelin Salomon" <amichelins@hotmail.com>
> Cc: "'sueandant'" <hollandsathome@tiscali.co.uk>; <
> php-general@lists.php.net>
> Sent: Wednesday, October 06, 2010 9:43 PM
> Subject: Re: RES: [PHP] 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@tiscali.co.uk]
>> Enviada em: quarta-feira, 6 de outubro de 2010 17:27
>> Para: sstaples@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" <sstaples@mnsi.net>
>> To: "sueandant" <hollandsathome@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
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

--0016e64ca94e2999700491f93bb2--

Report this message

#13: Re: RES: Class mysqli not found

Posted on 2010-10-06 23:18:26 by sueandant

------=_NextPart_000_0118_01CB65A4.65A6E730
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I'm running phpinfo from my browser under localhost.
----- Original Message -----=20
From: chris h=20
To: sueandant=20
Cc: PHP=20
Sent: Wednesday, October 06, 2010 10:12 PM
Subject: Re: RES: [PHP] Class mysqli not found


Are you doing phpinfo() off the CLI or via apache mod? Is it the same =
way you are running the actual script that's calling on mysqli?


On Wed, Oct 6, 2010 at 4:58 PM, sueandant =
<hollandsathome@tiscali.co.uk> wrote:

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@welsh.co.nz>
To: "Alejandro Michelin Salomon" <amichelins@hotmail.com>
Cc: "'sueandant'" <hollandsathome@tiscali.co.uk>; =
<php-general@lists.php.net>
Sent: Wednesday, October 06, 2010 9:43 PM
Subject: Re: RES: [PHP] 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 =3D 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@tiscali.co.uk]
Enviada em: quarta-feira, 6 de outubro de 2010 17:27
Para: sstaples@mnsi.net
Cc: PHP
Assunto: Re: [PHP] Class mysqli not found

Thanks Steve. Here's the php file:

<?php

/**
*
*
* @version $Id$
* @copyright 2010
*/
$mysqli =3D 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@mnsi.net>
To: "sueandant" <hollandsathome@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 =3D
"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




--=20
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=3D81d520e5e





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


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




------=_NextPart_000_0118_01CB65A4.65A6E730--

Report this message

#14: RE: Class mysqli not found

Posted on 2010-10-07 01:36:19 by Tommy Pham

> -----Original Message-----
> From: chris h [mailto:chris404@gmail.com]
> Sent: Wednesday, October 06, 2010 1:44 PM
> To: Alejandro Michelin Salomon
> Cc: sueandant; php-general@lists.php.net
> Subject: Re: [PHP] Class mysqli not found
>
> mysqli is set of functions not a class. The name to connect is
mysqli_connect
>
>
> mysqli can be used as either a set of functions ( mysqli_connect(..) ) OR
it
> can be used an an object ( new mysqli(...) ). When used as an object you
> just use the various functions as methods.
>
> http://www.php.net/manual/en/mysqli.connect.php
>
>
> Chris.
>

Correction: mysqli extension can be implemented as either procedural via
functions or as class objects via
$mysqli = new mysqli('localhost', 'my_user', 'my_password', 'my_db');

Regards,
Tommy


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

Report this message

#15: Re: Class mysqli not found

Posted on 2010-10-07 23:09:39 by sueandant

Hi Steve

I've uninstalled PHP5.3.3 and re-installed PHP5.2.14. Everything now
works!

Best wishes and thanks to everyone for their help and input.

tholland
----- Original Message -----
From: "Steve Staples" <sstaples@mnsi.net>
To: "sueandant" <hollandsathome@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

Report this message