1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / techoozesolution / public_html / webpanel /
Filename : insert.php
back
<?php include 'db.php'; ?>
<?php
if(isset($_POST['banner'])) {

  InsertBanner();
}
function InsertBanner() {
  include 'db.php';
  if(isset($_FILES['img'])) {
    $errors     = array();
    $maxsize    = 2097152;
    $acceptable = array(
        'application/pdf',
        'image/jpeg',
        'image/jpg',
        'image/gif',
        'image/png'
    );

    if($_FILES['img']['size'] >= $maxsize) {
        $errors[] = 'File too large. File must be less than 2 megabytes.';
    }

    if((!in_array($_FILES['img']['type'], $acceptable)) && (!empty($_FILES["img"]["type"]))) {
        $errors[] = 'Invalid file type. Only PDF, JPG, GIF and PNG types are accepted.';
    }

    if(count($errors) === 0) {
      $randomgen=rand(1121,9989);
      $newname=date("dymhis");
      move_uploaded_file($_FILES['img']['tmp_name'], "../img/".$newname.$randomgen.$_FILES['img']['name']);
      $img = "img/".$newname.$randomgen.$_FILES['img']['name'];
    } else {
        foreach($errors as $error) {
            echo '<script>alert("'.$error.'");</script>';
            echo'<script>window.location="Add_banner.php";</script>';
        }

        die(); //Ensure no more processing is done
    }
}

    
    $i1=$_POST['b1'];
    $i2=$_POST['b2'];
    $i3=$_POST['b3'];
    $i4=mysqli_real_escape_string($conn,$_POST['b4']);
    $date = date('Y-m-d');
$upload5="INSERT INTO `banner` (`images`,`bheading`,`imagealt`,`links`,`paragraph`,`date`) VALUES ('$img','$i1','$i2','$i3','$i4','$date')";
$upload_check=mysqli_query($conn,$upload5);
header("location:Add_banner.php?id=Banner Added Successfully");
}

?>

<?php
if(isset($_POST['testimonial'])) {

  InsertTestimonial();
}
function InsertTestimonial() {
  include 'db.php';
  $imgchk1=$_FILES['img']['size'];
  $i1=$_POST['alt'];
  $i2=$_POST['star'];
  $i3=$_POST['title'];
  $i4=$_POST['desc'];
  if($i1!=null || $i2!=null || $i3!=null || $i4!=null || $imgchk1!=null){

    if(isset($_FILES['img'])) {
      $errors     = array();
      $maxsize    = 2097152;
      $acceptable = array(
          'application/pdf',
          'image/jpeg',
          'image/jpg',
          'image/gif',
          'image/png'
      );
  
      if($_FILES['img']['size'] >= $maxsize)  {
          $errors[] = 'File too large. File must be less than 2 megabytes.';
      }
  
      if((!in_array($_FILES['img']['type'], $acceptable)) && (!empty($_FILES["img"]["type"]))) {
          $errors[] = 'Invalid file type. Only PDF, JPG, GIF and PNG types are accepted.';
      }
      if($_FILES['img']['tmp_name']!=null){
      if(count($errors) === 0) {
        $randomgen=rand(1121,9989);
        $newname=date("dymhis");
        move_uploaded_file($_FILES['img']['tmp_name'], "../img/".$newname.$randomgen.$_FILES['img']['name']);
        $img = "img/".$newname.$randomgen.$_FILES['img']['name'];
      } else {
          foreach($errors as $error) {
              echo '<script>alert("'.$error.'");</script>';
              echo'<script>window.location="add_testimonial.php";</script>';
          }
  
          die(); //Ensure no more processing is done
      }
    }
  }

    
    $i1=$_POST['alt'];
    $i2=$_POST['star'];
    $i3=$_POST['title'];
    $i4=$_POST['desc'];
    $date = date('Y-m-d');
$upload5="INSERT INTO `testimonial` (`image`,`alt`,`star`,`title`,`description`,`date`) VALUES ('$img','$i1','$i2','$i3','$i4','$date')";
$upload_check=mysqli_query($conn,$upload5);
header("location:add_testimonial.php?id=Testimonial Added Successfully");
}
else{
  
}
}

?>

<?php
if(isset($_POST['certificate'])) {

  InsertCertificate();
}
function InsertCertificate() {
  include 'db.php';



    if(isset($_FILES['img'])) {
      $errors     = array();
      $maxsize    = 2097152;
      $acceptable = array(
          'application/pdf',
          'image/jpeg',
          'image/jpg',
          'image/png'
      );
  
      if(($_FILES['img']['size'] >= $maxsize) || ($_FILES["img"]["size"] == 0)) {
          $errors[] = 'File too large. File must be less than 2 megabytes.';
      }
  
      if((!in_array($_FILES['img']['type'], $acceptable)) && (!empty($_FILES["img"]["type"]))) {
          $errors[] = 'Invalid file type. Only JPG, PDF and PNG types are accepted.';
      }
  
      if(count($errors) === 0) {
        $randomgen=rand(1121,9989);
        $newname=date("dymhis");
        move_uploaded_file($_FILES['img']['tmp_name'], "../img/".$newname.$randomgen.$_FILES['img']['name']);
        $img = "img/".$newname.$randomgen.$_FILES['img']['name'];
      } else {
          foreach($errors as $error) {
              echo '<script>alert("'.$error.'");</script>';
              echo'<script>window.location="add_certificate.php";</script>';
          }
  
          die(); //Ensure no more processing is done
      }
  }
    $i3=$_POST['title'];
    $date = date('Y-m-d');
$upload5="INSERT INTO `certificate` (`image`,`title`,`date`) VALUES ('$img','$i3','$date')";
$upload_check=mysqli_query($conn,$upload5);
header("location:add_certificate.php?id=Certificate Added Successfully");
}

?>

<?php
if(isset($_POST['video'])) {

  InsertVideo();
}
function InsertVideo() {
  include 'db.php';

    $i3=$_POST['link'];
    $date = date('Y-m-d');
$upload5="INSERT INTO `video_gallery` (`video_link`,`date`) VALUES ('$i3','$date')";
$upload_check=mysqli_query($conn,$upload5);
header("location:video_gallery.php?id=Video Added Successfully");
}

?>
<?php
if(isset($_POST['counter'])) {

  InsertCounter();
}
function InsertCounter() {
  include 'db.php';
  if(isset($_FILES['img'])) {
    $errors     = array();
    $maxsize    = 2097152;
    $acceptable = array(
        'application/pdf',
        'image/jpeg',
        'image/jpg',
        'image/png'
    );

    if($_FILES['img']['size'] >= $maxsize) {
        $errors[] = 'File too large. File must be less than 2 megabytes.';
    }

    if((!in_array($_FILES['img']['type'], $acceptable)) && (!empty($_FILES["img"]["type"]))) {
        $errors[] = 'Invalid file type. Only JPG, PDF and PNG types are accepted.';
    }

    if(count($errors) === 0) {
      $randomgen=rand(1121,9989);
      $newname=date("dymhis");
      move_uploaded_file($_FILES['img']['tmp_name'], "../img/".$newname.$randomgen.$_FILES['img']['name']);
      $img = "img/".$newname.$randomgen.$_FILES['img']['name'];
    } else {
        foreach($errors as $error) {
            echo '<script>alert("'.$error.'");</script>';
            echo'<script>window.location="add_certificate.php";</script>';
        }

        die(); //Ensure no more processing is done
    }
}
    $i3=$_POST['icon'];
    $i4=$_POST['title'];
    $i5=$_POST['number'];
    $date = date('Y-m-d');
$upload5="INSERT INTO `counters` (`icon`,`image`,`title`,`counternum`,`date`) VALUES ('$i3','$img','$i4','$i5','$date')";
$upload_check=mysqli_query($conn,$upload5);
header("location:addcounter.php?id=Counter Added Successfully");
}

?>

<?php
if(isset($_POST['gallerys'])) {

  InsertGall();
}
function InsertGall() {
  include 'db.php';
  $filecheck = count($_FILES['img']['name']);

$totalfiles = count($_FILES['img']['name']);
    // Looping over all files
    for($i=0;$i<$totalfiles;$i++){
    $filename = $_FILES['img']['name'][$i];
    $randomgen=rand(1121,9989);
    $newname=date("dymhis");
    if(move_uploaded_file($_FILES["img"]["tmp_name"][$i],'../img/'.$newname.$randomgen.$filename)){
      $img = "img/".$newname.$randomgen.$_FILES['img']['name'][$i];
      $i3=$_POST['title'];
      $i4=$_POST['alt'];
      $date = date('Y-m-d');
      $upload5="INSERT INTO `gallery` (`images`,`title`,`alt`,`date`) VALUES ('$img','$i3','$i4','$date')";
      mysqli_query($conn,$upload5);
      
    }else{
      echo '';
    } 
    }
}
?>


<?php
if(isset($_POST['menu'])) {

  InsertMenu();
}
function InsertMenu() {
  include 'db.php';

    $i3=$_POST['mname'];
    $i4=strtolower(str_replace(" ","-",$_POST['mname']));
    $filename=$i4.".php";
    $date = date('Y-m-d');
$upload5="INSERT INTO `add_menu` (`menu_name`,`menu_link`,`date`) VALUES ('$i3','$i4','$date')";
$upload_check=mysqli_query($conn,$upload5);
header("location:add-menu.php?id=Menu Added Successfully");
}

?>
<?php
if(isset($_POST['catago'])) {

  InsertCata();
}
function InsertCata() {
  include 'db.php';



    if(isset($_FILES['img'])) {
      $errors     = array();
      $maxsize    = 2097152;
      $acceptable = array(
          'application/pdf',
          'image/jpeg',
          'image/jpg',
          'image/png'
      );
  
      if($_FILES['img']['size'] >= $maxsize) {
          $errors[] = 'File too large. File must be less than 2 megabytes.';
     
      }
  
      if((!in_array($_FILES['img']['type'], $acceptable)) && (!empty($_FILES["img"]["type"]))) {
          $errors[] = 'Invalid file type. Only JPG, PDF and PNG types are accepted.';
       
      }
  if($_FILES['img']['tmp_name']!=null){
      if(count($errors) === 0) {
        $randomgen=rand(1121,9989);
        $newname=date("dymhis");
        move_uploaded_file($_FILES['img']['tmp_name'], "../img/".$newname.$randomgen.$_FILES['img']['name']);
        $img = "img/".$newname.$randomgen.$_FILES['img']['name'];
      } else { 
          foreach($errors as $error) {
              echo '<script>alert("'.$error.'");</script>';
              echo'<script>window.location="add-product.php";</script>';
          }
  
          die(); //Ensure no more processing is done
      }
    }
  }

  if(isset($_FILES['img1'])) {
    $errors     = array();
    $maxsize    = 2097152;
    $acceptable = array(
        'application/pdf',
        'image/jpeg',
        'image/jpg',
        'image/png'
    );

    if($_FILES['img1']['size'] >= $maxsize) {
        $errors[] = 'File too large. File must be less than 2 megabytes.';
      
    }

    if((!in_array($_FILES['img1']['type'], $acceptable)) && (!empty($_FILES["img1"]["type"]))) {
        $errors[] = 'Invalid file type. Only JPG, PDF and PNG types are accepted.';

    }
if($_FILES['img1']['tmp_name']!=null){
    if(count($errors) === 0) {
      $randomgen=rand(1121,9989);
      $newname=date("dymhis");
      move_uploaded_file($_FILES['img1']['tmp_name'], "../img/".$newname.$randomgen.$_FILES['img1']['name']);
      $img2 = "img/".$newname.$randomgen.$_FILES['img1']['name'];
    } else {
        foreach($errors as $error) {
            echo '<script>alert("'.$error.'");</script>';
            echo'<script>window.location="add-products.php";</script>';
        }

        die(); //Ensure no more processing is done
    }
  }
}

if(isset($_FILES['img2'])) {
  $errors     = array();
  $maxsize    = 2097152;
  $acceptable = array(
      'application/pdf',
      'image/jpeg',
      'image/jpg',
      'image/png'
  );

  if($_FILES['img2']['size'] >= $maxsize) {
      $errors[] = 'File too large. File must be less than 2 megabytes.';

  }

  if((!in_array($_FILES['img2']['type'], $acceptable)) && (!empty($_FILES["img2"]["type"]))) {
      $errors[] = 'Invalid file type. Only JPG, PDF and PNG types are accepted.';
   
  }
if($_FILES['img2']['tmp_name']!=null){
  if(count($errors) === 0) {
    $randomgen=rand(1121,9989);
    $newname=date("dymhis");
    move_uploaded_file($_FILES['img2']['tmp_name'], "../img/".$newname.$randomgen.$_FILES['img2']['name']);
    $img3 = "img/".$newname.$randomgen.$_FILES['img2']['name'];
  } else {
      foreach($errors as $error) {
          echo '<script>alert("'.$error.'");</script>';
          echo'<script>window.location="add-product.php";</script>';
      }

      die(); //Ensure no more processing is done
  }
}
}

if(isset($_FILES['img3'])) {
  $errors     = array();
  $maxsize    = 2097152;
  $acceptable = array(
      'application/pdf',
      'image/jpeg',
      'image/jpg',
      'image/png'
  );

  if($_FILES['img3']['size'] >= $maxsize) {
      $errors[] = 'File too large. File must be less than 2 megabytes.';

  }

  if((!in_array($_FILES['img3']['type'], $acceptable)) && (!empty($_FILES["img3"]["type"]))) {
      $errors[] = 'Invalid file type. Only JPG, PDF and PNG types are accepted.';

  }
if($_FILES['img3']['tmp_name']!=null){
  if(count($errors) === 0) {
    $randomgen=rand(1121,9989);
    $newname=date("dymhis");
    move_uploaded_file($_FILES['img3']['tmp_name'], "../img/".$newname.$randomgen.$_FILES['img3']['name']);
    $img4 = "img/".$newname.$randomgen.$_FILES['img3']['name'];
  } else {
      foreach($errors as $error) {
          echo '<script>alert("'.$error.'");</script>';
          echo'<script>window.location="add-product.php";</script>';
      }

      die(); //Ensure no more processing is done
  }
}
}

if(isset($_FILES['img4'])) {
  $errors     = array();
  $maxsize    = 2097152;
  $acceptable = array(
      'application/pdf',
      'image/jpeg',
      'image/jpg',
      'image/png'
  );

  if($_FILES['img4']['size'] >= $maxsize) {
      $errors[] = 'File too large. File must be less than 2 megabytes.';

  }

  if((!in_array($_FILES['img4']['type'], $acceptable)) && (!empty($_FILES["img4"]["type"]))) {
      $errors[] = 'Invalid file type. Only JPG, PDF and PNG types are accepted.';
    
  }
if($_FILES['img4']['tmp_name']!=null){
  if(count($errors) === 0) {
    $randomgen=rand(1121,9989);
    $newname=date("dymhis");
    move_uploaded_file($_FILES['img4']['tmp_name'], "../img/".$newname.$randomgen.$_FILES['img4']['name']);
    $img5 = "img/".$newname.$randomgen.$_FILES['img4']['name'];
  } else {
      foreach($errors as $error) {
          echo '<script>alert("'.$error.'");</script>';
          echo'<script>window.location="add-product.php";</script>';
      }

      die(); //Ensure no more processing is done
  }
}
}

    $pro1=$_POST['name'];
    $short=mysqli_real_escape_string($conn,strtolower(str_replace(" ","-",$pro1)));
    $pro2=$_POST['unit'];
    $pro3=$_POST['mrp'];
    $pdf="";
    $pro4=$_POST['price'];
    $pro5=$_POST['std'];
    $pro6=$_POST['mt'];
    $pro9=$_POST['ml'];
    $pro10=$_POST['md'];
    $pro7=$_POST['editor1'];
    $pro8=$_POST['editor2'];
    $date = date('Y-m-d');
$upload5="INSERT INTO `add_products`(`date`,`name`,`image`,`mrp`,`price`,`unit`,`editor1`,`editor2`,`img1`,`img2`,`img3`,`img4`,`img5`,`stitle`,`sdes`,`scanon`,`std`,`pdf`,`pg_url`) VALUES ('$date','$pro1','$img','$pro3','$pro4','$pro2','$pro7','$pro8','$img2','$img3','$img4','$img5','$img6','$pro6','$pro10','$pro9','$pro5','$pdf','$short')";
$upload_check=mysqli_query($conn,$upload5);
header("location:add-products.php?id=Services Added Successfully");
}

?>
<?php
if(isset($_POST['Subcata'])) {

  InsertSubcata();
}
function InsertSubcata() {
  include 'db.php';

  $cata=strtolower(str_replace(" ","-",$_GET['product']));

    if(isset($_FILES['img'])) {
      $errors     = array();
      $maxsize    = 2097152;
      $acceptable = array(
          'application/pdf',
          'image/jpeg',
          'image/jpg',
          'image/png'
      );
  
      if($_FILES['img']['size'] >= $maxsize) {
          $errors[] = 'File too large. File must be less than 2 megabytes.';
       
      }
  
      if((!in_array($_FILES['img']['type'], $acceptable)) && (!empty($_FILES["img"]["type"]))) {
          $errors[] = 'Invalid file type. Only JPG, PDF and PNG types are accepted.';
         
      }
  if($_FILES['img']['tmp_name']!=null){
      if(count($errors) === 0) {
        $randomgen=rand(1121,9989);
        $newname=date("dymhis");
        move_uploaded_file($_FILES['img']['tmp_name'], "../img/".$newname.$randomgen.$_FILES['img']['name']);
        $img = "img/".$newname.$randomgen.$_FILES['img']['name'];
      } else {
          foreach($errors as $error) {
              echo '<script>alert("'.$error.'");</script>';
              echo'<script>window.location="sub-products.php?id=Sub-Catagory Added Successfully&product=$cata";</script>';
          }
  
          die(); //Ensure no more processing is done
      }
    }
  }

  if(isset($_FILES['img1'])) {
    $errors     = array();
    $maxsize    = 2097152;
    $acceptable = array(
        'application/pdf',
        'image/jpeg',
        'image/jpg',
        'image/png'
    );

    if($_FILES['img1']['size'] >= $maxsize) {
        $errors[] = 'File too large. File must be less than 2 megabytes.';

    }

    if((!in_array($_FILES['img1']['type'], $acceptable)) && (!empty($_FILES["img1"]["type"]))) {
        $errors[] = 'Invalid file type. Only JPG, PDF and PNG types are accepted.';

    }
if($_FILES['img1']['tmp_name']!=null){
    if(count($errors) === 0) {
      $randomgen=rand(1121,9989);
      $newname=date("dymhis");
      move_uploaded_file($_FILES['img1']['tmp_name'], "../img/".$newname.$randomgen.$_FILES['img1']['name']);
      $img2 = "img/".$newname.$randomgen.$_FILES['img1']['name'];
    } else {
        foreach($errors as $error) {
            echo '<script>alert("'.$error.'");</script>';
            echo'<script>window.location="sub-products.php?id=Sub-Products Added Successfully&product=$cata";</script>';
        }

        die(); //Ensure no more processing is done
    }
  }
}

if(isset($_FILES['img2'])) {
  $errors     = array();
  $maxsize    = 2097152;
  $acceptable = array(
      'application/pdf',
      'image/jpeg',
      'image/jpg',
      'image/png'
  );

  if($_FILES['img2']['size'] >= $maxsize) {
      $errors[] = 'File too large. File must be less than 2 megabytes.';

  }

  if((!in_array($_FILES['img2']['type'], $acceptable)) && (!empty($_FILES["img2"]["type"]))) {
      $errors[] = 'Invalid file type. Only JPG, PDF and PNG types are accepted.';

  }
if($_FILES['img2']['tmp_name']!=null){
  if(count($errors) === 0) {
    $randomgen=rand(1121,9989);
    $newname=date("dymhis");
    move_uploaded_file($_FILES['img2']['tmp_name'], "../img/".$newname.$randomgen.$_FILES['img2']['name']);
    $img3 = "img/".$newname.$randomgen.$_FILES['img2']['name'];
  } else {
      foreach($errors as $error) {
          echo '<script>alert("'.$error.'");</script>';
          echo'<script>window.location="sub-products.php?id=Sub-Catagory Added Successfully&product=$cata";</script>';
      }

      die(); //Ensure no more processing is done
  }
}
}

if(isset($_FILES['img3'])) {
  $errors     = array();
  $maxsize    = 2097152;
  $acceptable = array(
      'application/pdf',
      'image/jpeg',
      'image/jpg',
      'image/png'
  );

  if($_FILES['img3']['size'] >= $maxsize) {
      $errors[] = 'File too large. File must be less than 2 megabytes.';

  }

  if((!in_array($_FILES['img3']['type'], $acceptable)) && (!empty($_FILES["img3"]["type"]))) {
      $errors[] = 'Invalid file type. Only JPG, PDF and PNG types are accepted.';

  }
if($_FILES['img3']['tmp_name']!=null){
  if(count($errors) === 0) {
    $randomgen=rand(1121,9989);
    $newname=date("dymhis");
    move_uploaded_file($_FILES['img3']['tmp_name'], "../img/".$newname.$randomgen.$_FILES['img3']['name']);
    $img4 = "img/".$newname.$randomgen.$_FILES['img3']['name'];
  } else {
      foreach($errors as $error) {
          echo '<script>alert("'.$error.'");</script>';
          echo'<script>window.location="sub-products.php?id=Sub-Catagory Added Successfully&product=$cata";</script>';
      }

      die(); //Ensure no more processing is done
  }
}
}

if(isset($_FILES['img4'])) {
  $errors     = array();
  $maxsize    = 2097152;
  $acceptable = array(
      'application/pdf',
      'image/jpeg',
      'image/jpg',
      'image/png'
  );

  if($_FILES['img4']['size'] >= $maxsize) {
      $errors[] = 'File too large. File must be less than 2 megabytes.';

  }

  if((!in_array($_FILES['img4']['type'], $acceptable)) && (!empty($_FILES["img4"]["type"]))) {
      $errors[] = 'Invalid file type. Only JPG, PDF and PNG types are accepted.';

  }
if($_FILES['img4']['tmp_name']!=null){
  if(count($errors) === 0) {
    $randomgen=rand(1121,9989);
    $newname=date("dymhis");
    move_uploaded_file($_FILES['img4']['tmp_name'], "../img/".$newname.$randomgen.$_FILES['img4']['name']);
    $img5 = "img/".$newname.$randomgen.$_FILES['img4']['name'];
  } else {
      foreach($errors as $error) {
          echo '<script>alert("'.$error.'");</script>';
          echo'<script>window.location="sub-products.php?id=Sub-Catagory Added Successfully&product=$cata";</script>';
      }

      die(); //Ensure no more processing is done
  }
}
}

    $pro1=$_POST['name'];
    $catagory=$_GET['product'];
    $cata=strtolower(str_replace(" ","-",$_GET['product']));
    $short=mysqli_real_escape_string($conn,strtolower(str_replace(" ","-",$pro1)));
    $pro2=$_POST['unit'];
    $pro3=$_POST['mrp'];
    $pdf="";
    $pro4=$_POST['price'];
    $pro5=$_POST['std'];
    $pro6=$_POST['mt'];
    $pro9=$_POST['ml'];
    $pro10=$_POST['md'];
    $pro7=$_POST['editor1'];
    $pro8=$_POST['editor2'];
    $date = date('Y-m-d');
$upload5="INSERT INTO `add_sub_products`(`date`,`name`,`image`,`mrp`,`price`,`unit`,`editor1`,`editor2`,`img1`,`img2`,`img3`,`img4`,`img5`,`stitle`,`sdes`,`scanon`,`std`,`pdf`,`pg_url`,`catagory`,`pg_cata`) VALUES ('$date','$pro1','$img','$pro3','$pro4','$pro2','$pro7','$pro8','$img2','$img3','$img4','$img5','$img6','$pro6','$pro10','$pro9','$pro5','$pdf','$short','$catagory','$cata')";
$upload_check=mysqli_query($conn,$upload5);
header("location:sub-products.php?id=Sub-Catagory Added Successfully&product=$cata");
}

?>

<?php
if(isset($_POST['whchoose'])) {

  Insertabout();
}
function Insertabout() {
  include 'db.php';
  $imgchk1=$_FILES['img']['size'];
  $i1=$_POST['icon'];
  $i3=$_POST['title'];
  $i4=$_POST['desc'];
  if($i1!=null || $i2!=null || $i3!=null || $i4!=null || $imgchk1!=null){

    if(isset($_FILES['img'])) {
      $errors     = array();
      $maxsize    = 2097152;
      $acceptable = array(
          'application/pdf',
          'image/jpeg',
          'image/jpg',
          'image/gif',
          'image/png'
      );
  
      if($_FILES['img']['size'] >= $maxsize)  {
          $errors[] = 'File too large. File must be less than 2 megabytes.';
      }
  
      if((!in_array($_FILES['img']['type'], $acceptable)) && (!empty($_FILES["img"]["type"]))) {
          $errors[] = 'Invalid file type. Only PDF, JPG, GIF and PNG types are accepted.';
      }
      if($_FILES['img']['tmp_name']!=null){
      if(count($errors) === 0) {
        $randomgen=rand(1121,9989);
        $newname=date("dymhis");
        move_uploaded_file($_FILES['img']['tmp_name'], "../img/".$newname.$randomgen.$_FILES['img']['name']);
        $img = "img/".$newname.$randomgen.$_FILES['img']['name'];

      } else {
          foreach($errors as $error) {
              echo '<script>alert("'.$error.'");</script>';
              echo'<script>window.location="about_content.php";</script>';
          }
  
          die(); //Ensure no more processing is done
      }
    }
  }

    
    $i1=$_POST['icon'];
    $i3=$_POST['title'];
    $i4=mysqli_real_escape_string($conn,$_POST['desc']);
    $i67=$_POST['cata'];
    $date = date('Y-m-d');
$upload5="INSERT INTO `whychooseus` (`icon`,`title`,`description`,`image`,`catagory`,`date`) VALUES ('$i1','$i3','$i4','$img','$i67','$date')";
$upload_check=mysqli_query($conn,$upload5);
header("location:about_content.php?id=Content Added Successfully");
}
else{
  
}
}

?>

<?php
if(isset($_POST['Blogs'])) {

  InsertBlogs();
}
function InsertBlogs() {
  include 'db.php';



    if(isset($_FILES['img'])) {
      $errors     = array();
      $maxsize    = 2097152;
      $acceptable = array(
          'application/pdf',
          'image/jpeg',
          'image/jpg',
          'image/png'
      );
  
      if($_FILES['img']['size'] >= $maxsize)  {
          $errors[] = 'File too large. File must be less than 2 megabytes.';
      }
  
      if((!in_array($_FILES['img']['type'], $acceptable)) && (!empty($_FILES["img"]["type"]))) {
          $errors[] = 'Invalid file type. Only JPG, PDF and PNG types are accepted.';
      }
  
      if(count($errors) === 0) {
        $randomgen=rand(1121,9989);
        $newname=date("dymhis");
        move_uploaded_file($_FILES['img']['tmp_name'], "../img/".$newname.$randomgen.$_FILES['img']['name']);
        $img = "img/".$newname.$randomgen.$_FILES['img']['name'];
      } else {
          foreach($errors as $error) {
              echo '<script>alert("'.$error.'");</script>';
              echo'<script>window.location="blogs.php";</script>';
          }
  
          die(); //Ensure no more processing is done
      }
  }
    $i3=$_POST['title'];
    $item3=$_POST['mt'];
    $item4=$_POST['md'];
    $item5=$_POST['ml'];
    
    $item6=strtolower(str_replace(" ","-",$i3));
    $i4=mysqli_real_escape_string($conn,$_POST['editor1']);
    $date = date('Y-m-d');
$upload5="INSERT INTO `blogs` (`image`,`title`,`description`,`stitle`,`sdes`,`scanon`,`pg_url`,`date`) VALUES ('$img','$i3','$i4','$item3','$item4','$item5','$item6','$date')";
$upload_check=mysqli_query($conn,$upload5);
header("location:blogs.php?id=Blogs Added Successfully");
}

?>