SQL CRUD $ret=$Model->execute("update think_user set score={$score} where username='{$username}'");

 

    //http://localhost/thinkphp323/index.php/home/User/query_score/score/20
    public function query_score($score=60){    
        $Model = new \Think\Model(); // 实例化一个model对象 没有对应任何数据表
        $ret = $Model->query("select * from think_user where score >= " . $score);
        var_dump($ret);
    }
    
    //http://localhost/thinkphp323/index.php/home/User/insert_user?username=lily&score=60
    public function insert_user($username,$score=60){
        $Model = new Model(); // 实例化一个model对象 没有对应任何数据表
        $ret=$Model->execute("insert into think_user(username,score) values('{$username}',{$score})");
        var_dump($ret);
    }
    
    //http://localhost/thinkphp323/index.php/home/User/delete_user?username=lily
    public function delete_user($username){
        $Model = new Model(); // 实例化一个model对象 没有对应任何数据表
        $ret=$Model->execute("delete from think_user where username='{$username}'");
        var_dump($ret);
    }

    //http://localhost/thinkphp323/index.php/home/User/update_user?username=lily&score=60
    public function update_user($username,$score=60){
        $Model = new Model(); // 实例化一个model对象 没有对应任何数据表
        $ret=$Model->execute("update think_user set score={$score} where username='{$username}'");
        var_dump($ret);
    }