Database: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 14: | Line 14: | ||
$password = "password"; // Password database | $password = "password"; // Password database | ||
$dbname = "nama_database"; // Nama database | $dbname = "nama_database"; // Nama database | ||
// Membuat koneksi | // Membuat koneksi | ||
$conn = mysqli_connect($servername, $username, $password, $dbname); | $conn = mysqli_connect($servername, $username, $password, $dbname); | ||
// Memeriksa koneksi | // Memeriksa koneksi | ||
if (!$conn) { | if (!$conn) { | ||
Latest revision as of 06:51, 20 June 2024
Backup
mysqldump -u database_username -p database_name > /home/cpanel_username/backup/backup_satu_database.sql
Docker
docker run -d -p 3388:3306 --name db_record -e MYSQL_ROOT_PASSWORD=4rt1s4n -v /DATA/record:/var/lib/mysql mysql
PHP
<?php
$servername = "localhost"; // Nama server, biasanya 'localhost'
$username = "username"; // Username database
$password = "password"; // Password database
$dbname = "nama_database"; // Nama database
// Membuat koneksi
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Memeriksa koneksi
if (!$conn) {
die("Koneksi gagal: " . mysqli_connect_error());
}
echo "Koneksi berhasil";
?>