<?php
require('header.php');
if (empty($username)) {
echo '
<p>Please choose a username:</p>
<form method="POST" action="submit.php">
<input type="text" name="username">
<input type="submit" value="Submit">
</form>
';
require('footer.php');
exit;
} else {
$dbname = 'xxx'; // db name
$dbuser = 'xxx'; // db username
$dbpass = 'xxx'; // db password
$dbhost = 'localhost'; // db host, localhost should suffice.
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die(mysql_error());
mysql_select_db($dbname, $conn) or die(mysql_error());
$username = mysql_real_escape_string(htmlspecialchars(strip_tags($_POST['username'])));
mysql_query('INSERT INTO `users` SET `username`="'.$username.'"') or die(mysql_error());
echo '<p>All done! <a href="submit.php">Insert another?</a></p>';
require('footer.php');
exit;
}
?>