1BzzNdKR

1<?php
2  try
3  {
4    //open the database
5    $db = new PDO('sqlite:client.db');
6
7    //create the database
8    $db->exec("CREATE TABLE IF NOT EXISTS Client (id INTEGER PRIMARY KEY AUTOINCREMENT, first_name VARCHAR(50), last_name VARCHAR(50), email VARCHAR(50), gender VARCHAR(50))");
9
10$page = 1;
11if(!empty($_GET['page'])) {
12    $page = filter_input(INPUT_GET, 'page', FILTER_VALIDATE_INT);
13    if(false === $page) {
14        $page = 1;
15    }
16}
17
18if ($_SERVER['REQUEST_METHOD'] === 'POST') {
19    //something posted
20
21    if (isset($_POST['Previous'])) {
22        print 'current value of $page = ' . $page;
23        print "<br>";
24        if($page <= 0) {
25          $page = 1;
26        }else {
27          $page = $page - 1;
28        }
29    } else if(isset($_POST['Next'])) {
30        print 'current value of $page = ' . $page;
31        print "<br>";
32        $page = $page + 1;
33    }
34}
35
36
37
38
39
40// set the number of items to display per page
41$limit = 10;
42
43// build query
44$offset = ($page - 1) * $limit;
45if($offset <= 0) {
46  $offset = 0;
47}
48print '$page = ' . $page;
49print "<br>";
50print '$offset = ' . $offset;
51    //now output the data to a simple html table...
52    print "<table border=1>";
53    print "<tr><td>Id</td><td>First Name</td><td>Last Name</td><td>Age</td><td>Gender</td></tr>";
54    $sql = "SELECT * FROM Client LIMIT " . $offset . "," . $limit;
55
56    $result = $db->query($sql);
57    //$rows = count($result);
58    //print $rows;
59    //checks if table has data
60    //$count = $result->fetchColumn();
61
62    foreach($result as $row)
63    {
64      print "<tr><td>".$row['id']."</td>";
65      print "<td>".$row['first_name']."</td>";
66      print "<td>".$row['last_name']."</td>";
67      print "<td>".$row['email']."</td>";
68      print "<td>".$row['gender']."</td></tr>";
69    }
70
71
72  print "</table>";
73  print "<br>";
74  //print "<button type="button" name="button"><< Previous </button>";
75  //print "<button type="button" name="button">Next >></button>";
76  print "<form class="" action="" method="post">";
77  print  "<button type="submit" name="Previous">Previous</button>";
78  print  "<br><br><button type="submit" name="Next">Next</button>";
79  print "</form>";
80
81    // close the database connection
82    $db = NULL;
83  }
84  catch(PDOException $e)
85  {
86    print 'Exception : '.$e->getMessage();
87  }
88?>