<?php
require_once ('mysql.php'); // connect to database
if (isset ($_POST['submit'])) { // check if form has been sent
// now get the form values
$field1 = $_POST['field1'];
$field2 = $_POST['field2'];
// insert them to database with SQL query
$sql = mysql_query ("INSERT INTO tablename (field1, field2) VALUES ('".$field1."', '".$field2."')");
echo 'inserted';
} else { // the form was not sent, so display it
echo '<form action="insert.php" method="post">
Field 1 <input type="text" name="field1" /><br />
Field 2 <input type="text" name="field2" /><br />
<input type="submit" name="submit" value="Submit" />
</form>';
}
?>