<?
$artist=$_POST['artist'];
$song=$_POST['song'];
$album=$_POST['album'];
mysql_connect("localhost", "swaters210", "password") or die(mysql_error());
mysql_select_db("swaters210") or die(mysql_error());
CREATE TABLE data (artist VARCHAR(30), song VARCHAR(30), album VARCHAR(30));
mysql_query("INSERT INTO `data` VALUES ('$artist', '$song', '$album')");
Print "Your information has been successfully added to the database.";
?>

 
<form method="POST" action="music.php">
<label for="artist"><b>Artist Name:</b></label>
<input type="text" name="artist" value="" /><br />
<label for="song"><b>Song Title:</b></label>
<input type="text" name="song" value="" /><br />
<label for="album"><b>Album:</b></label>
<input type="text" name="album" value="" /><br />
<input type="submit" name="submitbutton" id="submitbutton" value="Submit" />

CREATE TABLE data (artist VARCHAR(30), song VARCHAR(30), album VARCHAR(30));