[insert_php]
$db_host = ‘localhost’; // Nama Server
$db_user = ‘mueduhosterz_admin’; // User Server
$db_pass = ‘mlTk9?y(ItPN’; // Password Server
$db_name = ‘mueduhosterz_lms’; // Nama Database
$conn = mysqli_connect($db_host, $db_user, $db_pass, $db_name);
$conn->set_charset("utf8”);
print_r($_POST);
$username=”AA230105″;
$ipaddress = get_client_ip();
if(!empty($_POST[kkdate])) {
$sqlinsert = "INSERT INTO `datesheet` (`id`, `username`, `book`, `date`, `time`, `ip`) VALUES (NULL, ‘$username’, ‘kk’, ‘$_POST[kkdate]’, ‘$_POST[kktime]’, ‘$ipaddress’)”;
$query1 = mysqli_query($conn, $sqlinsert);
}
if(!empty($_POST[wrdate])) {
$sqlinsert = "INSERT INTO `datesheet` (`id`, `username`, `book`, `date`, `time`, `ip`) VALUES (NULL, ‘$username’, ‘wr’, ‘$_POST[wrdate]’, ‘$_POST[wrtime]’, ‘$ipaddress’)”;
$query1 = mysqli_query($conn, $sqlinsert);
}
if(!empty($_POST[hadate])) {
$sqlinsert = "INSERT INTO `datesheet` (`id`, `username`, `book`, `date`, `time`, `ip`) VALUES (NULL, ‘$username’, ‘ha’, ‘$_POST[hadate]’, ‘$_POST[hatime]’, ‘$ipaddress’)”;
$query1 = mysqli_query($conn, $sqlinsert);
}
if(!empty($_POST[mtdate])) {
$sqlinsert = "INSERT INTO `datesheet` (`id`, `username`, `book`, `date`, `time`, `ip`) VALUES (NULL, ‘$username’, ‘mt’, ‘$_POST[mtdate]’, ‘$_POST[mttime]’, ‘$ipaddress’)”;
$query1 = mysqli_query($conn, $sqlinsert);
}
[/insert_php]