19
Expand|Select|Wrap|Line Numbers
- <!DOCTYPE html>
- <html>
- <head>
- <link href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/themes/base/jquery-ui.css" rel="stylesheet" type="text/css"/>
- <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js"></script>
- <script src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/jquery-ui.min.js"></script>
- <script>
- $(document).ready(function() {
- $(".datepicker").datepicker()
- });
- </script>
- </head>
- <body>
- <?php
- error_reporting(E_PARSE);
- $status = $_POST['status'];
- $driver_name= $_POST['driver_name'];
- $from=date('y-m-d',strtotime($_POST['date_from']));
- $to=date('y-m-d',strtotime($_POST['date_to']));
- $conn = mysqli_connect('localhost', 'root', '', 'punbus') or
- die("Database not connected" . mysqli_error());
- if(isset($_POST['sub'])) {
- foreach($status as $k=>$s){
- $ins = "insert into driver_status(driver_name,status,date_from,date_to) VALUES
- ('".$driver_name[$k]."','$s','$from','$to')";
- if (mysqli_query($conn, $ins)) {
- echo "added";
- } else {
- echo "NOT" . mysqli_error($conn);
- }
- }
- }
- $sel = 'select Driver_name from driver_master';
- $query = mysqli_query($conn, $sel);
- echo "<form action='driver_status.php' method='post'>";
- echo "<table cellpadding=5>";
- echo "<tr>";
- echo "<th>Driver Name</th>";
- echo "<th>Status</th>";
- echo "<th>From</th>";
- echo "<th>To</th>";
- echo "</tr>";
- while($row=mysqli_fetch_assoc($query)){
- echo "<tr><td>".$row['Driver_name']
- ."<input type=\"hidden\" name=\"driver_name[]\" value=\"".$row['Driver_name']."\"/></td>";
- $sel1='select d_status from status';
- $query1=mysqli_query($conn,$sel1);
- echo "<td><select name=\"status[]\">";
- while($row1=mysqli_fetch_assoc($query1)){
- echo "<option value=\"".$row1['d_status']."\">".$row1['d_status']."</option>";
- }
- echo "</select></td>";
- echo "<td>".'<input type="text" name="date_from" class="datepicker">'."</td>";
- echo "<td>".'<input type="text" name="date_to" class="datepicker">'."</td>";
- echo "</tr>";
- }
- echo "</table>";
- echo '<input type="submit" name="sub" value="Update"/>';
- echo "</form>";
- ?>
- </body>
- </html>
