I am trying to containerize my company's app. When I deploy that app in VM, I have to install MySQL in the same VM because the application has a hardcoding 127.0.0.1:3306 in the source code. Now I am trying to…
I'm trying to achieve a simple custom AJAX request from my Wordpress Page. I don't want to use form data but custom data from input fields. When I try to use the data, that is send by the AJAX Call…
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…
Good day, I am making a website. I'd like this site to have an account-system. Following multiple tutorials and teaching myself, I believe I've made a decent system using Apache and MySQL. However, when linking the PHP files from the…
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'm working on localhost doing some pages with wordpress. Yesterday I've finished to work with some pages, and then I turn off my pc. Today when I turned it on and I've tried to reach some pages (after have turned…
I run php artisan migrate, my basic migrations are taking a very long time. Then the database server is restarted and laravel returns an error SQLSTATE[HY000] [2002] Connection refused. What could be the problem? My .env db DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306…
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…
Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE SET numb='61' WHERE ID='#ID'' at line 1 in C:xampphtdocsweb_2.1phpsend.php:20 Stack…