<?php
ini_set('display_errors', 'On');
error_reporting(E_ALL);
$host="mysql2.myhost.net:3306"; // Host name
$username="username"; // Mysql username
$password="password"; // Mysql password
$db_name="dbname"; // Database name
$tbl_name="thetable"; // Table name

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

// Get values from form
$xname=$_POST['name'];
$xwebsite=$_POST['website'];
$xnumberlat=$_POST['numberlat'];
$xnumberlng=$_POST['numberlng'];
$xmessage=$_POST['message'];
echo "made_variables ok";
// Insert data into mysql
$sql="INSERT INTO $tbl_name(lat, long, name, url, note)VALUES('$_POST[numberlat]','$_POST[numberlng]','$_POST[name]','$_POST[website]','$_POST[message]')";
$result=mysql_query($sql);
echo mysql_query($sql);
// if successfully insert data into database, displays message "Successfulllllllllllllll".
if($result){
echo "Successful";
echo "<BR>";
echo "<a href='insert.php'>Back to main page</a>";
}

else {
echo "ERROR";
echo $_POST['numberlat'];
echo $_POST['numberlng'];
echo $_POST['message'];
echo "($result)";
}
?>

<?php
// close connection
mysql_close();
?>