MAINHACK

Viewing / Editing File: enquiry.php

<?php 
  include("header.php");
  $id=base64_decode($_REQUEST['id']);

$sq="select * from doctor where doctor_id='".$id."' order by id desc";
$r=mysqli_query($con,$sq);
while($row=mysqli_fetch_array($r)){
$doc=$row['doctor_id'];
  $name=$row['name'];
  $cate=$row['category'];

}
?>
<script src="js/jquery-1.11.1.min.js"></script>

<script type="text/javascript">
 
 $(document).ready(function(){
            // Add more
            $('#addmore').click(function(){

// Get last id 
                var lastname_id = $('.tr_input input[type=file]:nth-child(1)').last().attr('id');
                var split_id = lastname_id.split('_');

// New index
                var index = Number(split_id[1]) + 1;
                // Create row with input elements
var html = "<div class='tr_input'><input type='file' class='username'  id='testcode_"+index+"' name='files[]' style=''><div class='col-lg-1 col-md-1 col-sm-1 col-xs-1' style=''><a href='javascript:void(0);' id='remove_field'  class='remCF btn btn-info' >-</a></div></div>";
                // Append data
                $('#tab').append(html);
            });
      
           $("#tab").on('click','.remCF',function(){
        $(this).parent().parent().remove();

});
        });
  $(document).ready(function(){
            // Add more
            $('#addmore').click(function(){
        
        
      });
      
  }); 
</script>

<div class="enquiry">
  <div class="spec aos-init aos-animate" data-aos="fade-down" style="transition:all 1500ms ease-in-out">
    <h2>Enquiry Form</h2>
  </div>
      
    <div class="container">
        <div class="col-md-3"></div>
        <div class="col-md-6 contact-left">
              <form action="" enctype="multipart/form-data" method="post">

<div class="form-left">
                        <label style="color: #FFF;font-weight: bold;">Name:</label>
                        <input type="text" placeholder="Patient Name" name="na" required="">
                      </div>
                      <div class="form-right">
                        <label style="color: #FFF;font-weight: bold;">Phone no :</label>
                        <input type="text" placeholder="Patient Phone No" maxlength="10" pattern="[0-9]+" name="phn" required="">
                      </div>
                      <div class="form-rightt">
                        <label style="color: #FFF;font-weight: bold;">Sex :</label> 
                          <input type="radio" name="gender" value="Male" required> Male
                          <input type="radio" name="gender" value="Female" required> Female
                          <input type="radio" name="gender" value="Other" required> Other
                      </div>                    
                      <div class="form-left">
                        <label style="color: #FFF;font-weight: bold;">Date of Birth :</label>
                        <input type="text" id="datepicker5" name="dob" placeholder="Enter Date of Birth"  />
                      </div>  
                      <div class="form-right">
                        <label style="color: #FFF;font-weight: bold;">File Upload:</label>
                        <div class='tr_input' id="tab">
                          <input type='file' class='username'  id='testcode_1' name="files[]" style="">
                          <input type='button' class="btn btn-info" value='+' id='addmore' >
                        </div>
                      </div>
                      <div class="form-left">
                        <label style="color: #FFF;font-weight: bold;">Doctor Name :</label> 
                        <input type="text" name="doc_name" value="<?=$name?>" placeholder="Enter doctor Name" readonly="">
                        <input type="hidden" name="doc_id" value="<?=$id?>">
                      </div>
                     <div class="form-right">
                      <label style="color: #FFF;font-weight: bold;">What is your Query? :</label> 
                      <textarea name="desc" placeholder="Enter Your Message" required=""></textarea>    
                      </div>
                      <label style="color: #FFF;font-weight: bold;">Enquiry Charge :</label> 
                    <input type="text" name="doc_name" value="100" placeholder="Enter doctor Name" readonly="">
                      
                    <input type="submit" value="Submit" name="sub">
              </form> 
<?php
if(isset($_POST['sub'])){
    	include('ids.php');

if(isset($_FILES['files'])){
	foreach($_FILES['files']['tmp_name'] as $key => $tmp_name ){
		$file_name = $_FILES['files']['name'][$key];
		$file_size =$_FILES['files']['size'][$key];
		$file_tmp =$_FILES['files']['tmp_name'][$key];
		$file_type=$_FILES['files']['type'][$key];	
        if($file_size > 2097152){
			$errors[]='File size must be less than 2 MB';
        }		
        $query="INSERT into enquiry_img(enquiry_id,img,date) VALUES('".$id."','$file_name',curdate())";
        $desired_dir="user_data";
        if(empty($errors)==true){
            if(is_dir($desired_dir)==false){
                mkdir("$desired_dir", 0700);		// Create directory if it does not exist
            }
            if(is_dir("$desired_dir/".$file_name)==false){
                move_uploaded_file($file_tmp,"user_data/".$file_name);
            }else{									//rename the file if another one exist
                $new_dir="user_data/".$file_name.time();
                 rename($file_tmp,$new_dir) ;				
            }
         mysqli_query($con,$query);
        }else{
                print_r($errors);
        }
		
    }
	
if(empty($error)){
		echo "Success";
	$r=0;

$sq="insert into enquiry(enquiry_id,user_id,patient_name,phone,sex,dob,doc_id,doc_name,description,date) 
values('".$id."','".trim($user_id)."','".trim($_POST['na'])."','".trim($_POST['phn'])."','".trim($_POST['gender'])."','".trim(date('Y-m-d',strtotime($_POST['na'])))."','".trim($_POST['doc_id'])."','".trim($_POST['doc_name'])."','".trim(mysqli_real_escape_string($con,$_POST['desc']))."',CURDATE())";
//echo $sq;
//exit();
$r=mysqli_query($con,$sq) or die(mysqli_error($con));
  $sq1="insert into enquiry_all(enquiry_id,enquiry,date) values('".$id."','".mysqli_real_escape_string($con,$_POST['desc'])."',curdate())";
   $r1=mysqli_query($con,$sq1);
	if($r==1)
echo "<script>sweetAlert('OK','Thank you for your query . We will get back to you soon','success');</script>";

}
		
		  }
    
    
}              
              ?>
        </div>
        <div class="col-md-3"></div>
    </div>
</div>

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

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: enquiry.php

Server Info

System Features

User Info