I have a problem in retrieving datas and using it to check checkboxes in Laravel. I want that when the edit pages are opened, the checkboxes will be checked based on the records on the database. Edit view page: @php…
I have a laravel project and in this project there is a table like this: I need to run a query and return a result where the $circulation variable is in range of the column range_from and range_to. So I…
I'm a newbie to Laravel so I'm probably making some sort of noob error. That said, here's my problem. I'm trying to access a related table from within my blade,. Here are relevant portions of my models: class _MeetingUser extends…
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,…