• 0

عندي خطا في كود php عند تحويله منmysql to sqlserver2008

 

<?php
session_start();
//error_reporting(0);
include('include/config.php');
include('include/checklogin.php');
check_login();
$serverName = "AZZA-PC";
$connectionInfo = array( "Database"=>"hms");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if(isset($_GET['cancel']))
{
sqlsrv_query($conn,"update appointment set userStatus='0' where id = '".$_GET['id']."'");
$_SESSION['msg']="Your appointment canceled !!";
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
<title>User | Appointment History</title>

<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0, user-scalable=0, minimum-scale=1.0, maximum-scale=1.0">
<meta name="apple-mobile-web-app-capable" content="yes">
<meta name="apple-mobile-web-app-status-bar-style" content="black">
<meta content="" name="description" />
<meta content="" name="author" />

<link href="http://fonts.googleapis.com/css?family=Lato:300,400,400italic,600,700|Raleway:300,400,500,600,700|Crete+Round:400italic" rel="stylesheet" type="text/css" />
<link rel="stylesheet" href="vendor/bootstrap/css/bootstrap.min.css">
<link rel="stylesheet" href="vendor/fontawesome/css/font-awesome.min.css">
<link rel="stylesheet" href="vendor/themify-icons/themify-icons.min.css">
<link href="vendor/animate.css/animate.min.css" rel="stylesheet" media="screen">
<link href="vendor/perfect-scrollbar/perfect-scrollbar.min.css" rel="stylesheet" media="screen">
<link href="vendor/switchery/switchery.min.css" rel="stylesheet" media="screen">
<link href="vendor/bootstrap-touchspin/jquery.bootstrap-touchspin.min.css" rel="stylesheet" media="screen">
<link href="vendor/select2/select2.min.css" rel="stylesheet" media="screen">
<link href="vendor/bootstrap-datepicker/bootstrap-datepicker3.standalone.min.css" rel="stylesheet" media="screen">
<link href="vendor/bootstrap-timepicker/bootstrap-timepicker.min.css" rel="stylesheet" media="screen">
<link rel="stylesheet" href="assets/css/styles.css">
<link rel="stylesheet" href="assets/css/plugins.css">
<link rel="stylesheet" href="assets/css/themes/theme-1.css" id="skin_color" />

</head>
<body>
<div id="app">		
<?php include('include/sidebar.php');?>

<div class="app-content">
<?php include('include/header.php');?>
<!-- end: TOP NAVBAR -->

<div class="main-content" >
<div class="wrap-content container" id="container">

<!-- start: PAGE TITLE -->
<section id="page-title">
<div class="row">

<div class="col-sm-8">
<h1 class="mainTitle">User  | Appointment History</h1>
</div>

<ol class="breadcrumb">
<li>
<span>User </span>
</li>

<li class="active">
<span>Appointment History</span>
</li>

</ol>
</div>
</section>
<!-- end: PAGE TITLE -->

<!-- start: BASIC EXAMPLE -->
<div class="container-fluid container-fullw bg-white">						
<div class="row">

<div class="col-md-12">
<p style="color:red;"><?php echo htmlentities($_SESSION['msg']);?>
<?php echo htmlentities($_SESSION['msg']="");?></p>	

<table class="table table-hover" id="sample-table-1">
<thead>
<tr>
<th class="center">#</th>
<th class="hidden-xs">Doctor Name</th>
<th>Specialization</th>
<th>Consultancy Fee</th>
<th>Appointment Date / Time </th>
<th>Appointment Creation Date  </th>
<th>Current Status</th>
<th>Action</th>
</tr>
</thead>

<tbody>
<?php
$sql=sqlsrv_query($conn,"select doctors.doctorName as docname,appointment.*  from appointment join doctors on doctors.id=appointment.doctorId where appointment.userId='".$_SESSION['id']."'");
$cnt=1;
while($row=sqlsrv_fetch_array($sql))
{
?>

<tr>
<td class="center"><?php echo $cnt;?>.</td>
<td class="hidden-xs"><?php echo $row['docname'];?></td>
<td><?php echo $row['doctorSpecialization'];?></td>
<td><?php echo $row['consultancyFees'];?></td>
<td><?php echo $row['appointmentDate'];?> / <?php echo
$row['appointmentTime'];?>
</td>
<td><?php echo $row['postingDate'];?></td>

<td>
<?php if(($row['userStatus']==1) && ($row['doctorStatus']==1))  
{
	echo "Active";
}
if(($row['userStatus']==0) && ($row['doctorStatus']==1))  
{
	echo "Cancel by You";
}

if(($row['userStatus']==1) && ($row['doctorStatus']==0))  
{
	echo "Cancel by Doctor";
}
?></td>

<td >
<div class="visible-md visible-lg hidden-sm hidden-xs">
<?php if(($row['userStatus']==1) && ($row['doctorStatus']==1))  
{ 
?>
<a href="appointment-history.php?id=<?php echo $row['id']?>&cancel=update" onClick="return confirm('Are you sure you want to cancel this appointment ?')"class="btn btn-transparent btn-xs tooltips" title="Cancel Appointment" tooltip-placement="top" tooltip="Remove">Cancel</a>
<?php } 
else {
echo "Canceled";
} 
?>
</div>

<div class="visible-xs visible-sm hidden-md hidden-lg">
<div class="btn-group" dropdown is-open="status.isopen">
<button type="button" class="btn btn-primary btn-o btn-sm dropdown-toggle" dropdown-toggle>
<i class="fa fa-cog"></i>&nbsp;<span class="caret"></span>
</button>

<ul class="dropdown-menu pull-right dropdown-light" role="menu">
<li><a href="#">Edit</a></li>
<li><a href="#">Share</a></li>
<li><a href="#">Remove</a></li>
</ul>
</div>
</div></td>
</tr>

<?php 
$cnt=$cnt+1;
}?>

</tbody>
</table>
</div></div>
</div>
<!-- end: BASIC EXAMPLE -->
<!-- end: SELECT BOXES -->
</div></div>
</div>

<!-- start: FOOTER -->
<?php include('include/footer.php');?>
<!-- end: FOOTER -->		

<!-- start: SETTINGS -->
<?php include('include/setting.php');?>
<!-- end: SETTINGS -->
</div>

<!-- start: MAIN JAVASCRIPTS -->
<script src="vendor/jquery/jquery.min.js"></script>
<script src="vendor/bootstrap/js/bootstrap.min.js"></script>
<script src="vendor/modernizr/modernizr.js"></script>
<script src="vendor/jquery-cookie/jquery.cookie.js"></script>
<script src="vendor/perfect-scrollbar/perfect-scrollbar.min.js"></script>
<script src="vendor/switchery/switchery.min.js"></script>
<!-- end: MAIN JAVASCRIPTS -->

<!-- start: JAVASCRIPTS REQUIRED FOR THIS PAGE ONLY -->
<script src="vendor/maskedinput/jquery.maskedinput.min.js"></script>
<script src="vendor/bootstrap-touchspin/jquery.bootstrap-touchspin.min.js"></script>
<script src="vendor/autosize/autosize.min.js"></script>
<script src="vendor/selectFx/classie.js"></script>
<script src="vendor/selectFx/selectFx.js"></script>
<script src="vendor/select2/select2.min.js"></script>
<script src="vendor/bootstrap-datepicker/bootstrap-datepicker.min.js"></script>
<script src="vendor/bootstrap-timepicker/bootstrap-timepicker.min.js"></script>
<!-- end: JAVASCRIPTS REQUIRED FOR THIS PAGE ONLY -->

<!-- start: CLIP-TWO JAVASCRIPTS -->
<script src="assets/js/main.js"></script>

<!-- start: JavaScript Event Handlers for this page -->
<script src="assets/js/form-elements.js"></script>

<script>
jQuery(document).ready(function() {
Main.init();
FormElements.init();
});
</script>
<!-- end: JavaScript Event Handlers for this page -->

<!-- end: CLIP-TWO JAVASCRIPTS -->
</body>
</html>

 

favicon.ico

appointment-history.php

appointment-history.php

انشر على الشّبكات الاجتماعية


رابط هذه المساهمة

لا توجد أي إجابات على هذا السؤال بعد


يجب أن تكون عضوًا لدينا لتتمكّن من التعليق

انشاء حساب جديد

يستغرق التسجيل بضع ثوان فقط


سجّل حسابًا جديدًا

تسجيل الدخول

تملك حسابا مسجّلا بالفعل؟


سجّل دخولك الآن