Hi all,

I need to generate PHP (php >= 5.3) code from MySQL database using PDO.

You will have to use SELECT (...) FROM INFORMATION_SCHEMA (...). More info about INFORMATION_SCHEMA.

The idea is to create a script "[url removed, login to view]" with the following inputs in a form:

- Host:

- Database:

- User:

- Password:

and a submit button that will generate files for all the tables and views of the database supplied.

Data access will be made with PDO.

For each table / view, the generator will generate the following files:

- .[url removed, login to view] : Business class

- [url removed, login to view]: Data access functions

- [url removed, login to view]: Rest full services functions (Slim framework. You don't need to know anything about Slim. The code and documentation are quite clear)

There are 3 different cases. For each case, the generator will generate slighty different code:

- For a table with a unique PK. In this case, the PK always is autogenerated.

- For a table with more than one field as PK. In this case, PK fields are NOT autogenerated

- For a view

The files generated by the script, will be saved in the same directory than [url removed, login to view]

If any error occurs (for example, the file output is used and cannot be overwritten), show a error message in [url removed, login to view]

Optional: Meanwhile the generator is working, show progress information in the generator.php.

See attached file "[url removed, login to view]" and other sample files.

Best regards,

Taidot: MySQL, PHP

Näytä lisää: pdo generator, mysql php pdo generator, php pdo database code generator, php slim framework pdo, php generator mysql pdo, php mysql pdo generator, pdo code generator, php pdo code generator, php mysql pdo code generator, the best php code generator, sample data generator, php in full, php code for, mysql documentation, mysql data access, example of idea generation, create php code, create mysql database using php, best code, access database services, mysql code show info database, slim, php slim, php pdo, pdo

Tietoa työnantajasta:
( 7 arvostelua ) BINEFAR, Spain

Projektin tunnus: #4272555

8 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


php/mysql devloper

€175 EUR 4 päivässä
(98 arvostelua)

Experienced team specializing in open sources like Wordpress, Drupal, Joomla, Open Cart, PHP Frameworks like Yii, Zend, CakePHP, CodeIgniter, Seagull, Symfony and more with latest web trends and standards are ready to Lisää

€200 EUR 7 päivässä
(78 arvostelua)

Hi, Experts team of SEO/Wordpress/PHP/joomla/Drupal developers and designers. Thanks Gaurav

€200 EUR 6 päivässä
(96 arvostelua)

Hello, I have not see any attach doc-file(only php). Regards. Dima

€100 EUR 5 päivässä
(62 arvostelua)

Please check your PM box.

€95 EUR 2 päivässä
(17 arvostelua)

i can do it for you

€250 EUR 7 päivässä
(1 arvostelu)

Hello Sir, We are expertise in latest technologies and we can deliver the project as you required. refer PMB for more details. Thanks

€125 EUR 5 päivässä
(0 arvostelua)

Greetings, Let's start..... We are one of the India's highly skilled web technology experts. We specialize in giving an App idea a concrete shape with a Guarantee of Excellence, Quick turnaround and Cost-effectiven Lisää

€150 EUR 3 päivässä
(0 arvostelua)