I built a web app in Visual Studio 2019 .net that runs fine when hosted in IIS. The web app connects to a MySql server on my Synology NAS. I want to build a docker image for it to move…
I followed the guide on azerothcore.org to install the server. When I launch the authserver.exe and worldserver.exe, everything seems to work fine. I can see in MySQL Workbench that acore is connecting to the database. When I open a client…
I have a wordpress website that was hacked. The hacker inserted hidden HTML in my posts (wp_posts table) using this HTML pattern: <div style="overflow:hidden;height:1px;"> <p>Text here, always different</p> <p>More text....</p> </div> Is it possible to locate in the DB everything…
I have tables named course, student and students_in in a MySQL database. The tables look like this: course course_id name 3 Physics 12 English 19 Basket Weaving 4 Computer Science 212 Discrete Math 102 Biology 20 Chemistry 50 Robotics 7…
There's been a lot of talk about this already, but I just found confusion. I want to send notifications on my android app to a single user. (I hate android studio, and I'm not that good at java) I have…
My table structure: CREATE TABLE `jobs_view_stats` ( `id` int(11) NOT NULL AUTO_INCREMENT, `job_id` int(11) NOT NULL, `created_at` datetime NOT NULL, `account_id` int(11) DEFAULT NULL, `country` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_D05BC6799FDS15210` (`job_id`), KEY `FK_YTGBC67994591257` (`account_id`), KEY…
I'm trying to multiply the result of a subquery with a field from the 'main' query. See the following example: Table: subscriptions id title price Table: users subscription_id SELECT subscriptions.id, subscriptions.title, (select count(*) from users where users.subscription_id = subscriptions.id) AS…
I have a two-column table: product name cars ["bmw", "mazda", "ford", "dodge"] fruit ["lemon", "orange", "lime", "apple"] I'm using a wildcard to search the product's name column. My question is, is there a way to search a column only by…
I try to POST data to database with "form-data" on "postman" with Laravel 9, and I try to return the data to JSON. This is my controller: <?php namespace AppHttpControllers; use IlluminateHttpRequest; use AppHttpRequests; use AppM_Barang; class Utama extends Controller…
I was trying to make a simple database to write and read from and on pretty much one of the first steps I encountered a problem: it would not connect. I got the error message: "No connection could be made…