摘要:/* Medoo框架的配置 */ // 如果你使用php的依赖安装。可以使用以下方法自动载入 require __DIR__ . '/vendor/autoload.php'; use Medoo\Medoo as Db; //数据库配置参数 $config&n
/* Medoo框架的配置 */ // 如果你使用php的依赖安装。可以使用以下方法自动载入 require __DIR__ . '/vendor/autoload.php'; use Medoo\Medoo as Db; //数据库配置参数 $config = [ // 必填 'database_type' => 'mysql', 'database_name' => 'blog', 'server' => 'localhost', 'username' => 'root', 'password' => 'root', // 可选 'charset' => 'utf8', 'port' => 3306, ]; //实例化 $db = new Db($config); var_export($db);
//实例化Medoo框架类 require('zuoye1.php'); //执行查询 $table = 'tp_admin'; $field = ['id','username','password']; $rows = $db->select($table,$field); foreach($rows as $row){ echo print_r($row,true),'<hr>'; } //执行添加 $table = 'tp_admin'; $data['username'] = '郭襄'; $data['password'] = 'guoxiang'; $stmt = $db->insert($table, $data); //执行更新 $table = 'tp_admin'; $data['username'] = '欧阳锋'; $data['password'] = 'ouyangfeng'; $where['id'] = 22; $stmt = $db->update($table, $data, $where); //执行删除 $table = 'tp_admin'; $where['id'] = 3; $stmt = $db -> delete($table, $where);
批改老师:韦小宝批改时间:2018-12-27 11:08:35
老师总结:不错不错!代码写的很规范!注释的也很清晰!