MAINHACK

Viewing / Editing File: add_video.php

<?php
include('header.php');

<div class="main-panel">
			<div class="content">
				<div class="container-fluid">
			<div class="row">	
<div class="col-md-6">
<div class="card">
	<div class="card-header">
		<div class="card-title">Add Video</div>
	</div>
        <form method="post" data-toggle="validator" enctype="multipart/form-data">                                     
                                       
                    <div class="form-group">
                        <label>Video URL</label>
                        
                        <input type="text" name="url" class="form-control" placeholder="Please copy paste the youtube URL" required>
                        </div>
                     	<div class="card-action">
			<div class="row">
				<div class="col-md-12">
					<input class="btn btn-success" type="submit" name="sub" value="Submit">
					<button class="btn btn-danger">Cancel</button>
				</div>										
			</div>
		</div>
					
					</form>
</div>	
</div>

<?php
if(isset($_POST['sub'])){
 $video=htmlentities(strip_tags($_POST['url']));
 $vid=explode('=',$video);

$data=array(
    'url'=>$vid[1],
    'date'=>date('Y-m-d'),
	);
	$r1=$show->insert('video',$data);
	if($r1){
	echo "<script>sweetAlert('Ok','product has been added','success');window.location.href='".$_SERVER['request_uri']."';</script>";
	
	}
	
}

?>	
<div class="col-md-6">

<div class="card">
							
								<div class="card-body">
									<div class="table-responsive">
											<h5 class="page-title">All Videos</h5>
		<table id="basic-datatables" class="display table table-striped table-hover">
			<thead>
				<tr>
				<th>ID</th>
			    <th>Gallery Video</th>
			    <th>Feature</th>
				<th>Delete</th>
                                            
				</tr>
			</thead>
	<tbody>
	<?php
			
$count=1;
$sr='video';
$stmt =$show->readAll($sr);
$num = $stmt->rowCount();
     
     if($num>0){
 
        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
        extract($row);
        $id=$row['id'];

echo "<tr>
		<td>$count</td>
		<td><iframe src='https://www.youtube.com/embed/".$row['url']."' frameborder='0' style='width:200px;height:200px;left:0' allowfullscreen></iframe></td>	
		";
		?>
		 <td>
                                <script>
                                function status(a){
                                var st="#status"+a;
                                var id_txt="#id"+a;
                               var status=$(st).val();
                                var id=$(id_txt).val();
                               // alert(id);
                                $.ajax({
                                type: "POST",
                                url: "ajax_check.php", // Name of the php files
                                data: "feature="+status+"&id="+id,
                                async: false,
                                global: false,
                                success: function(result)
                                {
                                    if(result==2){
                                        alert('One video is already Featured. Please remove to make it featured video');window.location.reload();
                                    }else{
                                window.location.reload();
                                }
                                }
                                });
                               
                                }
                                </script>			   
						   
						     	<?php 
						     	$interests = array('YES','NO'); 
?>
						<select name="status" onchange="status(<?=$count;?>)" id="status<?=$count;?>">
<?php foreach( $interests as  $interest ): ?>
<option value="<?php echo $interest ?>"<?php if( $interest==$row['feature']): ?> selected="selected"<?php endif; ?>><?php echo $interest ?></option>
<?php endforeach; ?>
</select>	  <input type="hidden" id="id<?=$count?>" value="<?=$row['id']?>" >
             
		</td>
		<?php echo"<td>
		<a href='edit_product.php?id=$id&table=$sr&url=".$_SERVER['REQUEST_URI']."' class='label label-success' >Edit</a>

<a href='delete.php?id=$id&table=$sr&url=".$_SERVER['REQUEST_URI']."' class='label label-danger' onclick='return send();'>Delete</a>
		</td>
		</tr>";

++$count;
 }
}

?>						
			</tbody>		</table>

</div>
				
									</div>
								</div>
	</div>
  
		
			</div>
			</div>
		
		
		<?php 
		
		include('footer.php');
		?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: add_video.php

Server Info

System Features

User Info