Advertisement
Guest User

Untitled

a guest
Jan 19th, 2017
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.42 KB | None | 0 0
  1. <?php
  2. //CONNECT TO THE DATABASE
  3. include_once 'includes/db_connect.php';
  4. $dynamicDisplay = '';
  5. if (isset($_GET['rc'])) {
  6. $rc = $_GET['rc'];
  7. if($rc == ""){
  8. $dynamicDisplay = "Please Enter a Valid RC Number";
  9. }else {
  10. $sql = "SELECT * FROM v WHERE rc='$rc' LIMIT 1";
  11. $query = mysqli_query($con, $sql);
  12. $numrows = mysqli_fetch_row($query);
  13. if($numrows > 0){
  14. while ($row = mysqli_fetch_row($query)) {
  15. $id = $row["id"];
  16. $rc = $row['rc'];
  17. $mn = $row['mn'];
  18. $en = $row['en'];
  19. $bn = $row['bn'];
  20. $color = $row['colour'];
  21. $company = $row['company'];
  22. $year = $row['year'];
  23. $weight = $row['weight'];
  24. $dynamicDisplay = '
  25. <table id="details_table" width="70%" align="center" cellpadding="10" cellspacing="0" border="2px solid black" >
  26. <tr>
  27. <td class="rws1">RC</td>
  28. <td class="rws2">'.$row["mn"].'</td>
  29. </tr>
  30. <tr>
  31. <td class="rws1">Model Number</td>
  32. <td class="rws2">'.$mn.'</td>
  33. </tr>
  34. <tr>
  35. <td class="rws1">Engine Number</td>
  36. <td class="rws2">'.$en.'</td>
  37. </tr>
  38. <tr>
  39. <td class="rws1">Body Number</td>
  40. <td class="rws2">'.$bn.'</td>
  41. </tr>
  42. <tr>
  43. <td class="rws1">Color</td>
  44. <td class="rws2">'.$color.'</td>
  45. </tr>
  46. <tr>
  47. <td class="rws1">Company Name</td>
  48. <td class="rws2">'.$company.'</td>
  49. </tr>
  50. <tr>
  51. <td class="rws1">Year</td>
  52. <td class="rws2">'.$year.'</td>
  53. </tr>
  54. <tr>
  55. <td class="rws1">Max-Weight (KG)</td>
  56. <td class="rws2">'.$weight.'</td>
  57. </tr>
  58. ';
  59. }
  60.  
  61. }else {
  62. $dynamicDisplay = "Sorry! No data Found.";
  63. }
  64. }
  65. }
  66. ?>
  67. <html>
  68. <head>
  69. <title>View Details</title>
  70. <?php include_once "includes/css.php";?>
  71. <style>
  72. #middle{
  73. height: 100vh;
  74. }
  75. </style>
  76. </head>
  77. <body>
  78. <div id="container">
  79. <?php include_once "includes/nav.php" ?>
  80. <div id="middle">
  81. <h1 style="text-align: center">Enter Vehicle's RC Number:</h1>
  82. <form name="rc_form" action="view.php" method="get" >
  83. <table id="details_table" width="70%" align="center" cellpadding="10" cellspacing="0" border="2px solid black" >
  84. <tr>
  85. <td class="rws1">Registration Certificate</td>
  86. <td class="rws2"><input type="text" id="rc" name="rc" placeholder="RC Number"/> </td>
  87. </tr>
  88. <tr>
  89. <td colspan="2" align="center"><input type="submit" id="submitBtn" value="Get Information" /> </td>
  90. </tr>
  91. </table>
  92. </form>
  93. <?php echo $dynamicDisplay; ?>
  94. </div>
  95. </div>
  96. </body>
  97. </html>
  98.  
  99. if($numrows > 0){
  100. while ($row = mysqli_fetch_row($query)) {
  101. $id = $row["id"];
  102. $rc = $row['rc'];
  103. $mn = $row['mn'];
  104. .....
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement