Ben Sgro (ProjectSkyline) wrote:
I suppose I can use PEAR:DB:SQLwhatever, but I'm intimate
what my SQL code and don't want to give it up.
I've mostly worked with ADODB. When I last looked, ADODB was far
ahead of PEAR:DB, but it looks like PEAR:DB has come a long way.
I have a few serio
ant to give it up.
Anyways, thanks again to all!
- Ben
- Original Message -
From: "Paul Houle" <[EMAIL PROTECTED]>
To: "NYPHP Talk"
Sent: Saturday, March 31, 2007 10:05 PM
Subject: Re: [nyphp-talk] Creating database tables when deploying products
Ben Sgro (P
Ben Sgro (ProjectSkyline) wrote:
$sqlStr = "CREATE TABLE admin "
. " (id int(11) NOT NULL auto_increment,"
. " username varchar(64) default '',"
. " password varchar(64) default '',"
. " last_login int(12) default 0,"
k"
Sent: Wednesday, March 28, 2007 2:35 PM
Subject: Re: [nyphp-talk] Creating database tables when deploying products
Hi Ben:
Your oo approach looks nice. If you want to do something really cross
platform, check out PEAR's MDB2 package. Can reverse engineer an existing
table into an
Hi Ben:
Your oo approach looks nice. If you want to do something really cross
platform, check out PEAR's MDB2 package. Can reverse engineer an existing
table into an XML syntax. The XML syntax can then be used to create
tables in any DMBS.
--Dan
--
T H E A N A L Y S I S A N D S O L
Jiju - So you use an .sql file w/the instructions to build the table. Do
you
execute from CL, PHP or
phpMyAdmin. As stated above, I often do not have CL access to a host.
>> statement is in one line. The script issues a source setup.sql to the
>> mysql after connecting to the database.
We us
ss to a host.
Thanks for your suggestions.
- Ben
- Original Message -
From: "Brian Dailey" <[EMAIL PROTECTED]>
To: "NYPHP Talk"
Sent: Tuesday, March 27, 2007 8:05 AM
Subject: Re: [nyphp-talk] Creating database tables when deploying products
If you are depl
If you are deploying databases across multiple systems on a regular
basis (ie: planning on doing it more than once or twice) I recommend you
look into the PHP version of Ant called Phing.
http://phing.info/trac/
Jiju Thomas Mathew wrote:
So my question is ... is what I'm doing ok?
So my question is ... is what I'm doing ok? .. there must be a better way
to do it ... How are you all
doing database table creation for products that need to be deployed on
multiple systems.?
We use a more or less the same method, with one difference, that is the sql
query instead of being e
