I want to store images in Database. My database is hosted in hostinger and my whole website is hosted in hostinger.
I have tried with this code.
const express = require("express");
const mysql = require("mysql2");
require("dotenv").config();
const multer = require("multer");
const path = require("path");
const bcrypt = require("bcrypt");
const cors = require("cors");
const app = express();
const fs = require('fs');
app.use(express.json());
app.use(cors());
const PORT = process.env.PORT;
app.use('/profile_pic', express.static('/home/u7425348897/public_html/profile_pic'));
const pool = mysql.createPool({
host: process.env.DB_HOST,
user: process.env.DB_USER,
password: process.env.DB_PASSWORD,
database: process.env.DB_NAME,
});
pool.getConnection((err, connection) => {
if (err) {
console.error("Database connection failed:", err.message);
} else {
console.log("Connected to MySQL database.");
connection.release();
}
});
// ✅ Ensure 'profile_pic' Directory Exists
const uploadDir = '/home/u7425348897/public_html/profile_pic';
if (!fs.existsSync(uploadDir)) {
fs.mkdirSync(uploadDir, { recursive: true });
}
//
发布者:admin,转转请注明出处:http://www.yc00.com/questions/1744107512a4558794.html
评论列表(0条)