Search code using ChatGPT

To submit a form in React and send a request to a Node.js server to save the data in a MySQL database, you can follow these steps:

1. Create a form component in your React application that collects the necessary data from the user.

2. Handle the form submission in the React component by calling a function that sends a POST request to your Node.js server.

3. In the Node.js server, create a route that listens for POST requests and handles the data sent from the React form.

4. Use a MySQL database connection in your Node.js server to insert the submitted data into the database.

Here is an example implementation:

React form component:

import React, { useState } from 'react';

const FormComponent = () => {
  const [formData, setFormData] = useState({
    name: '',
    email: '',
    message: ''
  });

  const handleSubmit = async (e) => {
    e.preventDefault();

    try {
      const response = await fetch('http://localhost:3001/saveData', {
        method: 'POST',
        headers: {
          'Content-Type': 'application/json'
        },
        body: JSON.stringify(formData)
      });

      if (response.ok) {
        console.log('Data saved successfully');
      }
    } catch (error) {
      console.error('Error saving data:', error);
    }
  }

  const handleChange = (e) => {
    setFormData({ ...formData, [e.target.name]: e.target.value });
  }

  return (
    <form onSubmit={handleSubmit}>
      <input type="text" name="name" value={formData.name} onChange={handleChange} />
      <input type="email" name="email" value={formData.email} onChange={handleChange} />
      <textarea name="message" value={formData.message} onChange={handleChange} />
      <button type="submit">Submit</button>
    </form>
  );
}

export default FormComponent;

Node.js server:

const express = require('express');
const bodyParser = require('body-parser');
const mysql = require('mysql');

const app = express();
const port = 3001;

const db = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'mydatabase'
});

db.connect((err) => {
  if (err) {
    console.error('Error connecting to database:', err);
    return;
  }
  console.log('Connected to database');
});

app.use(bodyParser.json());

app.post('/saveData', (req, res) => {
  const { name, email, message } = req.body;

  const sql = 'INSERT INTO mytable (name, email, message) VALUES (?, ?, ?)';
  db.query(sql, [name, email, message], (err, result) => {
    if (err) {
      console.error('Error saving data to database:', err);
      res.status(500).send('Error saving data');
      return;
    }

    console.log('Data saved to database');
    res.status(200).send('Data saved successfully');
  });
});

app.listen(port, () => {
  console.log(`Server running on port ${port}`);
});

Make sure to replace 'http://localhost:3001/saveData' with the appropriate URL to your Node.js server and adjust the database connection details in the Node.js server code. This is a basic example, and you may need to add error handling and validation based on your specific requirements.