include('dbconnect.php');
$bericht = '';
if(!empty($_POST['Submit'])) {
$timestamp = date("Y-m-d H:m:s");
$error = 0;
$ipadres = trim ($_POST["ipadres"]);
$client = trim ($_POST["client"]);
$message = trim ($_POST["message"]);
if(!empty($_POST["naam"])) {
$naam = trim ($_POST["naam"]);
} else {
$error = 1;
$error_naam = "1";
}
if(!empty($_POST["email"])) {
if (!ereg('[A-Za-z0-9_-]+\@[A-Za-z0-9_-]+\.[A-Za-z0-9_-]+', $email) ) {
$error_email_ongeldig = "1";
} else {
$email = trim ($_POST["email"]);
}
} else {
$error = 1;
$error_email = "1";
}
if(!empty($_POST["naam_filmpje"])) {
$naam_filmpje = trim ($_POST["naam_filmpje"]);
} else {
$error = 1;
$error_naam_filmpje = "1";
}
if(!empty($_POST["youtube_code"])) {
$youtube_code = trim ($_POST["youtube_code"]);
} else {
$error = 1;
$error_youtube_code = "1";
}
if($error == 1) {
$form = 1;
} else {
$query = "INSERT INTO `tbl_video` (`naam`, `naam_filmpje`, `email`, `youtube_code`, `message`, `timestamp`, `ipadres`, `client`) VALUES ('$naam', '$naam_filmpje', '$email', '$youtube_code', '$message', '$timestamp', '$ipadres', '$client')";
//print_r($query);
if (mysql_db_query ("jasper_jack", $query, $connection)) {
$headers = "From:" . $naam . " <" . $email . ">\n";
$headers .= "Content-Type: text/html; charset=iso-8859-1\n";
$headers .= "MIME-Version: 1.0\n";
$subject = "J.A.C.K filmpje toegevoegd door " . $naam . ".";
$message = "Naam: " . $naam . "
Email adres: " . $email . "
Naam Filmpje: " . $naam_filmpje . "
Bericht: " . $message . "
IP adres: " . $ipadres . "
Client: " . $client . "
";
mail('jasper@punkboy.nl', $subject, $message, $headers);
$form = 0;
} else {
$form = 1;
}
}
} else {
$form = 1;
}
if(!empty($_GET['video_del'])) {
$video_id = $_GET['video_del'];
include('dbconnect.php');
$query = "DELETE FROM `tbl_video` WHERE `id` = $video_del LIMIT 1";
if(mysql_query($query) or die (mysql_error())) {
$delete = 'Het filmpje is verwijderd.';
}
}
?>
include('includes/header.php'); ?>
Check onderstaande filmpjes door erop te klikken!
$query = "SELECT * FROM tbl_video ORDER BY id DESC";
$result = mysql_query($query);
while ($data = mysql_fetch_array ($result)) {
$id = $data['id'];
$naam = $data['naam'];
$naam_filmpje = $data['naam_filmpje'];
$email = $data['email'];
$youtube_code = $data['youtube_code'];
$message = $data['message'];
$timestamp = $data['timestamp'];
$ipadres = $data['ipadres'];
$client = $data['client'];
echo '' . $naam_filmpje . ' van ' . $naam . '';
if (($ipadres == $HTTP_SERVER_VARS["REMOTE_ADDR"]) && ($client == gethostbyaddr($HTTP_SERVER_VARS["REMOTE_ADDR"]))) {
echo ' (verwijderen)';
}
echo ' ' . "\n";
}
?>
echo $delete; ?> |
Voeg een filmpje toe!
if ($form == 0) { ?>
Het filmpje echo $naam_filmpje; ?> is geplaatst.
Klik hier om nog een filmpje toe te voegen...
} else { ?> |
include('includes/footer.php'); ?>
include('includes/google_analytics.php'); ?>