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"; ?>