<?php
require __DIR__ . "/../vendor/autoload.php";
use crodas\Autocomplete\Autocomplete;
use crodas\Autocomplete\PDOConn;
$file = __DIR__ . '/data.db';
if (!is_file($file)) {
$install = true;
}
// create PDO connection
$pdo = new PDO("sqlite:$file");
// Create transaction, speed up things
$pdo->beginTransaction();
// create Autocomplete DBInterface
$conn = new PDOConn($pdo);
// Create suggest object
$suggest = new Autocomplete($conn);
if (!empty($install)) {
$conn->install();
}
$suggest->index("PHP", 999);
$suggest->index("Python", 93);
$suggest->index("Perl", 83);
$suggest->index("Ruby", 74);
$suggest->index("PHP Programming ", 600);
$suggest->index("Python Programming ", 500);
$suggest->index("Perl Programming ", 400);
$pdo->commit();
|