<?php
require_once("../includes/dbsmain.inc.php");
if(isset($_REQUEST['submit'])){
	db_query("insert into tbl_video set video_title='$video_title',video_clip='$video_clip',video_status='Active',video_add_date=now() ");
	      set_session_msg("Video has been added successfully !");
		  header("Location: manage_video.php");
		  exit;
	}
?>
<?php
if(isset($_REQUEST['upvideo_date'])){
	$sql_upvideo_date="update tbl_video set video_title='$video_title',video_clip='$video_clip',video_status='Active', video_add_date =now() where video_id='".$video_id."'";
	$sql_upvideo_date=mysqli_query($sql_upvideo_date) or die(mysqli_error());
	set_session_msg("Video has been updated successfully !");
    header("Location: manage_video.php");
    exit;
  }
if(!empty($_REQUEST['video_id'])){
	$faq_video_id=$_REQUEST['video_id'];
	$sql_fectch_city=mysqli_query("select * from tbl_video  where video_id='".$_REQUEST['video_id']."'") or die(mysqli_error());
	$fetch_record=mysqli_fetch_array($sql_fectch_city);
	
}
?>
<link href="styles.css" rel="stylesheet" type="text/css">
<?php include("top.inc.php");?>
<div align="right" style="font-size:12px; font-weight:bold; margin-right:10px;"><a href="manage_video.php">Back to Video List</a>&nbsp;</div>
            <table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td video_id="content" align="center">
                  <form name="form1" method="post" enctype="multipart/form-data">
                    <br />
                    <table  border="0" width="80%"align="center" cellpadding="2" cellspacing="0" class="tableSearch" style="border:2px outset #fff;">
                      <tr align="center">
                        <th colspan="2" style="background:#004E9B; padding:8px; font-size:14px;">Add / Edit Video</th>
                      </tr>
                      <tr align="center">
                        <td colspan="2">&nbsp;
                          </th>
                      </tr>
                      <?php if(!empty($fetch_record['video_clip'])){?>
                      <tr>
                        <td width="40%" align="right" valign="middle" class="tdLabel" style="padding:8px;"><b style="color:#003A75;">Video Clip</b> </td>
                        <td class="tdLabel" style="padding:8px;"><iframe width="100" height="100" src="http://www.youtube.com/embed/<?=$fetch_record['video_clip']?>" frameborder="0" allowfullscreen></iframe></td>
                      </tr>
                      <? }?>
                      <tr>
                        <td width="40%" align="right" valign="middle" class="tdLabel" style="padding:8px;"><b style="color:#003A75;">Video Title</b> </td>
                        <td class="tdLabel" style="padding:8px;"><input type="text" name="video_title" size="30"  value="<?=$fetch_record['video_title']?>" style="height:26px; width:300px;"/></td>
                      </tr>
                      <tr>
                        <td width="40%" align="right" valign="top" class="tdLabel" style="padding:8px; padding-top:14px;"><b style="color:#003A75;">Video Clip Name</b> </td>
                        <td class="tdLabel" style="padding:8px;"><input type="text" name="video_clip" size="30"  value="<?=$fetch_record['video_clip']?>" style="height:26px; width:300px;"/>
                          <br />
                           <b style="color:#0000FF; font-size:10px;">[ Please Enter Only 11 digit last code like : </b><b style="color:#FF0000"> <u>0J4vY8rHeIc</u></b> <b>]</b></td>
                      </tr>
                      <tr>
                        <td align="center" colspan="2" style="padding:8px; padding-bottom:40px;"><input type="hidden"  name="video_id" id="video_id" value="<?=$_REQUEST['video_id']?>">
                          <?php if(empty($_REQUEST['video_id'])){?>
                          <input type="submit" name="submit" value='Submit' class="button" style="font-size:13px; font-weight:bold; height:27px; background-color:#006BD7; border-radius:4px; cursor:pointer; width:100px;" >
                          <? }else{?>
                          <input type="submit" name="upvideo_date" value='Submit' class="button" style="font-size:13px; font-weight:bold; height:27px; background-color:#006BD7; border-radius:4px; cursor:pointer; width:100px;" >
                          <? }?>
                        </td>
                      </tr>
                    </table>
                  </form>
                  <br />
                  <?php include("paging.inc.php");?>
                </td>
              </tr>
            </table>
            <?php include("bottom.inc.php");?>