In Progress

Mass MySQL update with PHP

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

Skills: Engineering, MySQL, PHP, Software Architecture, Software Testing

See more: used structures, search structures, search string in array, php form search mysql database, php code search mysql database, common string, code for update in php, info update, script update database mysql, mysql add fields, mysql change connection, php table array, mysql search table, update code sql, mysql function update, database connection php, delete mysql tables, script mass, mysql sql function, error connection database, mysql update field, connection php mysql, mysql delete mysql database tables, mysql connection error, mysql search database table

About the Employer:
( 65 reviews ) United Kingdom

Project ID: #2896046

Awarded to:

bramp

See private message.

$7 USD in 14 days
(84 Reviews)
5.1