ThinkPHP5.1框架数据库链接和增删改查操作示例

本文实例讲述了thinkphp5.1框架数据库链接和增删改查操作。分享给大家供大家参考，具体如下：

一、数据库的链接方式

<?phpnamespace app\index\controller;u think\db;class demo{//1、全局配置 config/databa.php配置public function dbtest(){return db::table('pzq_article')->where('id','29')->value('title');}//2、动态配置 think\db\query.php中有一个方法connect()public function dbtest2(){return db::connect(['type'=>'mysql','hostname'=>'localhost','databa'=>'top789','urname'=>'root','password'=>'root',])->table('pzq_article')->where('id','76')->value('title');}//3、dsn连接public function dbtest3(){$dsn = 'mysql://root:root@l学汽修ocalhost:3306/top789#utf8';return db::connect($dsn)->table('pzq_article')-&g十一月英文t;where('id','88')->value('title');}//4、单条查旬public function dbtest4(){$res = db:h2o2:table('pzq_article')->field(['title'=>'标题','id'=>'编号'])//可添加别名->where('id','=',20)//如果是等号，=可以省略->find();//如果是主键查询，可省略上面where,这行写->find(20);dump(is_null($res)?'没有查到':$res);}//5、多条查旬public function dbtest5(){$res = db::table('pzq_article')->field(['id','cat_id','title'])->where([['id','>',20],['cat_id','=',2],])//一个条件，直接用表达式->where('id','>',20)。多个条件用数组->order('id desc')->limit(3)->lect();if(empty($res)){return '没有查到';}el{dump($res);}}//6、数据添加public function dbtest6(){$data = ['name'=>'sam2','age'=>'29','posttime'=>time()];$dataall=[['name'=>'sam3','age'=>'29','posttime'=>time()],['name'=>'sam4','age'=>'30','posttime'=>time()],];//(1)单条插入//return db::table('test')->data($data)->inrt();//(2)插入同时返回新增主键id//return db::table('test')->inrtgetid($data);//(3)插入多条数据return db::table('test')->data($dataall)->inrtall(广外南国商学院);}//更新数据public function dbtest7(){// return db::table('test')// ->where('id','=',4)// ->update(['name'=>'samc','age'=>'31']);//如果where条件是主键，还可以如下使用return db::table('test')->update(['name'=>'samcheng','age'=>'30','id'=>4]);}//删除操作public function dbtest8(){//return db::table('test')->delete(6);//或者return db::table('test')->where('id',5)->delete();}//mysql原生语句 查询public function dbtest9(){$sql = "lect name,age from test where id>2";dump(db::query($sql));}//mysql 增、删、改 用db::e减小肚子的方法xecute($sql)public function dbtest10(){//$sql = "update test t name='samc' where id=4";//$sql = "inrt test t name='yan',age='30'";$sql = "delete from test where id=4";return db::execute($sql);}}