1、连接数据库打开D:\phpStudy\WWW\tp5\application\database.php设置服务器地址,数据库,数据库用户名,数据库密码
2、查询数据库传统数据库查询是select * from shijian where id = 1thinkphp5可以用db('shijian')->where('id',1)->find();
3、写入数据库传统数据库写入是inert into shijian(time1) value('1126085262')thinkphp5是$data=['time1'=>'1126085262'];db('shijian')->insert($data);
4、更改数据库镶毳呦躲传统数据库更改是updata shijian set time1 = '33160985121' where id=1thinkphp5是db('shijian')->where('id',1)->update(['time1'=>'13318069951'])
5、删除数据库传统数据库删除数据是delete from shijian where id=3thinkphp5是db('shijian')->where('id',3)->delete();
6、thinkphp5执行原生sql语句必须先引入use think\Db;然后Db:query('select * from shijian where id=1');
7、thinkphp5执行or语句传统sql语甜入艺阝句是:select * from shijian where id=1 or id=2;thinkphp5语句是Db::table('shijian')->where('id',1)->whereOr('id',2)->select()