Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //maintainCourse.php
- <?php
- ?>
- <div class="container">
- <div class="col-md-2"></div>
- <div class="col-md-8">
- <form method="post" id="insertCourse" action="">
- <div id = 'result' >
- <table id='newList'>
- <tr id="head"><td></td><td></td><td></td><td></td></tr>
- </table>
- </div>
- <div id="input-form" style="display: none">
- <label>รหัสวิชา</label>
- <input class='form-control' name='courseID' type='text' style='width: 200px;'id='cid'/><br>
- <label>ชื่อวิชา</label>
- <input class='form-control' name='courseName' type='text' style='width: 50em;' id='cname'/><br>
- <label>คำอธิบายรายวิชา</label>
- <textarea rows='5' cols='100' name="courseDesc" id="cdescript"></textarea>
- <label>หน่วยกิต</label><br>
- <input name="courseCredit" type='number' min='0' id="cunit"><br><br>
- <a type="submit" id="save" class='btn btn-success' href="#" onclick="addCourse()">บันทึก</a><br><br>
- </div>
- <a href='#' id='newCourse' class="btn btn-primary">Value</a><br>
- </form>
- </div>
- <div class="col-md-2"></div>
- <script type="text/javascript">
- document.getElementById('newCourse').addEventListener('click',function () {
- var newDiv = document.getElementById('input-form');
- newDiv.style.display = 'block';
- /* newDiv.innerHTML =
- "<label>รหัสวิชา</label>" +
- "<input class='form-control' name='courseID' type='text' style='width: 200px;'/><br>" +
- "<label>ชื่อวิชา</label><input class='form-control' name='courseID' type='text' style='width: 50em;' id='courseID'/><br>"+
- "<label>คำอธิบายรายวิชา</label><textarea rows='5' cols='100'></textarea>"+
- "<label>หน่วยกิต</label><br><input type='number' min='0'><br><br>"+
- "<a href='#' class='btn btn-success' name='save' onclick='addCourse(this)'>บันทึก</a><br><br>";
- document.getElementById('insertCourse').insertBefore(newDiv,document.getElementById('newCourse'));*/
- });
- function addCourse(){
- var courseID = document.getElementById('cid');
- var courseName = document.getElementById('cname');
- var courseDesc = document.getElementById('cdescript');
- var courseCredit = document.getElementById('cunit');
- var showText = document.createElement('tr');
- showText.innerHTML= '<td>'+courseID.value+'</td><td>'+ courseName.value + '</td><td>'+ courseDesc.value +
- '</td><td>'+courseCredit.value+'<td>';
- document.getElementById('newList').appendChild(showText);
- var data= "?courseID="+courseID + "&courseName=" + courseName +
- "&courseDesc=" + courseDesc + "&courseCredit="+ courseCredit;
- var xhr;
- if(window.XMLHttpRequest) {
- xhr= new XMLHttpRequest();
- } else {
- xhr = new ActiveXObject("Microsoft.XMLHTTP");
- }
- xhr.open("GET","DBConnect.php"+data,true);
- xhr.send(null);
- hide("input-form");
- }
- function hide(divId){
- var divId = divId;
- document.getElementById(divId).style.display = 'none';
- }
- </script>
- <link rel="stylesheet" href="bootstrap.min.css">
- <!--<link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css">-->
- <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.2/jquery.min.js"></script>
- <script src="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
- //DBConnect.php
- <?php
- $host = "localhost";
- $username = "root";
- $password = "root";
- $conn = mysqli_connect($host,$username,$password);
- if(!$conn){
- die("Couldn't connect database: ".mysqli_connect_error());
- }
- $selectDB = mysqli_select_db($conn,"msmis") or die("Failed to select database");
- $courseID = $_GET['courseID'];
- $courseName = $_GET['courseName'];
- $courseDesc = $_GET['courseDesc'];
- $courseCredit = $_GET['courseCredit'];
- $insertQuery = "INSERT INTO courses (CourseID,CourseName,CourseDesc,CourseCredit)
- VALUES ('$courseID','$courseName', '$courseDesc', $courseCredit)";
- $insert = mysqli_query($conn, $insertQuery) or die("Couldn't insert into db" . mysqli_error($conn));
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement