setAttribute(POD::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
return $conn;
}
catch (PDOException $e){
echo "Login failed: " . $e->getMessage();
return -1;
}
}
function hideLogin(){
echo '
';
}
if(isset($_POST['state'])){
$user = $_POST["usr"];
$pass = $_POST["psw"];
hideLogin();
if($_POST['state'] === "login"){
/* $conn = logIn($user, $pass);
if(!($conn === -1)){
echo 'Logged in as ' . $user;
}*/
}
else if($_POST['state'] === "show"){
/*$conn = logIn($user, $pass);
if(!($conn === -1)){
echo 'Logged in as ' . $user . '
';
echo 'Database state:' . '
';
$query = 'SELECT * FROM pin LIMIT 0';
$rs = $conn->query($query);
$query = 'SELECT * FROM pin';
foreach($conn->query($query) as $row){
echo $query_delimiter;
for($i = 0; $i < $rs->columnCount(); $i++) {
$col = $rs->getColumnMeta($i);
echo $query_element;
echo $col['name'] . ' : ' . $row[$col['name']];
}
echo '
';
}
}
*/
}
else if($_POST['state'] === "delete"){
echo "To do
";
}
else if($_POST['state'] === "update"){
$conn =
try{
echo '