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…
I am using this Docker config: https://github.com/romaricp/kit-starter-symfony-4-docker I start the environment by using: docker-compose build followed by: docker-compose up -d Everything is running fine but there is a problem with MySQL service. I get an Symfony error: "An exception occurred…
I'm getting this error with my code: SELECT flatpack_ig,FlatpackID ,Name,Colour,Type,UnitPrice,component_ig,ComponentNo, component_ig, description FROM flatpack_ig INNER JOIN flatpackcomponent_ig ON flatpack_ig, FlatpackID= flatpackcomponent_ig,FlatpackID INNER JOIN component_ig ON flatpackcomponent_ig, ComponentNo=component_ig,ComponentNo ORDER BY flatpack_ig,FlatpackID
I'm having trouble in fetching the data using aggregate function and BETWEEN clause. $statusQ = "SELECT COUNT(total_submit_sub) AS noofsub FROM total_noof_sub WHERE sub_name = 'PHP' AND sem = '8' AND dept = 'CE' AND laborlec = 'Lab' AND faculty_name =…
I want to make some function in phpmyadmin DELIMITER // CREATE FUNCTION total_bayar (order_id char(10)) RETURNS double DETERMINISTIC BEGIN DECLARE dist double; SET dist = SELECT sum(qty * price) FROM detail_masakan WHERE order_id = order_id; RETURN dist; END// DELIMITER ;…
I have a Magento shop (using MySql db) and just noticed that some developer introduced a custom db for capturing some structured data. Now I noticed that the tables are not linked via foreign keys with each other, but just…
i'm trying to create a multiple photo uploading script in php. All seems to be working fine except the update query. tried updating it manually in phpmyadmin and the problem of not updating persists don't know what to do can…