Advertisement
Guest User

Untitled

a guest
Sep 19th, 2017
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
HTML 5 2.82 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html lang="en">
  3.   <head>
  4.     <meta charset="utf-8">
  5.     <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  6.     <meta name="description" content="">
  7.     <meta name="author" content="">
  8.     <link rel="icon" href="http://getbootstrap.com/favicon.ico">
  9.  
  10.     <title>Starter Template for Bootstrap</title>
  11.  
  12.     <!-- Bootstrap core CSS -->
  13.     <link href="http://getbootstrap.com/dist/css/bootstrap.min.css" rel="stylesheet">
  14.  
  15.     <!-- Custom styles for this template -->
  16.     <link href="starter-template.css" rel="stylesheet">
  17.   </head>
  18.  
  19.   <body>
  20.  
  21.    
  22.     <div class="container">
  23.  
  24.      <form method="get">
  25.   Name:<br>
  26.   <input type="text" name="name">
  27.   <br>
  28.   <input type="submit" value="Submit">
  29. </form>
  30.  
  31. <?php
  32. $db_username = ''; //username
  33. $db_password = ''; //password
  34.  
  35. //path to database file
  36. $database_path = "c:/xampp/htdocs/User.mdb";
  37.  
  38.  
  39. //check file exist before we proceed
  40. if (!file_exists($database_path)) {
  41.    die("Access database file not found !");
  42. }
  43.  
  44. //create a new PDO object
  45. $database = new PDO("odbc:DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$database_path; Uid=$db_username; Pwd=$db_password;");
  46. $sql  = "SELECT * FROM Catalog";
  47. $result = $database->query($sql);
  48.  
  49. while ($row = $result->fetch()) {
  50.  
  51.  
  52.     echo $row["Name"]."<br>";
  53. }
  54. if(!empty($_GET)){
  55. $name = $_GET["name"];
  56.  
  57.  
  58. $sql  = "INSERT INTO Catalog(Name) VALUES ('$name')";
  59.  
  60. if($database->query($sql))
  61. {
  62.     echo 'Dane zostały zapisane w bazie danych';
  63. }else{
  64.    
  65.     $db_err = $database->errorInfo();
  66.     echo 'Error : ('. $db_err[0] .') -- ' . $db_err[2];
  67. }
  68. }
  69. ?>
  70.  
  71.     <table class="table table-hover">
  72.     <thead>
  73.       <tr>
  74.         <th>Imię</th>
  75.         <th>Wiek</th>
  76.       </tr>
  77.     </thead>
  78.     <tbody>
  79.     <?php while( $row = $result->fetch()) : ?>
  80.       <tr>
  81.         <td><?php echo $row['Name']; ?></td>
  82.         <td><?php echo $row['Wiek']; ?></td>
  83.       </tr>
  84.        <?php endwhile ?>
  85.     </tbody>
  86.   </table>
  87.     </div><!-- /.container -->
  88.  
  89.  
  90.     <!-- Bootstrap core JavaScript
  91.    ================================================== -->
  92.     <!-- Placed at the end of the document so the pages load faster -->
  93.     <script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script>
  94.     <script>window.jQuery || document.write('<script src="../../../../assets/js/vendor/jquery.min.js"><\/script>')</script>
  95.     <script src="http://getbootstrap.com/assets/js/vendor/popper.min.js"></script>
  96.     <script src="http://getbootstrap.com/dist/js/bootstrap.min.js"></script>
  97.     <!-- IE10 viewport hack for Surface/desktop Windows 8 bug -->
  98.     <script src="http://getbootstrap.com/assets/js/ie10-viewport-bug-workaround.js"></script>
  99.   </body>
  100. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement