create a new database and user.
call the database: tourney
call the database user: tourney
password: tourney
Run this in phpmyadmin
[code]
CREATE TABLE `tourney` (
`id` int(11) NOT NULL auto_increment,
`racername` varchar(30) NOT NULL default '',
`averageet` varchar(255) NOT NULL default '',
`car` varchar(55) NOT NULL default 'Integra',
`entry` varchar(40) NOT NULL default '$300',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
Save this as config.php
<?php
$host = "localhost"; //edit as required
$user = "tourney"; //edit as required
$pass = "tourney"; //edit as required
$db = "tourney"; //edit as required
$dbcon = mysql_connect("$host","$user","$pass");
mysql_select_db($db) or die(mysql_error());
?>
Save this as tourney.php
<?php
include ("config.php");
switch($_GET[page])
{
default:
echo ("
<html>
<title>Tourney App</title>
<body>
<form action="?page=register" method="post">
<b>Racername:</b><br><input type="text" name="racername"><br>
<b>Average ET:</b><br><input type="text" name="averageet"><br>
<b>Car:</b><br>
<INPUT TYPE="CHECKBOX" NAME="car" VALUE="Integra"/>Integra<br>
<INPUT TYPE="CHECKBOX" NAME="car" VALUE="Lancer"/>Lancer<br>
<INPUT TYPE="CHECKBOX" NAME="car" VALUE="RSX"/>RSX<br>
<INPUT TYPE="CHECKBOX" NAME="car" VALUE="G35"/>G35<br>
<INPUT TYPE="CHECKBOX" NAME="car" VALUE="Mustang"/>Mustang<br>
<INPUT TYPE="CHECKBOX" NAME="car" VALUE="Vette"/>Vette<br>
<INPUT TYPE="CHECKBOX" NAME="car" VALUE="Ford GT40"/>Ford GT40<br>
<b>Which entry amount would you like to pay?</b><br>
<INPUT TYPE="CHECKBOX" NAME="entry" VALUE="$300"/>$300<br>
<INPUT TYPE="CHECKBOX" NAME="entry" VALUE="$400"/>$400<br>
<input type="Submit" value="Register"/>
</form></body>
</html>
");
break;
case 'register':
$racername = "$_POST[racername]";
$averageet = "$_POST[averageet]";
$car = "$_POST[car]";
$entry = "$_POST[entry]";
$query = mysql_query("INSERT INTO tourney (racername, averageet, car, entry) VALUES('$racername', '$averageet', '$car', '$entry')");
echo ("
<html>
<title>Submitted Data</title>
<body>
<center>Hello $racername.<br>
You have chose to use a $car for this tourney with the average et of $averageet.<br>
With the agreement to pay the entry fee of <?php echo $entry.<br>
Your information has been submitted to our tourney system.<br>
Thanks and enjoy the tourney.</body>
</html>
");
break;
}
?>
That will insert everything into the database for you to use later on
A very big tut