01.<? session_start();
02. include("nusoap/nusoap.php");
03. include ("connect_db.php");
04. $txtUsername=$_POST['txtUsername'];
05. $txtPassword=$_POST['txtPassword'];
06. $strSQL = "SELECT * FROM OFFICER WHERE USERNAME = '".trim($_POST['txtUsername'])."' and PASSWORD = '".trim($_POST['txtPassword'])."'";
07. $objParse = oci_parse ($objConnect, $strSQL);
08. oci_execute ($objParse,OCI_DEFAULT);
09. $objResult = oci_fetch_array($objParse,OCI_BOTH);
10.
11. $OFFICERID=$objResult["OFFICERID"];
12. if ($objResult)
13. { $_SESSION["OFFICERID"] = $objResult["OFFICERID"];
14. $_SESSION["OFFICERNAME"] = $objResult["OFFICERNAME"];
15. $_SESSION["OFFICERSURNAME"] = $objResult["OFFICERSURNAME"];
16. $_SESSION["type_id"] = $objResult["type_id"];
17. if ($type_id== '1')
18. {
19. echo "<meta http-equiv='refresh' content='0;URL=index1.php'>";
20.
21. session_write_close();
22. }
23. else if ($type_id== "2")
24. {
25. echo "<meta http-equiv='refresh' content='0;URL=index_officer.php'>";
26.
27. session_write_close();
28. }
29. else if ($type_id== "3")
30. {
31. echo "<meta http-equiv='refresh' content='0;URL=index_officer1.php'>";
32.
33. session_write_close();
34. }
35.
36.
37. }else{
38.
39.
40.
41.
42. }
43.
45. $result= $client->call('auth', array('username' => $txtUsername,'password' => $txtPassword));
46.
47. if ($result<>"?????????????????????????????????")
48. {
49. $b = explode(",",$result);
50. $_SESSION["student_code"]= $b[0];
51. $_SESSION["cars_id"]=$b[1];
52. $_SESSION["prefix"]=$b[2];
53. $_SESSION["std_name"]=$b[3];
54. $_SESSION["std_surname"]=$b[4];
55. $_SESSION["program"]=$b[5];
56. $_SESSION["faculty"]=$b[6];
57. session_write_close();
58. echo "<meta http-equiv='refresh' content='0;URL=index_std.php?student_code=".$_SESSION["student_code"]."' >";
59.
60. }else {
61. echo"<script language='JavaScript'>";
62. echo"alert('ª×èÍáÅÐÃËÑʼèÒ¹äÁè¶Ù¡µéͧ');";
63. echo"</script >";
64. echo "<meta http-equiv='refresh' content='0;URL=login_admin.php'>";
65. }
66.
67.
68.?>
Quote:
