I have the following code in a controller file $customer->update([ 'name' => $request->input('name'), 'address' => $request->input('address'), 'phone' => $request->input('phone'), 'percentage' => $request->input('percentage') ]); which successfully updates everything except the percentage field which is of type DECIMAL(2,2) I get no error…
Each "Item_ID" with its data is inserted 4 times into database, here's my code: try { $user_id = $_SESSION['uid']; $sql = "SELECT * FROM items WHERE Item_ID IN (" . implode(',', $_SESSION['cart']) . ")"; $query = $pdo->query($sql); $orders = $query->fetchAll(PDO::FETCH_ASSOC);…
I have made a blogging application in Laravel 8. The (single) article view displays comments under the article and I am now working on adding a comments reply functionality (link to the current code). In appModelsComment.php I have: class Comment…
I am trying to query a list of rows from the database. It has 7 fields (columns) (A,B,C,VA,VB,VC,LISTED). SELECT * FROM datas WHERE ((A=1 OR A IS NULL) AND (B=1 OR B IS NULL) AND (C=1 OR C IS NULL))…
I have two tables A and B. A (id int PRIMARY_KEY, json_field JSON) B (a_id FOREIGN_KEY, value int) The relationship is One To Many. So A.id might occur several times in B.a_id. So the tables could look something like this:…
Working on a MySQL db which contains the Book Title, Author, Publication in a single column(field). The original db designer is said to put all those in single field to allow for easy search. Age-old client database, so I am…
I want to deploy application called "banksmart" in glassfish application server. This step is done for database connection for banksmart deployment. I am getting the following error when I ping in glassfish from here: https://imgur.com/a/4gwvIsj Ping Connection Pool failed for…
I'm hurting for an answer on this one. I'm not great at SQL just yet, but I'm trying to write a select statement that finds dates within a certain range. My problem, I think, is that the date values are…
I want to retrieve yesterday's record in an exact hour and minute time For example, this is today's date and time 2023-04-22 14:32:15 I want the records in 2023-04-21 14:32:15 I tried some queries but non of them works for…
I am trying to search userId for value 22 from nested json in mysql Column my json is '{ "data": [ {"calendarId":"11","userId": "12"}, {"calendarId":"21","userId": "22"} ] }' I tried the following syntax : 1. where JSON_EXTRACT(column_field,'$.userId') = 22 2. where…