File: /var/www/nclive/technc/modal.php
<!DOCTYPE html>
<html lang="en">
<head>
<title></title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
</head>
<body>
<!-- Modal -->
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
</div>
<div class="modal-body">
<?php
include 'db_conn.php';
$userid=$_REQUEST['id'];
$query="Select name,url_slug,img_icon,display_order from sp_exam_category where id = '$userid'";
$sql = $db->prepare($query);
$sql->execute();
$row = $sql->fetch();
if(isset($_REQUEST['submit'])){
$userid=$_REQUEST['id'];
$exm= $_REQUEST['exm_name'];
$slug= $_REQUEST['slug'];
$order= $_REQUEST['num'];
$userpic=$_REQUEST['image'];
$target_dir = ABS_ADMIN_PATH."images/";
if(basename($_FILES["img"]["name"])!= NULL){
$target_file = $target_dir . basename($_FILES["img"]["name"]);
}
else{
$target_file=$userpic;
}
if (move_uploaded_file($_FILES["img"]["tmp_name"], $target_file)) {
}
$query="UPDATE sp_exam_category SET name='$exm',url_slug='$slug',img_icon='$target_file',display_order='$order' WHERE id='$userid'";
$sql = $db->prepare($query);
$sql->execute();
header('location:exam_list.php');
}
?>
<form action="modal.php?id=<?php echo $userid; ?>" method="post" enctype="multipart/form-data">
<div class="form-group">
<label class="col-md-4 control-label" for="val-username">Name<span class="text-danger">*</span></label>
<div class="col-md-7">
<input class="form-control" type="text" name="exm_name" placeholder="" value="<?php echo $row['name']; ?>">
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="val-email">Url Slug<span class="text-danger">*</span></label>
<div class="col-md-7">
<input class="form-control" type="text" name="slug" placeholder="" value="<?php echo $row['url_slug']; ?>">
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="val-password">Image icon<span class="text-danger">*</span></label>
<div class="col-md-7">
<input class="form-control" type="file" name="img" src="<?php echo $row['img_icon']; ?>">
<input type="hidden" name="image" value="<?php echo $row['img_icon']; ?>">
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="val-confirm-password">Display order<span class="text-danger">*</span></label>
<div class="col-md-7">
<input class="form-control" type="number" name="num" placeholder="" value="<?php echo $row['display_order']; ?>">
</div>
</div>
<div class="form-group">
<div class="col-md-8 col-md-offset-4">
<button class="btn btn-sm btn-primary" type="submit" name="submit">Update</button>
</div>
</div>
</form>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
</div>
</body>
</html>