Example #1
0
 public static function create($sqliteFile, $newRecords = 32)
 {
     if (!file_exists($sqliteFile)) {
         $dbh = Sqlite::connect($sqliteFile);
         try {
             $sql = "CREATE TABLE IF NOT EXISTS user (\n                            id INTEGER PRIMARY KEY AUTOINCREMENT,\n                            name TEXT,\n                            email TEXT,\n                            address TEXT,\n                            phone TEXT);";
             $create = $dbh->prepare($sql);
             $create->execute();
             // Start adding dummy data to the db with the help of Faker
             $faker = Faker\Factory::create();
             for ($i = 1; $i <= $newRecords; $i++) {
                 $sth = $dbh->prepare('INSERT INTO user (name, email, address, phone) 
                                         VALUES (:name, :email, :address, :phone)');
                 $sth->bindParam(':name', $faker->name, PDO::PARAM_STR);
                 $sth->bindParam(':email', $faker->email, PDO::PARAM_STR);
                 $sth->bindParam(':address', $faker->address, PDO::PARAM_STR);
                 $sth->bindParam(':phone', $faker->phoneNumber, PDO::PARAM_STR);
                 $sth->execute();
                 // Echo a point for each new record
                 echo '. ';
             }
             echo '<br><strong>' . $newRecords . ' new records were created</strong><hr>';
         } catch (PDOException $ex) {
             echo $ex->getMessage();
         }
     } else {
         echo 'Attention! Remove <code>UserFaker::create()</code> line from your code. ' . $sqliteFile . ' database already exists.<hr>';
     }
 }
Example #2
0
<?php

require_once 'vendor/autoload.php';
use leoshtika\libs\Pagination;
use leoshtika\libs\Sqlite;
use leoshtika\libs\UserFaker;
$sqliteFile = 'demo.sqlite';
// Create a new sqlite db if not exists and load some dummy data.
// After the database is created, you don't need this line of code anymore
UserFaker::create($sqliteFile, 120);
$dbh = Sqlite::connect($sqliteFile);
// Get the total number of records
$totalRecords = $dbh->query('SELECT count(*) FROM user')->fetch(PDO::FETCH_COLUMN);
// Instantiate the Pagination
$pagination = new Pagination($_GET['page'], $totalRecords, 10);
// Get records using the pagination
$sth = $dbh->prepare('SELECT * FROM user LIMIT :offset, :records');
$sth->bindValue(':offset', $pagination->offset(), PDO::PARAM_INT);
$sth->bindValue(':records', $pagination->getRecordsPerPage(), PDO::PARAM_INT);
$sth->execute();
$users = $sth->fetchAll(PDO::FETCH_OBJ);
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <title>Pagination</title>
    <!-- Bootstrap -->
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.2/css/bootstrap.min.css">
</head>
<body class="container-fluid">