<?php session_start();
include '../koneksi.php';
include("tampilan.php");
$user = $_SESSION['user'];
$uu = mysql_query("SELECT * FROM login WHERE Username='$user'");
$join = mysql_query ("SELECT * FROM login LEFT JOIN pegawai ON login.id_p = pegawai.id_p");
$join1 = mysql_query ("SELECT * FROM login
                        LEFT JOIN pegawai ON login.id_p = pegawai.id_p
                        WHERE login.id_p='$user'
                    ");
$row=mysql_fetch_assoc($join1);
if(isset($_GET['id'])) {
    $edit_id = $_GET['id'];
    $sql = mysql_query("SELECT * FROM siswa WHERE id_siswa = $edit_id");
    if($sql) {
        $edit = mysql_fetch_array($sql);
    } else {
        echo "<h4>Data tidak Tersedia</h4>";
    }
} else {
    echo "<h4>Data tidak Tersedia</h4>";
}
$jen = mysql_query ("SELECT * FROM jenjang");
$ag = mysql_query ("SELECT * FROM agama");
?>
<div class="content1">
            <article class="topcontent1">
                <header>
                <td><h2><a href="#" title="Fist post">Selamat Datang <?=$row['nama_p'];?></a></h2></td>
                </header>
                <content>
                    <form method="post" name="form1" action="proses_siswa.php">
                      <table align="center">
                        <tr valign="baseline">
                          <td nowrap align="right">Id_siswa:</td>
                          <td><?php echo $edit['id_siswa']; ?></td>
                        </tr>
                        <tr valign="baseline">
                          <td nowrap align="right">Nama_siswa:</td>
                          <td><input type="text" name="nama_siswa" value="<?php echo $edit['nama_siswa']; ?>" size="32"></td>
                        </tr>
                        <tr valign="baseline">
                          <td nowrap align="right">Id_jenjang:</td>
                          <td><select type="text" name="id_jenjang" value="<?php echo $edit['id_jenjang']; ?>"><?php while($je=mysql_fetch_assoc($jen)){?><option value="<?=$je['id_jenjang'];?>"><?=$je['lvl'];?></option><?php } ?></select></td>
                        </tr>
                        <tr valign="baseline">
                          <td nowrap align="right">Foto_s:</td>
                          <td><input type="file" name="foto_s" value="<?php echo $edit['foto_s']; ?>" size="32"></td>
                        </tr>
                        <tr valign="baseline">
                          <td nowrap align="right">Jk:</td>
                          <td><select type="text" name="jk" value="<?php echo $edit['jk']; ?>" size="32"><option value="L">L</option><option value="P">P</option></select></td>
                        </tr>
                        <tr valign="baseline">
                          <td nowrap align="right">Tempat_lhr:</td>
                          <td><input type="text" name="tempat_lhr" value="<?php echo $edit['tempat_lhr']; ?>" size="32"></td>
                        </tr>
                        <tr valign="baseline">
                          <td nowrap align="right">Tgl_lahir:</td>
                          <td><input type="text" name="tgl_lahir" value="<?php echo $edit['tgl_lahir']; ?>" size="32"></td>
                        </tr>
                        <tr valign="baseline">
                          <td nowrap align="right">Goldar:</td>
                          <td><input type="text" name="Goldar" value="<?php echo $edit['Goldar']; ?>" size="32"></td>
                        </tr>
                        <tr valign="baseline">
                          <td nowrap align="right">Height:</td>
                          <td><input type="text" name="height" value="<?php echo $edit['height']; ?>" size="32"></td>
                        </tr>
                        <tr valign="baseline">
                          <td nowrap align="right">Weight:</td>
                          <td><input type="text" name="weight" value="<?php echo $edit['weight']; ?>" size="32"></td>
                        </tr>
                        <tr valign="baseline">
                          <td nowrap align="right">Penyakit:</td>
                          <td><input type="text" name="penyakit" value="<?php echo $edit['penyakit']; ?>" size="32"></td>
                        </tr>
                        <tr valign="baseline">
                          <td nowrap align="right">Kebutuhan:</td>
                          <td><input type="text" name="kebutuhan" value="<?php echo $edit['kebutuhan']; ?>" size="32"></td>
                        </tr>
                        <tr valign="baseline">
                          <td nowrap align="right">Dk:</td>
                          <td><input type="text" name="dk" value="<?php echo $edit['dk']; ?>" size="32"></td>
                        </tr>
                        <tr valign="baseline">
                          <td nowrap align="right">Hobi:</td>
                          <td><input type="text" name="hobi" value="<?php echo $edit['hobi']; ?>" size="32"></td>
                        </tr>
                        <tr valign="baseline">
                          <td nowrap align="right">Id_agama:</td>
                          <td><select type="text" name="id_agama" value="<?php echo $edit['id_agama']; ?>"><?php while($aga=mysql_fetch_assoc($ag)){?><option value="<?=$aga['id_agama'];?>"><?=$aga['agama'];?></option><?php }?></select></td>
                        </tr>
                        <tr valign="baseline">
                          <td nowrap align="right">Nama_ayah:</td>
                          <td><input type="text" name="nama_ayah" value="<?php echo $edit['nama_ayah']; ?>" size="32"></td>
                        </tr>
                        <tr valign="baseline">
                          <td nowrap align="right">Nama_ibu:</td>
                          <td><input type="text" name="nama_ibu" value="<?php echo $edit['nama_ibu']; ?>" size="32"></td>
                        </tr>
                        <tr valign="baseline">
                          <td nowrap align="right">Pekerjaan_ortu:</td>
                          <td><input type="text" name="pekerjaan_ortu" value="<?php echo $edit['pekerjaan_ortu']; ?>" size="32"></td>
                        </tr>
                        <tr valign="baseline">
                          <td nowrap align="right">Alamat:</td>
                          <td><input type="text" name="alamat" value="<?php echo $edit['alamat']; ?>" size="32"></td>
                        </tr>
                        <tr valign="baseline">
                          <td nowrap align="right">Telp:</td>
                          <td><input type="text" name="telp" value="<?php echo $edit['telp']; ?>" size="32"></td>
                        </tr>
                        <tr valign="baseline">
                          <td nowrap align="right">Email:</td>
                          <td><input type="text" name="email" value="<?php echo $edit['email']; ?>" size="32"></td>
                        </tr>
                        <tr valign="baseline">
                          <td nowrap align="right">Tgl_masuk:</td>
                          <td><input type="text" name="tgl_masuk" value="<?php echo $edit['tgl_masuk']; ?>" size="32"></td>
                        </tr>
                        <tr valign="baseline">
                          <td nowrap align="right">Pass:</td>
                          <td><input type="text" name="pass" value="<?php echo $edit['pass']; ?>" size="32"></td>
                        </tr>
                        <tr valign="baseline">
                          <td nowrap align="right">&nbsp;</td>
                          <td><input type="submit" name="edit" value="Edit"></td>
                        </tr>
                      </table>
                    </form>
                    <?php
                        if(isset($_POST["edit"])){
                            $folder ="../siswa/photo/";
                            $name = $_FILES['foto_s']['name'];
                            $sumber = $_FILES['foto_s']['tmp_name'];
                            move_uploaded_file($sumber,$folder.$name);
                                if (isset($_FILES["foto_s"])&&$_FILES["foto_s"]["error"]==0){
                                    $update=UPDATE siswa SET nama_siswa='$_POST['nama_siswa']',id_jenjang='$_POST['id_jenjang']',foto_s='$name',jk='$_POST['jk']',tempat_lhr='$_POST['tempat_lhr']',tgl_lahir='$_POST['tgl_lahir']',Goldar='$_POST['Goldar']',height='$_POST['height']',weight='$_POST['weight']',penyakit='$_POST['penyakit']',kebutuhan='$_POST['kebutuhan']',dk='$_POST['dk']',hobi='$_POST['hobi']',id_agama='$_POST['id_agama']',nama_ayah='$_POST['nama_ayah']',nama_ibu='$_POST['nama_ibu']',pekerjaan_ortu='$_POST['pekerjaan_ortu']',telp='$_POST['telp']',email='$_POST['email']',tgl_masuk='$_POST['tgl_masuk']',pass='$_POST['pass']' WHERE id_siswa= '$edit_id';
                                    $up=mysql_query($update);
                                }else{
                                    echo "error".$_FILES["foto_s"]["error"];
                                }
                        }
                    ?>
                </content>
            </article>
        </div>
    </div>
     <footer class="mainfooter">
        <p>Copyright &copy; 2017 <a href="#" title="Nurachman">Nurachman Nurawi</a></p>
    </footer>