I'm not sure what is happening or why this is happening so hopefully someone can give me tips on how to debug or where to look. I have 2 docker containers, 1 for phpmyadmin and another for mysql. The phpmyadmin…
My client gave me access to his hosting account in order to create a new user for his Wordpress site since he forgot the credentials for the old one. I got the FTP account and opened wp-config.php and normally i…
How can I write query for below table in Laravel. Like In my app logged user id is 109 So I need whose user match with logged user in BlindDate and PaidDate table to user id. This is User table…
I'm using GCP for hosting my Wordpress website, which is using php 7.4 and Debian. I followed the steps for Google Click to Deploy and I am able to access <IP/Domain>/phpmyadmin to get to the database. How can I make…
I need to import a sql. database to Wordpress through phpMyAdmin. Anytime I want to create a new database this error happens (#1044 - Access denied for user 'xxx' to database 'zzz'). Thanks for your help.
I am new to Laravel and I built a Linktree clone following a Youtube video. I had many problems since I was coding in Laravel 8 and his project was in an older version of Laravel. Now, I don't have…
I am trying multiple having but problem is with multiple having conditions any one guide me how to adjust two having in same query Here is SQL Query : SELECT schools.*, schools.required_gpa AS gpa, (college_act_scores.min_act + college_act_scores.max_act)/2 AS act_avrg ,…
I have a table where I save plays for players over a specific game on it. the game has different levels. the player can play the same level multiple times. I need to query that table to count the number…
I have a central database containing millions of IDs. And I have a group of users (50-100 users), all being able to request extraction of IDs from this big database. Atm what I do is when a user sends a…
I installed Xampp server and Wamp server together in my computer. Wampp is working fine. But Xampp is getting errors. I watched some videos on youtube. But nothing worked for me. I want to Xampp and wamp server together on…