Heim > Fragen und Antworten > Hauptteil
<?php //数据库操作类 class Model{ private $host; //数据库地址 private $user; //数据库用户名 private $pwd; //数据库密码 private $tabName; //表名 private $preFix; //表前缀 private $dbName; //数据库名 private $charset; //字符 private $link=null; //数据连接对象 function __construct($tabName = ''){ $this->host = DB_HOST; $this->user = DB_USER; $this->pwd = DB_PWD; $this->charset = CHARSET; $this->preFix = DB_PREFIX; $this->dbName = DB_NAME; if($tabName == ''){ $this->tabName = $this->prefix.strtolower(substr(get_class($this),0,-5)) ; }else{ $this->tabName = $this->preFix.$tabName; } $this->link = $this->connect(); } private function connect(){ $link = @mysqli_connect($this->host,$this->user,$this->pwd,$this->dbname) or die('数据库连接错误'); if(!$link){ return false; } mysqli_set_charset($link,$this->charset); return $link; } public function insert(array $data){ //var_dump($data); //INSERT INTO user(name,sex,age) VALUE(); $key = $val = ''; foreach($data as $k=>$v){ $key .='`'.$k.'`,'; $val .="'".$v."',"; } $key = rtrim($key,','); $val = rtrim($val,','); // var_dump($key); // var_dump($val); $sql = "INSERT INTO {$this->tabName} ({$key}) VALUES ({$val})"; echo $sql; return $this->exec($sql); } private function exec($sql){ $result = mysqli_query($this->link,$sql); if($result && mysqli_affected_rows($this->link) > 0){ return mysqli_insert_id($this->link) ?? mysqli_affected_rows($this->link); }else{ return false; } } } //调用方法,为什么不成功?总是插入不进去,提示false;?? <?php $m = new Model('user'); // echo '<pre>'; // var_dump($m); $_POST = array('name'=>'小驴','age'=>'20','sex'=>'1'); $result = $m->insert($_POST); var_dump($result);