Eloquent has() method counts soft deleted rows

using

$users = User::has('comments','>=',3);

in Laravel 5.6 returns users with more than 3 comments but counts soft deleted comments, while I want the list of users who have more than 3 active comments.



from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3m5FvUc
via IFTTT

تعليقات

إرسال تعليق

المشاركات الشائعة من هذه المدونة

How to Create Treeview with Bootstrap and jQuery

صورة
Hi! Today let's see about creating treeview using bootstrap and jquery . A Treeview is a tree like representation of elements in a hierarchical structure. It offers a quick and easy navigation through websites. Although there are several jquery plugins available for tree view that simplify the task, I wanted something that works well with bootstrap. And I found out a good library called 'Bootstrap Treeview' . It leverages the best of bootstrap framework and helps you display hierarchical tree structures using the JSON data set. You can do much more than a simple tree, like fetch data from the database and render a dynamic tree, make it collapsible, add icons , checkboxes and filters etc. Building Treeview with Bootstrap: Now let's see how to add treeview in bootstrap. To build the menu, we need three different libraries, Bootstrap CSS jQuery Bootstrap Treeview These libraries are available in the cdn, so you can load them directly on your projects without down...
قراءة المزيد

Api routes not found when hosted laravel application on server

I have created my application using laravel and vue.js and hosted my application on server in subfolder inside public_html, Accessing it using url like this: https://maindomain.in/projectfolder/public/login but after login if i click on any link it points back to https://maindomain.in/dashboard and i get 404 not found in console for the api routes that are accessed for eg. accessing dashboard https://maindomain.in/api/backend/get-dashboatd-data My root htaccess file content is : <IfModule mod_rewrite.c> RewriteEngine on </IfModule> <IfModule mod_rewrite.c> RewriteEngine On # Force SSL RewriteCond %{HTTPS} !=on RewriteRule ^ https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301] # Remove public folder form URL RewriteRule ^(.*)$ public/$1 [L] </IfModule> and content of .htaccess file inside public folder is <IfModule mod_rewrite.c> <IfModule mod_negotiation.c> Options -MultiViews -Indexes </IfModule> RewriteEngi...
قراءة المزيد

How to Add Images to Dropdown List using jQuery

صورة
Hi! In this post, let's see how to add images to dropdown list using jquery . I had a form with a drop-down element for the list of countries and wanted to insert the corresponding country flag before each country name. But HTML does not support the addition of elements to select box. Then I found some CSS hack but this method is not compatible with all browsers. Finally, I decided to go with java script and found a fairly neat solution. Actually, it is a jquery plugin called 'select2'. It includes the autocomplete feature to dropdown list , but also allows you to add icons to those select options. Below, I'll show you how to use the select2 add-on to insert country flags before the country names in a drop-down list. jQuery - Adding Images to the Dropdown List: STEP-1) First load the 'jQuery' and 'Select2' libraries on the Web page. You need to add both 'css' and 'js' files of the plugin. <link href="https://cdnjs.cloudflar...
قراءة المزيد