Advertisement
Guest User

Untitled

a guest
May 8th, 2016
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
4CS 4.70 KB | None | 0 0
  1. //maintainCourse.php
  2. <?php
  3.  
  4.  
  5. ?>
  6. <div class="container">
  7.     <div class="col-md-2"></div>
  8.     <div class="col-md-8">
  9.         <form method="post" id="insertCourse" action="">
  10.             <div id = 'result' >
  11.                 <table id='newList'>
  12.                     <tr id="head"><td></td><td></td><td></td><td></td></tr>
  13.                 </table>
  14.             </div>
  15.             <div id="input-form" style="display: none">
  16.                 <label>รหัสวิชา</label>
  17.                 <input class='form-control' name='courseID' type='text' style='width: 200px;'id='cid'/><br>
  18.                 <label>ชื่อวิชา</label>
  19.                 <input class='form-control' name='courseName' type='text' style='width: 50em;' id='cname'/><br>
  20.                 <label>คำอธิบายรายวิชา</label>
  21.                 <textarea rows='5' cols='100' name="courseDesc" id="cdescript"></textarea>
  22.                 <label>หน่วยกิต</label><br>
  23.                 <input name="courseCredit" type='number' min='0' id="cunit"><br><br>
  24.                 <a type="submit" id="save" class='btn btn-success' href="#"  onclick="addCourse()">บันทึก</a><br><br>
  25.             </div>
  26.             <a href='#' id='newCourse' class="btn btn-primary">Value</a><br>
  27.  
  28.         </form>
  29.     </div>
  30.     <div class="col-md-2"></div>
  31.  
  32.  
  33. <script type="text/javascript">
  34.  
  35.     document.getElementById('newCourse').addEventListener('click',function () {
  36.         var newDiv = document.getElementById('input-form');
  37.         newDiv.style.display = 'block';
  38.        /* newDiv.innerHTML =
  39.             "<label>รหัสวิชา</label>" +
  40.             "<input class='form-control' name='courseID' type='text' style='width: 200px;'/><br>" +
  41.             "<label>ชื่อวิชา</label><input class='form-control' name='courseID' type='text' style='width: 50em;' id='courseID'/><br>"+
  42.             "<label>คำอธิบายรายวิชา</label><textarea rows='5' cols='100'></textarea>"+
  43.             "<label>หน่วยกิต</label><br><input type='number' min='0'><br><br>"+
  44.             "<a href='#' class='btn btn-success' name='save' onclick='addCourse(this)'>บันทึก</a><br><br>";
  45.         document.getElementById('insertCourse').insertBefore(newDiv,document.getElementById('newCourse'));*/
  46.     });
  47.  
  48.         function addCourse(){
  49.             var courseID = document.getElementById('cid');
  50.             var courseName = document.getElementById('cname');
  51.             var courseDesc = document.getElementById('cdescript');
  52.             var courseCredit = document.getElementById('cunit');
  53.             var showText = document.createElement('tr');
  54.             showText.innerHTML=  '<td>'+courseID.value+'</td><td>'+ courseName.value + '</td><td>'+ courseDesc.value +
  55.                 '</td><td>'+courseCredit.value+'<td>';
  56.             document.getElementById('newList').appendChild(showText);
  57.             var data= "?courseID="+courseID + "&courseName=" + courseName +
  58.                 "&courseDesc=" + courseDesc + "&courseCredit="+ courseCredit;
  59.  
  60.             var xhr;
  61.             if(window.XMLHttpRequest) {
  62.                 xhr= new XMLHttpRequest();
  63.             } else {
  64.                 xhr = new ActiveXObject("Microsoft.XMLHTTP");
  65.             }
  66.  
  67.             xhr.open("GET","DBConnect.php"+data,true);
  68.             xhr.send(null);
  69.             hide("input-form");
  70.         }
  71.  
  72.         function hide(divId){
  73.             var divId = divId;
  74.             document.getElementById(divId).style.display = 'none';
  75.         }
  76.  
  77.  
  78.  
  79. </script>
  80. <link rel="stylesheet" href="bootstrap.min.css">
  81. <!--<link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css">-->
  82. <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.2/jquery.min.js"></script>
  83. <script src="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
  84.    
  85.    
  86.  
  87.  
  88.  
  89.  
  90.  
  91.  
  92.  
  93.  
  94. //DBConnect.php
  95. <?php
  96.     $host = "localhost";
  97.     $username = "root";
  98.     $password = "root";
  99.  
  100.     $conn = mysqli_connect($host,$username,$password);
  101.     if(!$conn){
  102.         die("Couldn't connect database: ".mysqli_connect_error());
  103.     }
  104.  
  105. $selectDB = mysqli_select_db($conn,"msmis") or die("Failed to select database");
  106.  
  107.  
  108.     $courseID = $_GET['courseID'];
  109.     $courseName = $_GET['courseName'];
  110.     $courseDesc = $_GET['courseDesc'];
  111.     $courseCredit = $_GET['courseCredit'];
  112.  
  113.  
  114.  
  115.     $insertQuery = "INSERT INTO courses (CourseID,CourseName,CourseDesc,CourseCredit)
  116.                    VALUES  ('$courseID','$courseName', '$courseDesc', $courseCredit)";
  117.     $insert = mysqli_query($conn, $insertQuery) or die("Couldn't insert into db" . mysqli_error($conn));
  118.  
  119. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement