PHP Classes

File: programtemplates/template_php_code_generator.html

Recommend this page to a friend!
  Classes of Valics Lehel   PHP or Java Class Code Generator   programtemplates/template_php_code_generator.html   Download  
File: programtemplates/template_php_code_generator.html
Role: Auxiliary data
Content type: text/plain
Description: template for generating for Java
Class: PHP or Java Class Code Generator
Generate PHP or Java database access classes
Author: By
Last change: new template generator
Date: 15 years ago
Size: 10,077 bytes
 

Contents

Class file image Download
<?php /* CODE GENERATED BY: GRAFXSOFTWARE CODE GENERATOR http://www.grafxsoftware.com ====================================== CLASS MADE BY: {AUTHOR} DATE: {DATE} PROJECT: {PROJECT_NAME} PHP: version 4.x ====================================== */ /* ${CLASSVAR}=new {NAME}(); <!-- BEGIN DYNAMIC BLOCK: getfunctionsvar --> ${CLASSVAR}->get{FUNC_NAME}(); <!-- END DYNAMIC BLOCK: getfunctionsvar --> <!-- BEGIN DYNAMIC BLOCK: setfunctionsvar --> ${CLASSVAR}->set{FUNC_NAME}(); <!-- END DYNAMIC BLOCK: setfunctionsvar --> ${CLASSVAR}->save(); */ /** * * @author - {AUTHOR} * @desc - * @vers - 1.0 */ class {NAME} { var $where_clause; var $enable_undo={ENABLE_UNDO}; var $id_key='id'; var $history_table='{HISTORY_TABLE}'; var $valid=false; //do not modify var $where_mode=false;//do not modify <!-- BEGIN DYNAMIC BLOCK: row --> var ${VARIABLES}; <!-- END DYNAMIC BLOCK: row --> /** * @author - {AUTHOR} * @type - public * @desc - Constructor * @param - string ${IDCLASS} - the ID * @return - mixed rewrite array * @vers - 1.0 * @Mod - **/ function {NAME}(${IDCLASS}) { if ((is_int($id)&&($id==0))||(is_string($id)&&($id=="0"))) { $this->valid=true; $this->where_mode=false; return; }; $this->{IDCLASS} = ${IDCLASS}; if ((is_string($id))&&(stristr($id,"where"))) { $this->where_clause=$id; $this->where_mode=true; }else { $this->where_clause=" WHERE `id`='".$this->id."'"; $this->where_mode=false; }; $SQL = " SELECT {LIST} FROM {DBNAME} ".$this->where_clause; $retid = mysql_query($SQL) or die(mysql_error()); if ($row = mysql_fetch_array($retid)) { $this->valid=true; <!-- BEGIN DYNAMIC BLOCK: value --> $this->{FIELD_NAME} = $row["{FIELD_NAME}"]; <!-- END DYNAMIC BLOCK: value --> } else { $this->valid=false; <!-- BEGIN DYNAMIC BLOCK: nullvalue --> $this->{FIELD_NAME} = ""; <!-- END DYNAMIC BLOCK: nullvalue --> } }//end constructor {NAME} <!-- BEGIN DYNAMIC BLOCK: getfunctions --> /** * @author - {AUTHOR} * @type - public * @desc - get $this->{VAR_NAME} * @return - string * @vers - 1.0 * @Mod - **/ function get{FUNC_NAME}() { return $this->{VAR_NAME}; } // end get{FUNC_NAME}() <!-- END DYNAMIC BLOCK: getfunctions --> <!-- BEGIN DYNAMIC BLOCK: setfunctions --> /** * @author - {AUTHOR} * @type - public * @desc - set $this->{VAR_NAME} to ${VAR_NAME} * @param - string ${VAR_NAME} * @return - void * @vers - 1.0 * @Mod - **/ function set{FUNC_NAME}(${VAR_NAME}) { $this->{VAR_NAME}=${VAR_NAME}; } // end set{FUNC_NAME}() <!-- END DYNAMIC BLOCK: setfunctions --> /** * @author - {AUTHOR} * @type - public * @desc - check if the data is valid * @return - void * @vers - 1.0 * @Mod - **/ function is_valid() { return $this->valid; } /** * @author - {AUTHOR} * @type - public * @desc - saves data into database * @return - void * @vers - 1.0 * @Mod - **/ function save() { if (!$this->valid) return; //$this->slashesAdd (); if ((($this->{IDCLASS})==0)&&(!$this->where_mode)) { $SQL = "INSERT INTO {DBNAME} ({LIST})"; $SQL .= " VALUES({LIST_INSERT})"; $retid = mysql_query($SQL); if (!$retid) { echo( mysql_error()); } $this->{IDCLASS} = mysql_insert_id(); if ($this->enable_undo) { $this->write_insert_undo($this->{IDCLASS}); }; } else { if ($this->enable_undo){ $this->write_update_undo(); } $SQL = "UPDATE {DBNAME} SET {LIST_UPDATE}"; $SQL .= $this->where_clause; $retid = mysql_query($SQL); if (!$retid) { echo( mysql_error()); } } }//end save() /** * @author - {AUTHOR} * @type - public * @desc - delete ${IDCLASS} from database * @return - void * @vers - 1.0 * @Mod - **/ function delete(${IDCLASS}) { if (is_int(${IDCLASS})) $where_clause="WHERE `{IDCLASS}`='".${IDCLASS}."'"; else $where_clause=${IDCLASS}; if ($this->enable_undo){ $this->write_delete_undo($where_clause); }; $SQL = "DELETE FROM {DBNAME} ".$where_clause; $retid = mysql_query($SQL); if (!$retid) { echo( mysql_error()); } } // end delete() /** * @author - {AUTHOR} * @type - public * @desc - write undo into history table * @return - void * @vers - 1.0 * @Mod - **/ /* //--- create a history table from this SQL CREATE TABLE `{HISTORY_TABLE}` ( `id` int(11) NOT NULL AUTO_INCREMENT, `item_id` int(11) NOT NULL, `tablename` varchar(100) COLLATE utf8_bin DEFAULT NULL, `command` text COLLATE utf8_bin, `date` datetime DEFAULT NULL, `userid` int(11) DEFAULT NULL, `valid` tinyint(4) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM; */ function write_undo($item_id,$sql_text){ if ((!$this->enable_undo)||($sql_text=="")) return; $sql_text=base64_encode($sql_text); $userid=0; $tablename="{DBNAME}"; $SQL="INSERT INTO `$this->history_table` (`item_id`,`tablename`,`command`,`date`,`userid`,`valid`)"; $SQL.=" VALUES('".$item_id."','".$tablename."','".$sql_text."',NOW(),'".$userid."','1');"; $retid = mysql_query($SQL); if (!$retid) { echo( mysql_error()); } } /** * @author - {AUTHOR} * @type - public * @desc - write undo for UPDATE * @return - void * @vers - 1.0 * @Mod - **/ function write_update_undo(){ $this->make_replace_row_sql($this->where_clause); } /** * @author - {AUTHOR} * @type - public * @desc - write INSERT * @return - void * @vers - 1.0 * @Mod - **/ function write_insert_undo(${IDCLASS}){ $this->make_sql_for_insert(${IDCLASS}); } /** * @author - {AUTHOR} * @type - public * @desc - get SQL query for DELETE * @return - string * @vers - 1.0 * @Mod - **/ function write_delete_undo($id_or_where_clause){ $this->make_replace_row_sql($id_or_where_clause); } /** * @author - {AUTHOR} * @type - public * @desc - get SQL query for INSERT * @return - string * @vers - 1.0 * @Mod - **/ function make_sql_for_insert(${IDCLASS}){ $SQL="SELECT * FROM `{DBNAME}` ".$where_clause; $result=""; $retid=mysql_query($SQL); if (!$retid) return ""; $id_value=""; while ($row = mysql_fetch_assoc($retid)){ $keys=""; $values=""; foreach($row as $key => $value){ if ($key==$this->id_key) { $id_value=$value; }; if ($keys!="") $keys.=","; $keys.="`".$key."` "; if ($values!="") $values.=","; $values.="'".$value."' "; }; }; $this->write_undo($id_value, "DELETE FROM `{DBNAME}` WHERE `{IDCLASS}`='".${IDCLASS}."' AND $this->id_key='$id_value';"); } /** * @author - {AUTHOR} * @type - public * @desc - get the SQL query which make the existing rows * @return - void * @vers - 1.0 * @Mod - **/ function make_replace_row_sql($id_or_where_clause){ if (is_int($id_or_where_clause)) $where_clause="WHERE `{IDCLASS}`='".$id_or_where_clause."'"; else $where_clause=$id_or_where_clause; $SQL="SELECT * FROM `{DBNAME}` ".$where_clause; $result=""; $retid=mysql_query($SQL); if (!$retid) return ""; while ($row = mysql_fetch_assoc($retid)){ $keys=""; $values=""; $id_value=""; foreach($row as $key => $value){ if ($key==$this->id_key) $id_value=$value; if ($keys!="") $keys.=","; $keys.="`".$key."` "; if ($values!="") $values.=","; $values.="'".$value."' "; }; $this->write_undo($id_value,"REPLACE INTO `{DBNAME}` (".$keys.") VALUES (".$values.");"); }; } /** * @author - {AUTHOR} * @type - public * @desc - debugging function which shows what's in history table * @return - void * @vers - 1.0 * @Mod - **/ function debug_print_history(){ $SQL="SELECT * from $this->history_table;"; $retid=mysql_query($SQL); if (!$retid) return ""; while ($row = mysql_fetch_assoc($retid)){ foreach($row as $key => $value){ if ($key=='command') $value=base64_decode($value); print("`$key` = '$value'<br>"); }; print("<br />"); }; } /** * @author - {AUTHOR} * @type - public * @desc - do multiple query, each query is separted by ";;\n" * @return - string * @vers - 1.0 * @Mod - **/ function mysql_multiple_query($q) { $tok = strtok($q, ";;\n"); while ($tok) { $results=mysql_query("$tok"); $tok = strtok(";;\n"); } return $results; } /** * @author - {AUTHOR} * @type - public * @desc - undo function * @return - boolean * @vers - 1.0 * @Mod - **/ function undo($item_id){ $SQL="SELECT * from `$this->history_table` WHERE tablename='{DBNAME}' AND valid='1' AND item_id='$item_id' ORDER BY date DESC LIMIT 1;"; $retid=mysql_query($SQL); if (!$retid) return ""; if ($row = mysql_fetch_assoc($retid)){ $command=$row['command']; if ($command=="") return false; $command=base64_decode($command); $SQL="DELETE from `$this->history_table` ORDER BY date DESC LIMIT 1;"; if (!mysql_query($SQL)) return false; return $this->mysql_multiple_query($command); }; return false; } /** * @author - {AUTHOR} * @type - public * @desc - adding slashes if necesary * @return - void * @vers - 1.0 * @Mod - **/ function slashes($str){ if ((get_magic_quotes_gpc()) && (!empty($str))) return addslashes($str); else return $str; } /* function slashesAdd() { $class_vars = get_class_vars ( get_class ( $this ) ); foreach ( $class_vars as $name => $value ) { if (get_magic_quotes_gpc () && ! empty ( $name )) $this->$name = addslashes ( $this->$name ); } } */ /**************************************************************/ /* ADD YOUR CUSTOM FUNCTIONS BELOW */ /**************************************************************/ } // end class {NAME} ?>