/var/www/(Del)therainbows.org.hk/webadmin/videoadd.php


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
<?php require("configure.php"); ?>
<?
$videotitleen    
htmlspecialchars($_POST["videotitleen"],ENT_QUOTES);
$videotitletc    htmlspecialchars($_POST["videotitletc"],ENT_QUOTES);
$videotitlesc    htmlspecialchars($_POST["videotitlesc"],ENT_QUOTES);

$videodescen     preg_replace("/'/","\'",$_POST["videodescen"]);
$videodesctc     preg_replace("/'/","\'",$_POST["videodesctc"]);
$videodescsc     preg_replace("/'/","\'",$_POST["videodescsc"]);


$sql "select max(videoid) as maxid ";
$sql .= "from video";
$result=mysql_query($sql);
$row mysql_fetch_array($result,MYSQL_ASSOC);
$videoid $row{maxid}+1;

$sql "insert into video (videoid, videotitleen, videodescen, videotitletc, videodesctc, videotitlesc, videodescsc) values ('$videoid', '$videotitleen', '$videodescen', '$videotitletc', '$videodesctc', '$videotitlesc', '$videodescsc')";
//echo $sql;
mysql_query($sql);
mysql_close($dbh);

header("Location: videoindex.php?msg=Add Successful");
?>