create table Demo(

    -> id  int,

    -> name varchar(10),

    -> age int,

    -> sex varchar(5)

    -> );

$d = $a->add(['id'=>'12','name'=>'job','age'=>18,'sex'=>'gril']);

            $a->id='666';

            $a->name='haha';

            $a->age='22';

            $a->sex='boy';

            $a->add();

/*三种添加数据的方法*/

<?php

namespace Home\Controller;

use Think\Controller;

class UserController extends Controller {

    public function ff(){

    //    $a = new \Home\Model\DemoModel();

        $a = D('Demo');//thinkphp 封装的方法(优先得到子类的方法)

    //    $a->papa();//调用model里面的方法，添加数据

        //controller里面添加数据(过程化风格)

        //$d = $a->add(['id'=>'12','name'=>'job','age'=>18,'sex'=>'gril']);

        //面向对象风格

            $a->id='666';

            $a->name='haha';

            $a->age='22';

            $a->sex='boy';

            $a->add();

        //var_dump($d);

    }

}

<?php

    namespace Home\Model;

    use Think\Model;

    class DemoModel extends Model {

        public function papa(){

            //echo 'Model';

            $arr = array('id'=>'123','name'=>'healy','age'=>'99','sex'=>'girl');

            $this->add($arr);

        }

    }

?>

<?php

namespace Home\Controller;

use Think\Controller;

class UserController extends Controller {

    public function cha(){

        $DemoModel = D('Demo');

        //find()

        //var_dump($DemoModel->find('12'));//查询主键为12的

        //var_dump($DemoModel->where('id=12')->find());//加where条件

         // var_dump($DemoModel->field('name')->where('id=12')->find());//选择性操作

            //select

        // var_dump($DemoModel->field('name')->where('id>12')->select());//多条选择操作

            //var_dump($DemoModel->field('id,name,age')->where('id>10')->order('age desc')->select());//排序操作从大到小

            var_dump($DemoModel->field('id,name,age')->where('id>10')->order('age desc')->limit(1,2)->select());//limit限制性操作

    }

}

//改

    public function up(){

        $DemoModel = D('Demo');

        $arr = array('name'=>'lisi');

        $DemoModel->where('id=12')->save($arr);

    }

//删除

    public function de(){

        $DemoModel = D('Demo');

        $a = $DemoModel->where('id>4')->delete();

        echo $a;//返回删除的个数

    }