<?

$dbuser="root";
$dbpass="121212";
$dbname="videotuga";  //the name of the database
$chandle = mysql_connect("localhost", $dbuser, $dbpass)
    or die("Connection Failure to Database");
mysql_select_db($dbname, $chandle) or die ($dbname . " Database not found." . $dbuser);

if ($_SERVER["REQUEST_METHOD"] == "POST")
{

	$nome = $_POST["nome"];
	$link = $_POST["link"];
	$comentario = $_POST["comentario"];
	$dat = gmdate("Y-m-d H:i:s");

	mysql_query("INSERT INTO videos (nome, link, comentario, data) VALUES('$nome', '$link', '$comentario', '$dat')") or sqlerr(__FILE__, __LINE__);


	header("Location: $BASEURL/listagem.php");
	die;
}

?>

<form method=post action=adicionarvideo.php>
<table border=1 cellspacing=0 cellpadding=5>

<tr><td class=rowhead>*Nome</td><td><input type=text  name=nome size=100></td></tr>

<tr><td class=rowhead>*Embed do video</td><td><input type=text  name=link size=100></td></tr>

<tr><td class=rowhead>Comentário</td><td><textarea rows=8 type=\"text\" name=comentario cols="90" size=\"80\" /></textarea></td></tr>

<tr><td colspan=2 align=center><input type=submit value="Inserir"></td></tr>
</table></form>