I have a Node.js application that allows users to upload images, which are then stored in a directory named uploads.
My goal is to save the image URLs in a MySQL database and display all the uploaded images using HTML.
To handle image uploads, I am utilizing the formidable module.
app.get('/upload', function (req, res){
res.sendFile(__dirname + '/index.html');
});
app.post('/up', function (req, res){
var form = new formidable.IncomingForm();
form.parse(req);
form.on('fileBegin', function (name, file){
file.path = __dirname + '/uploads/' + file.name;
});
form.on('file', function (name, file) {
console.log('Uploaded ' + file.name);
connection.query('SELECT * FROM images', (err, results) => {
// Throw error if find function fails
if (err) return (new Error(err));
// Throw error if there is already a file with that name
if (results[0]) return (new Error('File with that name already exists, please choose another name'));
connection.query('INSERT INTO images', (error, results) => {
// Throw error if save function fails
if (err) return (new Error(err));
// Throw error if you cannot verifty the save occured.
if (results.affectedRows !== 1) return (new Error('There was an unexpected error. Please try again'));
// Send Log to signal successfull upload
console.log('Uploaded ' + file.name);
});
});
});
});