• 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($_POST['submit']))
{
$sql=sqlsrv_query("insert into doctorSpecilization(specilization) values('".$_POST['doctorspecilization']."')");
$_SESSION['msg']="Doctor Specialization added successfully !!";
}

if(isset($_GET['del']))
{
sqlsrv_query("delete from doctorSpecilization where id = '".$_GET['id']."'");
 $_SESSION['msg']="data deleted !!";
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
<title>Admin | Doctor Specialization</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">Admin | Add Doctor Specialization</h1>
</div>

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

<li class="active">
<span>Add Doctor Specialization</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">									
<div class="row margin-top-30">
<div class="col-lg-6 col-md-12">
<div class="panel panel-white">

<div class="panel-heading">
<h5 class="panel-title">Doctor Specialization</h5>
</div>

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

<form role="form" name="dcotorspcl" method="post" >

<div class="form-group">
<label for="exampleInputEmail1">
Doctor Specialization
</label>
<input type="text" name="doctorspecilization" class="form-control"  placeholder="Enter Doctor Specialization">
</div>																																									

<button type="submit" name="submit" class="btn btn-o btn-primary">
Submit
</button>
</form>
</div>

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

<div class="col-lg-12 col-md-12">

<div class="panel panel-white">												
</div>
</div>
</div>

<div class="row">

<div class="col-md-12">
<h5 class="over-title margin-bottom-15">Manage <span class="text-bold">Docter Specialization</span></h5>
									
<table class="table table-hover" id="sample-table-1">
<thead>
<tr>
<th class="center">#</th>
<th>Specialization</th>
<th class="hidden-xs">Creation Date</th>
<th>Updation Date</th>
<th>Action</th>
</tr>
</thead>

<tbody>
<?php
$sql=sqlsrv_query("select * from doctorSpecilization");
$cnt=1;
while($row=sqlsrv_fetch_array($sql))
{
?>
<tr>
<td class="center"><?php echo $cnt;?>.</td>
<td class="hidden-xs"><?php echo $row['specilization'];?></td>
<td><?php echo $row['creationDate'];?></td>
<td><?php echo $row['updationDate'];?>
</td>

<td >
<div class="visible-md visible-lg hidden-sm hidden-xs">

<a href="edit-doctor-specialization.php?id=<?php echo $row['id'];?>" 
class="btn btn-transparent btn-xs" tooltip-placement="top" tooltip="Edit">
<i class="fa fa-pencil"></i></a>

<a href="doctor-specilization.php?id=<?php echo $row['id']?>&del=delete" 
onClick="return confirm('Are you sure you want to delete?')"
class="btn btn-transparent btn-xs tooltips" tooltip-placement="top" tooltip="Remove">
<i class="fa fa-times fa fa-white"></i></a>

</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>
</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>

 

1 شخص أعجب بهذا

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


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

اخي , يرجى التوضيح اكثر ,لائدر افيدك ؟؟؟ ,شو الخطا يلي ظهر ؟؟

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


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

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

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

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


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

تسجيل الدخول

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


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