I have made a dropdown list which fetches data (name) from database and displays in options of dropdown list. Now I am trying to fetch full row of that selected name from the list and want to save each data into a variable for further usage. Can anyone guide me… This is my first project in PHP/MySQL, pl…
Tag: mysql
Does it matter if the function calls in this loop run concurrently? And if so, how do I make each wait until previous is done?
This code works as expected now, but as my app loads, I am doing API calls to gather data from 8 different tables. I notice that all the calls are happening almost simultaneously and out of order. Order doesn’t actually matter as long as they all happen, as I’m just loading data. I’m just tr…
Why am I getting this UNEXPECTED HTTP error in NodeJS
So guys i’m setting up my backend in NodeJS for an e-commerce website. But I ran into an error trying to implement the “Order” method. First the connection to mysql database : Then in my Models there is a Client class that contains the following method : The orderData parameter in the order(…
nodejs MySQL – Server requests authentication using unknown plugin
When attempting to connect to MySQL 8.0.21 server running Ubuntu 20.04 using NodeJS and mysql2 package, I receive the common error below: Server requests authentication using unknown plugin sha256_password I know that mysqljs and mysql2 do not support sha256, so I confirmed my user was setup for mysql_native_…
Upload a file to byte array in MySQL successfully, however the content is not readable when download
I am having a problem when downloading the content after I uploaded the file using FormData in JavaScript XMLHttpRequest and connect to Web API and save it to MySQL DB as LONGBLOB data type. When I tried to download the file that is being uploaded previously as BLOB to MySQL DB, the file is being downloaded, …
Gettting an undefined value from bcrypt hash function
Ok, I’m getting an undefined value from a function, I don’t know why, I’m trying to get the value of a password hash for insert in the database, but the const that have the function has the value “undefined”, so what I should change in my code? Answer When you call bcrypt.hash() …
Question about code execution and the nature of javascript blocking/ non blocking
Basically I have something similar to the code below and I’m not entirely sure what order of execution is always going to happen. Right now I suppose it executes in a non blocking fashion, being But I’ve had times that it’s I have no control over when res.on(‘data’) is called bec…
Query not working with SQL Template Strings npm
I’m trying to use the sql template strings npm package to use template literals in my SQL queries securely, but I keep getting an error that states that there is a problem with the sql syntax. When I omit the “SQL” bit, everything works. I’ve installed the sql-template-strings package.…
SQL UPDATE event not working correctly with discord.js via message event
I’ve been trying over the past days to get an SQL UPDATE event to work correctly with discord.js using the mysql npm package. All the login details and table, column names are correct. This is meant to update the integer every time a message is sent in the Discord text channel. I have tried multiple typ…
Looping an SQL statement on razor
Attempted to create a ‘cart’ which holds selected items by the user but upon form completion, all the data from the ‘cart’ is inserted into one row Example: How do I separate the data into a row each? Intended Result: How it works: The user will click a button that will generate the fo…