node.js - How to store images in MySQL hosted in Hostinger thorough Nodejs? - Stack Overflow

I want to store images in Database. My database is hosted in hostinger and my whole website is hosted i

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条)

  • 暂无评论

联系我们

400-800-8888

在线咨询: QQ交谈

邮件:admin@example.com

工作时间:周一至周五,9:30-18:30,节假日休息

关注微信