PHP Scaffold Demo

PHP Code

<?php

require_once('Scaffold.php');

mysql_connect('db_host', 'db_user', 'db_pass') or die(mysql_error());
mysql_select_db('db_name') or die(mysql_error());

$scaffold = new Scaffold('items');

$scaffold->parent_table  = 'categories';
$scaffold->wysiwyg       = true;
$scaffold->rows_per_page = 5;

$scaffold->image_upload = true;
$scaffold->image_path   = dirname(__FILE__).'/photos/';
$scaffold->image_url    = 'http://www.aaronharp.com/scaffold/photos/';
$scaffold->image_width  = 500;
$scaffold->image_height = 500;

$scaffold->thumb        = true;
$scaffold->thumb_width  = 70;
$scaffold->thumb_height = 70;

$output = $scaffold->build();

?>

Table "items":

+-------------+--------------------------------------------------------------------+------+-----+---------+----------------+
| Field       | Type                                                               | Null | Key | Default | Extra          |
+-------------+--------------------------------------------------------------------+------+-----+---------+----------------+
| id          | int(11)                                                            | NO   | PRI | NULL    | auto_increment | 
| category_id | int(11)                                                            | NO   |     | NULL    |                | 
| name        | varchar(100)                                                       | NO   |     | NULL    |                | 
| description | text                                                               | NO   |     | NULL    |                | 
| price       | float(8,2)                                                         | NO   |     | NULL    |                | 
| image1      | varchar(255)                                                       | NO   |     | NULL    |                | 
| image2      | varchar(255)                                                       | NO   |     | NULL    |                | 
| image3      | varchar(255)                                                       | NO   |     | NULL    |                | 
| image4      | varchar(255)                                                       | NO   |     | NULL    |                | 
| color       | enum('N/A','white','black','blue','red','green','orange','purple') | NO   |     | N/A     |                | 
+-------------+--------------------------------------------------------------------+------+-----+---------+----------------+