Im doing a project for restaurant.so in it i need invoice tabel in database.in invoise there are multiple items like mango juice and fried rice, like wise.the amount of items are different for each bills.so how i create my in…
I have a PHP form which saves user data to a MySQL database. I want to show the user which information is held about them and display it in a form in order for them to update or edit the…
I wanna deploy MySQL+PHPMyAdmin. My docker-compose.yml: version: "3" services: db: image: mysql:5.7 restart: always container_name: db volumes: - ./~mysql:/var/lib/mysql - ./mysql.cnf:/etc/mysql/conf.d/my.cnf environment: MYSQL_DATABASE: "dbtest" MYSQL_ROOT_PASSWORD: "123456" MYSQL_ROOT_HOST: "%" networks: - db command: --default-authentication-plugin=mysql_native_password healthcheck: test: "mysqladmin ping -h localhost" interval:…
I'm trying to make a list of the best items in the database. An item is better if the profit is higher. The problem is an item a can have duplicates like 500 profit at 10 o'clock and 750 profit…
I have a 70mb table dump that I need to added back into a database. I have tried phpMyAdmin but even with increasing the time_out and other settings in php.ini and config.inc.php it keeps timing out. max_execution_time 900 max_input_time 900…
I have two different types of objects, let’s say event and person. Each person can attend multiple events. I want to have two tables event - id [int (4),primary] - name [varchar (30)] - … person - id [int (4),primary]…
I use phpmyadmin for handle the mysql database. I have got a table that call NodeJS and the column of this table calls id and number. I tried to create a JSON file with this trigger on mysql: SELECT id,…
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…
My code: $sql = "SET @row_number = 0; SELECT (@row_number:=@row_number + 1) AS num, player, reinforcees, reinforcers FROM _KoT_villages WHERE o = '".$data[2]."' OR o = '".$data[4]."' ORDER BY CASE WHEN player = '".$user_class->id."' THEN 1 ELSE 2 END"; $result…