PHP Scaffold Generator
UPDATE:
—————
I have done a little reworking of the scaffold generator, you can still download it here. I made a new built in search functionality and took out the status page, now there is just a notice on the main listing page after you take an action. I also cleaned the code up a bit. And since I was called a lazy bastard here is a simple demo. Play with that all you want and tear apart the code.
—————-
Here is a little tool I created for myself when building or working on MySQL databases. It is a scaffold generator similar in functionality to the Ruby on Rails generator and only needs to know how to connect to your database to get up and running. It creates a CRUD (Create, Read, Edit, Delete) admin system for your databases. There are no config files or any of that to mess with. I find it pretty handy and thought I would share it since it is a pain to manually code forms and functionality when you change a field name or add a few fields. It works in PHP 4.3 and up, so pretty much on any server..(although I have no idea about 6.0 when it comes out).
Some basic database structure is assumed for the scaffold to run smoothly..
- Table names are all plural and lowercase.
- Primary keys are all named ‘id’.
- Field names are lowercase and can be underscored .. ie-> ‘first_name’.
- Timestamps named ‘created_at’ and ‘updated_at’ cannot be edited, they will be updated automatically.
- Foreign keys are named as {table_name_singluar_id}, so.. ‘author_id’ references table ‘authors’, ‘book_id’ references table ‘books’, ‘category_id’ references table ‘categories’ and so on.
- Foreign key tables also ARE ASSUMED TO have a field ‘name’.
- Special case for odd plurals can be put in the configuration so ‘person_id’ can reference table ‘people’.
All the details are in the file.
Some nice features of the scaffold..
- Automatically build drop down menus for foreign keys.
- Automatically assign foreign key relationship between singular ‘_id’ and plural table name.. category_id relates to categories and so on.
- Create custom plurals.. ie-> person_id for people
- Limit what is displayed on the listing page.
- Set record count for pagination.
- Set listing table width to drop into a page layout.
- Automatically create reader friendly names from the underscores
All you have to do is include this file on your page
<?php include("path_to/scaffold.php"); ?>
and create the scaffold.
<?php new Scaffold("TABLE_NAME"); ?>
This will setup a fully functional admin system. Throw in a simple stylesheet like this and wrap the scaffold in a centered div and you can pass it off as a custom built system!
body {
margin:2em;
font-family: arial, veranda, helvetica, san-serif;
font-size:1em;
color:#333;
}
You can also call the scaffold like this to set up a custom listing page.
<?php new Scaffold("TABLE_NAME", 10, array('fields', 'that', 'will', 'show'), FALSE, 400); ?>
This will generate listings for your table with 10 records per page, only show the fields you sent in the array, will turn off html safe display and make your table width 400.
Download the PHP Scaffold Generator and feel free to use it how ever you wish. It is licensed under the Creative Commons License so just keep the original credit in tact. Let me know of any suggestions or problems.
Related Articles:
It’s nice, but I think there are too many database structure requirements. Any ways it was interesting to test your script and to read your code. As a suggestion, instead showing the message “Back To Listings” may be you can redirect automatically to the listing page and show the message “Record Modified” there.
For instance add to the line 275:
header(”Location: “.$_SERVER[’PHP_SELF’].”?message=record_added”);
Then do something like if ($_REQUEST[’message’]==’record_added’) {….new record….}
p.s. Get rip of spaces in order to avoid errors like Warning: Cannot modify header information
@Master Employment
I know most don’t like any restrictions on the database, but I feel it is a good trade off for ease of use.. really the only requirements are having the table names plural and the foreign keys named for the singular table name with and ‘_id’ on the end. It’s a pretty common construct anyway..
I had it set to redirect in the code just by calling list_table(’your message here’), but i decided against it in case there was a field name conflict in the db.. I’ve got a workaround in my head right now actually.. just hit me.
I use this to quickly set up a backend and it has worked well for me. I thought it might be of use to some others especially if they are developing the dbs as they go, then there is no need to modify admin code. And it works great for plain dbs.
Once the dbs get too complicated of course you will probably want something else to handle things.
Thanks Nick, for your script and feedback.
Although I have some ideas to make it more interesting, I think your tool is good, I like it. Probably I am going to use it today
Let me know if you want to know more of my thoughts
Have a nice day, your blog is added to my bookmarks.
How about making a demo you lazy bastard.
[…] an observation from the past 2 days.. My last post, the PHP Scaffold Generator got ‘StumbledUpon’ and within an hour I had 500 site visits. Not too shabby at all. […]
Paxil gad message boards
3d hentai games
Cardinal games
Free anime hentai games adult media
Free mobile java games sites
Free shower games pages
Free 56k internet access
Internet marketing toronto
Loteria primitiva internet
Wireless internet laptop
Miramar real estate
O fallon real estate
Playa del rey real estate
Real estate appleton wi
Real estate in neptune nj
Real estate monument colorado
Redondo real estate
Tawas bay real estate listings
Urban economics and real estate markets
Aberrometer new york
Auto glass repair new york
Bonita daily news
Buy new honda truck
Cheap new balance shoes
Craigslist new haven
Dog friendly areas in new england
Fairbanks daily news
Fox news memphis
Free female masterbation movies
Columbus new car loan
Government loan grants school
Zenerx message valentine’s added confident
Valentine in the morning station
Valentine jigsaw puzzle
Valentine lessons
Valentine light sculptures
Valentine magic
Valentine mice
Valentine ne tucson az
Valentine nebraska romantic gift idea
Valentine party planning
Valentine brownie recipe
Valentine capitol
Valentine card s
Valentine cards for kids printable
Valentine charade
Valentine cllip art
Valentine cookie bouque
Valentine crafts and game for kid
Valentine cupcakes for kid
Valentine cut out cookie recipes
Boyfriend valentine gift
Brooke gallery valentine
Brooke valentine girlfight mp3 download
Bullet floor hit lyric valentine
Bullet for my valentine given up
Bullet valentine
Cadeau de saint valentine
Camwithher valentine bath
Card child make valentine
Card dad e free valentine
Origin of valentine’s day
Paint shop pro tubes valentine
Personalised gift for valentine day
Personalised valentines day gifts
Picture pooh valentine
Poems for boyfriends on valentines day
Portugese valentine poems
Preschool valentines day poems for parents
Purple ronnie valentines
Day flag valentine
Day funky gift man valentine
Day gift man romantic valentine
Day happy screensaver valentine
Day history site valentine
Day inspirational poem valentine
Day party throwing valentine
Day teacher valentine worksheets
De dia rimas san valentine
Decoration heart valentine
Card day free greeting print valentine
Card e free humor valentine
Card e free valentine xxx
Card free st valentine
Care bear printable valentines day cards
Cartes saint valentine virtuelles
Charlie brown valentine
Cheap gifts for valentines day
Child valentine coloring
Children’s valentine’s day events
Chloe valentine
Choldrens menus for valentines day
Christian valentines jokes
Church valentines tea
Clever valentine gifts
Colorado valentines day
Cookie easy recipe valentine
Cookies delivery valentine’s day
2006 air day force valentine
2006 day horoscope valentine
A fun foam bunny valentines box
Activity day science valentine
Adult email valentine card
America valentine paper
Arrangement flower rose valentine
Art collector michael valentine
Awesome valentines gifts for her
Bad poem about valentine day
Free glitter graphic valentine
Free online anti valentines ecards
Free printable valentine cards
Free quiz valentine
Free valentine border clipart
Free valentine day card friends
Free valentine day font
Free valentine letterheads
Free valentine print and color card
Free valentine’s day mailbox crafts
Games for teen sleepovers
Keyboarding games
Newgrounds games
Free valentine’s day projects
Free valentines party ideas
Free victorian era valentines wallpaper
Fun facts about valentine’s day
Fun valentine gift for him
Funny light hearted valentines
Funny valentine flash cards
Funny valentines quotes
Garfield valentines wallpaper
Geometry valentines poems
Gift golf valentine
Gift guy teen valentine
Gifts for mom for valentines day
Gifts men valentines day
Good ideas for valentines day presents
Gothic valentines e card
Great valentine present
Hallmark best valentine
Happy bunny valentine
Happy valentine day color pages
Happy valentine’s day in polish
Heading letter valentine
Heart saying valentine
Hilarious valentine ecards
History of valentine’s day and valentinus
Humorous valentine limericks
I love you poems for valentines
Image site valentine
Instructions valentine favors
Intimate valentine gifts
Iran valentine
Jill valentine doujinshi
John valentine hinckley
Jumbo valentine cards
Kemp valentine
Quick free thoughtful valentine’s gifts
Recipe for valentine chocolate candy
Regalos para dia de san valentine
Sailors valentine gallery nantucket
School valentine party game idea
Search valentine word
Send valentine card free
Shannon valentine email addresses
Simpson valentine
Email valentines day songs
Engraved valentines gift
Favorite valentines day gift
Faye valentine nude hentai
Flower delivered valentine day
For him valentines gift
Free animated valentine wallpaper
Free cards valentines
Free email cards valentines
Free funny dancing valentines card
Kid picture printable valentine
Kids valentine card designs
Kids valentines day pics
Krispie rice valentine
Counting valentines
Coupon to print for valentine day
Craft valentines day card
Creative valentine craft ideas
Day decoration valentine
Mark a valentine florida
Mls 6473 valentine way