Lavarel 输出带参数sql

aloneship

1. $where = [
   
2.     'is_finance' => 2,
   
3.     'status' => -2,
   
4.     'refund_status' => 2,
   
5.     'add_time' => 2,
   
6.     ['add_time', '<', 123456789]
   
7. ];
   
8. $query = self::where($where);
   
9. $sql = $query->toSql();
   
10. $bindings = $query->getBindings();
    
11. $results = $query->get();
    
12. 
    
13. $full_sql = vsprintf(str_replace('?', '%s', $sql), collect($bindings)->map(function ($binding) {
    
14.     return is_numeric($binding) ? $binding : "'{$binding}'";
    
15. })->toArray());
    
16. 
    
17. dd($full_sql, $results);

复制代码

aloneship

         $sql = $obj_db->toSql();
            $bindings = $obj_db->getBindings();
           // $results = $obj_db->get();

            $full_sql = vsprintf(str_replace('?', '%s', $sql), collect($bindings)->map(function ($binding) {
                return is_numeric($binding) ? $binding : "'{$binding}'";
            })->toArray());

            dd($full_sql);