MAINHACK

Viewing / Editing File: edit_enquiry.php

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

$sq="select * from enquiry where enquiry_id='".$id."' order by id desc";
$r=mysqli_query($con,$sq);
while($row=mysqli_fetch_array($r)){
$doc=$row['doctor_id'];
  $name=$row['patient_name'];
  $phn=$row['phone'];
  $uid=$row['user_id'];
  $dob=date('d-m-Y',strtotime($row['date']));
  $sex=$row['sex'];
$status=$row['status'];
}
?>

  
<div id="page-wrapper">
	<div class="main-page">
		<div class="row">
			<div class="col-md-6">
				<div class="form-grids row widget-shadow" data-example-id="basic-forms"> 
					<div class="form-title">
						<h4>Enquiry Details</h4>
					</div>
					<div class="form-body">
						<form method="post" data-toggle="validator" enctype="multipart/form-data"> 
							<div class="form-group">
								<div class="row">
										<div class="col-md-12 ">
										<label>Enquiry ID*</label>
										<input type="text" class="form-control" placeholder="Name" name="na" value="<?=$id?>"size="30" id="na" readonly> 
									</div>
									<div class="col-md-12 ">
										<label>User Id*</label>
										<input type="text" class="form-control" placeholder="Name" name="na" value="<?=$uid?>" size="30" id="na" readonly> 
									</div>
										<div class="col-md-12">
										<label>Patient Name*</label>
										<input type="text" class="form-control" placeholder="Pan No"  value="<?=$name?>" name="pan" size="30" id="pan" readonly>
									</div>
									<div class="col-md-4">
										<label>Phone*</label>
										<input type="text" class="form-control" placeholder="Pan No" name="pan"  value="<?=$phn?>" size="30" id="pan" readonly>
									</div>
										<div class="col-md-4">
										<label>Sex*</label>
										<input type="text" class="form-control" placeholder="Pan No" name="pan" value="<?=$sex?>"  size="30" id="pan" readonly>
									</div>
										<div class="col-md-4">
										<label>Dob*</label>
										<input type="text" class="form-control" placeholder="Pan No" name="pan" value="<?=$dob?>"  size="30" id="pan" readonly>
									</div>
												<div class="col-md-12">
										<label>Personal Details*</label>
								
							<table class="table">
							<thead>
								<tr>  
								  <th>Sl</th>
								  <th>File</th> 
								  
								  <th>Delete</th>
								</tr>
							</thead>
							<tbody>
							
			<?php
//			echo $_SERVER['REQUEST_URI'] ;
$count=1;  
$sq="select * from enquiry_img where enquiry_id='".$id."'";		
$r=mysqli_query($con,$sq);
while($row=mysqli_fetch_array($r)){
	//$status=$row['status'];
	$id=$row['id'];
	  $file=explode(".",$row['img']);
 	$img=$row['img']==''?"<a href='../user_data/noi.png'>No file available</a>":"<a href='../user_data/".$row['file']."' class='btn btn-success' target='_blank'>Download</a>";

echo "	<tr>
								  <td>$count</td>
								 
								  <td>$img</td>
								 
						<td> <a href='edit_pic.php?id=$id&url=".$_SERVER['REQUEST_URI']."' class='label label-success' rel='facebox'>Edit</a>

<a href='delete_pic.php?id=$id&url=".$_SERVER['REQUEST_URI']."&img=".$row['file']."' class='label label-danger' onclick='return send();'>Delete</a>
								
								</td>
								</tr>";

++$count;
								}

?>	
					
					</tbody></table>				
								</div>
						
								</div>								
							</div> 						
						</form>
						
						
					</div>							
				</div>
			</div>	
			<div class="col-md-6" id="myDiv">
							<div class="profile-banner">
								<div class="row">
							<div class="col-md-12">
									    <h2>Enquiry Details</h2>
<?php
$id=$_REQUEST['id'];

$sq="select * from enquiry_all where enquiry_id='".$id."' order by id";
$r=mysqli_query($con,$sq);
while($row=mysqli_fetch_array($r)){
$ans=$row['answer'];
$ques_id=$row['id'];
?>
		
                             <div class="qur">
                             <img src="../images/qursen.png" alt="" style="width:10%;" />
                             <p><?=$row['enquiry']?></p>
                             <span class="time-right"><?=ucfirst($_SESSION['user_name'])?></span>
                              </div>
                              
                              <div class="qur answer">
                              <img src="../images/answ.png" alt="" class="right" style="width:10%;" />
                              <p><?=$row['answer'];?></p>
                              <span class="time-left">Admin</span>
                               </div>
<?php } ?>                      </div>
								</div>
	<?php if($status!="Closed"){?>		            <div class="snipcart-details top_brand_home_details item_add single-item hvr-outline-out">
                                    <form action="" enctype="multipart/form-data" method="post">
                                        <input type="hidden" name="ques_id" value="<?=$ques_id?>">
                                     <p><textarea class="form-control" name="query" placeholder="Post a answer"></textarea></p>
                                   <input type="submit" value="Send" name="sub" class="btn btn-info">
              </form>
<?php if(isset($_POST['sub'])){
   $sq="update enquiry_all set answer='".mysqli_real_escape_string($con,$_POST['query'])."' where id=".$ques_id." and enquiry_id='".$id."'";
   $r=mysqli_query($con,$sq);
   if($r){
      echo"<script> alert('Answer has been submitted .');
       window.location.href='edit_enquiry.php?id=$id';
       </script>";
   }
}   ?>           
                               </div>
                               	<hr/>
									
								<div class="text-center_1">
									<div class="snipcart-details top_brand_home_details item_add single-item hvr-outline-out">
										<a href="close_topic.php?id=<?=$id?>" class="btn btn-warning">Close Topic</a>
									</div>
								</div>
								
                               <?php }else{ ?>
								<hr/>
									
								<div class="text-center_1">
									<div class="snipcart-details top_brand_home_details item_add single-item hvr-outline-out">
                                    <p><b>This topic has been closed.</b></p>								
                                    </div>
								</div>
								<?php } ?>
							</div>

</div>
		</div>	
	</div>
</div>

});
$("#date1").datepicker({
format: 'dd-mm-yyyy',

});
$("#date2").datepicker({
format: 'dd-mm-yyyy',

});
});
</script>

<?php

include('footer.php');
?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: edit_enquiry.php

Server Info

System Features

User Info