Build simple array using php as function

Виконано Опубліковано %project.relative_time Оплачується при отриманні
Виконано Оплачується при отриманні

Here is what I need.

PHP Script that gets all tables.

Columns for each table

and Primary keys (all Primary Keys) for each table

the datatype of each primary key

stores them in an array

and then outputs them into a text file in an easy to read text file that makes sense to the reader, i.e.

Table1

Columns from table1

Primary Keys for table1 and Datatype beside primary key

Table2

Columns form table2

Primary keys for table2 and Datatype beside primary key

etc...

There are a few small exceptions I need,

First of all I don't want the table "Updates" listed.

Nor do I want any table that starts with the characters "phpplayers"

Nor do I want any table listed that is actually a view, they are named with a "v_" at the beginning of the name. (VT_ is fine however)

nor do I want any columns of datatype "datetimestamp" displayed.

And lastly, I need this as a funtion.

I have included a database dump from the MYSQL database.

Hopefully my instructions are clear and unfortunately I need this as soon as possible so there is only a 24hour time limit. Should be a piece of cake for a good php programmer.

Thanks,

Chris

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Windows

Техніка MySQL PHP Архітектура ПЗ Тестування ПЗ

ID Проекту: #3621699

Про проект

4 заявок(-ки) Дистанційний проект Остання активність Jul 4, 2006

Доручено:

lokeshvvw

See private message.

$42.5 USD за 1 день
(93 відгуків(-и))
5.8

4 фрілансерів(-и) готові виконати цю роботу у середньому за $637511

farroid

See private message.

$850000 USD за 1 день
(90 відгуків(и))
6.9
zeeshannaqvi

See private message.

$850000 USD за 1 день
(29 відгуків(и))
6.0
sandglasssoft

See private message.

$850000 USD за 1 день
(20 відгуків(и))
3.3