RE: [PEAR] Problem creating tables from XML with MDB

From: Date: Thu, 17 Apr 2003 15:37:55 +0000
Subject: RE: [PEAR] Problem creating tables from XML with MDB
Groups: php.pear.general 
Request: Send a blank email to pear-general+get-4920@lists.php.net to get a copy of this message
I tried changing my user id to the root account in the script thinking it might be a db permissions problem, but it still hangs in the browser. I pulled this from my apache error log file: [Thu Apr 17 11:38:21 2003] [error] PHP Notice: mysql_create_db() [<a href='http://www.php.net/function.mysql-create-db'>function.mysql-create-db< /a>]: This function is deprecated, please use mysql_query() to issue a SQL CREATE DATABASE statement instead. in c:\pear\MDB\Modules\Manager\mysql.php on line 143 Other than that, any ideas? BTW, running Apache 1.3.24, PHP 4.3.1, MySQL 4.0.12 on Win 2000 SP3. Thanks Dave -----Original Message----- From: Lukas Smith [mailto:smith@backendmedia.com] Sent: Thursday, April 17, 2003 11:09 AM To: 'Merritt, Dave'; 'Pear General (E-mail)' Subject: RE: [PEAR] Problem creating tables from XML with MDB > From: Merritt, Dave [mailto:Dave.Merritt@ArvinMeritor.com] > Sent: Thursday, April 17, 2003 4:55 PM > > Okay, I corrected my code to use the MDB::loadFile('Manager') and I used > the > reverse_engineer_xml_schema.php to generate a sample xml. When I use the > xml file with my updated code the browser just hangs. > > Dave Merritt > dave.merritt@arvinmeritor.com > > Here's my php code: > > <?php > > require_once('MDB.php'); > MDB::loadFile('Manager'); > > $schema_file='test.xml'; > > $manager=new MDB_manager; > > $dbinfo = array > ( > "phptype"=>'mysql', > "username"=>'pdmweb', > "password"=>'pdmweb', > "hostspec"=>'localhost' > ); > > $manager->connect($dbinfo); Hmm that scripts works perfectly over here. All I changed was the username and password obviously and it created the table and echoed "Good Connection". Are you sure that no other problems might be interfering here? Regards, Lukas -- PEAR General Mailing List (http://pear.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

« previous php.pear.general (#4920) next »