<?php include"header.php";?>
<?php include"sidebar.php";?>

<!-- ============================================================== -->
<!-- Start right Content here -->
<!-- ============================================================== -->
<div class="main-content">
 <div class="page-content">
       <div class="container-fluid">

                    <!-- start page title -->
                    <div class="row">
                        <div class="col-12">
                            <div class="page-title-box d-sm-flex align-items-center justify-content-between">
                                <h4 class="mb-sm-0">Update About Us</h4>

                                <div class="page-title-right">
                                    <ol class="breadcrumb m-0">
                                        <li class="breadcrumb-item"><a href="javascript: void(0);">About</a></li>
                                        <li class="breadcrumb-item active">Update</li>
                                    </ol>
                                </div>

                            </div>
                        </div>
                    </div>
                    <!-- end page title -->


                    <div class="row">

                        <!--end col-->
                        <div class="col-lg-12">
							<div class="card">
                                <div class="card-header">
                                    <ul class="nav nav-tabs-custom rounded card-header-tabs border-bottom-0" role="tablist">
                                        <li class="nav-item">
                                            <a class="nav-link active" data-bs-toggle="tab" href="#personalDetails" role="tab" aria-selected="false">
                                                <i class="fas fa-home"></i> Update About Us
                                            </a>
                                        </li>


                                    </ul>
                                </div>

    <?php
           $status = "OK"; //initial status
$msg="";
           if(ISSET($_POST['save'])){
			   
			   $about_title = mysqli_real_escape_string($con,$_POST['about_title']);
				$about_text = mysqli_real_escape_string($con,$_POST['about_text']);
				$about_detail = mysqli_real_escape_string($con,$_POST['about_detail']);	

$uploads_dir = 'uploads/about';

$about_img=mysqli_query($con,"SELECT  `ufile`  FROM `about` WHERE `id`='1'");
$about_img_res= mysqli_fetch_row($about_img);
$about_image = $about_img_res[0];
$uploads_dir = 'uploads/about';
 if(!empty($_FILES["ufile"]["tmp_name"]))
 {
        $tmp_name = $_FILES["ufile"]["tmp_name"];
        // basename() may prevent filesystem traversal attacks;
        // further validation/sanitation of the filename may be appropriate
        $name = basename($_FILES["ufile"]["name"]);
        $random_digit=rand(0000,9999);
        $new_file_name=$random_digit.$name;

        move_uploaded_file($tmp_name, "$uploads_dir/$new_file_name");
		unlink('uploads/about/'.$about_image);
 }
 else
	 $new_file_name=$about_image;
	 
$about_img=mysqli_query($con,"SELECT  `ufile2`  FROM `about` WHERE `id`='1'");
$about_img_res= mysqli_fetch_row($about_img);
$about_image = $about_img_res[0];
$uploads_dir = 'uploads/about';	 
	 
 if(!empty($_FILES["ufile2"]["tmp_name"]))
 {
	
        $tmp_name = $_FILES["ufile2"]["tmp_name"];
        // basename() may prevent filesystem traversal attacks;
        // further validation/sanitation of the filename may be appropriate
        $name = basename($_FILES["ufile2"]["name"]);
        $random_digit=rand(0000,9999);
        $new_file_name2=$random_digit.$name;

        move_uploaded_file($tmp_name, "$uploads_dir/$new_file_name2");
		unlink('uploads/about/'.$about_image);
 }
 else
	 $new_file_name2=$about_image;
	 
$about_img=mysqli_query($con,"SELECT  `ufile3`  FROM `about` WHERE `id`='1'");
$about_img_res= mysqli_fetch_row($about_img);
$about_image = $about_img_res[0];
$uploads_dir = 'uploads/about';	 
 if(!empty($_FILES["ufile3"]["tmp_name"]))
 {

        $tmp_name = $_FILES["ufile3"]["tmp_name"];
        // basename() may prevent filesystem traversal attacks;
        // further validation/sanitation of the filename may be appropriate
        $name = basename($_FILES["ufile3"]["name"]);
        $random_digit=rand(0000,9999);
        $new_file_name3=$random_digit.$name;

        move_uploaded_file($tmp_name, "$uploads_dir/$new_file_name3");
		unlink('uploads/about/'.$about_image);
 }
 else
	 $new_file_name3=$about_image;

if($status=="OK")
{
  $qb=mysqli_query($con,"UPDATE `about` SET `about_title`='$about_title',`about_text`='$about_text',`about_detail`='$about_detail',`ufile`='$new_file_name' ,`ufile2`='$new_file_name2' ,`ufile3`='$new_file_name3'  WHERE  `id`=1");

		if($qb){
		    	$errormsg= "
<div class='alert alert-success alert-dismissible alert-outline fade show'>
                 Data updated successfully.
                  <button type='button' class='btn-close' data-bs-dismiss='alert' aria-label='Close'></button>
                  </div>
 "; //printing error if found in validation

		}
	}

        elseif ($status!=="OK") {
            $errormsg= "
<div class='alert alert-danger alert-dismissible alert-outline fade show'>
                     ".$msg." <button type='button' class='btn-close' data-bs-dismiss='alert' aria-label='Close'></button> </div>"; //printing error if found in validation


    }
    else{
			$errormsg= "
      <div class='alert alert-danger alert-dismissible alert-outline fade show'>
                 Some Technical Glitch Is There. Please Try Again Later Or Ask Admin For Help.
                 <button type='button' class='btn-close' data-bs-dismiss='alert' aria-label='Close'></button>
                 </div>"; //printing error if found in validation


		}
           }
           ?>

                                <div class="card-body p-4">
                                    <div class="tab-content">
                                        <div class="tab-pane active" id="personalDetails" role="tabpanel">

                                     <?php
					 $query="SELECT * FROM  about where id=1";
 $result = mysqli_query($con,$query);
$i=0;
while($row = mysqli_fetch_array($result))
{
	$about_title="$row[about_title]";
	$about_text="$row[about_text]";
	$about_detail="$row[about_detail]";
	$ufile="$row[ufile]";
	$ufile2="$row[ufile2]";
	$ufile3="$row[ufile3]";
	$mission="$row[mission]";
	$vision="$row[vision]";
	$value="$row[value]";
}
 
if($_SERVER['REQUEST_METHOD'] == 'POST')
						{
						print $errormsg;
						}
   ?>         <script src="https://cdn.ckeditor.com/4.22.1/standard/ckeditor.js"></script>
              <form action="" method="post" enctype="multipart/form-data">
                                                <div class="row">


                                                    <div class="col-lg-6">
                                                     <span>Current Photo 1: </span> <img src="uploads/about/<?php print $ufile; ?>" alt="img" style="max-height:120px;">
                                                        <div class="mb-3">
                                                            <label for="firstnameInput" class="form-label">Photo</label>
                                                            <input type="file" class="form-control" id="firstnameInput" name="ufile" >
                                                        </div>
                                                    </div>
                                                    
													
													<div class="col-lg-6">
												<div class="mb-3">
													<label for="firstnameInput" class="form-label"> About Title</label>
													<input type="text" class="form-control" id="firstnameInput" name="about_title" value="<?php print $about_title ?>" placeholder="Enter Service Title">
                                                        </div>
												</div>
												<div class="col-lg-6">
													<div class="mb-3">
														<label for="firstnameInput" class="form-label">  About Sub Title</label>
														<input type="text" class="form-control" id="firstnameInput" name="about_text" placeholder="Enter Portfolio Title" value="<?php print $about_text ?>">
                                                        </div>
													</div>
													<div class="col-lg-6">
														<div class="mb-3">
															<label for="firstnameInput" class="form-label"> About Detail</label>
															<textarea class="form-control" name="about_detail" rows="3" id="editor1"><?php print $about_detail ?>
															</textarea>
														</div>
													</div>
													
													 
                                                    <!--end col-->
                                                    <div class="col-lg-12">
                                                        <div class="hstack gap-2 justify-content-end">
                                                            <button type="submit" name="save" class="btn btn-primary">Update About Us</button>

                                                        </div>
                                                    </div>
                                                    <!--end col-->
                                                </div>
                                                <!--end row-->
                                            </form>
                                        </div>
                                        <!--end tab-pane-->

                                    </div>
                                </div>
                            </div>
                        </div>
                        <!--end col-->
                    </div>
                <script>
						CKEDITOR.replace( 'editor1' );
				</script>

                </div>
                <!-- container-fluid -->
            </div>
            <!-- End Page-content -->

            <?php include"footer.php";?>