Untitled

<?php

$hostname = "localhost"; // usually is localhost, but if not sure, check with your hosting company, if you are with webune leave as localhost
$db_user = "*******"; // change to your database password
$db_password = "*******"; // change to your database password
$database = "smislich"; // provide your database name
$db_table = "Superhero"; // leave this as is


$db = mysql_connect($hostname, $db_user, $db_password);
mysql_select_db($database,$db);
?>
<html>
<head>
<title>Superhero Form</title>
</head>
<body>

<?php
if (isset($_REQUEST['Submit'])) {
# THIS CODE TELL MYSQL TO INSERT THE DATA FROM THE FORM INTO YOUR MYSQL TABLE
$sql = "INSERT INTO $db_table(FirstName, LastName, HeroName, PictureLink, Publisher, Power) values ('".mysql_real_escape_string(stripslashes($_REQUEST['firstname']))."','".mysql_real_escape_string(stripslashes($_REQUEST['lastname']))."','".mysql_real_escape_string(stripslashes($_REQUEST['heroname']))."','".mysql_real_escape_string(stripslashes($_REQUEST['picturelink']))."','".mysql_real_escape_string(stripslashes($_REQUEST['publisher']))."','".mysql_real_escape_string(stripslashes(implode(',',$_REQUEST['power'])))."')";
if($result = mysql_query($sql ,$db)) {
echo '<h1>Thank you</h1>Your information has been entered into our database.<br><form method="link" action="dbm2.php"><input type="submit" value="See database">
</form>';

} else {
echo "ERROR: ".mysql_error();
}
} else {
?>
<h1>Enter New Superhero Information</h1>
<form method="post" action="">
First:<br>
<input type="text" name="firstname">
<br>
Last: <br>
<input type="text" name="lastname">
<br>
Hero Name:<br>
<input type="text" name="heroname">
<br>
Picture:<br>
<input type="text" name="picturelink">
<br>
Publisher:<br>
<select name= "publisher">
<option value="DC">DC</option>
<option value="Marvel">Marvel</option>
<option value="Other">Other</option>
</select>
<br>
Power:<br>
<select name="power[]" size="11" multiple>
<option value="Strength">Super Strength</option>
<option value="Bouncing">Bouncing</option>
<option value="Flying">Flying</option>
<option value="Speed">Speed</option>
<option value="Immortality">Immortality</option>
<option value="X-Ray Vision">X-Ray Vision</option>
<option value="Morphing">Morphing</option>
<option value="Swimming">Swimming</option>
<option value="Invisibility">Invisibility</option>
<option value="Amputation">Amputation</option>
<option value="Intelligence">Super Intelligence</option>
</select>
<br>
<br>
<input type="submit" name="Submit" value="Submit">
</form>
<?php
}
?>
</body>
</html>