Description:
Hi there:
I need a php script that can be used to update many table structures in a single
mysql database simultaneously.
The format of the function should be something like:
function updateDBStructures($dbinfo,$suffix,$process)
$dbinfo will be an array with all the connection & database info
$suffix will be a common string to search for at the end of the table names
(e.g. if my tables are named client1_stuf,client2_stuff etc, I want to set $suffix
to "_stuff" to operate on all tablenames ending in _stuff.
$process will be whatever changes need to be made to each table. The format
of $process I'm not sure of, perhaps you could offer some suggestions, I assume
it could be a SQL statement. However, in the end I want to be able to:
- Add new fields with the correct formats
- Delete a field
- Change the format of a field
Should a table have been manually changed, the function will simply skip that
table without returning an error.
That's all!
Cheers
Chris
Deliverables:
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Complete ownership and distribution copyrights to all work purchased.
Platform:
PHP/MySQL
Must be 100% finished and received by buyer on:
Jan 6, 2003 EDT
Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date.
Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements.
We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation.
If you notice a violation please help out the site and report it. Thanks for your help.
|
live RSS newsfeeds