Example #1
0
 /**
  * 保存账户信息到数据库
  *
  * @param array $data 账户数据
  *
  * @return int
  */
 public static function insert(array $data)
 {
     $data['createtime'] = date("Y-m-d H:i:s");
     $input_params = array();
     foreach ($data as $k => $v) {
         $input_params[':' . $k] = $v;
     }
     $sql = 'INSERT INTO z_accounts(' . implode(',', array_keys($data)) . ') VALUES (' . implode(',', array_keys($input_params)) . ')';
     $statement = Local::query($sql, $input_params);
     $statement->closeCursor();
     return Local::getLastInsertId();
 }