Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html>
- <body>
- <form method=post>
- <h1 style="font-size:200%;">Welcome to the Employee/Accident Database</h1></td>
- <table style="width:100%">
- <h2 style="font-size:150%;">Add Employe Data</h2></td>
- <tr>
- <td>First Name: </td>
- <td style="text-align:left"><input type="text" name="FirstName"></td>
- <td>Last Name: </td>
- <td style="text-align:left"><input type="text" name="LastName"></td>
- <td>MI: </td>
- <td style="text-align:left"><input type="text" name="MI"></td>
- </tr>
- <tr>
- <td>Address: </td>
- <td style="text-align:left"><input type="text" name="Address"></td>
- <td>Zip Code: </td>
- <td style="text-align:left"><input type="text" name="ZipCode"></td>
- <td>Country: </td>
- <td style="text-align:left">
- <select name="Country">
- <option>DE</option>
- <option>DK</option>
- <option>FR</option>
- <option>SE</option>
- <option>US</option>
- </select></td>
- </tr>
- <tr>
- <td>Date of Birth</td>
- <td style="text-align:left"><input type="text" name="DOB"></td>
- <td></td>
- <td></td>
- <td>State</td>
- <td style="text-align:left">
- <select name="State">
- <option>MA</option>
- <option>NJ</option>
- <option>NY</option>
- <option>PA</option>
- <option>VA</option>
- </select></td>
- </tr>
- <tr>
- <td>Hire Date:</td>
- <td style="text-align:left"><input type="text" name="HireDate"></td>
- <td>License Date:</td>
- <td style="text-align:left"><input type="text" name="LicenseDate"></td>
- <td>Salary:</td>
- <td style="text-align:left"><input type="text" name="Salary"></td>
- </tr>
- <tr>
- <td>Termination Date:</td>
- <td style="text-align:left"><input type="text" name="TermDate"></td>
- </tr>
- <tr>
- <tr>
- <td></td>
- </tr>
- <td></td>
- <td style="text-align:left"><input type="submit" name="CommittEmp" value="Committ"
- <?php
- $server = "localhost";
- $user = "root";
- $password = "bugweiserr";
- $database = "lab4";
- $con = new mysqli($server,$user,$password,$database);
- if ($con->connect_error){
- die("Connection failed: " . $con->connect_error);
- }
- if (isset($_POST['CommittEmp']))
- {
- server = "localhost";
- $user = "root";
- $password = "bugweiserr";
- $database = "lab4";
- $con = new mysqli($server,$user,$password,$database);
- mysqli_select_db($con,"lab4";)
- $sqlInsertEmp = "INSERT INTO EMPLOYEE (FIRSTNAME, LASTNAME, MI, HOMEADDRESS,
- ZIP, DATEOFBIRTH, HIREDATE, TERMINATIONDATE, ANNUALSALARY,
- LICENSEDATE, STATEABBREVIATION, COUNTRYABBREVIATION)
- VALUES (" . "'" . $_Post['FirstName'] . "', " . "'" . $_Post['$LastName'] . "', " . " '" . $_Post['$MI'] . "', " .
- "'" . $_Post['$Address'] . "', " . "'" . $_Post['$Zip'] . "', " . "'" . $_Post['$DOB'] . "', " .
- "'" . $_Post['$HireDate'] . "', " . "'" . $_Post['$TermDate'] . "', " . "'" . $_Post['$Salary'] . "', " .
- "'" . $_Post['$LicenseDate'] . "', " . "'" . $_Post['$State'] . "', " . "'" . $_Post['$Country'] . "')";
- if(mysqli_query($con,$sqlInsertEmp) == TRUE){
- echo nl2br ("Employee Added");
- } else {
- echo nl2br ("Error");
- }
- }
- mysqli_close($con);
- }
- ?>
- ></td>
- <td style="text-align:left">Employee Age:<input type="text" name="Age" readonly></td>
- <td style="text-align:right"><button type="button">Display Salaries</button></td>
- </tr>
- </table>
- <div>
- <table style="float: left">
- <h3 style="font-size:150%;">Add Accident Data</h3></td>
- <tr>
- <td>Date of Accident:</td>
- <td style="text-align:left"><input type="text" name="AccDate"></td>
- </tr>
- <tr>
- <td>Accident Description:</td>
- <td style="text-align:left"><input type="text" name="AccDescr"></td>
- </tr>
- <tr>
- <td>Accident Location:</td>
- <td style="text-align:left"><input type="text" name="AccLoc"></td>
- </tr>
- <tr>
- <td>Employee ID:</td>
- <td style="text-align:left">
- <select name="EmployeeID">
- </select></td>
- </tr>
- <tr>
- <td></td>
- <td style="text-align:left"><button type="button">Committ</button></td>
- </tr>
- <tr>
- <td></td>
- <td style="text-align:left"><button type="button">Display Records</button></td>
- </tr>
- <tr>
- <td></td>
- <td style="text-align:left"><button type="button">Display Truck Data</button></td>
- </tr>
- </table>
- <textarea rows="10" cols="60" style="float: right" readonly>
- </textarea>
- </div>
- </form>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement