about summary refs log blame commit diff stats
path: root/store/browser/db.php
blob: bfe73d88676a4f81e9e5b2d45cea5d4a980c839c (plain) (tree)






















                                                             
<?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;
}

?>