function AutoID() { global $db; $querycount = "SELECT count(id_servis) as LastID FROM servis"; $result = $db->query($querycount) or die($db->error()); $row = $result->fetch_assoc(); return $row['LastID']; } function IdKredit($num) { $num = $num + 1; switch (strlen($num)) { case 1: $NoTrans = "S0000" . $num; break; case 2: $NoTrans = "S000" . $num; break; case 3: $NoTrans = "S00" . $num; break; case 4: $NoTrans = "S0" . $num; break; default: $NoTrans = $num; } return $NoTrans; } echo IdKredit(autoID());
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <!-- CSS --> <script src="js/sweetalert-dev.js"></script> <link rel="stylesheet" href="css/sweetalert.css"> <link href="css/custom.css" type="text/css" rel="stylesheet"> </head> <body> <?php require_once "connect.php"; session_start(); require_once "functionsparepart.php"; $id_sparepart = IdKredit(autoID()); $nama_sparepart = $_POST['nama_sparepart']; $harga_sparepart = $_POST['harga_sparepart']; $query = "INSERT INTO sparepart VALUES ('{$id_sparepart}','{$nama_sparepart}','{$harga_sparepart}')"; if (mysqli_query($db, $query)) { echo "<script>\n swal({\n title: \"Sukses!\",\n text: \"Data Servis Berhasil Ditambah\",\n type: \"success\"\n },\n function () {\n window.location.href = 'menuservis.php';\n });\n </script>"; } else { echo "<script>\n swal({\n title: \"Gagal!\",\n text: \"Data Servis Gagal ditambah\",\n type: \"error\"\n },\n function () {\n window.location.href = 'menuservis.php';\n });\n </script>"; } mysqli_close($db); ?> </body> </html>
<?php require_once "connect.php"; require_once "functionproduct.php"; $id_kredit = IdKredit(autoID()); $id_product = $_POST['id_product']; $uang_muka = $_POST['uang_muka']; $tahun1 = $_POST['tahun1']; $tahun2 = $_POST['tahun2']; $tahun3 = $_POST['tahun2']; $query = "INSERT INTO kredit VALUES ('{$id_kredit}','{$id_product}','{$uang_muka}','{$tahun1}','{$tahun2}','{$tahun3}')"; if (mysqli_query($db, $query)) { echo "<script>\n alert('Berhasil ditambah');\n window.location.href='menukredit.php';\n </script>"; exit; } else { echo "<script>\n alert('Product sudah ada');\n window.location.href='index.php';\n </script>"; } mysqli_close($db);
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <!-- CSS --> <script src="js/sweetalert-dev.js"></script> <link rel="stylesheet" href="css/sweetalert.css"> <link href="css/custom.css" type="text/css" rel="stylesheet"> </head> <body> <?php require_once "connect.php"; session_start(); require_once "functionservis.php"; $id_servis = IdKredit(autoID()); $jenis_servis = $_POST['jenis_servis']; $harga_servis = $_POST['harga_servis']; $query = "INSERT INTO servis VALUES ('{$id_servis}','{$jenis_servis}','{$harga_servis}')"; if (mysqli_query($db, $query)) { echo "<script>\n swal({\n title: \"Sukses!\",\n text: \"Data Servis Berhasil Ditambah\",\n type: \"success\"\n },\n function () {\n window.location.href = 'menuservis.php';\n });\n </script>"; } else { echo "<script>\n swal({\n title: \"Gagal!\",\n text: \"Data Servis Gagal ditambah\",\n type: \"error\"\n },\n function () {\n window.location.href = 'menuservis.php';\n });\n </script>"; } mysqli_close($db); ?> </body> </html>
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <!-- CSS --> <script src="js/sweetalert-dev.js"></script> <link rel="stylesheet" href="css/sweetalert.css"> <link href="css/custom.css" type="text/css" rel="stylesheet"> </head> <body> <?php session_start(); require_once "connect.php"; require_once "functionbook.php"; $id_book = IdKredit(autoID()); $_SESSION['id_book'] = $id_book; $nopol = $_POST['nopol']; $jam = $_POST['jam']; $query = "INSERT INTO booking (id_book,tanggal,ktp,nopol,jam,status) VALUES ('{$id_book}',now(),'" . $_SESSION['ktp'] . "','{$nopol}','{$jam}','pending')"; if (mysqli_query($db, $query)) { echo "<script>\n swal({\n title: \"Sukses!\",\n text: \"Booking sukses\",\n type: \"success\"\n },\n function () {\n window.location.href = 'home.php';\n });\n </script>"; exit; } else { echo "<script> \n swal({\n title: \"Gagal!\",\n text: \"Booking gagal\",\n type: \"error\"\n },\n function () {\n window.location.href = 'home.php';\n });\n </script>"; } mysqli_close($db); ?> </body> </html>