<?php 
include('header.php');
include('left_sidebar.php');
$button=@$_GET["mode"]=="edit"? "Update": "Submit";
if(@$_GET["objID"]!="")
{
	  $CatRs=mysqli_query($con,"select * from tp_testi where id='".$_GET["objID"]."'") ;
	  $CatRow=mysqli_fetch_assoc($CatRs) ;  
  
}


if($_POST["Submit"]=="Update")
{
	
@extract($_POST);

$cQuery="update tp_testi set name='".mysqli_real_escape_string($con,$_REQUEST["name"])."',
description='".mysqli_real_escape_string($con,$_REQUEST["description"])."',
status='".mysqli_real_escape_string($con,$_REQUEST['status'])."'";
			 $cQuery.="  where id='".$_GET["objID"]."'" ;
		
		$RowCons=mysqli_query($con,$cQuery) or die(mysql_error());
		  if($RowCons)
		   {
				 $_SESSION["msg"]="record is updated successfully ";
				 header("location:view_testi.php");
				 exit() ;
		   }

}else if(isset($_POST["Submit"])=="Submit")
{
@extract($_POST);

		$cQuery="insert into tp_testi set name='".mysqli_real_escape_string($con,$_REQUEST["name"])."',
description='".mysqli_real_escape_string($con,$_REQUEST["description"])."',
status='".mysqli_real_escape_string($con,$_REQUEST['status'])."'";
				
		$RowCons=mysqli_query($con,$cQuery) or die(mysql_error());
		if($RowCons)
		   {
				 $_SESSION["msg"]="One Record Is Inserted ";
				 header("location:view_testi.php");
				 exit() ;
		   
		   }

}

?>
       
        <!-- ============================================================== -->
        <!-- Page wrapper  -->
        <!-- ============================================================== -->
        <div class="page-wrapper">
            <!-- ============================================================== -->
            <!-- Container fluid  -->
            <!-- ============================================================== -->
            <div class="container-fluid">
                <!-- ============================================================== -->
                <!-- Bread crumb and right sidebar toggle -->
                <!-- ============================================================== -->
                <div class="row page-titles">
                    <div class="col-md-5 col-8 align-self-center">
                        <h3 class="text-themecolor">New Testimonial</h3>
                       
                    </div>
                    <div class="col-md-7 col-4 align-self-center">
					 <div class="d-flex m-t-10 justify-content-end">
                       <ol class="breadcrumb">
                            <li class="breadcrumb-item"><a href="javascript:void(0)">Home</a></li>
                            <li class="breadcrumb-item active">Add Testimonial</li>
                        </ol>
                    </div>
					</div>
                </div>
                <!-- ============================================================== -->
                <!-- End Bread crumb and right sidebar toggle -->
                <!-- ============================================================== -->
                <!-- ============================================================== -->
                <!-- Start Page Content -->
                <!-- ============================================================== -->
                
                 <!-- Row -->
                   <div class="row">
                    <div class="col-sm-12">
                        <div class="card">
                            <div class="card-body">
                                <h4 class="card-title">Add Testimonial</h4>
                              
                               
                                <form class="form" method="post" action="" enctype="multipart/form-data">
                                 <?php if(isset($_SESSION["msg"]))
					{ ?>										
										<div class="alert alert-danger"> <?php echo $_SESSION["msg"]; ?>
                                            <button type="button" class="close" data-dismiss="alert" aria-label="Close"> <span aria-hidden="true">×</span> </button>
                                        </div>
									<?php unset($_SESSION["msg"]);	}
										?>
                                   
                                   
                                     <div class="form-group m-t-40 row">
                                        <label for="example-text-input" class="col-2 col-form-label">Name</label>
                                        <div class="col-10">
                                            <input class="form-control" type="text" id="example-text-input" name="name" placeholder="Name" value="<?php echo $CatRow['name'];?>" >
                                        </div>
                                    </div>
								
									<div class="form-group row">
                                        <label for="example-text-input" class="col-2 col-form-label">Content</label>
                                        <div class="col-10">
                                           <textarea class="form-control" name="description" required><?php echo $CatRow['description'];?></textarea>
                                        </div>
                                    </div>
                                    
                                     <div class="form-group row">
                                        <label for="example-search-input" class="col-2 col-form-label">Status</label>
                                        <div class="col-10">
                                             <select class="custom-select col-12" id="inlineFormCustomSelect" name="status" required>
                                           
											  <?php if($CatRow['status']=='1'){ ?>
                                                <option value="1" selected >Active</option>
												<option value="0">Deactive</option>
												<?php }else if($CatRow['status']=='0'){?>
                                                <option value="0" selected >Deactive</option>
												  <option value="1"  >Active</option>
											  <?php }else{ ?> 
											    <option value="1" selected>Active</option>
                                               <option value="0">Deactive</option>
											  <?php } ?>
                                                 
                                              </select>
                                        </div>
                                    </div>
                                   <input name="Submit" type="hidden"  value="<?=$button;?>"/> 
                                   <button type="submit" name="submit" class="btn btn-info waves-effect waves-light ">Submit</button
                                </form>
                            </div>
                        </div>
                    </div>
                </div>  
               
                
                     
                <!-- ============================================================== -->
                <!-- End PAge Content -->
                <!-- ============================================================== -->
               <?php include('footer.php');?>