PHP Classes

File: example.gen.php

Recommend this page to a friend!
  Classes of zengwenjie   genpo   example.gen.php   Download  
File: example.gen.php
Role: Example script
Content type: text/plain
Description: how to genarate a class base one table
Class: genpo
Generate class to access table records as objects
Author: By
Last change:
Date: 15 years ago
Size: 1,065 bytes
 

Contents

Class file image Download
<?php

include "class.genpo.php";
/*
CREATE TABLE IF NOT EXISTS `compinfo` (
  `id` bigint(20) NOT NULL auto_increment,
  `mylink` varchar(100) NOT NULL,
  `compname` varchar(500) default NULL,
  `address` varchar(100) default NULL,
  `post` varchar(100) default NULL,
  `email` varchar(100) default NULL,
  `phone` varchar(500) default NULL,
  `zip` varchar(100) default NULL,
  `memo` varchar(100) default NULL,
  `intime` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=636 ;
*/

$dbserver="localhost";
$dbuser="annie";
$dbpass="annie";
$link=mysql_connect($dbserver,$dbuser, $dbpass);
$dbname="annie";
$tablename="compinfo";

$fields = mysql_list_fields ( $dbname , $tablename , $link );
$columns = mysql_num_fields ( $fields );
$fieldnames = array();
for (
$i = 0 ; $i < $columns ; $i ++) {
   
$fieldnames[]= mysql_field_name ( $fields , $i ) ;
}

$g = new genpo($tablename,$fieldnames);
echo
"<textarea rows=100 cols=100>";
echo
$g->genpo() ;
echo
"</textarea>";
?>