SitePoint Sponsor

User Tag List

Results 1 to 6 of 6

Thread: PHP Code Generators

  1. #1
    SitePoint Zealot
    Join Date
    Sep 2005
    Posts
    139
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    PHP Code Generators

    I'm looking to write a fairly simple inventory program, which I would prefer to run on a hosted server. I think I can do it with a code generator.

    Some of the generators I'm looking into include:

    PHP-Peanuts
    AppGini
    dbQwikSite
    PHPMaker
    PHPRunner
    DaDaBik
    WizzyWeb
    Navicat
    PHPMagic
    CodeGenie

    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.

  2. #2
    is_empty(2); foofoonet's Avatar
    Join Date
    Mar 2006
    Posts
    1,000
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.

  3. #3
    SitePoint Zealot
    Join Date
    Sep 2005
    Posts
    139
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Pakts "Mastering PHPMyAdmin" ? I'm not quite sure what you mean.

  4. #4
    is_empty(2); foofoonet's Avatar
    Join Date
    Mar 2006
    Posts
    1,000
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Sorry. Its a book about PhpMyAdmin.

    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.

  5. #5
    SitePoint Zealot
    Join Date
    Sep 2005
    Posts
    139
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.

  6. #6
    is_empty(2); foofoonet's Avatar
    Join Date
    Mar 2006
    Posts
    1,000
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Oh righto.

    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.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •