mysql

i struggle with php, so i was thinking should i use firebase instead of mysql, or should i keep using mysql and use node.js instead of php

Hello everyone, with a friend we make a dynamic website and for collaborate, we make it on replit.com, because we don't find how to create a database in this website. Did you know how to make it? (sorry for the spelling, i'm french) Thank you and good evening.

I'm trying to make a dynamic gallery page for a website. This code works fine: <?php $servername = "server"; $username = "username"; $password = "password"; $dbname = "dbname"; $conn = new mysqli($servername, $username, $password, $dbname); if ($conn->connect_error) { die("Connection...

I have a problem about running docker-compose file through this command (`docker-compose up -d`). After running the command, I noticed that 3 services (**advertisement service, user service and lastly report service**) cannot run. It throws an error when I try to see logs in each services...

I'm follow a tutorial on Spring Boot Security, but I got stuck. Currently I'm setting up a CommandLineRunner, which does 3 things: - Create Roles - Create User - Add roles to users Running the code creates a table with the created roles and a table for the created users, but adding roles to...

I am trying to calculate the total leave days based on two dates. I tried using datediff and timestampdiff but it gives me the wrong result. For example I input: leaveStart = "2022-04-26" leaveEnd = "2022-04-27" So the total leave days should be 2 days because the leave is from 26 to 27...

i am creating a program that is coded in c++ in visual studio and don't know how to connect to MySQL server that is hosted by the university on myphpadmin will someone be able to show me the code I would use to connect to it?

Sir, I have studied and tried to put login page but it shows code error please tell me the correction sir It shows error: System.InvalidOperationException: 'The connection is already and also code error private void button14_Click(object sender, EventArgs e) { if (textBox9.Text != "" &&...

I want to insert table in db and make connection to mysql to vs. Error for below code is: System.NullReferenceException: 'Object reference not set to an instance of an object.' System.Configuration.ConnectionStringSettingsCollection.this[string].get returned null. using System; using...

This may seem like a pretty basic one but I am executing the query: var sql = 'SELECT command FROM motoron2 ORDER BY id DESC LIMIT 1'; and seeing the following from console.log(result) --> [ RowDataPacket { command: 1 } ] How can I make a variable named command equal to 1 from this? Below is...

I created a view for weekly sales. Everything is working fine on localhost using MySQL. But when I upload the database on GoDaddy Lag doesn't seem to work. When I am typing LAG on phpmyadmin, no suggestion is showing. Can anyone help me with this one? Thanks the structure of vw_sales is...

Can u help with this: -find an item in the database by entering part of its name CREATE TABLE Confectionery ( IDConfect INT IDENTITY NOT NULL PRIMARY KEY, NameProduct NVARCHAR(50) NOT NULL, Category INT NOT NULL, Quantity SMALLINT NOT NULL, Price DECIMAL(20) ); CREATE TABLE...

I have a product categories listed in my website. But, I don't want to show categories that has 0 products under it, as you can see in the image below. Here is my code: SELECT c.category AS category, (SELECT COUNT(*) FROM products AS p WHERE p.categoryID =...

Hello, I have been stuck on this and figured I would come here to seek assistance. The main objective of this project is to create an intranet and have the employee name link to a details.php which displays details about that specific employee. the problem I am having is that whenever I click on...

Please help me. I have a problem, I can't get the day/s old. 2 MONTHS AND 14 DAYS DECLARE n_yr INT(11); DECLARE n_mon INT(4); DECLARE n_day INT(4); SELECT TIMESTAMPDIFF( YEAR, prev_dte, cur_dte ) INTO n_yr; SELECT TIMESTAMPDIFF( MONTH, prev_dte, cur_dte ) % 12 INTO...

Much like popular online software, we can create scripts that automatically generate database tables. This comes in handy because it allows the user to simply give us the database name / user / password / host information instead of forcing them to upload an SQL file or manually create the...