I wrote the following code DELIMITER $$ CREATE TRIGGER bm_keuangan AFTER UPDATE ON pembayaran_project FOR EACH ROW BEGIN DECLARE nama_project varchar(100); DECLARE cek_di_keuangan varchar(100); IF (!(isnull(NEW.deleted_at))) THEN UPDATE keuangan SET keuangan.deleted_at = now() WHERE keuangan.ref = NEW.id AND keuangan.jk_id =…
PHPMyAdmin is showing some strange results when I go to export a table as SQL. If I go to the main database and select Export (i.e. the whole database) at the top it works as expected but when I go…
I'm working for a page where it shows a tables from database. Let's say I have 100 rows. How to show 21st-30th row? In the table, there's some fields, not only email, name, and description. So, I used mysqli_fetch_assoc for($num=21;$num<=30;$num++){…
I want to fetch number of rows with highest number of multiple of 20, Like if my table have 148 rows then limit should be 140 leaving the latest 8 entry behind, or if my table have 170 rows then…
I`ve just installed LAMP stack (also tried with nginx) and after installing the phpmyadmin and trying to access 'localhost/phpmyadmin', I receive this message: The mysqli extension is missing. Please check your PHP configuration I already have tried the steps from…
I have a very simple table that looks like this: It's called anni_tot and it has a single field called anni. Now, there is another table that looks like this: It is called people_emp. Now, I want to insert a…
I'm trying to build a filter function with several dependencys but when i add an AND to the SQL query, it seems like no results were found but if i'm searching with the queries before and after the AND, the…
I’m new at php and I got some problem that I don’t know how to fix, I made A HTML form that should change the name of a database <div class="form-group"> <form action="name.php" method="post"> <input type="text" class="form-control" name="name"> <input type="submit"…
How to create the well known export as SQL in latest phpMyAdmin ? There is no choice for SQL anymore!
So I tried to make these following two tables with phpmyadmin. create table category ( catId int identity(1,1), catName varchar(20), Constraint pk_category PRIMARY KEY(catId)) create table subcategory ( subCatId INT IDENTITY(1,1), catId INT, subCatName VARCHAR(20), CONSTRAINT pk_subcategory PRIMARY KEY(catId,subCatId), CONSTRAINT…