js上传图片到数据库

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Upload Image</title>
</head>
<body>
    <input type="file" id="imageUpload" accept="image/*">
    <button onclick="uploadImage()">Upload</button>

    <script>
        async function uploadImage() {
            const fileInput = document.getElementById('imageUpload');
            const file = fileInput.files[0];
            if (!file) return alert('Please select a file');

            const formData = new FormData();
            formData.append('image', file);

            try {
                const response = await fetch('/upload', {
                    method: 'POST',
                    body: formData
                });
                const result = await response.json();
                alert(result.message);
            } catch (error) {
                console.error('Error uploading image:', error);
                alert('Failed to upload image');
            }
        }
    </script>
</body>
</html>

const express = require('express');
const multer = require('multer');
const mysql = require('mysql');

const app = express();
const upload = multer({ storage: multer.memoryStorage() });

const db = mysql.createConnection({
    host: 'localhost',
    user: 'your_username',
    password: 'your_password',
    database: 'your_database'
});

db.connect(err => {
    if (err) throw err;
    console.log('Connected to the database');
});

app.post('/upload', upload.single('image'), (req, res) => {
    const image = req.file.buffer;
    const sql = 'INSERT INTO images (image_data) VALUES (?)';
    db.query(sql, [image], (err, result) => {
        if (err) return res.status(500).json({ message: 'Database error' });
        res.json({ message: 'Image uploaded successfully' });
    });
});

app.listen(3000, () => {
    console.log('Server started on port 3000');
});