Using Laravel 10 and trying to get a belongsTo relationship to work and it's not working. Basically a Fragment has one FragmentGroup while a FragmentGroup has many Fragments. I'm using it this way and it's giving me null: $fragment =…
I have a simple json table containing an array of values: [1,2,3,4,5,6,7,8,9] I'm trying to query this table by multiple conditions: Must contain the value 2 Must contain atleast 3 of the other values, it does not matter which ones…
I have an array which I use to filter out the results of a certain query. There is a known issue where the query returns null, when the passed array in whereNotIn() or whereIn() exceeds a certain amount (I think…
I'm working on a project using Laravel 10. My goal is to show all customers data and added with a field containing the date of the last penawaran data made by that customer. Each Customer can create multiple Penawaran, but…
I use Laravel 10. I try to fetch some data from my mariaDB with the following condition. $contentList = $this->get(); foreach($contentList as $content){ $this->product()->where('id', '=', $content->content_product_id)->ddRawSql(); } But the query I get is: select * from `radio_content_products` where `radio_content_products`.`id` is…
I'm trying to delete data in my Laravel project, but when I click on the Delete menu, it just shows the confirmation alert. After I click OK, it only refreshes the /barang page, which shows the records list in the…
I have two tables bets and users. bets columns tickets (json) draw_date user_id I would like to get all tickets from users of a specific draw_date. Example result: [ 1 => [283983, 389239, 484843], 2 => [122343, 332344] ] 1,…
I would create a virtual model modelC (with no real table on the DB) as join between model modelA and model modelB. My need is to access to model modelC like a standard model and access to his attributes (modelA…
I have two tables in my db. Table Permit ID Permit_type Max_allowed 1 Full 24 2 Half 12 3 Quarter 6 Table Entry ID User_ID User_Name Permit_type Duration Status Date 1 1 John Smith Full 6 Approved 2023-12-08 2 2…
When Laravel Eloquent calls a relation property that indicates the original model of the relation destination from a certain model, it issues a re-query and returns the original model. Is there a way to return the original model without issuing…