API tools faq
paste
Advertisement
Guest User

slesh

a guest
Feb 24th, 2019
160
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.47 KB | None | 0 0
raw download clone embed print report
  1. details.php
  2. <!DOCTYPE html>
  3. <html lang="en">
  4. <head>
  5. <title>Your Details</title>
  6. <meta charset="utf-8">
  7. <link rel="stylesheet" href="css/common.css" type="text/css">
  8. <script src="script/myscript.js"></script>
  9. </head>
  10. <body onload="pload()">
  11. <img src="img/logo.png" alt="logo">
  12. <p id="date1">DATE</p>
  13. <p id="time1">TIME</p>
  14. <h3>Navigation</h3>
  15. <nav>
  16. <ul>
  17. <li><a href="home.html">Home</a></li>
  18. <li><a href="login.html">Login</a></li>
  19. <li><a href="addedit.php">New User</a></li>
  20. <li><a href="aboutus.html">About Us</a></li>
  21. <li><a href="contactus.html">Contact Us</a></li>
  22. </ul>
  23. </nav>
  24. <h1>Welcome to Shailesh Insurance</h1>
  25. <h2>Place to order </h2>
  26.  
  27. <?php
  28. //declare all variables for db connection
  29. $dbserver="localhost:3307";
  30. $dbuser="root";
  31. $dbpassword="";
  32. $dbname="sbdb2019";
  33. //create connection
  34. $conn=new mysqli($dbserver,$dbuser,$dbpassword,$dbname);
  35. //check connection error
  36. if($conn->connect_error==true){
  37. die("connection failed error description $conn->Connect_error");
  38. }else{
  39. echo "<p class='success'>Connection Success</p>";
  40. }
  41. //read login from values
  42. $id=$_POST['userid'] ;
  43. $password=$_POST['password'] ;
  44. //create sql statement
  45. $sql="SELECT * FROM CUSTOMER WHERE ID='".$id."' and PASSWORD='".$password."'";
  46. //execute sql and assign to result
  47. $result = $conn->query($sql);
  48. if($result->num_rows>0){
  49. //display welcome
  50. echo "<h1>Welcome $id your details are below</h1>";
  51. echo "<h2>Please enter new details except id if you need changes</h2>";
  52. echo "<form method = 'post' action = 'update.php'>";
  53. //create table to display information
  54. echo "<table>";
  55. while($row=$result->fetch_assoc()){
  56. echo "<tr><td>ID:</td><td><input type='number' id='box' name='id' readonly value=".$row['ID']."></td></tr>";
  57. echo "<tr><td>Name:</td><td><input type='text' id='box' name='name' value=".$row['NAME']."></td></tr>";
  58. echo "<tr><td>City:</td><td><input type='text' id='box' name='city' value=".$row['CITY']."></td></tr>";
  59. echo "<tr><td>DOB:</td><td><input type='date' id='box' name='dob' value=".$row['DOB']."></td></tr>";
  60. echo "<tr><td>Phone:</td><td><input type='phone' id='box' name='phone' value=".$row['PHONE']."></td></tr>";
  61. echo "<tr><td>Password:</td><td><input type='text' id='box' name='password' value=".$row['PASSWORD']."></td></tr>";
  62. echo "<tr><td colspan=1><input type=submit value=UPDATE class=btn></td><td colspan=2><input type=submit value=DELETE
  63. class=btn formaction='delete.php' onclick=\"return confirm('Are you sure you want to delete this item?');\"></td></tr>";
  64. echo"<tr><td colspan=2><input type=submit value='GO SHOPPING' class='btn' formaction='shopping.php'></td></tr>";
  65. echo"<tr><td colspan=2><input type=submit value='VIEW ORDERS' class='btn' formaction='details2.php'></td></tr>";
  66. }
  67. echo "</table>";
  68. echo "</form>";
  69. //close db connection
  70. $conn->close();
  71. }else{
  72. echo "<p class='fail'>You are not authorised to access this information</p>";
  73. }
  74. ?>
  75. <footer>
  76. <p>Copyright&copy; 2019 - All Rights Reserved</p>
  77. <p>Shailesh Bhandari</p>
  78. </footer>
  79. </body>
  80. </html>
  81.  
  82. _______________________________________________________________
  83. conn.php
  84.  
  85. <!DOCTYPE html>
  86. <html lang="en">
  87. <head>
  88. <title>Your Details</title>
  89. <meta charset="utf-8">
  90. <link rel="stylesheet" href="css/common.css" type="text/css">
  91. <script src="script/myscript.js"></script>
  92. </head>
  93. <body onload="pload()">
  94. <img src="img/logo.png" alt="logo">
  95. <p id="date1">DATE</p>
  96. <p id="time1">TIME</p>
  97. <h3>Navigation</h3>
  98. <nav>
  99. <ul>
  100. <li><a href="home.html">Home</a></li>
  101. <li><a href="login.html">Login</a></li>
  102. <li><a href="addedit.php">New User</a></li>
  103. <li><a href="aboutus.html">About Us</a></li>
  104. <li><a href="contactus.html">Contact Us</a></li>
  105. </ul>
  106. </nav>
  107. <h1>Welcome to Shailesh Insurance</h1>
  108. <h2>Place to order </h2>
  109.  
  110. <?php
  111. //declare all variables for db connection
  112. $dbserver="localhost:3307";
  113. $dbuser="root";
  114. $dbpassword="";
  115. $dbname="sbdb2019";
  116. //create connection
  117. $conn=new mysqli($dbserver,$dbuser,$dbpassword,$dbname);
  118. //check connection error
  119. if($conn->connect_error==true){
  120. die("connection failed error description $conn->Connect_error");
  121. }else{
  122. echo "<p class='success'>Connection Success</p>";
  123. }
  124. //read login from values
  125. $id=$_POST['userid'] ;
  126. $password=$_POST['password'] ;
  127. //create sql statement
  128. $sql="SELECT * FROM CUSTOMER WHERE ID='".$id."' and PASSWORD='".$password."'";
  129. //execute sql and assign to result
  130. $result = $conn->query($sql);
  131. if($result->num_rows>0){
  132. //display welcome
  133. echo "<h1>Welcome $id your details are below</h1>";
  134. echo "<h2>Please enter new details except id if you need changes</h2>";
  135. echo "<form method = 'post' action = 'update.php'>";
  136. //create table to display information
  137. echo "<table>";
  138. while($row=$result->fetch_assoc()){
  139. echo "<tr><td>ID:</td><td><input type='number' id='box' name='id' readonly value=".$row['ID']."></td></tr>";
  140. echo "<tr><td>Name:</td><td><input type='text' id='box' name='name' value=".$row['NAME']."></td></tr>";
  141. echo "<tr><td>City:</td><td><input type='text' id='box' name='city' value=".$row['CITY']."></td></tr>";
  142. echo "<tr><td>DOB:</td><td><input type='date' id='box' name='dob' value=".$row['DOB']."></td></tr>";
  143. echo "<tr><td>Phone:</td><td><input type='phone' id='box' name='phone' value=".$row['PHONE']."></td></tr>";
  144. echo "<tr><td>Password:</td><td><input type='text' id='box' name='password' value=".$row['PASSWORD']."></td></tr>";
  145. echo "<tr><td colspan=1><input type=submit value=UPDATE class=btn></td><td colspan=2><input type=submit value=DELETE
  146. class=btn formaction='delete.php' onclick=\"return confirm('Are you sure you want to delete this item?');\"></td></tr>";
  147. echo"<tr><td colspan=2><input type=submit value='GO SHOPPING' class='btn' formaction='shopping.php'></td></tr>";
  148. echo"<tr><td colspan=2><input type=submit value='VIEW ORDERS' class='btn' formaction='details2.php'></td></tr>";
  149. }
  150. echo "</table>";
  151. echo "</form>";
  152. //close db connection
  153. $conn->close();
  154. }else{
  155. echo "<p class='fail'>You are not authorised to access this information</p>";
  156. }
  157. ?>
  158. <footer>
  159. <p>Copyright&copy; 2019 - All Rights Reserved</p>
  160. <p>Shailesh Bhandari</p>
  161. </footer>
  162. </body>
  163. </html>
  164.  
  165. _____________________________________________________________________________________________
  166. nav.html
  167. <img src="img/logo.png" alt="logo">
  168. <p id="date1">DATE</p>
  169. <p id="time1">TIME</p>
  170. <h3>Navigation</h3>
  171. <nav>
  172. <ul>
  173. <li><a href="home.html">Home</a></li>
  174. <li><a href="login.html">Login</a></li>
  175. <li><a href="addedit.php">New User</a></li>
  176. <li><a href="aboutus.html">About Us</a></li>
  177. <li><a href="contactus.html">Contact Us</a></li>
  178. </ul>
  179. </nav>
  180. <h1>Welcome to Shailesh Insurance</h1>
  181. _____________________________________________________________________________________
  182. shopping.php
  183.  
  184. <!DOCTYPE html>
  185. <html>
  186. <head>
  187. <title>Shopping</title>
  188. <meta charset="utf-8">
  189. <link rel="stylesheet" href="css/common.css" type="text/css">
  190. <script src="script/myscript.js"></script>
  191. </head>
  192. <body onload="pload()">
  193. <?php
  194. include 'nav.html';
  195. include 'conn.php';
  196. ?>
  197. </body>
  198. </html>
  199.  
  200. ________________________________________________________________________
  201. details2.php (not done)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!