Nodejs: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
Line 1: | Line 1: | ||
mkdir nodejsapi<br> | mkdir nodejsapi<br> | ||
cd nodejsapi<br> | cd nodejsapi<br> | ||
npm i -D @types/cors @types/express @types/ip types/mysql2 nodemon ts-node typescript | npm i -D @types/cors @types/express @types/ip types/mysql2 nodemon ts-node typescript | ||
Baru | Baru |
Latest revision as of 12:12, 8 February 2024
mkdir nodejsapi
cd nodejsapi
npm i -D @types/cors @types/express @types/ip types/mysql2 nodemon ts-node typescript
Baru
npm install express mysql body-parser
const express = require('express'); const mysql = require('mysql'); const bodyParser = require('body-parser');
const app = express(); const port = process.env.PORT || 3000;
app.use(bodyParser.json());
// Konfigurasi koneksi ke database MySQL const db = mysql.createConnection({ host: 'localhost', user: 'username', password: 'password', database: 'nama_database', });
// Terhubung ke database db.connect((err) => { if (err) { console.error('Koneksi ke database gagal: ' + err.stack); return; } console.log('Terhubung ke database dengan ID ' + db.threadId); });
// Contoh endpoint untuk mengambil data dari database app.get('/data', (req, res) => { const query = 'SELECT * FROM nama_tabel'; db.query(query, (err, result) => { if (err) { console.error('Error dalam pengambilan data: ' + err); res.status(500).json({ error: 'Gagal mengambil data' }); return; } res.json(result); }); });
// Mulai server app.listen(port, () => { console.log(`Server berjalan pada port ${port}`); });