admin管理员组

文章数量:1394980

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 });
}

// 

                本文标签：
                nodejsHow to store images in MySQL hosted in Hostinger thorough NodejsStack Overflow

                        版权声明：本文标题：node.js - How to store images in MySQL hosted in Hostinger thorough Nodejs? - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人，
                        转载请联系作者并注明出处：http://www.betaflare.com/web/1744107512a2591133.html，
                        本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。