} if (!$_POST['city'] || !preg_match(" /[^\$%\\^*£=~@0123456789]/ ", $_POST['city'])) { $errCity = 'Please enter your city'; } if (!$_POST['phone'] || !preg_match("/^[0-9]+\$/", $_POST['phone'])) { $errPhone = 'Please enter your phone number'; } if (!$_POST['participation']) { $errParticipation = 'Participation statement is required'; } // If there are no errors, send the email if (!$errName && !$errMail && !$errStreet && !$errStreetnumber && !$errZip && !$errCity && !$errParticipation && !$errPhone) { $db = new SQLite3('db.sqlite3'); $query = sprintf("INSERT INTO guest (lastname, firstname, mail, street, streetnumber, zip, city, phone, participation, comment) VALUES\r\n ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')", $lastname, $firstname, $mail, $street, $streetnumber, $zip, $city, $phone, $participation, $comment); #echo '<p>'.$query.'</p>'; $count = $db->exec($query) or die(print_r($db->errorInfo(), true)); $db->close(); if ($count !== 0) { $result = '<div class="alert alert-success">Guest successfully added! Reloading...</div>'; $page = $_SERVER['PHP_SELF']; $sec = "2"; header("Refresh: {$sec}; url={$page}"); } else { $result = '<div class="alert alert-danger">Sorry there was an error executing your query. Please try again later.</div>'; } } } ?> <!DOCTYPE html> <html lang="en">