<?php

$name = $_POST['name'];
$email = $_POST['email'];
$phonenumber = $_POST['phonenumber'];

$db_host = 'localhost';
$db_name = 'znzpromo_subscriptions';
$db_user = 'username';
$db_pass = 'password';


$dbh = new PDO("mysql:host=$db_host; dbname=$db_name;", $db_user, $db_pass);
$sql = "INSERT INTO Subscriptions ('Name', 'Email', 'Phone_Number') VALUES(?,?,?)";
$sth = $dbh->prepare($sql);
$sth->execute(array($name, $email, $phonenumber));
?>