about summary refs log tree commit diff stats
path: root/store/browser/db.php
blob: bfe73d88676a4f81e9e5b2d45cea5d4a980c839c (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
<?php

$db = new PDO('sqlite:db_websites.sqlite3');

$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$query = "CREATE TABLE IF NOT EXISTS websites
(id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
    login_name TEXT
)";

$db->exec($query);

function cleanText($value) {
	$value = strip_tags($value);
	$value = htmlentities($value, ENT_QUOTES, "UTF-8");
	$value = trim($value);
	$value = stripslashes($value);
	$value = strval($value);
	return $value;
}

?>