Permalink
Cannot retrieve contributors at this time
Name already in use
A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?
ABC_Air_Service/update.php
Go to fileThis commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
93 lines (81 sloc)
3.2 KB
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| //Connecting the database to the webpage | |
| include 'connect1.php'; | |
| $id=$_GET['updateid']; | |
| $sql="Select * from `crud` where id=$id"; | |
| $result=mysqli_query($con,$sql); | |
| $row=mysqli_fetch_assoc($result); | |
| $name=$row['name']; | |
| $engg=$row['engg']; | |
| //$selected=$engg; | |
| $fhr=$row['fhr']; | |
| $fno=$row['fno']; | |
| $date=$row['date']; | |
| //echo "$selected"; | |
| if(isset($_POST['submit'])){ | |
| $date = date('Y-m-d', strtotime($_POST['date'])); | |
| $name=$_POST['name']; | |
| $engg=$_POST['engg']; | |
| $fhr=$_POST['fhr']; | |
| $fno=$_POST['fno']; | |
| $date=$_POST['date']; | |
| $sql="update `crud` set id=$id,name='$name',engg='$engg',fhr=$fhr,fno=$fno,date='$date' where id=$id"; | |
| $result=mysqli_query($con,$sql); | |
| if($result){ | |
| //echo "Data updated successfully"; | |
| header('location:display.php'); | |
| }else{ | |
| die(mysqli_error($con)); | |
| } | |
| } | |
| ?> | |
| <!doctype html> | |
| <html lang="en"> | |
| <head> | |
| <meta charset="utf-8"> | |
| <meta name="viewport" content="width=device-width, initial-scale=1"> | |
| <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet"> | |
| <title>ABC Air Services</title> | |
| </head> | |
| <body background="https://images.unsplash.com/photo-1436491865332-7a61a109cc05?ixlib=rb-1.2.1&ixid=MnwxMjA3fDB8MHxwaG90by1wYWdlfHx8fGVufDB8fHx8&auto=format&fit=crop&w=2074&q=80" background-size="no-repeat center center fixed;"> | |
| <h2 class="text-center mt-5" style="color:white;"><b>Update your details</b></h2> | |
| <div class="container my-5"> | |
| <form method="post"> | |
| <div class="mb-3"> | |
| <label style="color:white;"><b>Maintenance task</b></label> | |
| <input type="text" class="form-control" placeholder="Enter Name of Maintenance" name="name" autocomplete="off" | |
| value=<?php echo $name;?>> | |
| </div> | |
| <div class="mb-3"> | |
| <label style="color:white;"><b>Engineer Assigned</b></label> | |
| <select id="engg" name="engg" placeholder="Select Engineer" class="form-control" value=<?php echo $engg;?>> | |
| <option value="AME">Aircraft Maintenance Engineer(AME)</option> | |
| <option value="AMT">Aircraft Maintenance Technician (AMT)</option> | |
| <option value="AMM">Aircraft Maintenance Mechanic (AMM)</option> | |
| </select> | |
| <!-- <input type="text" class="form-control" placeholder="Enter Name of Engineer" name="engg" autocomplete="off" | |
| value=>--> | |
| </div> | |
| <div class="mb-3"> | |
| <label style="color:black;"><b>Flight Hours</b></label> | |
| <input type="text" class="form-control" placeholder="Enter number of Flight Hours" name="fhr" autocomplete="off" | |
| value=<?php echo $fhr;?>> | |
| </div> | |
| <div class="mb-3"> | |
| <label style="color:black;"><b>Flight Number</b></label> | |
| <input type="text" class="form-control" placeholder="Enter Flight Number" name="fno" autocomplete="off" | |
| value=<?php echo $fno;?>> | |
| </div> | |
| <div class="mb-3"> | |
| <label style="color:black;"><b>Schedule Date</b></label> | |
| <input type="date" class="form-control" placeholder="Enter scheduled date for maintenance" name="date" autocomplete="off" | |
| value=<?php echo $date;?>> | |
| </div> | |
| <center><button type="submit" class="btn btn-dark" name="submit">Update</button> | |
| <button class="btn btn-dark my-3"><a href="display.php" class="text-light" style="text-decoration: none;">Airframe Dashboard</a> | |
| </button> | |
| </center> | |
| </form> | |
| </div> | |
| </body> | |
| </html> |