搭建tp环境，了解配置文件，实战操作数据库

原声操作数据库

原声mysql (查询所有数据)

$res=Db::query("SELECT *  FROM `shop_goods` "  );
if(!empty($res)){
      foreach($res   as   $key){
          echo $key['title'];
          echo  '<br>';
      }
  }
  printf('<pre>%s</pre>',print_r($res,true));

原声mysql 添加和修改execute 方法用于执行 MySql 新增和修改操作

查询数据库里有多少条数句
$res = Db::execute("SELECT * FROM `shop_goods` ");// echo $res;

添加

$res = Db::execute("INSERT INTO `lx`.`shop_goods` (`id`, `cat`, `title`, `price`, `discount`, `stock`, `status`, `add_time`) VALUES (null, 1, '内衣学姐风', 300.00, 0, 100, 1, 1576080000); ");
// echo $res

修改

$res = Db::execute("UPDATE `lx`.`shop_goods` SET  `add_time` = 1380013801 WHERE `id` = 24; ");
//  echo $res

tp

select 查询全部

$res = Db::table('shop_goods')->select();
if(!empty($res)){
   foreach($res   as   $key){
      echo $key['title'];
      echo  '<br>';
  }
}
printf('<pre>%s</pre>',print_r($res,true));

find 查询单条数据要增加条件
$res = Db::table('shop_goods')->find('1');printf('<pre>%s</pre>',print_r($res,true));
value 查询单个数据默认查询第一个
$res = Db::table('shop_goods')->value('title');//printf('<pre>%s</pre>',print_r($res,true));
where 条件
$res = Db::table('shop_goods')->where('id',20)->value('title');// printf('<pre>%s</pre>',print_r($res,true));
column 查询一列
$res = Db::table('shop_goods')->column('id');// printf('<pre>%s</pre>',print_r($res,true));id 为索引进行查询// $ress = Db::table('shop_goods')->column('title','id');// printf('<pre>%s</pre>',print_r($ress,tr

insert 插入

arr  =[
'id'=>'',
'cat'=>'2',
'title'=>'苹果X',
'price'=>'1688',
'discount'=>'200',
'stock'=>'300',
'status'=>'1',
'add_time'=>'123',
];
$res =  Db::table('shop_goods')->insert($arr);
printf('<pre>%s</pre>',print_r($res,true));

insertGetId 查询插入的ID

$arr  =[
'id'=>'',
'cat'=>'2',
'title'=>'苹果X',
'price'=>'1688',
'discount'=>'200',
'stock'=>'300',
'status'=>'1',
'add_time'=>'123',
];
$res =  Db::table('shop_goods')->insertGetId($arr);
printf('<pre>%s</pre>',print_r($res,true));

insertAll 插入多条数据

//insertAll 插入多条数据
$arr  =[
[
   'id'=>'',
   'cat'=>'2',
   'title'=>'苹果X',
   'price'=>'1688',
   'discount'=>'200',
   'stock'=>'300',
   'status'=>'1',
   'add_time'=>'123',
],
[
   'id'=>'',
   'cat'=>'2',
   'title'=>'苹果12',
   'price'=>'1588',
   'discount'=>'200',
   'stock'=>'300',
   'status'=>'1',
   'add_time'=>'123',
],
[
   'id'=>'',
   'cat'=>'2',
   'title'=>'苹果13',
   'price'=>'168',
   'discount'=>'200',
   'stock'=>'300',
   'status'=>'1',
   'add_time'=>'123',
],
];
$res =  Db::table('shop_goods')->insertAll($arr);
printf('<pre>%s</pre>',print_r($res,true));

update 修改
$res = Db::table('shop_goods') ->where('id',42)->update(['title'=>'隔壁老王手机']);

where 条件查询

//默认的是等于
//$res = Db::table('shop_goods') ->where('id',40)->select();
//大于 >
//$res = Db::table('shop_goods') ->where('id','>',10)->select();
//小于<
//$res = Db::table('shop_goods') ->where('id','<',18)->select();
//大于等于
//$res = Db::table('shop_goods') ->where('id','>=',10)->select();
//小于等于
//$res = Db::table('shop_goods') ->where('id','<=',10)->select();
//printf('<pre>%s</pre>',print_r($res,true));

field 字段返回值

res = Db::table('shop_goods') ->field(['title','id'])->select();
printf('<pre>%s</pre>',print_r($res,true));
$arr=['ouyangke'=>'欧阳克'];
// printf('<pre>%s</pre>',print_r($arr,true));
// echo  $arr['ouyangke'];
//   order  排序
//    $res = Db::table('shop_goods') ->order('id DESC')->select();
//   printf('<pre>%s</pre>',print_r($res,true));

limit 查询几条

$res = Db::table('shop_goods') ->field(['title','id'])->limit(0,5)->select();
printf('<pre>%s</pre>',print_r($res,true));
//page  翻页 更方便
$res =  Db::table('shop_goods')->order('id DESC')->page(3,3)->select();  printf('<pre>%s</pre>',print_r($res,true));

实战-TP数据库操作(一)

搭建tp环境，了解配置文件，实战操作数据库

原声操作数据库

tp

更多相关文章

随机推荐