Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $host = "localhost";
- $user = "root";
- $pass = "yuli";
- $db = "smartschool";
- $con = mysqli_connect($host,$user,$pass,$db) or die("Koneksi Gagal!");
- $name = $con->real_escape_string($_POST['fullname']);
- echo $name;
- //var_dump($name);
- //echo "|";
- $nisn = $con->real_escape_string($_POST['nisn-siswa']);
- echo $nisn;
- //var_dump($nisn);
- //echo "|";
- $pass = $con->real_escape_string($_POST['pass']);
- echo $pass;
- //var_dump($pass);
- //echo "|";
- $kelas = $con->real_escape_string($_POST['kelas']);
- echo $kelas;
- //var_dump($kelas);
- //echo "|";
- $agama = $con->real_escape_string($_POST['agama']);
- echo $agama;
- //var_dump($agama);
- //echo "|";
- $jk = $con->real_escape_string($_POST['jk']);
- echo $jk;
- //var_dump($jk);
- //echo "|";
- $tmplhr = $con->real_escape_string($_POST['tmp-lhr']);
- echo $tmplhr;
- //var_dump($tmplhr);
- //echo "|";
- $tgllhr = $con->real_escape_string($_POST['tgl-lhr']);
- echo $tgllhr;
- //var_dump($tgllhr);
- //echo "|";
- $tglmsk = $con->real_escape_string($_POST['tgl-msk']);
- echo $tglmsk;
- //var_dump($tglmsk);
- //echo "|";
- $nohp = $con->real_escape_string($_POST['nohp']);
- echo $nohp;
- //var_dump($nohp);
- //echo "|";
- $alamat = $con->real_escape_string($_POST['alamat']);
- echo $alamat;
- //var_dump($alamat);
- //echo "|";
- //$query ="UPDATE `login` SET `password` = '$pass' WHERE `Username` = '$nisn';";
- $query1 ="UPDATE siswa
- SET password = '".$pass."',
- nama_siswa = '".$name."',
- id_kelas = '".$kelas."',
- agama = '".$agama."',
- jk = '".$jk."',
- tmp_lahir = '".$tmplhr."',
- tgl_lhr = '".$tgllhr."',
- tgl_masuk = '".$tglmsk."',
- no_hp = '".$nohp."',
- alamat = '".$alamat."'
- WHERE nisn = '".$alamat."'";
- //$success = $con->multi_query($query);
- $success1 = mysqli_query($con, $query1);
- if (!$success1) {
- die("Couldn't enter data: ".$con->error);
- }
- //if (!$success) {
- // die("Couldn't enter data: login".$con->error);
- //}
- header("location: ..\index.php");
- $con->close();
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement