Friday, May 16, 2014

member

-- phpMyAdmin SQL Dump
-- version 2.10.3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 16, 2014 at 05:28 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `huawei`
--

-- --------------------------------------------------------

--
-- Table structure for table `member`
--

CREATE TABLE `member` (
  `UserID` int(3) unsigned zerofill NOT NULL auto_increment,
  `Username` varchar(20) NOT NULL,
  `Password` varchar(20) NOT NULL,
  `Name` varchar(100) NOT NULL,
  `Type` varchar(10) NOT NULL,
  `LoginCount` int(2) NOT NULL default '0',
  `FlagLock` enum('Yes','No') NOT NULL default 'No',
  `BanExpire` datetime NOT NULL,
  PRIMARY KEY  (`UserID`),
  UNIQUE KEY `Username` (`Username`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `member`
--

INSERT INTO `member` VALUES (001, 'king', 'king', 'Channarong Krongyat', 'Admin', 1, 'No', '2014-04-16 17:30:52');
INSERT INTO `member` VALUES (002, 'testuser', 'testuser', 'name surname', 'User', 0, 'No', '0000-00-00 00:00:00');

FormBooking.php


file:///C:/AppServ/www/huawei/fullcalendar/FormBooking.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<link href="fullcalendar/css/bootstrap.css" rel="stylesheet">

    <link href="fullcalendar/css/datepicker.css" rel="stylesheet">
   
    <link href="fullcalendar/css/daterangepicker-bs2.css" rel="stylesheet">
   
<link rel="stylesheet" href="fullcalendar/css/bootstrap-timepicker.min.css">


</head>

<body>
<div class="container">
<div class="well well-small">
  บันทึกการจองขอใช้รถ</div>


<ul class="nav nav-tabs">
  <li class="active">
    <a href="#">เพิ่มการจอง</a>
  </li>
  <li><a href="#">แก้ไขการจอง</a></li>
</ul>
<form class="form-horizontal" method="post" action="Add_form.php">


 

    <div class="control-group">
    <label class="control-label" for="inputName">Name :<span class="text-error"> <strong>*</strong></span></label>
    <div class="controls">
      <input class="input-block-level" type="text" name="inputName" id="inputName" placeholder="Name" required>
    </div>
  </div>
 
   <div class="control-group">
    <label class="control-label" for="inputName2">And :</label>
    <div class="controls">
      <textarea rows="3" class="input-block-level" name="inputName2" id="inputName2" placeholder="Other Ones
" ></textarea>  
    </div>
  </div>

 <div class="control-group">
    <label class="control-label" for="inputRequest">Request car for :<span class="text-error"> <strong> *</strong></span></label>
    <div class="controls">
      <input class="input-block-level" type="text" name="inputRequest" id="inputRequest" placeholder="Detail" required>
    </div>
  </div>


<div class="control-group">
    <label class="control-label" for="reservationtime">ในวันที่ :<span class="text-error"> <strong> *</strong></span></label>

<div class="controls controls-row">
     
            <div class="input-append date" id="reservation">
      <input type="text" name="reservation" id="reservationtime" class="col-xs-4"  />
      <span class="add-on"><i class="icon-calendar"></i></span>
    </div>
     </div>
 </div>





 
  <div class="control-group">
  <label class="control-label" for="inputPlace">สถานที่ที่จะไป :<span class="text-error"> <strong> *</strong></span></label>
    <div class="controls">
       <textarea rows="3" class="input-block-level" name="inputPlace" id="inputPlace" required ></textarea>
</div>
  </div>
 
  <div class="control-group">
  <label class="control-label" for="Warning"></label>
  <div class="controls">
<p class="text-error">** สิ่งที่ต้องระบุ : สถานที่ / อำเภอหรือเขต / จังหวัด / ให้รถไปรับที่</p>
</div>
</div>

<div class="control-group">
  <label class="control-label" for="Warning">ใช้รถประเภท : <span class="text-error"> <strong> *</strong></span></label>
  <div class="controls">

<select class="span2" name="inputType">
  <option>รถตู้ 12 ที่นั่ง</option>
  <option>2</option>
  <option>3</option>
  <option>4</option>
  <option>5</option>
  </select>

</div>
</div>

<div class="control-group">
    <label class="control-label" for="inputEmail">Email Address : <span class="text-error"> <strong> *</strong></span> </label>
    <div class="controls">
      <input class="input-block-level" type="email" name="inputEmail" id="inputEmail" required placeholder="Test@Example.com">
    </div>
  </div>
 
 
<div class="control-group">
    <label class="control-label" for="inputPhonenumber">เบอร์โทรศัพท์ : <span class="text-error"> <strong> *</strong></span></label>
    <div class="controls">
      <input class="input-block-level" type="text" name="inputPhonenumber" id="inputPhonenumber" placeholder="xx-xxxx-xxxx" required >
    </div>
  </div>


  <div class="form-actions">
  <button type="submit" class="btn btn-primary" >Save changes</button>
  <button type="button" class="btn" onclick="ClearForm();">Reset</button>
</div>

<a href="#" data-toggle="tooltip" title="first tooltip" id=tooltip >hover over me</a>
   
</form>
</div>

<script src="fullcalendar/js/jquery.js"></script>
<script src="fullcalendar/js/bootstrap-datepicker.js"></script>
<script src="fullcalendar/js/moment.js"></script>
<script src="fullcalendar/js/daterangepicker.js"></script>
<script src="fullcalendar/js/bootstrap-timepicker.js"></script>
<script src="fullcalendar/js/bootstrap.js"></script>


 <script type="text/javascript">
// When the document is ready
  $(document).ready(function () {
$('#inputDay').datepicker({
format: "yyyy-mm-dd",
todayHighlight: true,

});
});
  </script>
   
 <script type="text/javascript">
            $('#timepicker1').timepicker();
        </script>
       
        <script type="text/javascript">
            $('#timepicker2').timepicker();
        </script>
       
        <script type="text/javascript">

$(document).ready(function() {
  $('#reservationtime').daterangepicker({
timePicker: true,
timePickerIncrement: 30,
format: 'YYYY-MM-DD hh:mm A'
});
});
</script>



<script type="text/javascript">
    function ClearForm(){
//window.location.reload(); //refesh
document.getElementById('inputName').value=""; //ใช้ id
document.getElementById('inputName2').value="";
document.getElementById('inputRequest').value="";
document.getElementById('reservationtime').value="";
document.getElementById('inputPlace').value="";
document.getElementById('inputEmail').value="";
document.getElementById('inputPhonenumber').value="";



}
 </script>
         
          <script type="text/javascript">
         $('#tooltip').tooltip()
           </script>
         
</body>
</html>