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

?>