My current project is a social media app somewhat like Facebook. Now the post created by both users and news post (there is a cron running every 15 min and it fetch latest news from various news channels) are keeping…
i'm just learned how to make database here. So i have a project to make database for item inventory and i'm using phpmyadmin. I'm struggling to add values in two columns. So i have this table: quantity jumlah_masuk jumlah_keluar saldo_akhir…
If I use this in PHP to count records, it gives a count of 1 when there are, in fact, no records. However, when I run the same query in HeidiSQL, phpmyadmin or any other, it gives the proper 0.…
I'm trying to write an SQL query that combines two tables and two columns in one of the tables. So, I have two tables Table: Items ID Material Shape 1 glass jar 2 plastic bottle 3 cardboard box 4 glass…
The order table is made up of quantity, price, username and orderdate which is in datetime format. An order is submitted from a cart page, if multiple items are submitted such as 8 monitors and 2 pcs. It will input…
I have a docker compose file which is basically trying to build a WAMP/LAMP style environment. Basically, PHPMyAdmin can't seem to connect to MySQL. Looking through answers here, it appeared that it was an issue with legacy auth using MySQL…
I'm trying to configure my own local server on Windows 7 with binary versions of PHP, Apache, MySQL and phpMyAdmin. I configured and run Apache with PHP successfully. Now I want to configure MySQL and phpMyAdmin. First I created the…
I have created on table with a PHP while loop right from the phpmyadmin database fine on page 1 (cpu.php). However, I am not able to send just the name variable ( $row['name'] ) from one selected row to another…
I am trying to write a query that counts the number of records that were created every 7 days, Using this query i get the number of records created per day, SELECT 'Closed' AS `Status`, COUNT(*) AS `Count`, `raisedon` AS…
Symfony can't seem to connect to the database even if I can do it with the same credentials using PMA. docker-compose.yml: version: '3' services: apache: build: .docker/apache container_name: sf4_apache ports: - 80:80 volumes: - .docker/config/vhosts:/etc/apache2/sites-enabled - .:/home/wwwroot/sf4 depends_on: - php…