<?php
$database = 'mysql: myHost =localhost;dbname=MYDATABASENAME;charset=utf8';
$username = 'USERNAME';
$password = 'PASSWORD';
try {
$pdo = new PDO($database, $username, $password);
$pdo ->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$pdo ->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
}
catch (PDOException $e) {
echo 'Connection failed: ' . $e->getMessage();
}
$fieldone = $_POST['fieldone'];
$fieldtwo = $_POST['fieldtwo'];
$fieldthree = $_POST['fieldthree'];
$sql1=("INSERT INTO mytable (fieldone,fieldtwo,fieldthree)
VALUES (:fieldone,:fieldtwo,:fieldthree)");
$q = $pdo->prepare($sql1);
$q->execute(array(':fieldone'=>$fieldone,':fieldtwo'=>$fieldtwo,':fieldthree'=>$fieldthree));
// if successfully inserted
if($q){
header("Location: ../../mypage.php");
exit();
}
else {
echo "ERROR";
}
?>