mysql

Hello, I've created a highly efficient and robust PHP library designed specifically for data sanitization. It combines simplicity with remarkable power, ensuring swift processing. This library empowers you to effortlessly sanitize diverse data types, eliminating the need for extensive manual...

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...