My database is called: (training_session) I try to print out some information from my data, but I do not want to have any duplicates. I do get it somehow, may someone tell me what I do wrong? SELECT DISTINCT athlete_id…
I am using docker compose, I want to open few extensions and edit. So basically I want to open php.ini file. How can we exactly do that. However some solutions I read are saying to do changing in docker_compose.yaml, I…
I am using Mac OS, mamp, phpmyadmin to create a simple login form. I have created my database in php myadmin and the first user. I am certain the username and password are correct (as per my database) but I…
My xampp phpadmin is is not giving me the option to add users for mysql. I have checked everywhere and cant find the solution. Here is my code in config.inc.php, my.ini and wp-config from config.inc.php <?php /*enter code here *…
I'm taking over an existing site to make updates for a client. The original developers dumped the files on the hosting provider, imported the database, and left. They never set up the site so it's not live and I don't…
I have a database containing different information from our website. One table (called Raw_Pages) contains a list of every page on our site and the path to it (along with other fields of course). Another table (called Paths) contains a…
In my Code Igniter (PHP) application I insert multiple rows using the query below: INSERT INTO attribute_data (attribute_ID,product_ID,attribute_value) VALUES (2,3,123),(2,3,543) The column named 'attribute_value' is set to 0 for both rows. However, when I paste the query directly into phpMyAdmin…
I am trying to connect my Laravel" (Locally setup) project with cPanel Mysql remotely. But I faced issues. Please help me how to solve this Manage SSH already permitted and also I connect SSH tunnels. DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=rashgsen_bdskills DB_USERNAME=rashgsen_skills…
I am using phpMyAdmin on MySQL 5.7 The code below selects the lowest values excluding any zero values and gives me a nice table of all the teamids with the lowest times in seconds next to them for that event…
i have a little problem with mysql server. i created my docker-compose.yml, but when i want to access to phpMyAdmin (localhost:8080), an error message appeared sais that: "phpMyAdmin tried to connect to the MySQL server, and the server rejected the…