mysql_connect works; DB::connect doesn't

[lwoods]

When I execute the following script I can connect using 'mysqli_connect' but
I get a "DB Error: Not Found" when I display the $db->Message() after
attempting the DB::Connect.

And, "yes", the "restaurant" database does exist.

Where should I start looking?

PHP 5.0.4 / mySQL 4.1.13-nt / IIS / XP Pro

TIA,

Larry Woods
<?php
require 'DB.php';
$db=mysqli_connect('localhost','root','xxxx','rest aurant');
if (! $db ) {
die("Can't connect: ".mysqli_connect_error());
}
else {
echo "Connection successful!<br/>";
mysqli_close($db);
}
$db=DB::connect('mysql://root:xxxx@localhost/restaurant');
if (DB::isError($db)) {
die($db->getMessage());
}
else {
print "\$db connection was successful!";
}
?>

[Justin Koivisto]

lwoods wrote:

When I execute the following script I can connect using 'mysqli_connect' but
I get a "DB Error: Not Found" when I display the $db->Message() after
attempting the DB::Connect.

And, "yes", the "restaurant" database does exist.

Where should I start looking?

PHP 5.0.4 / mySQL 4.1.13-nt / IIS / XP Pro

TIA,

Larry Woods
<?php
require 'DB.php';
$db=mysqli_connect('localhost','root','xxxx','rest aurant');
if (! $db ) {
die("Can't connect: ".mysqli_connect_error());
}
else {
echo "Connection successful!<br/>";
mysqli_close($db);
}
$db=DB::connect('mysql://root:xxxx@localhost/restaurant');
if (DB::isError($db)) {
die($db->getMessage());
}
else {
print "\$db connection was successful!";
}
?>

When using mysqli_* try also mysqli_select_db and mysqli_query to see if
there are any odd errors there. Your dsn looks fine, and you check for
an error the correct way for a PEAR package, but I don't use DB, so the
only other suggestion I would have is to print_r the $db var if it is an
error and inspect the other properties. Sometimes the PEAR::Error object
holds more information than what is returned in getMessage (FME, anyway)

[lwoods]

Thanks, Justin,

I'll play around with it a little more but I think your way is best: Don't
use DB!

Larry

"Justin Koivisto" <ju****@koivi.com> wrote in message
news:HU*****************@news7.onvoy.net...

lwoods wrote:

When I execute the following script I can connect using 'mysqli_connect' but I get a "DB Error: Not Found" when I display the $db->Message() after
attempting the DB::Connect.

And, "yes", the "restaurant" database does exist.

Where should I start looking?

PHP 5.0.4 / mySQL 4.1.13-nt / IIS / XP Pro

TIA,

Larry Woods
<?php
require 'DB.php';
$db=mysqli_connect('localhost','root','xxxx','rest aurant');
if (! $db ) {
die("Can't connect: ".mysqli_connect_error());
}
else {
echo "Connection successful!<br/>";
mysqli_close($db);
}
$db=DB::connect('mysql://root:xxxx@localhost/restaurant');
if (DB::isError($db)) {
die($db->getMessage());
}
else {
print "\$db connection was successful!";
}
?>

When using mysqli_* try also mysqli_select_db and mysqli_query to see if
there are any odd errors there. Your dsn looks fine, and you check for
an error the correct way for a PEAR package, but I don't use DB, so the
only other suggestion I would have is to print_r the $db var if it is an
error and inspect the other properties. Sometimes the PEAR::Error object
holds more information than what is returned in getMessage (FME, anyway)

[Justin Koivisto]

lwoods wrote:

Thanks, Justin,

I'll play around with it a little more but I think your way is best: Don't
use DB!

I've actually been using MDB, but when I finally get a production server
with php5, I will have to check out sqllite to see if what I've been
doing with databases can all be accomplished with that. If that is the
case, then I'll get rid of abstraction all together since it will be
portable enough for my case.

--
Justin Koivisto, ZCE - ju****@koivi.com
http://koivi.com

[lwoods]

I'm going the sqlite direction myself because most of my databases are not
that complex. Also, the price is right...and it's installed everywhere php5
is installed.

Larry

"Justin Koivisto" <ju****@koivi.com> wrote in message
news:3g*****************@news7.onvoy.net...

lwoods wrote:

Thanks, Justin,

I'll play around with it a little more but I think your way is best: Don't use DB!

I've actually been using MDB, but when I finally get a production server
with php5, I will have to check out sqllite to see if what I've been
doing with databases can all be accomplished with that. If that is the
case, then I'll get rid of abstraction all together since it will be
portable enough for my case.

--
Justin Koivisto, ZCE - ju****@koivi.com
http://koivi.com

[Marcin Dobrucki]

Two things:

1) your DSN for the DB should be:

'mysqli://root:xxxx@localhost/restaurant'

(see details on:
http://pear.php.net/manual/en/packag....intro-dsn.php)

2) You probably want to do this instead:

$db =& DB::connect(....);

There is little point copying the object.

And don't get discouraged. DB works very well indeed, and will allow
you to switch your DB at any point later (unlike using the mysqli...
methods).

/Marcin

lwoods wrote:

When I execute the following script I can connect using 'mysqli_connect' but
I get a "DB Error: Not Found" when I display the $db->Message() after
attempting the DB::Connect.

And, "yes", the "restaurant" database does exist.

Where should I start looking?

PHP 5.0.4 / mySQL 4.1.13-nt / IIS / XP Pro

TIA,

Larry Woods
<?php
require 'DB.php';
$db=mysqli_connect('localhost','root','xxxx','rest aurant');
if (! $db ) {
die("Can't connect: ".mysqli_connect_error());
}
else {
echo "Connection successful!<br/>";
mysqli_close($db);
}
$db=DB::connect('mysql://root:xxxx@localhost/restaurant');
if (DB::isError($db)) {
die($db->getMessage());
}
else {
print "\$db connection was successful!";
}
?>