AI时代，找源码已成为过去式，纪念我过去的十年0(回)
2天前
还有人吗2(回)
20天前会python真的可以为所欲为0(回)
500天前
这里还有人吗2(回)
685天前这里还有人吗0(回)
685天前
每天面对着电脑屏幕，敲打键盘。我所面对的并不只是代码，而是一种生活方式。0(回)
910天前<?php |
abstract class Model{ |
protected $pk = 'id'; |
protected $_ID = null; |
protected $_tableName; |
protected $_arRelationMap; |
protected $_modifyMap; |
protected $is_load = false; |
protected $_blForDeletion; |
protected $_DB; |
public function __consturct($id = null){ |
$this->_DB = mysql_connect('127.0.0.1','root','') ; |
$this->_tableName = $this->getTableName(); |
$this->_arRelationMap = $this->getRelationMap(); |
if(isset($id))$this->_ID = $id; |
} |
abstract protected function getTableName(); |
abstract protected function getRelationMap(); |
public function Load(){ |
if(isset($this->_ID)){ |
$sql = "SELECT "; |
foreach($this->_arRelationMap as $k => $v){ |
$sql .= '`'.$k.'`,'; |
} |
$sql .= substr($sql,0,strlen($sql)-1); |
$sql .= "FROM ".$this->_tableName." WHERE ".$this->pk." = ".$this->_ID; |
$result =$this->_DB->mysql_query($sql); |
foreach($result[0] as $k1 => $v1){ |
$member = $this->_arRelationMap[$key]; |
if(property_exists($this,$member)){ |
if(is_numeric($member)){ |
eval('$this->'.$member.' = '.$value.';'); |
}else{ |
eval('$this->'.$member.' = "'.$value.'";'); |
} |
} |
} |
} |
$this->is_load = true; |
} |
public function __call($method,$param){ |
$type = substr($method,0,3); |
$member = substr($method,3); |
switch($type){ |
case 'get': |
return $this->getMember($member); |
break; |
case 'set': |
return $this->setMember($member,$param[0]); |
} |
return false; |
} |
public function setMember($key){ |
if(property_exists($this,$key)){ |
if(is_numeric($val)){ |
eval('$this->'.$key.' = '.$val.';'); |
}else{ |
eval('$this->'.$key.' = "'.$val.'";'); |
} |
$this->_modifyMap[$key] = 1; |
}else{ |
return false; |
} |
} |
|
public function getMember($key,$val){ |
if(!$this->is_load){ |
$this->Load(); |
} |
if(property_exists($this,$key)){ |
eval('$res = $this->'.$key.';' ); |
return $this->$key; |
} |
return false; |
} |
public function save(){ |
if(isset($this->_ID)){ |
$sql = "UPDATE ".$this->_tableName." SET "; |
foreach($this->arRelationMap as $k2 => $v2){ |
if(array_key_exists( $k2, $this->_modifyMap)){ |
eval( '$val = $this->'.$v2.';'); |
$sql_update .= $v2." = ".$val; |
} |
} |
$sql .= substr($sql_update,0,strlen($sql_update)); |
$sql .= 'WHERE '.$this->pk.' = '.$this->_ID; |
}else{ |
$sql = "INSERT INTO ".$this->_tableName." ("; |
foreach($this->arRelationMap as $k3 => $v3){ |
if(array_key_exists( $k3,$this->_modifyMap)){ |
eval('$val = $this->'.$v3.';'); |
$field .= "`".$v3."`,"; |
$values .= $val; |
} |
} |
$fields = substr($field,0,strlen($field)-1); |
$vals = substr($values,0,strlen($values)-1); |
$sql .= $fields." ) VALUES (".$vals.")"; |
} |
echo $sql; |
//$this->_DB->query($sql); |
} |
public function __destory(){ |
if(isset($this->ID)){ |
$sql = "DELETE FROM ".$this->_tableName." WHERE ".$this->pk." = ".$this->_ID; |
// $this->_DB_query($sql); |
} |
} |
} |
class User extends Model{ |
protected function getTableName(){ |
return "test_user"; |
} |
protected function getRelationMap(){ |
return array( |
'id' => USER_ID, |
'user_name'=> USER_NAME, |
'user_age' => USER_AGE |
); |
} |
public function getDB(){ |
return $this->_DB; |
} |
} |
$UserIns = new User(); |
print_r($UserIns); |
?> |
