Re: mysql.php - create database issue

I agree that the behavior you describe is a bug. I can't seem to reproduce this error from the CVS version of the DB class, nor from the latest release of the DB class. I can reproduce the problem from the 4.2.2 install. It's possible that this has been fixed already. From the CVS repository, I see: Tue Jun 18 20:41:06 2002 (2 months ago) Allow connect/use the MySQL driver without specifying any database as v1.5 of the mysql.php distribution. I suppose that it's possible that it didn't make it into the 4.2.2 release which was about a month later. Go ahead and download the latest release of the DB module (v 1.3) and that should correct your problem. eric On Tue, 20 Aug 2002 george@mail.zoomedia.com wrote: > Hi, > > If I create a DSN and try to use PEAR to create a new MySQL database using > code like this: > > <? > INI_SET('include_path', ".:/usr/local/lib/php"); > require_once('DB.php'); > $db = DB::connect("mysql://user:password@localhost"); > $sql="create database mydatabase"; > $result = $db->query($sql); > if (DB::isError ($result)) die ("Error... :" . $result->getMessage () . > "\n"); > ?> > > I get the error: 'No Database Selected' > > This seems to be the case with the following version of DB/mysql.php: > mysql.php,v 1.89.2.1 2002/04/09 19:04:14 > > which I think is the version that ships with PHP 4.2.2 > > However, if I use a version of DB/mysql.php from an earlier distro such > as: > mysql.php,v 1.69.2.3 2001/11/13 01:26:42 > > it works just fine. > > Obviously, the problem is that the newer version is complaining that I > haven't specified a database in my DSN. However, the older version seems > more forgiving in this respect, and the newer functionality is arguably > buggy because the PEAR code is basically an abstraction for the following > native MySQL code: > > <? > mysql_connect("localhost","user","password"); > $sql="create database mydatabase"; > mysql_query($sql); > ?> > > Notice, no mysql_select_db() call was needed for the above to work, nor > should such a call be required when the action is not database dependent > (like CREATE DATABASE) > > Any thoughts on whether mysql.php should be modified to work the way it > used to? > > Regards, > George Mandella > george at zoomedia dot com > > > -- > PEAR General Mailing List (http://pear.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >