-
Notifications
You must be signed in to change notification settings - Fork 0
/
update_Member_mem2.php
106 lines (101 loc) · 6.31 KB
/
update_Member_mem2.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
<?php
session_start();
$title_name = "ntueIRC管理系統・修改社員" ;
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<link rel="stylesheet" href="css/e_w3.css">
<link rel="stylesheet" href="css/movepic.css">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
<link href="open-iconic-master/font/css/open-iconic-bootstrap.css" rel="stylesheet">
<title><?php print $title_name?></title>
</head>
<body>
<div class="takeup"><a href="#"><span class="oi oi-arrow-thick-top"> </span></a></div>
<nav class="navbar fixed-top navbar-expand-lg navbar-dark" style="background-color:#355772;"><a class="navbar-brand" href="naviTest.php"> <img class="d-inline-block align-top" src="images/phy_icon.png" width="30" height="30" alt=""> ntueIRC社團系統</a>
<button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarSupportedContent" aria-controls="navbarSupportedContent" aria-expanded="false" aria-label="Toggle navigation"><span class="navbar-toggler-icon"></span></button>
<div class="collapse navbar-collapse" id="navbarSupportedContent">
<ul class="navbar-nav mr-auto">
<!--導覽列生成位置-->
<?php
if(isset($_SESSION['Carde'])){
$carde = $_SESSION['Carde'];
if($carde == "社長"){
$temp_Nav_file = file('nav_leader.txt');
}else if($carde == "副社長"){
$temp_Nav_file = file('nav_leader2.txt');
}else if($carde == "資訊管理"){
$temp_Nav_file = file('nav_mis.txt');
}else if($carde == "總務"){
$temp_Nav_file = file('nav_general.txt');
}else if($carde == "文書"){
$temp_Nav_file = file('nav_secretary.txt');
}else if($carde == "教師"){
$temp_Nav_file = file('nav_teacher.txt');
}else{
$temp_Nav_file = file('nav_mem.txt');
}
}else{
$temp_Nav_file = file('nav_outside.txt');
}
foreach($temp_Nav_file as $line){
$line = trim($line);
$info = explode('|',$line);
print '<li class="nanav-item';
if($info[0]==substr($_SERVER['PHP_SELF'],13)){ //辨別目前網頁 如果相同則啟動導覽標記
print ' active';
}
print '"><a class="nav-link" href="'.$info[0].'">'.$info[1].'</a><span class="sr-only">(current)</span></li>';
}
?>
</ul>
</div>
<?php
if(isset($_SESSION['username'])){
?><span class= "important">您好， <?php print $_SESSION['Carde']." ".$_SESSION['username']?></span>
<span class="important"> <a href="logout.php"> 登出</a></span>
<?php
}else{?>
<span class= "important"><a href="login.php">登入</a></span>
<?php } ?>
</nav>
<div id="container">
<div id="sidebar">
<div id="content">
<div class="title">修改社員</div>
<div class="learn">
<?php
if($_SERVER['REQUEST_METHOD'] != 'POST'){
print "請先查詢您要的社員！";
print "<br>即將為您轉至首頁！";?>
<script type="text/javascript"> setTimeout("window.location.href='naviTest.php'",3000); </script>
<?php
}else{
try {
$conn = new PDO("sqlsrv:server = tcp:ntueirc.database.windows.net,1433; Database = xxxxx", "xxxx", "xxxx");
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$q = $conn ->exec("update Member set M_Name = '".$_POST['M_Name']."',FBName = '".$_POST['FBname']."',LineID = '".$_POST['LineID']."',Email = '".$_POST['Email']."',Phone = '".$_POST['Phone']."',Degree = '".$_POST['Degree']."',Sex = '".$_POST['Sex']."',B_date = '".$_POST['B_date']."',passwords = '".$_POST['passwords']."',Grade = '".$_POST['Grade']."',Enter_date = '".$_POST['Enter_date']."',Being = '".$_POST['Being']."',Dno = '".$_POST['Dno']."' where SId = '".$_POST['SId']."';");
//$q ->execute(array($_POST['SId'],$_POST['M_Name'],$_POST['FBname'],$_POST['LineID'],$_POST['Email'],$_POST['Phone'],$_POST['Degree'],$_POST['Sex'],$_POST['B_date'],$_POST['passwords'],$_POST['Grade'],$_POST['Enter_date'],$_POST['Being'],$_POST['Dno']));
//print "update Member set M_Name = '".$_POST['M_Name']."',FBName = '".$_POST['FBname']."',LineID = '".$_POST['LineID']."',Email = '".$_POST['Email']."',Phone = '".$_POST['Phone']."',Degree = '".$_POST['Degree']."',Sex = '".$_POST['Sex']."',B_date = '".$_POST['B_date']."',passwords = '".$_POST['passwords']."',Gradw = '".$_POST['Grade']."',Enter_date = '".$_POST['Enter_date']."',Being = '".$_POST['Being']."',Dno = '".$_POST['Dno']." where SId = '".$_POST['SId']."';";
print "已完成修改 ".$_POST['SId']." ".$_POST['M_Name']." 的資料";
print "<br>即將為您轉至首頁！";?>
<script type="text/javascript"> setTimeout("window.location.href='naviTest.php'",3000); </script>
<?php }
catch (PDOException $e) {
print("Error connecting to SQL Server.");
die(print_r($e));
}
}?>
</div>
</div>
</div>
<div id="footer">ntueIRC社團系統</div>
<script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js" integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q" crossorigin="anonymous"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl" crossorigin="anonymous"></script>
</div>
</body>
</html>