摘要:<?php
//载入文件
require __DIR__.'/vendor/autoload.php';
//medoo框架中,凡是写操作(insert,update,delete),都返回的是预处理对象
use Medoo\Medoo as Db;//给个别名
//数据库配置参数
$config = [
&nbs<?php
//载入文件
require __DIR__.'/vendor/autoload.php';
//medoo框架中,凡是写操作(insert,update,delete),都返回的是预处理对象
use Medoo\Medoo as Db;//给个别名
//数据库配置参数
$config = [
//必填
'database_type' =>'mysql',
'database_name' =>'edu',
'server'=>'127.0.0.1',
'username'=>'root',
'password'=>'root',
//可选
'charset'=>'utf8',
'port'=>'3306',
];
//实例化Medoo,创建db对象
$db = new Db($config);
//执行查询
$table = 'pdo';
$fields = ['id','name'];
$where = ['id[>=]'=>1];
//复合查询
//$where=['age[>]'=>4];//>4
//AND或OR
//$where=['AND'=>['age[40,'sex'=>1]];
$where=['AND'=>['status[>]'=>0]];
$rows = $db->select($table,$fields,$where);
foreach ($rows as $row){
echo print_r($row,true),'
';
}
//执行添加
$table = 'pdo';
$data['name']='靖';
$data['sex']=1;
$data['age']=37;
$data['email']='guojin@qq.com';
$data['password']=111;
$data['creat_time']=date('Y-m-d',time());
$stmt=$db->insert($table,$data);
//查看新增记录的主键
echo '增加的id:'.$db->id().'
';//medoo自带方法
//更新操作
//要更新的数据
$data['name']='郭襄';
$data['sex']=0;
$data['age']=16;
$data['email']='guoxiang@qq.com';
$data['password']=222;
$data['creat_time']=date('Y-m-d H:i:s',time());
$whe['id']=5;
//执行更新
$stmt = $db->update($table,$data,$whe);
//删除操作
$ere['id']=6;
$stmt = $db->delete($table,$ere);
if($stmt->rowCount()>0){
echo '成功的删除了'.$stmt->rowCount().'条记录';
}
批改老师:韦小宝批改时间:2019-03-10 09:14:53
老师总结:写的很不错 使用medoo框架来操作数据库 各种增删改查变的都太简单了 没事一定要多去练习