zxc

<?php
require_once'../_header.php';


?>
     <div class="container col-md-4 mt-4">
            <div class="container ">
                <h2 align="center" >Tambah Data Siswa</h2> <hr>
                <div class=" justify-content-center mt-5  ">
                    <div class="card ">
                        <div class="card-body">

                            <form method="post">
<?php
     if(isset($_POST['add'])){

            $nisn = trim(mysqli_real_escape_string($conn,$_POST['nisn']));
            $nama = trim(mysqli_real_escape_string($conn,$_POST['nama']));
            $jk= trim(mysqli_real_escape_string($conn,$_POST['jk']));
            $kelas = trim(mysqli_real_escape_string($conn,$_POST['kelas']));
            $alamat = trim(mysqli_real_escape_string($conn,$_POST['alamat']));
            $tlp = trim(mysqli_real_escape_string($conn,$_POST['tlp']));
            $cek_nisn= mysqli_query($conn,"SELECT * FROM siswa WHERE nisn = '$nisn'");
            if(mysqli_num_rows($cek_nisn)>0){
                echo "<script>alert('Nisn sudah ada');window.location='add.php'</script>";
            }else{
                mysqli_query($conn,"INSERT INTO siswa VALUES('$nisn','$nama','$jk','$kelas','$alamat','$tlp')");
                echo "<script>window.location='data.php'</script>";
            }
        }
?>
                                  <div class="form-group">
                                    <label for="nisn">NISN / KODE SISWA</label>
                                    <input type="number" class="form-control" id="nisn" placeholder= "NISN / KODE SISWA" required autocomplete="off"  name="nisn" autofocus onkeyup="cek()" onfocusout="getRANDOMNISN()">
                                    <br>
                                    <div class="alert alert-danger" id="alert" style="display: none;">
                                        NISN sudah terdaftar!
                                    </div>
                                  </div>
                                   <div class="form-group">
                                    <label for="NAMA">NAMA</label>
                                    <input type="text" class="form-control" id="NAMA" placeholder= "NAMA" required autocomplete="off"  name="nama" >
                                  </div>
                                    <div class="form-group">
                                        <label for="jk">Jenis Kelamin</label>
                                        <div>
                                            <label for="" class="radio-inline">
                                            <input type="radio" name="jk" id="jk" value="Laki-Laki" required>Laki-Laki
                                            </label>
                                            <label for="" class="radio-inline ml-4">
                                            <input type="radio" name="jk"  value="Perempuan" required>Perempuan
                                            </label>
                                    </div>
                                    </div>
                                    <div class="form-group">
                                    <label for="kelas">KELAS</label>
                                    <select required name="kelas" id="kelas" class="form-control col-md-12">
                                        <option disabled="true" value="" selected>Pilih Kelas</option>
                                        <?php

                                        $query=mysqli_query($conn,"select * from kelas order by kelas asc");

                                        while($row=mysqli_fetch_assoc($query))
                                        {
                                            ?><option value="<?php  echo $row['kd_kelas']; ?>"><?php  echo $row['kelas']; ?></option><?php
                                        }
                                        ?>
                                    </select>
                                  </div>
                                  <div class="form-group">
                                    <label for="alamat">Alamat</label>
                                    <textarea name="alamat" id="alamat"  class="form-control"placeholder='Alamat' required></textarea>
                                  </div>
                                  <div class="form-group">
                                    <label for="tlp">No Telp Wali Kelas</label>
                                    <input type="number" name="tlp" id="tlp" class="form-control" placeholder="08XXXXXXX" required>
                                  </div>
                                   <div class="form-group">
                                   <button type="submit" name="add" class="btn btn-primary " id="submit"> Simpan</button>
                                   <a href="data.php" class="btn btn-danger">Kembali</a>
                                  </div>


                            </form>
                        </div>
                     </div>
                </div>
             </div>
    </div>
<script type="text/javascript" src="<?= base_url('_assets/bootstrap/jquery.min.js') ?>"></script>
<script type="text/javascript">
function cek(){
     var nisn=document.getElementById( "nisn" ).value;

    $.ajax({
        type:'POST',
            url:'checked.php',// put your real file name
            data:{nisn:nisn},
            success:function(msg){
                if(msg == "ada"){
                    document.getElementById('alert').style.display = "block";
                    document.getElementById("submit").disabled = true;
                }else{
                    document.getElementById('alert').style.display = "none";
                    document.getElementById("submit").disabled = false;
                }
            // alert(msg); // your message will come here.
            },
     });

    }
    function getRANDOMNISN() {
        var nisn = document.getElementById("nisn").value;
        if(nisn == ""){
            document.getElementById('nisn').value = generate_random_number();
        }
    }
    function generate_random_number(){
        let num_low = 1;
        let num_high = 9;
        var random = "";
        for (var i = 1; i < 8; i++) {
            random += Math.floor((Math.random() * (num_high - num_low)) + num_low);
        }

        return random;
    }
</script>