All Questions
442
questions
0
votes
1
answer
40
views
Mysql2 messing with routing
I am trying to use mysql2 in the backend but it seems to messing with my routes when I use it in production.
My server file looks like this:
const express = require('express')
const app = express()
...
0
votes
0
answers
25
views
Data Received from frontend is not getting updated in database
//React Js (frontend) Code
function onclickcancel(){
setdate('0000-00-00')
settime('00:00:00')
settopic('Cancelled')
axios.put('http://localhost:8081/cancel',{email,...
0
votes
0
answers
39
views
ShadcnUI, with select, when item is clicked, i want to display some related datas
With react, node and shadcnUi, i call a list of product by there brands with a select. On the select item, i have the model of the product.
I want to display other information like the color for ...
0
votes
0
answers
15
views
Error: read ECONNRESET-node:events:492 Nodejs Auto Disconnect problem
My Server was lost connection sometime automatically.I don't know why this problem was coming!. I use database clone from another database if i use that previous database then it worked good but if i ...
0
votes
0
answers
33
views
Choosing Between SQL Logic and Frontend Mapping for Dynamic Data Presentation
I have a MySQL database table named "Tablets," which includes a column called "compartment" (compartment INT NOT NULL UNIQUE). The compartment value can only range from 1 to 32.
I'...
0
votes
0
answers
83
views
How do I push serveral id's from one table to another in sequelize?
I am trying to create a booking system using sequelize, and I have to seperate tables.
One for Rooms and one for Hotel
What I want to do, is basically to push the ID of the room into the hotel table ...
1
vote
0
answers
58
views
How do I make query as an option in sequelize?
I am trying to set up some Controller in sequelize.
I would like to be able to have different types of queries like for instance:
api/hotels
api/hotels/id
api/hotels?featured=true
api/hotels?featured=...
1
vote
1
answer
72
views
How to create a limit query in sequelize?
I am trying to create a limit in my query which is supposed to look like this:
/api/hotels?featured=1&limit=2
When I try and execute via postman and I get this message:
"message": "...
-1
votes
1
answer
99
views
Insert data into database using react and node.js error [closed]
I have a problem. when I try to insert data into the database it works and usually page does not refresh, but when I try to upload images too, images upload but the data does not insert into the ...
0
votes
0
answers
550
views
How to deal with react-hot-toast in next js 14 when I am dealing with server actions?
In the action.js file I am calling "use server" and dealing with server actions. Here I have created a function which responsible for updating users. After successfully updating I am ...
0
votes
1
answer
518
views
how to use .env connect to mysql for nextjs
const pool = mysql.createPool({
connectionLimit: 100,
host: process.env.NEXT_PUBLIC_MYSQL_HOST,
user: process.env.NEXT_PUBLIC_MYSQL_USER,
password: process.env....
0
votes
1
answer
320
views
How do I fix CRUD operation in React+NodeJS(Express)+MySql
I have setup React(Frontend) and NodejsExpress with MySql DB as backend. I am using material Table(client-side) to show data from MysQL server and Perform CRUD Operation. Below is my Backend code i.e
...
1
vote
1
answer
42
views
Fetch query result from MySQL by latin and cyrillic issue
I have website on React and want to fetch the data from MySQL when I use the cyrillic or latin characters. For example, I have 2 vehicles state numbers. One is in cyrillic and the second one is in ...
0
votes
0
answers
67
views
Login page is accepting all emails and passwords including those not stored in the database. No restricted acess at all
I am working on a to-do app. I have already setup the signup and login page. Signup page is working perfectly as all details been inputed is already stored in the database(sql). The main challenge now ...
0
votes
0
answers
60
views
How to delete task from todo list as well as mysql
I am working on todo list using react node.js and mysql but I cant delete the task from mysql database. How to delete the tasks from mysql database using todo list? Please help me.
My React code:
...