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");
?>