/** * (non-PHPdoc) * @see Model::save() */ public function save($data = null) { if (!$data['id']) { $data['create_time'] = time(); } $result = parent::save($data); if (!$result) { return false; } if ($this->lastInsertId) { $id = $this->lastInsertId; } else { $id = $data[$this->priKey]; } if (isset($data['content'])) { if ($this->saveContentType == 'txt') { $file = $this->getSaveFile($id); if (!is_dir($dir = dirname($file))) { mkdir($dir, 0777, true); } file_put_contents($file, $data['content']); } else { // 保存到数据 $content = array('id' => $id, 'content' => $data['content']); $result = Db::replace($this->tbl_content, $content); } } return $result; }
<?php Db::query("CREATE TABLE IF NOT EXISTS `system_users` (\n\t`user_id` INT(11) AUTO_INCREMENT,\n\t`user_name` VARCHAR(255),\n\t`user_surname` VARCHAR(255),\n\t`user_login` VARCHAR(255),\n\t`user_email` VARCHAR(255),\n\t`user_pass` VARCHAR(255),\n\t`user_roles` TEXT,\n\tPRIMARY KEY (`user_id`)\n)\nCOLLATE='latin1_swedish_ci'\nENGINE=MyISAM\n"); $master = Db::query("SELECT user_id FROM `system_users` WHERE user_id=1", true); if (empty($master)) { Db::replace('system_users', array('user_id' => 1, 'user_name' => 'Master', 'user_login' => 'master', 'user_email' => '*****@*****.**', 'user_pass' => md5('321321'))); }
public function db_write($id, $data) { $arr = array('sid' => $id, 'data' => $data, 'expire_time' => time() + $this->lifeTime); if (isset($_SESSION['uid'])) { $arr['uid'] = $_SESSION['uid']; } return Db::replace($this->tbl, $arr); }