How to use native MySQL statements in TP (code)-PHP Tutorial-php.cn

How to use native MySQL statements in TP (code)

不言

Release： 2023-04-03 20:58:02

Original

2853 people have browsed it

The content of this article is about the method (code) of using native MySQL statements in TP. It has certain reference value. Friends in need can refer to it. I hope it will be helpful to you.

Recently I was developing a project in Thinkphp and wanted to use native MySQL statements. I finally tried it and found it particularly helpful for complex query and update operations! Let’s introduce it in detail below!

1. Use the native mysql core

$Model = M();        
$result = $Model->query($sql);//查询
$Model->execute($sql_ex);//更新修改删除

Copy after login

2. Specific usage

  <?php
    /**
     * 一亩地
     */
    public function dealYimudi(){
        $sql = "SELECT * from yimudi y LEFT JOIN yimudi_use yu on y.yimudi_id =yu.yimudi_id WHERE  yu.yimudi_id = 12 and yu.use_status in (1,2) and y.use_end_time+86399 < UNIX_TIMESTAMP(now())";

        $Model = M();
        $result = $Model->query($sql);

        $yimudi_ids =[];
        foreach ($result as $key => $value) {
            $yimudi_ids[] =$value[&#39;id&#39;];
        }
        foreach ($result as $key1 => $value1) {
           if(in_array($value1[&#39;id&#39;],$yimudi_ids)){
            $str_yimudi_id = $value1[&#39;id&#39;];
            $sql_ex = "update yimudi_use set use_status = 6 where id = &#39;$str_yimudi_id&#39;";

              $Model->execute($sql_ex);

           }
        }
        // $result = $Model->query($sql);
        // dump($result);die;
    }

Copy after login

You can try it!

Related recommendations:

Thinkphp upload class implements code for uploading images

How to use TP5.1 template loop tags (code)

The above is the detailed content of How to use native MySQL statements in TP (code). For more information, please follow other related articles on the PHP Chinese website!