<?php
include"db.php";


  if (isset($_POST['Submit']))
   {


$errors = array();


	$gym_name=mysqli_real_escape_string($conn,$_POST["name"]);
	$gym_email=mysqli_real_escape_string($conn,$_POST["email"]);
	$gym_contact=mysqli_real_escape_string($conn,$_POST["gym_contact_number"]);
	$gym_address=mysqli_real_escape_string($conn,$_POST["address"]);
	$gym_city=mysqli_real_escape_string($conn,$_POST["city"]);
	$gym_area=mysqli_real_escape_string($conn,$_POST["area"]);
	$gym_proximity=mysqli_real_escape_string($conn,$_POST["proximity"]);
   	$open_time=mysqli_real_escape_string($conn,$_POST["open_time"]);
	$end_time=mysqli_real_escape_string($conn,$_POST["end_time"]);

  	$day=mysqli_real_escape_string($conn,$_POST["day"]);


	$admin_name=mysqli_real_escape_string($conn,$_POST["owner_name"]);
	// $admin_email=mysqli_real_escape_string($conn,$_POST["owner_email"]);
	$admin_contact=mysqli_real_escape_string($conn,$_POST["owner_contact"]);
	$admin_username=mysqli_real_escape_string($conn,$_POST["user_name"]);
	$admin_password=mysqli_real_escape_string($conn,$_POST["password_1"]);
	$expiry_date=mysqli_real_escape_string($conn,$_POST["expiry_date"]);
  $description=mysqli_real_escape_string($conn,$_POST["description"]);

$Sucess = "Gym Successfully Added";
// $error = "Gym Successfully Added";




   $images_arr = array();

if (count($_FILES["image"]['name']) <=5)
{
//check if any file uploaded
 // $GLOBALS['msg'] = ""; //initiate the global message
	$ccount =count($_FILES["image"]['name']);
   for($j=0; $j < $ccount; $j++)
 { //loop the uploaded file array
   $filename = $_FILES["image"]['name']["$j"]; //file name
    $tmp_name = $_FILES["image"]["tmp_name"]["$j"];


   // $path = 'images/'.$filen; //generate the destination path

    $fileinfo = getimagesize($tmp_name);
            $filewidth = $fileinfo[0];
            $fileheight = $fileinfo[1];


            if ( $filewidth < 1220 && $fileheight < 710 )       {

                $error="Please Check Image Dimensions ";
                   $_SESSION["error"] = $error;
            header('Location:gym_registration_form.php');


            } else {

      $extension= pathinfo($filename,PATHINFO_EXTENSION);

              //setting file path
              $i=$j+1;
              $extra ="image".$i."-";
              // echo $extra;
              $name = "gym_image/";
              //assigning a unique name to the image to avoid duplication
              $uniquesavename=time().uniqid(rand());
              //concatinating the file path and name with the extension
              $destFile = $name.$extra.$gym_name . $gym_area . $uniquesavename . ".".$extension;

              echo $destFile;


     $images_arr[] = $destFile;

     // echo count($images_arr);

   move_uploaded_file($tmp_name,$destFile);

}
}
     if (count($images_arr) == 1){
          $file1 = $images_arr[0];
          $file2 = '0';
          $file3 = '0';
          $file4 = '0';
          $file5 = '0';
     }elseif (count($images_arr) == 2) {
         $file1 = $images_arr[0];
         $file2 = $images_arr[1];
          $file3 = '0';
          $file4 = '0';
          $file5 = '0';
     } elseif (count($images_arr) == 3)
     {
         $file1 = $images_arr[0];
         $file2 = $images_arr[1];
          $file3 = $images_arr[2];
          $file4 = '0';
          $file5 = '0';
     } elseif (count($images_arr) == 4)
     {
          $file1 = $images_arr[0];
         $file2 = $images_arr[1];
          $file3 = $images_arr[2];
          $file4 = $images_arr[3];
          $file5 = '0';
     } elseif (count($images_arr) == 5)
     {
          $file1 = $images_arr[0];
         $file2 = $images_arr[1];
          $file3 = $images_arr[2];
          $file4 = $images_arr[3];
          $file5 = $images_arr[4];
     } else
     {
          $file1 = '0';
          $file2 = '0';
          $file3 = '0';
          $file4 = '0';
          $file5 = '0';
     }



$search="INSERT INTO fh_gym_list( admin_name,username,password,role,address,city,area,proximity,  gym_description,email_id,contact_no,contact_person,open_time,end_time,day,disable_flag,regi_date,expiry_date,updated_flag,image1, image2,image3, image4, image5) VALUES ('$gym_name','$admin_username','$admin_password','admin','$gym_address','$gym_city','$gym_area','$gym_proximity','$description','$gym_email','$gym_contact','$admin_name','$open_time','$end_time','$day','0',NOW(),'$expiry_date','0','$file1','$file2','$file3','$file4','$file5')";

        mysqli_query($conn,$search);

  // for getting the ladt id of the insert query
          $last_id = mysqli_insert_id($conn);

        //Inserting facility data in facility track table

              if (isset($_POST['activityname']))
          {
             $stmt = $conn->prepare("INSERT INTO fh_gym_activity (gym_id,activity_id,disable_flag) VALUES( ?, ?, ?)");
            $stmt->bind_param("sss", $gym_id,$activity_id,$disable_flag);


          foreach ( $_POST['activityname'] as $selectedOption)
          {
            $gym_id=$last_id;

            $activity_id=$selectedOption;
            //pending using select statement

            $disable_flag='0';
            /*use session*/
            // $activity_id=$;
            $stmt->execute();


            //echo $selectedOption."\n";
          }


        }
$_SESSION["Sucess"] = $Sucess;
     header('Location:gym_list.php');

    mysqli_close($conn);







} else{
 $_SESSION["error"] = $error;
     header('Location:gym_registration_form.php');

    mysqli_close($conn);

}
}
else{
  echo "error";

}


//$insert1="INSERT INTO gym_track_facility (facility_id,gym_id,added_datetime,added_by) VALUES ()";






?>