RE: [PEAR] Problem creating tables from XML with MDB
| From: | Merritt, Dave | 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