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

搭建tp环境，了解配置文件，实战操作数据库
<?php
namespace app\controller;
use app\BaseController;
use think\Facade\Db;
use think\facade\Db as FacadeDb;
class Index extends BaseController
{
    public function index()
    {
        return 'index';
    }
    public function test($name = 'ThinkPHP6')
    {
        return 'hello,' . $name;
    }
    public function testsql()
    {
        //原生sql写法  query查询
        $query = Db::query("select * from `shop_goods` where status =1");
        //print_r($query);
        foreach($query as $item){
            //print_r($item['title'].'<br>');
        }
        //原生sql写法  execute执行insert和update
        // INSERT
        // Db::execute("INSERT INTO 
        // `testsql`.`shop_goods`(`cat`, `title`, `price`, `discount`, `stock`, `status`, `add_time`) 
        // VALUES (2, '云朵般轻盈的仙女裙 高级钉珠收腰长裙 气质无袖连衣裙', 279.99, 0, 1100, 1, 1576080000)");
        // UPDATE
        // Db::execute("UPDATE `testsql`.`shop_goods` SET `status` = 4 WHERE `id` = 29");
        //TP写法
        // $tpquery =Db::table('shop_goods')->find(5);
        // $tpquery =Db::table('shop_goods')->select();
        // $tpquery =Db::table('shop_goods')->where('id',2)->value('title');
        // $tpquery =Db::table('shop_goods')->column('title');
        // $tpquery =Db::table('shop_goods')->column('title','id');
        // print_r($tpquery);
        $data = [
            'title'=>'555测试title插入数据',
            'cat'=>'2',
            'discount'=>'0',
            'price'=>'100',
            'add_time'=>'1576080000',
        ];
        $deletedata = [
            'delete'=>1,
            'update_time'=>'2576080000',
        ];
        // $tpinsert =Db::table('shop_goods')->where('id',5)->save($data);
        // $tpinsert =Db::table('shop_goods')->where('id',5)->update($data);
        // $tpinsert =Db::table('shop_goods')->insert($data);
        // $tpinsert =Db::table('shop_goods')->where('id',20)->delete();
        $tpinsert =Db::table('shop_goods')->where('id',10)->update($deletedata);
        print_r($tpinsert);
    }
}
更多相关文章

随机推荐
