mysql

  1. D

    PHP Simple powerful PHP library for data sanitization

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

    would Firebase be good for making a forum/chatroom?

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

    PHP how to make a mysql database on replit?

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

    PHP Getting content from SQL database with PHP works fine until I add a for loop

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

    Docker Compose Issue : Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not set

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

    Java CommandLineRunner won't add roles to users

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

    Calculate leave days based on leaveStart and leaveEnd

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

    How do i write the code to connect to mySQL on phpmyadmin that is hosted by my university

    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?
  9. madyrafi

    C# Login Details Code Error

    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 != "" &&...
  10. madyrafi

    C# Connection string Error C# to Mysql insert button code

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

    JavaScript Extract variable value from mysql query result

    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...
  12. Roy Harper

    LAG() not working on phpmyadmin

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

    SQL search by part of name

    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...
  14. Roy Harper

    How to select records if the total from another table is not equals to Zero (0)?

    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 =...
  15. D

    PHP Having problem involving getting database content to show up after passing a query string.

    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...
  16. @pearljy22

    Age calculate

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

    Tutorial Create Table in Installation Script

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