form to send message
Code: Select all
<form action="insert.php" method="post">
<fieldset>
<label>License Plate:</label><input type="text" name="tag" />
<label>Message:</label><textarea name="message" cols="55" rows="8"></textarea>
<input type="submit" name="Send" value="Send" />
</fieldset>
</form>Code: Select all
<?php
$con = mysql_connect("localhost","text_tag","db_pass);
$tm=time();
$ref=@$HTTP_REFERER;
$agent=@$HTTP_USER_AGENT;
$ip=@$REMOTE_ADDR;
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("text_tag", $con);
$sql="INSERT INTO testtable (tag, message, tm, ref, agent, ip, tracking_page_name)
VALUES
('$_POST[tag]','$_POST[message]','$tm', '$ref', '$agent', '$ip', '$tracking_page_name')";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "Your message has been sent";
mysql_close($con)
?>