I have a clean new mysql database on my localhost, and also I have a project built on codeigniter PHP framework and have a copy of that project database. However, when I import the database into my clean new database…
I have a table "rota" where volunteers submit the shifts they are available. They can submit more than 6 shifts, but 6 is the minimum required. I want to see how many volunteers have selected each of the shifts, but…
Attendance Portal in PHP I am facing problem at Final Attendance Report Generation I'm stuck at the final stage of the Project: I have a Table- attendance, If a student is Present I mark it as 1 if absent 0.…
With Laravel/Lumen eloquent I can get count relations like this: User::withCount('views')->get(); this will use SQL select `users`.*, (select count(*) from `views` where `users`.`id` = `views`.`user_id`) as `views_count` from `users` and return all models with views_count attribute, great. But I need…
Replace in a videos table with a column URL with many different URL types. I use MariaDB 10.3 https://google.com/questions/ask?963 https://google.com/embed/57=66.88.028.10/i/03/077fsdf https://google.com/top57=66.88.028.10/i/03/077 https://video.net/emb.html?asdeen45dr57=66.88.028.10/i/03/07776/asdeen45dr57 https://video.net/fomdfk5f7s1f.html https://video.net/emb.html?qsfeen4gttv1=54.47.158.810/i/11/00036/qsfeen4gttv1 I need to delete part of a specific URL (delete all after =) and replace with…
I have two tables: “rota” (1) and “volunteer” (2). The first name and last name columns are in (2), but the shifts in (1). With the following query I am able to see the names of those who have submitted…
I want to see new records and updates entered in the log table, I created a trigger for this but I get error 1442. Can you help me, please? CREATE TRIGGER `trigger_changes` AFTER UPDATE ON `customers` FOR EACH ROW Update…
Hello everyone I'm going to try to explain my problem as clear as possible, feel free to ask me more precision if you didn't understand what I meant and forgive my mistakes, English is not my mother tongue. My goal…
I'm doing a PDO UPDATE query to MariaDB database. $query = "UPDATE :table SET `name`=:name, `title`=:title, `description`=:description WHERE id=:id"; $stmt = $this->conn->prepare($query); $stmt->bindParam(':table',$this->table, PDO::PARAM_STR); $stmt->bindParam(':id',$this->id, PDO::PARAM_INT); $stmt->bindParam(':name',$this->name, PDO::PARAM_STR); $stmt->bindParam(':title',$this->title, PDO::PARAM_STR); $stmt->bindParam(':description',$this->description, PDO::PARAM_STR); $stmt->execute(); It seems to me that everything is…
I have the next query to get the 15 most sold plates in a place: This query is taking 12 seconds to execute over 100,000 rows. I think this execution takes too long, so I am searching a way to…