十一月份所有文章

Model

<?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);

?>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

<?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);

&lt;?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-&gt;_DB = mysql_connect('127.0.0.1','root','') ;
       $this-&gt;_tableName = $this-&gt;getTableName();
       $this-&gt;_arRelationMap = $this-&gt;getRelationMap();
       if(isset($id))$this-&gt;_ID = $id;
   }
   abstract protected function getTableName();
   abstract protected function getRelationMap();

   public function Load(){
       if(isset($this-&gt;_ID)){
           $sql = "SELECT ";
           foreach($this-&gt;_arRelationMap as $k =&gt; $v){
               $sql .= '`'.$k.'`,';
           }
           $sql .= substr($sql,0,strlen($sql)-1);
           $sql .= "FROM ".$this-&gt;_tableName." WHERE ".$this-&gt;pk." = ".$this-&gt;_ID;
           $result =$this-&gt;_DB-&gt;mysql_query($sql);
           foreach($result[0] as $k1 =&gt; $v1){
              $member = $this-&gt;_arRelationMap[$key];
              if(property_exists($this,$member)){
                 if(is_numeric($member)){
                     eval('$this-&gt;'.$member.' = '.$value.';');
                 }else{
                     eval('$this-&gt;'.$member.' = "'.$value.'";');
                 }
              }
           }
       }
       $this-&gt;is_load = true;
   }
   public function __call($method,$param){
      $type   = substr($method,0,3);
      $member = substr($method,3);
      switch($type){
         case 'get':
             return $this-&gt;getMember($member);
             break;
         case 'set':
             return $this-&gt;setMember($member,$param[0]);
      }
      return false;
   }
   public function setMember($key){
       if(property_exists($this,$key)){
          if(is_numeric($val)){
             eval('$this-&gt;'.$key.' = '.$val.';');
          }else{
             eval('$this-&gt;'.$key.' = "'.$val.'";');
          }
          $this-&gt;_modifyMap[$key] = 1;
       }else{
          return false;
       }
   }
   
   public function getMember($key,$val){
       if(!$this-&gt;is_load){
          $this-&gt;Load();
       }
       if(property_exists($this,$key)){
          eval('$res = $this-&gt;'.$key.';' );
          return $this-&gt;$key;
       }
       return false;
   }

   public function save(){
      if(isset($this-&gt;_ID)){
          $sql = "UPDATE ".$this-&gt;_tableName." SET ";
          foreach($this-&gt;arRelationMap as $k2 =&gt; $v2){
              if(array_key_exists( $k2, $this-&gt;_modifyMap)){
                  eval( '$val = $this-&gt;'.$v2.';');
                  $sql_update .=  $v2." = ".$val;
              }
          }
          $sql .= substr($sql_update,0,strlen($sql_update));
          $sql .= 'WHERE '.$this-&gt;pk.' = '.$this-&gt;_ID;
      }else{
          $sql = "INSERT INTO ".$this-&gt;_tableName." (";
          foreach($this-&gt;arRelationMap as $k3 =&gt; $v3){
              if(array_key_exists( $k3,$this-&gt;_modifyMap)){
                  eval('$val = $this-&gt;'.$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-&gt;_DB-&gt;query($sql);
   }
   public function __destory(){
      if(isset($this-&gt;ID)){
         $sql = "DELETE FROM ".$this-&gt;_tableName." WHERE ".$this-&gt;pk." = ".$this-&gt;_ID;
        // $this-&gt;_DB_query($sql);
      }
   }
}

class User extends Model{
    protected  function getTableName(){
       return "test_user";
    }
    protected function getRelationMap(){
        return array( 
                      'id'       =&gt; USER_ID,
                      'user_name'=&gt; USER_NAME,
                      'user_age' =&gt; USER_AGE
                    );
    }
    public function getDB(){
       return $this-&gt;_DB;
    }
}

$UserIns = new User();
print_r($UserIns);

?&gt;

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

<?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);

&lt;?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-&gt;_DB = mysql_connect('127.0.0.1','root','') ;
       $this-&gt;_tableName = $this-&gt;getTableName();
       $this-&gt;_arRelationMap = $this-&gt;getRelationMap();
       if(isset($id))$this-&gt;_ID = $id;
   }
   abstract protected function getTableName();
   abstract protected function getRelationMap();

   public function Load(){
       if(isset($this-&gt;_ID)){
           $sql = "SELECT ";
           foreach($this-&gt;_arRelationMap as $k =&gt; $v){
               $sql .= '`'.$k.'`,';
           }
           $sql .= substr($sql,0,strlen($sql)-1);
           $sql .= "FROM ".$this-&gt;_tableName." WHERE ".$this-&gt;pk." = ".$this-&gt;_ID;
           $result =$this-&gt;_DB-&gt;mysql_query($sql);
           foreach($result[0] as $k1 =&gt; $v1){
              $member = $this-&gt;_arRelationMap[$key];
              if(property_exists($this,$member)){
                 if(is_numeric($member)){
                     eval('$this-&gt;'.$member.' = '.$value.';');
                 }else{
                     eval('$this-&gt;'.$member.' = "'.$value.'";');
                 }
              }
           }
       }
       $this-&gt;is_load = true;
   }
   public function __call($method,$param){
      $type   = substr($method,0,3);
      $member = substr($method,3);
      switch($type){
         case 'get':
             return $this-&gt;getMember($member);
             break;
         case 'set':
             return $this-&gt;setMember($member,$param[0]);
      }
      return false;
   }
   public function setMember($key){
       if(property_exists($this,$key)){
          if(is_numeric($val)){
             eval('$this-&gt;'.$key.' = '.$val.';');
          }else{
             eval('$this-&gt;'.$key.' = "'.$val.'";');
          }
          $this-&gt;_modifyMap[$key] = 1;
       }else{
          return false;
       }
   }
   
   public function getMember($key,$val){
       if(!$this-&gt;is_load){
          $this-&gt;Load();
       }
       if(property_exists($this,$key)){
          eval('$res = $this-&gt;'.$key.';' );
          return $this-&gt;$key;
       }
       return false;
   }

   public function save(){
      if(isset($this-&gt;_ID)){
          $sql = "UPDATE ".$this-&gt;_tableName." SET ";
          foreach($this-&gt;arRelationMap as $k2 =&gt; $v2){
              if(array_key_exists( $k2, $this-&gt;_modifyMap)){
                  eval( '$val = $this-&gt;'.$v2.';');
                  $sql_update .=  $v2." = ".$val;
              }
          }
          $sql .= substr($sql_update,0,strlen($sql_update));
          $sql .= 'WHERE '.$this-&gt;pk.' = '.$this-&gt;_ID;
      }else{
          $sql = "INSERT INTO ".$this-&gt;_tableName." (";
          foreach($this-&gt;arRelationMap as $k3 =&gt; $v3){
              if(array_key_exists( $k3,$this-&gt;_modifyMap)){
                  eval('$val = $this-&gt;'.$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-&gt;_DB-&gt;query($sql);
   }
   public function __destory(){
      if(isset($this-&gt;ID)){
         $sql = "DELETE FROM ".$this-&gt;_tableName." WHERE ".$this-&gt;pk." = ".$this-&gt;_ID;
        // $this-&gt;_DB_query($sql);
      }
   }
}

class User extends Model{
    protected  function getTableName(){
       return "test_user";
    }
    protected function getRelationMap(){
        return array( 
                      'id'       =&gt; USER_ID,
                      'user_name'=&gt; USER_NAME,
                      'user_age' =&gt; USER_AGE
                    );
    }
    public function getDB(){
       return $this-&gt;_DB;
    }
}

$UserIns = new User();
print_r($UserIns);

?&gt;

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

<?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);

helloworld!

[codesyntax lang=”php”] [crayon-650e8f5887d […]

wordpress文章标题别名自动翻译为英文

文章别名自动翻译为英文，应用的百度翻译接口，可以说已经非常的ai化了，不过如果你的文章标题很长的话，别名也会很 […]

111

222

月份：2018年11月

Model

i love polan

Dplayer

helloworld!

wordpress文章标题别名自动翻译为英文

111

Already have an account? Login

Signup

Forgot Password

New to site? Create an Account

Login

Already have an account? Login

Signup

Forgot Password