escapeString(trim($_POST['first']));
$i_last = $db->escapeString(trim($_POST['last']));
$i_pass = $db->escapeString(trim($_POST['pass']));
$i_user = $db->escapeString(trim($_POST['user_name']));
if($i_first && $i_last && $i_pass && $i_user)
{
$q = "select user_id from users where user_name='$i_user'";
$r = $db->query($q);
if($r->numColumns() && $r->columnType(0) != SQLITE3_NULL)
{
$errors['name'] = "That user name is already in use.";
}
}
else
{
$errors['input'] = "Please fill in all fields!";
}
if(empty($errors))
{
$passcom = $i_pass . $i_first;
$passcom = SHA1($passcom);
if(isset($_POST['admin']))
{
$adminn = "true";
}
else
{
$adminn = "false";
}
$q = "insert into users(first_name, last_name, user_name, pass,
registration_date, admin) values ('$i_first', '$i_last'
, '$i_user', '$passcom', date('now'), false)";
$r = $db->query($q);
header("Location: index.php");
}
}
echo 'Register
';
echo '';
foreach($errors as $msg)
echo " - $msg
";
}