Location: PHPKode > scripts > DbCodeBuilder > dbcodebuilder/index.php
<?php
/* How to use the DbCodeBuilder and generate DAO's and VO's on the fly [START] */
include('AccessBuilder.class.php');
include('VOFormatter.class.php');
include('DAOFormatter.class.php');

$builder = new AccessBuilder('host','username','password','db');
$builder -> setTables();

$tables = $builder->getTables();
$columns = $builder->getColumnInfo();

$voFormatter = new VOFormatter($tables, $columns);
print $voFormatter -> getOutput();

$daoFormatter = new DAOFormatter($tables, $columns);
print $daoFormatter->getOutput();
/* How to use the DbCodeBuilder and generate DAO's and VO's on the fly [END] */



/*=================DB structure for the sample code below [START]================
CREATE TABLE `user` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(120) collate utf8_unicode_ci NOT NULL default '',
  `password` varchar(40) collate utf8_unicode_ci NOT NULL default '',
  `rank` int(2) NOT NULL default '99',
  `active` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;
=================DB structure for the sample code below [START]================*/



/* How to use the generated code to create a new record [START] */
require('User.VO.php');
require('User.DAO.php');

$vo = new UserVO();
$vo->setId(0); //A new record MUST ALWAYS be set to 0.
$vo->setUsername('a_user_name');
$vo->setPassword(sha1('a_password'));
$vo->setRank(99); // A parameter to keep track of user access levels.
$vo->setActive(0); // A parameter to see if someone registers but doesn't validate registration.

$link = mysql_connect('host', 'user', 'password');
mysql_select_db('db', $link);

$dao = new UserDAO($link);
$dao->save($vo);
/* How to use the generated code to create a new record [END] */

/* How to use the generated code to update an existing record [START] */
$vo->setPassword(sha1('a_new_password'));
$dao->save($vo);
/* How to use the generated code to update an existing record [END] */



/* How to use the generated code to delete an existing record [START] */
$dao->delete($vo);
/* How to use the generated code to delete an existing record [END] */
?>
Return current item: DbCodeBuilder