اذهب إلى المحتوى
  • 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>

 

رابط هذا التعليق
شارك على الشبكات الإجتماعية

Recommended Posts

انضم إلى النقاش

يمكنك أن تنشر الآن وتسجل لاحقًا. إذا كان لديك حساب، فسجل الدخول الآن لتنشر باسم حسابك.

زائر
أجب على هذا السؤال...

×   لقد أضفت محتوى بخط أو تنسيق مختلف.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   جرى استعادة المحتوى السابق..   امسح المحرر

×   You cannot paste images directly. Upload or insert images from URL.

  • إعلانات

  • تابعنا على



×
×
  • أضف...