Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //CONNECT TO THE DATABASE
- include_once 'includes/db_connect.php';
- $dynamicDisplay = '';
- if (isset($_GET['rc'])) {
- $rc = $_GET['rc'];
- if($rc == ""){
- $dynamicDisplay = "Please Enter a Valid RC Number";
- }else {
- $sql = "SELECT * FROM v WHERE rc='$rc' LIMIT 1";
- $query = mysqli_query($con, $sql);
- $numrows = mysqli_fetch_row($query);
- if($numrows > 0){
- while ($row = mysqli_fetch_row($query)) {
- $id = $row["id"];
- $rc = $row['rc'];
- $mn = $row['mn'];
- $en = $row['en'];
- $bn = $row['bn'];
- $color = $row['colour'];
- $company = $row['company'];
- $year = $row['year'];
- $weight = $row['weight'];
- $dynamicDisplay = '
- <table id="details_table" width="70%" align="center" cellpadding="10" cellspacing="0" border="2px solid black" >
- <tr>
- <td class="rws1">RC</td>
- <td class="rws2">'.$row["mn"].'</td>
- </tr>
- <tr>
- <td class="rws1">Model Number</td>
- <td class="rws2">'.$mn.'</td>
- </tr>
- <tr>
- <td class="rws1">Engine Number</td>
- <td class="rws2">'.$en.'</td>
- </tr>
- <tr>
- <td class="rws1">Body Number</td>
- <td class="rws2">'.$bn.'</td>
- </tr>
- <tr>
- <td class="rws1">Color</td>
- <td class="rws2">'.$color.'</td>
- </tr>
- <tr>
- <td class="rws1">Company Name</td>
- <td class="rws2">'.$company.'</td>
- </tr>
- <tr>
- <td class="rws1">Year</td>
- <td class="rws2">'.$year.'</td>
- </tr>
- <tr>
- <td class="rws1">Max-Weight (KG)</td>
- <td class="rws2">'.$weight.'</td>
- </tr>
- ';
- }
- }else {
- $dynamicDisplay = "Sorry! No data Found.";
- }
- }
- }
- ?>
- <html>
- <head>
- <title>View Details</title>
- <?php include_once "includes/css.php";?>
- <style>
- #middle{
- height: 100vh;
- }
- </style>
- </head>
- <body>
- <div id="container">
- <?php include_once "includes/nav.php" ?>
- <div id="middle">
- <h1 style="text-align: center">Enter Vehicle's RC Number:</h1>
- <form name="rc_form" action="view.php" method="get" >
- <table id="details_table" width="70%" align="center" cellpadding="10" cellspacing="0" border="2px solid black" >
- <tr>
- <td class="rws1">Registration Certificate</td>
- <td class="rws2"><input type="text" id="rc" name="rc" placeholder="RC Number"/> </td>
- </tr>
- <tr>
- <td colspan="2" align="center"><input type="submit" id="submitBtn" value="Get Information" /> </td>
- </tr>
- </table>
- </form>
- <?php echo $dynamicDisplay; ?>
- </div>
- </div>
- </body>
- </html>
- if($numrows > 0){
- while ($row = mysqli_fetch_row($query)) {
- $id = $row["id"];
- $rc = $row['rc'];
- $mn = $row['mn'];
- .....
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement