Gman — Thu, 15 Feb 2001 12:18:33 +0000

Thanks for that Mavrick.
I will post feedback later if it works.

Thanks

Maverick — Thu, 15 Feb 2001 06:32:36 +0000

You need some sort of intermediary language to communicate with the database, simple HTML doesn't cut it. If you're using MySQL, I assume you have PHP available since they play so nicely together. So

<HTML>
<HEAD>
<TITLE>test</TITLE>

</HEAD
<BODY>

<?PHP

// SET THE VARIABLES
$db = "databasename";
$table = "tablename";
$host = "databaseserver";
$user = "databaseusername";
$pw = "databasepassword";

if ($submit) {

mysql_connect($host,$user,$pw) or die ("Unable to connect");
mysql_select_db("$db") or die("Unable to open database");
$query = "insert into $table (name, address) VALUES ('$name', '$address') or die ("INSERT failed");
$result = mysql_query($query);
echo "data inserted";
} else {

echo "<FORM METHOD=\"post\" ACTION=$PHP_SELF>";
echo "Name: <INPUT type=\"text\" NAME=\"name\"><P>";
echo "Address: <INPUT type=\"password\" NAME=\"address\"><P>";

echo "<input type=\"submit\" value=\"Submit\" name=\"submit\">";
echo "</FORM>";

}

</BODY>
</HTML>

I didn't test that, so there might be a typo in there somewhere, but that's a nice simple way to do it. And for security purposes, it's best to set the values in a protected file and include it into the page that's running the script.