After years of writing PHP and MySQL forms and queries by hand, I decided enough was enough. I tried copying and pasting (reusing) code, using snippets, and writing generic functions to do some heavy lifting of database interactions but ultimately, it was all time consuming; and not every project is worth the overhead of OOP.
I had tried all the techniques, tips and tricks I could Google, for working more efficiently with forms and database interactions - everything I found was still time consuming. I sat back and thought, "What if I could dump a database on a page and just remove the stuff I don't need? Surely its faster to highlight and delete rather than write it from scratch ..." And so came the birth of my Database Code Generator.
I set out to create a tool that will hook into any database I point it at, evaluate its columns and give me over 100 different options that I can copy and paste into the project without having to write a lick!
This is written in PHP 5 using nothing more than Notepad++!! I hand code everything I do!
I started by creating the backend - a simple "Select All" query that displayed the result in an HTML Table. Worked like a dream! Easier deleting the few columns (query and table) than coding everything else!! I started adding more and more functions as time went on.
Then I made it more universal: DBCG hooks into a database and displays its tables. I select the table I want to work with and then the system grabs the columns from that table. I select what I want the system to generate and click it. Copy and paste the code into the project and I'm done!
This project is under continual development!
I was looking for something like this. I have tried a few other programs before (a lot more expensive like 30X as much!) This is what i needed! I am a moderate coder, this just boasts production time, i can easily edit the code to fit my needs! I am using phpBB for a user management (why renvent the wheel eh?) and so far the integration is going smoothly. There are some things in the database such as user id that i don't want displayed but removing that is much quicker then having to code all this my self! Keep up the great work!