<?php
require('top_inc.php');
$name='';
$description='';
$complete_desc='';
$mission='';
$experience='';
$meta_title='';
$meta_desc='';
$meta_keyword='';
$msg='';
$msg1='';
$image_required='required';
if (isset($_GET['id']) && $_GET['id']!='') {
$image_required='';
$id=get_safe_value($con,$_GET['id']);
$res=mysqli_query($con, "select * from about_us where id='$id'");
$check=mysqli_num_rows($res);
if($check>0){
$row=mysqli_fetch_assoc($res);
$name=$row['name'];
$description=$row['description'];
$complete_desc=$row['complete_desc'];
$mission=$row['mission'];
$experience=$row['experience'];
$meta_title=$row['meta_title'];
$meta_desc=$row['meta_desc'];
$meta_keyword=$row['meta_keyword'];
}
else{
}
}
if(isset($_POST['submit'])){
$name=get_safe_value($con,$_POST['name']);
$description=get_safe_value($con,$_POST['description']);
$complete_desc=get_safe_value($con,$_POST['complete_desc']);
$mission=get_safe_value($con,$_POST['mission']);
$experience=get_safe_value($con,$_POST['experience']);
$meta_title=get_safe_value($con,$_POST['meta_title']);
$meta_desc=get_safe_value($con,$_POST['meta_desc']);
$meta_keyword=get_safe_value($con,$_POST['meta_keyword']);
$res=mysqli_query($con, "select * from about_us where name='$name'");
$check=mysqli_num_rows($res);
if($check>0){
if (isset($_GET['id']) && $_GET['id']!='') {
$getData=mysqli_fetch_assoc($res);
if($id==$getData['id']){
}
else{
$msg="About Us already exist";
}
}
else{
$msg="About Us already exist";
}
}
if($_FILES['image']['type']!='image/png' && $_FILES['image']['type']!='image/jpg' && $_FILES['image']['type']!='image/jpeg'){
$msg="Please select only png, jpg and jpeg image formate";
}
if($msg==''){
if (isset($_GET['id']) && $_GET['id']!='') {
if ($_FILES['image']['name']!='') {
$image=rand(111111111,999999999).'_'.$_FILES['image']['name'];
move_uploaded_file($_FILES['image']['tmp_name'], PRODUCT_IMAGE_SERVER_PATH.$image);
$update_sql="update about_us set name='$name',description='$description',complete_desc='$complete_desc',mission='$mission',image='$image',experience='$experience',meta_title='$meta_title',meta_desc='$meta_desc',meta_keyword='$meta_keyword' where id='$id'";
}
else{
$update_sql="update about_us set name='$name',description='$description',complete_desc='$complete_desc',mission='$mission',experience='$experience',meta_title='$meta_title',meta_desc='$meta_desc',meta_keyword='$meta_keyword' where id='$id'";
}
mysqli_query($con,$update_sql);
}
else{
$image=rand(111111111,999999999).'_'.$_FILES['image']['name'];
move_uploaded_file($_FILES['image']['tmp_name'], PRODUCT_IMAGE_SERVER_PATH.$image);
mysqli_query($con,"insert into about_us(name,description,complete_desc,mission,image,experience,meta_title,meta_desc,meta_keyword,status) values('$name','$description','$complete_desc','$mission','$image','$experience','$meta_title','$meta_desc','$meta_keyword',1)");
}
$msg1="About Us Successfull Submit";
}
}
?>
<!-- Page Area Start Here -->
<div class="dashboard-page-one">
<!-- Sidebar Area Start Here -->
<?php
require('side_menu.php');
?>
<!-- Sidebar Area End Here -->
<div class="dashboard-content-one">
<!-- Breadcubs Area Start Here -->
<div class="breadcrumbs-area">
<h3>Add About Us</h3>
<ul>
<li>
<a href="index.php">Home</a>
</li>
<li>Add About Us</li>
</ul>
</div>
<!-- Breadcubs Area End Here -->
<!-- Student Table Area Start Here -->
<div class="card height-auto">
<div class="card-body">
<div class="heading-layout1">
<div class="item-title">
<h3>Add About Us</h3>
</div>
</div>
<form method="post" enctype="multipart/form-data" class="mg-b-20">
<div class="row gutters-8">
<div class="col-3-xxxl col-xl-6 col-lg-6 col-12 form-group">
<input type="text" placeholder="Enter name ..." class="form-control" name="name" value="<?php echo $name; ?>">
</div>
<div class="col-3-xxxl col-xl-6 col-lg-6 col-12 form-group">
<input type="file" class="form-control" name="image" <?php echo $image_required ?>>
</div>
<div class="col-3-xxxl col-xl-12 col-lg-12 col-12 form-group">
<textarea placeholder="Enter experience..." class="form-control" name="experience"><?php echo $experience; ?></textarea>
</div>
<div class="col-3-xxxl col-xl-12 col-lg-12 col-12 form-group">
<textarea placeholder="Enter description ..." class="form-control" name="description"><?php echo $description; ?></textarea>
</div>
<div class="col-3-xxxl col-xl-12 col-lg-12 col-12 form-group">
<textarea placeholder="Enter Complete description ..." class="form-control" name="complete_desc"><?php echo $complete_desc; ?></textarea>
</div>
<div class="col-3-xxxl col-xl-12 col-lg-12 col-12 form-group">
<textarea placeholder="Enter Mission ..." class="form-control" name="mission"><?php echo $mission; ?></textarea>
</div>
<div class="col-3-xxxl col-xl-12 col-lg-12 col-12 form-group">
<textarea placeholder="Enter Meta Title ..." class="form-control" name="meta_title"><?php echo $meta_title; ?></textarea>
</div>
<div class="col-3-xxxl col-xl-12 col-lg-12 col-12 form-group">
<textarea placeholder="Enter Meta Desc ..." class="form-control" name="meta_desc"><?php echo $meta_desc; ?></textarea>
</div>
<div class="col-3-xxxl col-xl-12 col-lg-12 col-12 form-group">
<textarea placeholder="Enter Meta Keyword ..." class="form-control" name="meta_keyword"><?php echo $meta_keyword; ?></textarea>
</div>
<div class="col-1-xxxl col-xl-12 col-lg-12 col-12 form-group">
<button type="submit" name="submit" class="fw-btn-fill btn-gradient-yellow">SUBMIT</button>
</div>
</div>
</form>
<div class="field_error">
<?php echo $msg ?>
</div>
<div class="field_error">
<?php echo $msg1 ?>
</div>
</div>
</div>
<!-- Student Table Area End Here -->
<?php
require('footer_inc.php');
?>