I need to find all results that include this substring (note the leading zero): $code = '02549'; Nomenclature::where('code', 'like', '%' . $code . '%')->get(); With such a builder, I get the correct request: select * from `nomenclatures` where `code` like…
My database : MySQL Project : Symfony 6 Table structure : 1 article may have many comments each article must have 1 article. Steps : 1 - I can list my articles filtered by user roles. 2 - I can…
Name Date Score A 01-01-2023 100 A 01-01-2023 200 A 03-01-2023 300 B 02-01-2023 400 B 03-01-2023 100 B 03-01-2023 100 i have this table and i want to seperate it into multiple column of date and SUM the score…
I'm coding in Symfony a search bar working with a query builder for an entity named "Structure" which is related to an entity "Partenaire" (OneToMany), it's working great but the problem is that it shows all the structures and I…
I need to make a query to return only active records which in this case are imo_status == 1 What is the best way to make this query? I'm using CI3 Below is the source code. // LISTA OS AGENCIAMENTOS…
My solution: $author_id = 25; $sql = "SELECT DISTINCT author_id AS label FROM users WHERE author_id ::text LIKE '%:term%' AND role = 'Editor'"; $query = Users::findbysql($sql, [ ':term' => $author_id ] )->all(); The problem is the label alias, which then…
I am working with a booking appointment system. I want to find out how many time slots are available and how many time slots are already booked. time slot count will be change base on the appointment. I used laravel…
Hi I have a situation where I want $first_name = $request->first_name; $last_name = $request->last_name; $customers = Customer::where('first_name','=',$first_name) ->where('last_name','=',$last_name **OR $last_name <> NULL**) ->get(); I want where clause to be implemented only if the input $last_name is not blank. How can…
I have the following Laravel query, it does not appear to be returning the $abort and $pend variables as strings: $abort = "Aborted"; $pend = "Pending"; $transactions = DB::table('callpay_transactions') ->select(DB::raw('SUBSTR(created,1,7) as YrMth') ,DB::raw('SUM(amount) as total_sales' )) ->where('status', '!=', $abort) ->where('status',…