{"id":8848,"date":"2023-02-27T18:06:02","date_gmt":"2023-02-27T14:36:02","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/laravel-useful-dbeloquent-functions-23bh\/"},"modified":"2023-02-27T18:06:02","modified_gmt":"2023-02-27T14:36:02","slug":"laravel-useful-dbeloquent-functions-23bh","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/laravel-useful-dbeloquent-functions-23bh\/","title":{"rendered":"\u062a\u0648\u0627\u0628\u0639 \u0645\u0641\u06cc\u062f \u0644\u0627\u0631\u0627\u0648\u0644 DB\/Eloquent:"},"content":{"rendered":"<p>\u062f\u0631\u06cc\u0627\u0641\u062a sql \u062e\u0627\u0645 \u0627\u0632 \u067e\u0631\u0633 \u0648 \u062c\u0648\u06cc eloquent.\n<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight php\"><code><span class=\"no\">DB<\/span><span class=\"o\">::<\/span><span class=\"nf\">enableQueryLog<\/span><span class=\"p\">();<\/span>\n<span class=\"nv\">$spam_events<\/span> <span class=\"o\">=<\/span> <span class=\"nc\">SpamEvent<\/span><span class=\"o\">::<\/span><span class=\"nf\">where<\/span><span class=\"p\">(<\/span><span class=\"s1\">'user_id'<\/span><span class=\"p\">,<\/span> <span class=\"nv\">$user_id<\/span><span class=\"p\">)<\/span><span class=\"o\">-&gt;<\/span><span class=\"nf\">pluck<\/span><span class=\"p\">(<\/span><span class=\"s1\">'event_id'<\/span><span class=\"p\">);<\/span>\n\n<span class=\"nv\">$users<\/span> <span class=\"o\">=<\/span> <span class=\"nc\">User<\/span><span class=\"o\">::<\/span><span class=\"nf\">all<\/span><span class=\"p\">();<\/span>\n<span class=\"nf\">dd<\/span><span class=\"p\">(<\/span><span class=\"no\">DB<\/span><span class=\"o\">::<\/span><span class=\"nf\">getQueryLog<\/span><span class=\"p\">());<\/span>\n<\/code><\/pre>\n<\/div>\n<p><code>Raw SQL's will be shown<\/code><\/p>\n<p>\u0631\u0648\u0634 \u0647\u0627\u06cc \u0628\u06cc\u0634\u062a\u0631 \u0628\u0647 \u0632\u0648\u062f\u06cc \u0628\u0647 \u0631\u0648\u0632 \u062e\u0648\u0627\u0647\u062f \u0634\u062f.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u062f\u0631\u06cc\u0627\u0641\u062a sql \u062e\u0627\u0645 \u0627\u0632 \u067e\u0631\u0633 \u0648 \u062c\u0648\u06cc eloquent. DB::enableQueryLog(); $spam_events = SpamEvent::where(&#8216;user_id&#8217;, $user_id)-&gt;pluck(&#8216;event_id&#8217;); $users = User::all(); dd(DB::getQueryLog()); Raw SQL&#8217;s will be shown \u0631\u0648\u0634 \u0647\u0627\u06cc \u0628\u06cc\u0634\u062a\u0631 \u0628\u0647 \u0632\u0648\u062f\u06cc \u0628\u0647 \u0631\u0648\u0632 \u062e\u0648\u0627\u0647\u062f \u0634\u062f.<\/p>\n","protected":false},"author":2,"featured_media":8849,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"","fifu_image_alt":"","footnotes":""},"categories":[339],"tags":[],"class_list":["post-8848","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dev"],"_links":{"self":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/8848","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/comments?post=8848"}],"version-history":[{"count":0,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/8848\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media\/8849"}],"wp:attachment":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media?parent=8848"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/categories?post=8848"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/tags?post=8848"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}