Peruttu

PHP CODE GENERATION FROM DATABASE: PHP, MYSQL, PDO

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 slim framework pdo, php generator mysql pdo, php mysql pdo generator, pdo code generator, php pdo code generator, best php code generator, sample data generator, mysql data access, example idea generation, create php code, best code, access database services, slim, php slim, php pdo, pdo, sample generator, php data table, php table generator, tables generator, php data view, php code sample, rest framework php

About the Employer:
( 7 reviews ) BINEFAR, Spain

Projektin tunnus: #4272555

8 freelanceria on tarjonnut keskimäärin 162 € tähän työhön

neoconcepts

php/mysql devloper

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

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)
6.7
ValueCoders

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

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

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

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

Please check your PM box.

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

i can do it for you

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

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)
0.0
wisknowtechl

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)
0.0