<?php include 'database.php' ?>

<?php

if(isset($_POST['name']) && isset($_POST['shout'])){

$name = mysqli_real_escape_string($con, $_POST['name']);

$shout = mysqli_real_escape_string($con, $_POST['shout']);

$date = mysqli_real_escape_string($con, $_POST['date']);

//Set timezone

date_default_timezone_set('America/Los_Angeles');

$date = date('h:i:s: a',time());

$query = "INSERT INTO shouts (name, shout, date)

VALUES ('$name', '$shout', '$date')";

if(!mysqli_query($con, $query)){

echo 'Error: ' .myqli_error($con);

} else {

echo '<li>'.$name.': '.$shout.' ['.$date.']</li>';

}

}

?>