All pastes #729640 Raw Edit

Anonymous

public text v1 · immutable
·published 2007-10-08 04:58 UTC
rendered paste body
<?PHP
	require(getcwd() . "/inc/config.php");
	$connection = mysql_connect($db_host, $db_user, $db_password) or die("Error connecting to the database!");
	mysql_select_db($db_name, $connection);
	require(getcwd() . "/header.php");
	
        $info = array('title', 'poster', 'description', 'embed', 'category');
        $passed = true;
        foreach ($info as $in) {
            if (!isset($_REQUEST[$in])) {
                 $passed = false;
                 break;
             }
        }
        if (!$passed) {
                echo("You have not completed the necessary information to submit!");
        }
		
		$title = $_POST["title"];
		$poster = $_POST["poster"];
		$posterurl = $_POST["posterurl"];
		$category = $_POST["category"];
		$description = $_POST["description"];
		$embed = $_POST["embed"];
		$date = time();
		
		$query = "INSERT INTO video (id, title, poster, posterurl, category, embed, description, date_auto) VALUES (NULL, '$title', '$poster', '$posterurl', '$category', '$embed', '$description', '$date');";
		mysql_query($query, $connection) or die(mysql_error());
?>

	<form action="index.php" method="POST">
		Video Title:<br />
			<input type="text" name="title" /><br /><br />
		Your Name:<br />
			<input type="text" name="poster" /><br /><br />
		Your Website: <br />
			<input type="text" name="posterurl" /><br /><br />
		Video Description:<br />
			<textarea style="width:75%" rows="10" name="description" /><br /><br />
		Embed Code: <br />
			<textarea style="width:75%" rows="10" name="embed" /><br /><br />
		Category: <br />
			<input type="radio" name="category" value="nfl_game">NFL Games
			<input type="radio" name="category" value="nfl_highlight">NFL Highlights
			<input type="radio" name="category" value="nfl_films">NFL Films
			<input type="radio" name="category" value="ncaa_game">NCAA Games
			<input type="radio" name="category" value="ncaa_highlight">NCAA Highlights
			<input type="radio" name="category" value="cfl_game">CFL Games
			<input type="radio" name="category" value="cfl_highlight">CFL Hightlights
			<input type="radio" name="category" value="hs_games">Highschool Games & Highlights
			<input type="radio" name="category" value="misc">Misc.
		<br />
		<input type="submit" value="submit" />
	</form>

<?PHP	
	require(getcwd() . "/footer.php");
?>