<?php
try{
$conn = new PDO ('mysql:host=localhost; dbname=mydb', 'myuser','mypassword');
} catch (PDOException $e) {
    echo 'ERROR: ' $e->getMessage ();
}
?>
</br>
<form action="form.php"method="post">
</br>


Field 1<input type="text" id="name1" name="name1"><br/>
Field 2<input type="text" id="name2" name="name2"><br/>
Digits<input type="text" id="digits" name="digits"><br/>
<input type="reset" name="reset">
<input type="submit" name="submit"></br>
</form>

<?php
if(isset($_POST ['submit'])){
if(empty($_POST ['name1'])){
echo "Input missing";}
echo "<br/>";
if(empty($_POST ['name2'])){
echo "Input missing</font>";}
echo "<br/>";
if(empty($_POST ['digits'])){
echo "Input missing<br/>";}
else {
$name1 = $_POST ['name1'];
$name2 = $_POST ['name2'];
$digits = $_POST ['digits'];
$q = "INSERT INTO mytable (name1, name2, digits) VALUES (:name1, :name2, :digits);";
$query = $conn->prepare($q);
$results = $query->execute(array(
":name1" -> $name1,
":name2" -> $name2,
":digits" -> $digits
));
header ("Location: page2.php");}}
?>