<?php
/**
Example file for classGenerator.class.php (ClassGenerator Class)
Author: Stephen Powis
Date: March 2008
This Example assumes you want to create a class for the following mysql DB table structure,
but you should be able to tweak this example easily to fit whatever table structure you have.
CREATE TABLE `userTable` (
`user_id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
`user_name` VARCHAR( 255 ) NOT NULL ,
`user_email` VARCHAR( 255 ) NOT NULL ,
`user_phone` VARCHAR( 255 ) NOT NULL ,
`user_age` INT NOT NULL ,
`join_date` DATETIME NOT NULL ,
PRIMARY KEY ( `user_id` )
);
*/
// Include the class
require("classGenerator.class.php");
/*
Instantiate the class, passing in the name of the class you want to generate
along with the name of the table you are creating the class for
*/
$class = new ClassGenerator("Example","userTable");
/*
Add in the primary key field for this table, the fields are
$fieldName - the name of the DB Field
$displayName - what you want the name to be in your class
$dataType - Optional, sets the type in the PHPDoc comments for you
$keyField - Optional, set to true on your primary key field
*/
$class->addDataMember("user_id","userId","int",true);
/*
Add in all other additional fields in your table
*/
$class->addDataMember("user_name","username","string");
$class->addDataMember("user_email","email","string");
$class->addDataMember("user_phone","phone","string");
$class->addDataMember("user_age","age","int");
/*
If you set the $dataType parameter to datetime, date, time, or timestamp it will
create the getter method for this field slightly differently...check the output for this field.
*/
$class->addDataMember("join_date","joinDate","datetime");
// Generate the class!
if (!$class->generateClass())
echo "<br/>Failed!";
else
echo "Success!";
|
Download
