thinkphp之数据库操作

<?php

namespace app\zjd\Model;

use think\Db;
use think\Model;

class CityModel extends Model
{
    function selectId($Id)
    {
//        $req = Db::query('select * from city where id = 54');

        //select返回一个二维数组集合,如果没有返回空数组
        $req2 = Db::table('city')->field('id,name,num_people as numPeople')->where('id',$Id)->select();

        //column 返回一个一维数据,如果没有返回空数组
//        $req2 = Db::table('city')->column('name');

        //fine返回一条数据,如果没有返回null
//        $req2 = Db::table('city')->where('num_people',113)->find();


//        $req2 = Db::name('city')->find();


        if (empty($req2))
        {
            $req2 = [];
        }
        return $req2;

    }

    //添加数据
    function addCity($cityDict)
    {
        //返回插入的行数
//        $row = Db::name('city')->insert(
//            $cityDict
//        );
        //返回插入id
        $row = Db::name('city')->insertGetId(
            $cityDict
        );

//        $data = [];
//
        for ($i=0;$i<10;$i++)
        {
            //$arr[]=$a;$arr[]=$b 等价于 array_push($arr, a, b ... eln);
            //往数组中追加元素
            //'北京{$i}'与"北京{$i}"有区别,""解析变量-输出北京0,''不解析变量-输出北京{$i}
            $data[] = ['name'=>"北京{$i}",'num_people'=>300];
        }
        echo json_encode($data);


        $row = Db::name('city')->insertAll($data);

        if ($row>0)
        {
            return $row;
        }else
        {
            return $row;
        }
    }

    //修改数据
    function updateCity(){

        $row = Db::name('city')->where('id',690) ->update(
            [
                'name'=>'北京',
                'num_people'=>'230'
            ]
        );

        return $row;

    }



}

 

<?php
namespace app\zjd\controller;
use app\zjd\Model\CityModel;
use lib\Returns;
use think\Db;

class CityController
{
    //根据id查询数据
    function selectCity()
    {
        $Id = input('Id');

        $model = new CityModel();

        $req2 = $model->selectId($Id);

        if (empty($req2))
        {
            return Returns::returnJson(1000,'失败',$req2);
        }else
        {
            return Returns::returnJson(2000,'成功',$req2);
        }

    }
    //添加数据
    function addCity()
    {
        $name = input('name');
        if (empty($name))
        {
            return Returns::returnJson(1000,'请输入城市');

        }
        $num_people = input('num_people');
        if (empty($num_people))
        {
            return Returns::returnJson(1000,'请输入人口');
        }

        $cityDict = ['name'=>$name,'num_people'=>$num_people];

        $model = new CityModel();

        $req2 = $model->addCity($cityDict);

        if (!$req2)
        {
            return Returns::returnJson(1000,'失败');
        }else
        {
            return Returns::returnJson(2000,'成功',['id'=>$req2]);
        }

    }
    //修改数据
    function updateCity(){

        $model = new CityModel();

        $req = $model->updateCity();

        if ($req>0)
        {
            return Returns::returnJson(2000,'成功',$req);
        }else
        {
            return Returns::returnJson(1000,'失败',$req);
        }
    }
}