摘要:<?php namespace app\index\controller; use think\Db; class Index { public function index() { &n
<?php namespace app\index\controller; use think\Db; class Index { public function index() { return '<style type="text/css">*{ padding: 0; margin: 0; } div{ padding: 4px 48px;} a{color:#2E5CD5;cursor: pointer;text-decoration: none} a:hover{text-decoration:underline; } body{ background: #fff; font-family: "Century Gothic","Microsoft yahei"; color: #333;font-size:18px;} h1{ font-size: 100px; font-weight: normal; margin-bottom: 12px; } p{ line-height: 1.6em; font-size: 42px }</style><div style="padding: 24px 48px;"> <h1>:) </h1><p> ThinkPHP V5.1<br/><span style="font-size:30px">12载初心不改(2006-2018) - 你值得信赖的PHP框架</span></p></div><script type="text/javascript" src="https://tajs.qq.com/stats?sId=64890268" charset="UTF-8"></script><script type="text/javascript" src="https://e.topthink.com/Public/static/client.js"></script><think id="eab4b9f840753f8e7"></think>'; } public function hello($name = 'ThinkPHP5') { return 'hello,' . $name; } //新增操作 public function insert() { $data=[ 'goods_name'=>'华为荣耀5S手机', 'shop_price'=>1999, 'goods_number'=>2000 ]; $num = Db::table('goods')->data($data)->insert(); $id = Db::getLastInsId(); return $num?'成功添加了'.$num.'条记录,id是'.$id:'添加失败'; } public function insertAll() { $data = [ ['goods_name'=>'iPhone5S','shop_price'=>3000,'goods_number'=>1000], ['goods_name'=>'iPhone6S','shop_price'=>3500,'goods_number'=>1200], ['goods_name'=>'iPhone7S','shop_price'=>3800,'goods_number'=>3000], ]; $num = Db::table('goods')->data($data)->insertAll(); return $num?'成功添加了'.$num.'条记录':'添加失败'; } //更新操作 public function update() { $num = Db::table('goods')->where('id',4)->data(['shop_price'=>Db::raw('shop_price+2300')])->update(); return $num?'成功更新':'更新失败'; } //查询单条记录 public function find() { $row = Db::table('goods')->where('id','4')->find(); dump($row); } //查询多条记录 public function select() { $rows = Db::table('goods')->select(); dump($rows); } //删除记录 public function delete() { $num = Db::table('goods')->delete(4); return $num?'成功删除了'.$num.'条记录':'删除失败'; } }
批改老师:韦小宝批改时间:2019-01-20 09:20:46
老师总结:写的很不错 看来你db类库用的还是很不错的啊 继续加油吧