<?php
 
//includes the connection parameters FROM external file
 
require_once('connection.php');
 
// Receive the variables
$fname = $_POST['fname'];
$lname = $_POST['lname'];
$email = $_POST['email'];
$ip = gethostbyname($_SERVER['REMOTE_ADDR']);
 
// Establish connection with database
$connect = mysql_connect($hostname, $username, $password) OR die("Could not connect to localhost");
 
// SELECT database
$select = mysql_select_db($database, $connect) OR die("Could not find database.");
 
// INSERT data to database
$sql = mysql_query("INSERT INTO tc_mailist ('fname', 'lname', 'email', 'ip') VALUES ('Joe', 'Bloggs', 'joe@bloggs.com', $ip)");
 
if(!$sql) {
	die("Nope");
} ELSE {
	echo "1 record added";
}
 
mysql_close($connect);
?>

$sql = mysql_query("INSERT INTO tc_mailist (fname, lname, email, ip) VALUES ('Joe', 'Bloggs', 'joe@bloggs.com', $ip)");