<?php
if(isset($_POST['submit_video']))
{
    if($_FILES['FileVideo']['type']!= "video/mp4")
    {
    die('<script type="text/javascript">window.location.href="upload.php?error=type";</script>');
    }
    $fileDname=date("Ymdhms");
    $ext=pathinfo($_FILES["FileVideo"]["name"],PATHINFO_EXTENSION);
    $fullFileName="videos/".$fileDname.".".$ext;
    $res=move_uploaded_file($_FILES["FileVideo"]["tmp_name"],$fullFileName );
    if(!$res)
    {
        die('<script type="text/javascript">window.location.href="upload.php?error=upload";</script>');
    }else
    {
        // when file upload success we will add the file to the database
        include('config.php');
        $con=connect2db();
        // read video date
        $vTitle=$_POST['txtVideoName'];
        $vDesc=$_POST['txtVideoDesc'];
        $vCatID=$_POST['CatID'];
        $sql = "INSERT INTO `videos` (`Video_ID`, `Title`, `Description`, `FileName`, `Cat_ID`, `Views`, `VLikes`, `DisLikes`, `UploadDateTime`, `Allowed`) VALUES (NULL, '$vTitle', '$vDesc', '$fullFileName', $vCatID, 0, 0, 0, NOW(), 0);";
echo $sql;
        $res1=mysqli_query($con,$sql);
        mysqli_close($con);
        if(!$res1)
        {
            die('<script type="text/javascript">window.location.href="upload.php?error=sql";</script>');
        }
        die('<script type="text/javascript">window.location.href="upload.php?error=no";</script>');
    }
}
?>

<?php
function connect2db()
{
    $host="localhost";
$db_name="abdosoftvideo";
$db_user="root";
$db_pass="";
    $con=mysqli_connect($host,$db_name,$db_pass);
    if(!$con)
    {
        die('Cannot connect to database pleace contact administrator!');
    }
    //mysqli_set_charset($con,'utf8');
    mysqli_select_db($con,$db_name);
    return($con);
}
?>

DROP TABLE IF EXISTS `videos`;
CREATE TABLE `videos` (
  `Video_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Title` varchar(100) DEFAULT NULL,
  `Description` text,
  `FileName` varchar(255) DEFAULT NULL,
  `Cat_ID` int(11) DEFAULT NULL,
  `Views` int(11) DEFAULT NULL,
  `VLikes` int(11) DEFAULT NULL,
  `DisLikes` int(11) DEFAULT NULL,
  `UploadDateTime` datetime DEFAULT NULL,
  `Allowed` int(11) DEFAULT NULL,
  PRIMARY KEY (`Video_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;