44 lines
1.0 KiB
PHP
Executable File
44 lines
1.0 KiB
PHP
Executable File
<?php
|
|
|
|
require_once(__DIR__ . '/AbstractDb.php');
|
|
|
|
class SQLite extends AbstractDb
|
|
{
|
|
public function __construct($db, $hostname = null, $username = null, $password = null, $prefix = '')
|
|
{
|
|
$this->db = new \PDO('sqlite:' . $db);
|
|
$this->prefix = '';
|
|
}
|
|
|
|
protected function query(string $sql, array $params): array
|
|
{
|
|
$stmt = $this->db->prepare($sql);
|
|
if (!$stmt) {
|
|
return false;
|
|
}
|
|
$stmt->execute($params);
|
|
|
|
$result = array();
|
|
while ($data = $stmt->fetch(\PDO::FETCH_ASSOC)) {
|
|
// Loop through results here $data[]
|
|
$result[] = $data;
|
|
}
|
|
|
|
$stmt->closeCursor();
|
|
return $result;
|
|
}
|
|
|
|
protected function execute(string $sql, array $params): bool
|
|
{
|
|
$stmt = $this->db->prepare($sql);
|
|
if (!$stmt) {
|
|
return false;
|
|
}
|
|
$result = $stmt->execute($params);
|
|
if ($result) {
|
|
$stmt->closeCursor();
|
|
}
|
|
return $result;
|
|
}
|
|
}
|