<?php

require_once $_SERVER["DOCUMENT_ROOT"] . '/project-school/config/init.php';

error_reporting(E_ALL);
ini_set('display_errors', 'On');

$id		= isset($_GET['id_pengajar']) ? $_GET['id_pengajar'] : NULL;
$sql	= "SELECT * FROM pengajar WHERE id_pengajar='$id_pengajar'";
$query 	= mysqli_query($koneksi, $sql);
while ($row=mysqli_fetch_array($query))
{
	$id = $row['id_pengajar'];
}


if(isset($_POST['submit-admin-updatepengajar']))
{
	$nip			= db_escape($koneksi, $_POST['nip']);
	$nama_lengkap	= db_escape($koneksi, $_POST['nama_lengkap']);
	$tempat_lahir	= db_escape($koneksi, $_POST['tempat_lahir']);
	$tgl_lahir		= db_escape($koneksi, $_POST['thn'].'-'.$_POST['bln'].'-'.$_POST['tgl']);
	$jenis_kelamin	= db_escape($koneksi, $_POST['jenis_kelamin']);
	$alamat			= db_escape($koneksi, $_POST['alamat']);
	$agama			= db_escape($koneksi, $_POST['agama']);

	$lokasi_file    = $_FILES['foto']['tmp_name'];
	$tipe_file      = $_FILES['foto']['type'];
	$nama_file      = $_FILES['foto']['name'];
	$direktori_file = BASE_URL . "assets/images/foto-pengajar/" . $nama_file;
	UploadImage($nama_file);

	$username 		= db_escape($koneksi, $_POST['username']);
	$password 		= db_escape($koneksi, md5($_POST['password']));

	$sql = "UPDATE pengajar ";
	$sql .= "SET nip			= '$nip',
			 nama_lengkap		= '$nama_lengkap',
			 tempat_lahir		= '$tempat_lahir',
			 tgl_lahir			= '$tgl_lahir',
			 jenis_kelamin		= '$jenis_kelamin',
			 alamat				= '$alamat',
			 agama				= '$agama',
			 foto				= '$nama_file',
			 username_login		= '$username',
			 password_login		= '$password' ";
	$sql .= "WHERE id_pengajar	= '$id'";
    $query= mysqli_query($koneksi, $sql) or die(mysqli_error($koneksi));
    alihkan_ke( ADMIN_URL . 'view/admin-detail-pengajar.php');
}