I have had some success with the evaluation editions of PHPRunner, and PHPMaker. I found dbQwikSite slow and I couldn't get it to work.
PHPRunner is much more expensive than PHPMagic: $200 vs $35. But, it might be worth it. PHPRunner has an "Events" feature. So if I change one value in one field, other fields will automagically be updated. For example if ship one units, and adjust the inventory, I can have it set up to autoincrement the qnt_to_order, and autodecrement the gnt_on_hand.
Anyway, I wondering if anybody had any thoughts on any of these produce. I know some php/mysql. But, I'm no expert.
I'd spend 17 quid (28 us?) and buy a copy of Pakts "Mastering PHPMyAdmin", it has an amazing amount of features that most users never get to figure out.
I have used PMA for 7 years and never knew it could do this stuff, its not a code generator, but you are going to have to learn some sql anyway once you get started - the linked tables features are awesome.
That is an open source programme which helps you manage your databases, its very easy to use, I am responding to this information : "I know some php/mysql. But, I'm no expert.".
There are some advanced features to PhpMyAdmin which are really useful to beginners, but its unlikely that you would come across them unaided. I bought the book partly because I know Pakt (the publisher) make sure that the author, who is generally the person who maintains the project - gets some recompense.
I was very surprised to see how the advanced features could help a newbie. It wont "generate script" (whatever that means). I read your post because I consider myself a PHP Code Generator - and decided to give you my 2c becuase nobody else seems to have an opinion, or cares to share it.
I am sure you will soon outgrow the benefits of a "code generator" and you will have to get your hands dirty in sql at some point, this book is a very good starting point.
I am somewhat familiar with phpmyadmin. Often, on a hosted server, phpmyadmin is the only access to mysql that is available. But phpmyadmin is different from a code generator.
A code generator lets you graphically design a database application, then you generate the code, and upload the code to your host. They provide a very fast, easy way to develop database application. Although, of course, nothing is as flexible as hand-coding your own applications.
Got a copy of MS Access around? that had a tricky tool for designing your schema last time I looked. The PMA outputs your schemas to pdf, which was a new trick for me.
Personally I get a huge sheet of paper and work the whole thing out with arrows and colored pens, it usually takes a few revisions, but once I have done it, it kinda sticks in my head and I never need to look at them again - though I do keep them.
I dont see the need for anything that writes all the kind of " varchar (60) " stuff.... then again I am a bit old.