\u9ed8\u8ba4toSql \u83b7\u53d6\u5230\u7684 sql \u91cc\u9762\u7684\u53c2\u6570\u4f7f\u7528 “?” \u4ee3\u66ff\u7684\uff0c\u5982\u4e0b\uff1a
\nDB::table(‘news’)->where(‘id’, 1)->toSql();
\n\u83b7\u53d6\u5230\u7684 sql \u8bed\u53e5\u662f\uff1a
\nselect * from `cxybj_news` where `id` = ?
\n\u6709\u65f6\u5019\u6211\u4eec\u60f3\u8981\u5f97\u5230\u5177\u4f53\u7684\u8bed\u53e5\uff0c\u53ef\u4ee5\u5229\u7528 builder \u7684 getBindings \u65b9\u6cd5\uff1a
\n$builder = DB::table(‘news’)->where(‘id’, 1);
\n$bindings = $builder->getBindings();
\n$sql = str_replace(‘?’, ‘%s’, $builder->toSql());
\n$sql = sprintf($sql, …$bindings);
\ndd($sql);
\n\u83b7\u53d6\u5230\u7684 sql \u8bed\u53e5\u662f\uff1a
\nselect * from `cxybj_news` where `id` = 1
\n\u5982\u679c\u7ecf\u5e38\u4f7f\u7528\u53ef\u4ee5\u8003\u8651\u4f7f\u7528 Builder \u7684 macro \u65b9\u6cd5\u52a0\u8fdb Builder \u91cc\u9762\uff1a\\Illuminate\\Database\\Query\\Builder::macro(‘sql’, function () {
\n$bindings = $this->getBindings();
\n$sql = str_replace(‘?’, ‘%s’, $this->toSql());
\nreturn sprintf($sql, …$bindings);
\n});
\ndd(DB::table(‘news’)->where(‘id’, 1)->sql());<\/p>\n","protected":false},"excerpt":{"rendered":"