Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html lang="en">
- <head>
- <meta charset="utf-8">
- <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
- <meta name="description" content="">
- <meta name="author" content="">
- <link rel="icon" href="http://getbootstrap.com/favicon.ico">
- <title>Starter Template for Bootstrap</title>
- <!-- Bootstrap core CSS -->
- <link href="http://getbootstrap.com/dist/css/bootstrap.min.css" rel="stylesheet">
- <!-- Custom styles for this template -->
- <link href="starter-template.css" rel="stylesheet">
- </head>
- <body>
- <div class="container">
- <form method="get">
- Name:<br>
- <input type="text" name="name">
- <br>
- <input type="submit" value="Submit">
- </form>
- <?php
- $db_username = ''; //username
- $db_password = ''; //password
- //path to database file
- $database_path = "c:/xampp/htdocs/User.mdb";
- //check file exist before we proceed
- if (!file_exists($database_path)) {
- die("Access database file not found !");
- }
- //create a new PDO object
- $database = new PDO("odbc:DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$database_path; Uid=$db_username; Pwd=$db_password;");
- $sql = "SELECT * FROM Catalog";
- $result = $database->query($sql);
- while ($row = $result->fetch()) {
- echo $row["Name"]."<br>";
- }
- if(!empty($_GET)){
- $name = $_GET["name"];
- $sql = "INSERT INTO Catalog(Name) VALUES ('$name')";
- if($database->query($sql))
- {
- echo 'Dane zostały zapisane w bazie danych';
- }else{
- $db_err = $database->errorInfo();
- echo 'Error : ('. $db_err[0] .') -- ' . $db_err[2];
- }
- }
- ?>
- <table class="table table-hover">
- <thead>
- <tr>
- <th>Imię</th>
- <th>Wiek</th>
- </tr>
- </thead>
- <tbody>
- <?php while( $row = $result->fetch()) : ?>
- <tr>
- <td><?php echo $row['Name']; ?></td>
- <td><?php echo $row['Wiek']; ?></td>
- </tr>
- <?php endwhile ?>
- </tbody>
- </table>
- </div><!-- /.container -->
- <!-- Bootstrap core JavaScript
- ================================================== -->
- <!-- Placed at the end of the document so the pages load faster -->
- <script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script>
- <script>window.jQuery || document.write('<script src="../../../../assets/js/vendor/jquery.min.js"><\/script>')</script>
- <script src="http://getbootstrap.com/assets/js/vendor/popper.min.js"></script>
- <script src="http://getbootstrap.com/dist/js/bootstrap.min.js"></script>
- <!-- IE10 viewport hack for Surface/desktop Windows 8 bug -->
- <script src="http://getbootstrap.com/assets/js/ie10-viewport-bug-workaround.js"></script>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement