<?
	$c="\r\n/*\r\n*	This class generated by Mysql2php script.\r\n*	Author: Alexander Smelkov (alex@microgames.ru)\r\n*	Web page: www.microgames.ru\r\n*/\r\n";
	/*
	* SETTINGS
	*/
	$host 		= "localhost";
	$port 		= "3306";
	$dbname 	= "mydb";
	$user 		= "root";
	$password 	= "";
	$output_dir = "C:/Apache/my_site/entity/";
	$extends 	= "Entity";

	/*
	 * CONNECT TO DB
	 */
	$db_connect = mysql_connect($host,$user,$password);
	$select_db = mysql_select_db($dbname, $db_connect);

	/*
	 * TEMPLATES
	 */
	$template_h1 = "<?\r\n".$c."\r\n";
	$template_h2 = "require_once(\"<<>>.php\");\r\n\r\n";
	$template_h3 = "class <<>>";
	$template_h4 = " extends <<>> {\r\n\r\n";
	$template_h5 = " {\r\n\r\n";
	$template_h6 = "	var $<<>>\r\n";
	$template_h7 = "\r\n	public function getTableName(){\r\n";
	$template_h8 = "		return \"<<>>\";\r\n";
	$template_h9 = "	}\r\n";
	$template_h10 = "\r\n}\r\n\r\n";
	$template_h11 = "?>";

	/*
	 * get tables list and prepare class names
	 */
 
	$result = mysql_query("show tables from ".$dbname);
	$names = array();
	while($row = mysql_fetch_row($result)){
		$n = array();
		$n["table"] = $row[0];
		$className = "";
		foreach(explode("_", $n["table"]) as $piece){
			$className .= ucwords($piece);
		}
		$n["class"] = $className;
		$names[] = $n;
	}

	foreach($names as $name){
		$class_file = fopen($output_dir.$name["class"].".php", "w"); //Open for writing only; place the file pointer at the beginning of the file and truncate the file to zero length. If the file does not exist, attempt to create it. 
		//get column name from table
		$columns = mysql_query("show columns from ".$name["table"]);
		$columnArray = array();
		while($row = mysql_fetch_assoc($columns)){
			$c = array();
			$c["name"] = $row["Field"];
			$key = ($row["Key"] == "") ? "" : ", key: ".$row["Key"];
			$default = ($row["Default"] == "") ? "" : ", default: ".$row["Default"];
			$extra = ($row["Extra"] == "") ? "" : ", extra: ".$row["Extra"];
			$c["comment"] = "Type: ".$row["Type"].$key.$default.$extra;
			$columnArray[] = $c;
		}
	
		//start buid class
		$classText = "";
		$classText .= $template_h1;
		if($extends != "") $classText .= templateReplace($template_h2, "ENTITY_NAME", $extends);
		$classText .= templateReplace($template_h3, "CLASS_NAME", $name["class"]);
		$classText .= ($extends != "") ? templateReplace($template_h4, "ENTITY_NAME", $extends) : $template_h5;
		foreach($columnArray as $column){
			$classText .= templateReplace($template_h6, "VAR_NAME", $column["name"]."; 		// ".$column["comment"]);
		}
		$classText .= $template_h7;
		$classText .= templateReplace($template_h8, "TABLE_NAME", $name["table"]);
		$classText .= $template_h9;
		$classText .= $template_h10;
		$classText .= $template_h11;
		//write to file
		fwrite($class_file, $classText);
		fclose($class_file);
		echo "Class: ".$name["class"]." from table ".$name["table"]." READY!
";
	}

	function templateReplace($template, $replaceKey, $replaceVal) {
			$search = "/\<\<\<".strtoupper($replaceKey)."\>\>\>/";
			return preg_replace($search, $replaceVal, $template);
	}
?>

require_once("Entity.php");

class SiteUser extends Entity {

	var $id; 		// Type: int(11), key: PRI, extra: auto_increment
	var $name; 	// Type: varchar(255)
	var $lastName; // Type: varchar(255)
	var $createdOn; // Type: timestamp, default: CURRENT_TIMESTAMP, extra: on update CURRENT_TIMESTAMP

	public function getTableName(){
		return "site_user";
	}

}

public function select(){
}
public function insert() {
}
public function update(){
}

public function insert() {
	$class = new ReflectionClass(get_class($this));
	$classVars = get_object_vars($this);
	$props = $class->getProperties();
	$propsAarray = array();
	foreach( $props as $prop ) {
		if ( !$prop->isPublic() || $prop->isStatic() ) continue;
		$propsAarray[] = $prop->getName();
	}
	$query = "INSERT INTO ".$this->getTableName()." SET ";
	$sql = array();
	foreach($propsAarray as $k => $v){
		$sql[] = (is_null($classVars[$v])) ? $v."=NULL":$v."='".mysql_real_escape_string($classVars[$v])."'";
	}
	$query .= implode(", ", $sql);
	try{
		$this->execQuery($query);
	}catch(Exception $e){
   		echo "There is an exception: ". $e->getMessage();
	}
}
	
public function execQuery($query) {
	$host 		= "localhost";
	$port 		= "3306";
	$dbname 	= "mydb";
	$user 		= "root";
	$db_connect = mysql_connect($host,$user,$password);
	$select_db = mysql_select_db($dbname, $db_connect);
  	$result = @mysql_query ($query);
	if (!$result) throw new Exception (mysql_error ());
}

<?

require_once("entity/SiteUser.php");

$my_class = new SiteUser();
$my_class->name = "Vasily";
$my_class->lastName = "Pupkin";
$my_class->insert();

?>