KRIA DATA BASE HANESAN TUIR MAI NEE :
kria uluk fili koneksi :Nia kodigu mak hanesan tuir mai nee :
<?php
// halo koneksi ba database
$koneksi = mysqli_connect("localhost", "root", "", "otomatis");
// Cek apakah koneksi susessu ona ga seidauk
if (mysqli_connect_errno()) {
echo "Koneksi ba database gagal hela: " . mysqli_connect_error();
}
?>
Tuir mai ita halo kria file index.php Nia kodigu mak hanesan tuir mai nee :
<?php
include "koneck.php";
$sql = mysqli_query($koneksi,"select max(id) as maxID from data_otomatis");
$data =mysqli_fetch_array($sql);
$kode = $data['maxID'];
$kode++;
$ket ="ID";
$kodeauto=$ket .sprintf("%3s", $kode);
?>
<!DOCTYPE html>
<html>
<head>
<title></title>
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.0.0/dist/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
</head>
<body>
<form method="POST" action="simpan.php">
<div class="form-group">
<label for="disabledTextInput">NRE Estudante</label>
<input type="text" readonly class="form-control" name="id" value="<?php echo $kodeauto ?> " >
</div>
<div class="form-group">
<label for="disabledSelect">Disabled select menu</label>
<input type="txt" name="name" class="form-control">
</div>
<div class="form-check">
<input class="form-check-input" type="checkbox" id="disabledFieldsetCheck" disabled>
<label class="form-check-label" for="disabledFieldsetCheck">
Can't check this
</label>
</div>
<button type="submit" class="btn btn-primary">Submit</button>
</form>
</body>
<script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/popper.js@1.12.9/dist/umd/popper.min.js" integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q" crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@4.0.0/dist/js/bootstrap.min.js" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl" crossorigin="anonymous"></script>
</html>
include "koneck.php";
$sql = mysqli_query($koneksi,"select max(id) as maxID from data_otomatis");
$data =mysqli_fetch_array($sql);
$kode = $data['maxID'];
$kode++;
$ket ="ID";
$kodeauto=$ket .sprintf("%3s", $kode);
?>
<!DOCTYPE html>
<html>
<head>
<title></title>
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.0.0/dist/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
</head>
<body>
<form method="POST" action="simpan.php">
<div class="form-group">
<label for="disabledTextInput">NRE Estudante</label>
<input type="text" readonly class="form-control" name="id" value="<?php echo $kodeauto ?> " >
</div>
<div class="form-group">
<label for="disabledSelect">Disabled select menu</label>
<input type="txt" name="name" class="form-control">
</div>
<div class="form-check">
<input class="form-check-input" type="checkbox" id="disabledFieldsetCheck" disabled>
<label class="form-check-label" for="disabledFieldsetCheck">
Can't check this
</label>
</div>
<button type="submit" class="btn btn-primary">Submit</button>
</form>
</body>
<script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/popper.js@1.12.9/dist/umd/popper.min.js" integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q" crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@4.0.0/dist/js/bootstrap.min.js" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl" crossorigin="anonymous"></script>
</html>
Posting Komentar
0Komentar