<?php
include("include/header.php");
include("include/sidebar.php");
if(!empty($_REQUEST['did'])){
    $did=mysqli_real_escape_string($con,$_REQUEST['did']);
    $q=mysqli_query($con,"delete from crud_sample2 where id=$did");
    if($q){
        $_SESSION['msg']="Data Deleted Successfully";
    }else{
        $_SESSION['msg']="Data Deletion Failed";
    }
    header("location:crud_sample2.php");
}
if(!empty($_REQUEST['upid'])){
    $doid=mysqli_real_escape_string($con,$_REQUEST['upid']);
    $do="EditCrudSample2";
    $Row=mysqli_fetch_array(mysqli_query($con,"select * from crud_sample2 where id=$doid"));
}else{
    $doid="";
    $do="CrudSample2";
}
?>
<div class="content-wrapper">
    <section class="content-header">
        <h1>
            Crud Sample
            <small>Single Page</small>
        </h1>
        <ol class="breadcrumb">
            <li><a href="#"><i class="fa fa-dashboard"></i> Level</a></li>
            <li class="active">Crud Sample</li>
        </ol>
    </section>
    <!-- Main content -->
    <section class="content container-fluid">
        <div class="row">
            <div class="col-md-6">
                <div class="box box-primary">
                    <div class="box-header with-border">
                        <h3 class="box-title">Crud Sample</h3>
                    </div>
                    <div class="box-body">
                        <form role="form" action="action.php" method="post">
                            <input type="hidden" name="do" value="<?=$do;?>" />
                            <input type="hidden" name="doid" value="<?=$doid;?>" />
                            <div class="box-body">
                                <div class="form-group">
                                    <label for="name">Name</label>
                                    <input name="name" value="<?=!empty($_REQUEST['upid'])?$Row['name']:"";?>" type="text" class="form-control" id="name" placeholder="Enter Name" />
                                </div>
                                <div class="form-group">
                                    <label for="email">Email</label>
                                    <input name="email" value="<?=!empty($_REQUEST['upid'])?$Row['email']:"";?>" type="email" class="form-control" id="email" placeholder="Email">
                                </div>
                                <div class="form-group">
                                    <label for="mobile">Mobile</label>
                                    <input name="mobile" value="<?=!empty($_REQUEST['upid'])?$Row['mobile']:"";?>" type="mobile" class="form-control" id="mobile" placeholder="Enter Mobile Number">
                                </div>
                                <div class="form-group">
                                    <label for="city">City</label>
                                    <input name="city" value="<?=!empty($_REQUEST['upid'])?$Row['city']:"";?>" type="city" class="form-control" id="city" placeholder="Enter City">
                                </div>
                            </div>
                            <div class="box-footer">
                                <button type="submit" class="btn btn-primary">Submit</button>
                            </div>
                        </form>
                    </div>
                </div>
            </div>
        </div>
    </section>
</div>
<?php include("include/footer.php"); ?>
</body>
</html>