Search the Community

Hi all, 1. I want to delete selected(checkbox) items from database(MySQL). Here I am not getting any error, but I couldn't do the delete function.2. Wants to play videos in website. Here videos storing into folder and also into database, but cannot playin website. I tried in many ways, but I couldn't. So, please help to make above mentioned functions workable. dashboard.php<form method="post" enctype="multipart/form-data"><input type="submit" name="delete" class="btn btn-primary" onclick="myFunction(id)" style="font-size: 15px; margin-left: 3em;" value="Delete" /></form><div><?php$query = mysqli_query($database, "SELECT * FROM video");while($row = mysqli_fetch_assoc($query)){$id = $row['id'];$name = $row['name'];$url = "../uploads";// $url = $row['url'];$fileextensionvalue= $row['fileextension'];echo "<span class='col-md-6'><div class='row'><div class='col-md-1'><label class='checkbox'><input style='margin-right:1em;' name='checkbox[<?php echo $id; ?>]' type='checkbox' id='checkbox[]' data-toggle='checkbox' /></label></div><div class='col-md-1'><a href='#' style='color:red;font-size:18px;'>$id</a></div><div class='col-md-10'><a href='#' style='color:red;font-size:18px;'>$name</a></div></div><center style='padding:25px;'><video width='320' preload='auto' controls><source src='$url' type='video/$fileextensionvalue;codecs='avc1.42E01E, mp4a.40.2, H.264, aac, FLAC, Opus, VP9, VP8, Vorbis''/></video></center></span>";}?></div><script type="text/javascript">function myFunction(id){var r=confirm("Are you sure to delete selected video/s ?");if(r==true){window.location.assign("deleteVideo.php?id=" + id);}}</script>deleteVideo.php<?phpinclude '../database/database.php';$sql = mysqli_query($database, "SELECT * FROM video WHERE id='$id'");if(empty($_POST['delete'])){Print '<script>alert("Please choose file/s to delete.");</script>';Print '<script>window.location.assign("dashboard.php");</script>';}else if(!empty($_POST['delete'])){foreach($_POST['checkbox'] as $id => $val){if($val=='checked'){$query=mysqli_query("DELETE FROM video WHERE id = '".$id."'");$result= mysqli_query($database, $query) or die("Invalid query");}}}?>

Here I can upload videos successfully into database and videos are saving in appropriate folder named "uploaded". As I mentioned in question, once after uploading the video, if I refresh the browser the previously uploaded video is going saving in my database. Another question is, if I click on the video(displayed name in myvideo.php), video is not going to display instead I am getting "Object Not Found" error. I request you people to give me solutions to solve these problems. Below I am posting my code: myvideo.php: <div class="content"><div class="card"><div class="header" id="stand-fix" style="border-bottom: 1px solid #E1E1E1;"><?phpif(isset($_POST['submit'])){// $conn = mysqli_connect("localhost", "root", "", "videos") or die(mysqli_error());$name = (isset($_FILES['file']['name']) ? $_FILES['file']['name'] : '');$temp = (isset($_FILES['file']['tmp_name']) ? $_FILES['file']['tmp_name'] : '');move_uploaded_file($temp, "uploaded/".$name);$url = "http://localhost/xampp/htdocs/VS/uploaded/$name";mysqli_query($database, "INSERT INTO video VALUE ('','$name','$url')");}?><form action="myvideo.php" method="post" enctype="multipart/form-data"><div class="row"><div class="col-md-7"><h4 class="title">My Videos</h4></div><div class="col-md-3"><input type="file" name="file" class="btn btn-primary" style="font-size: 15px;"><br /></div><div class="col-md-2"><input type="submit" name="submit" class="btn btn-primary pull-right" style="font-size: 15px;" value="Upload"></div></div></form><?phpif(isset($_POST['submit'])){echo '<script language="javascript">';echo 'alert("Your video has been successfully uploaded.")';echo "window.location.href='dashboard.php'";echo '</script>';}?><hr width="50%"></div><div class="content" style="height: 30em; direction: ltr; overflow: auto;"><div class="row" style="margin-left:4em;" style="direction: rtl;"><?php$database = mysqli_connect("localhost", "root", "", "videos") or die(mysqli_error());$query = mysqli_query($database, "SELECT * FROM video");while($row=mysqli_fetch_assoc($query)){$id = $row['id'];$name = $row['name'];$url = $row['url'];echo "<p style='margin:0.5em;'><a href='watch.php?id=$id' style='color:red;'>$id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$name</a></p><br />";echo "<embed src='.$id.$url.'><video width='200' height='200' controls></video></embed>";}?></div></div></div></div> watch.php<?php$conn = mysqli_connect("localhost", "root", "", "videos") or die(mysqli_error());if(isset($_GET['id'])){$id = $_GET['id'];$query = mysqli_query($conn, "SELECT * FROM video WHERE id='$id'");while($row=mysqli_fetch_assoc($query)){$name = $row['name'];$url = $row['url'];}echo "<p style='font-size:20px;'><center>You are watching ".$name."</center></p><br /><embed src='.$url.'><video width='600' height='400' controls></video></embed>";}else{echo "Error!";}?>

does anyone know how i can make a php video uploader script?

Hello there! I have a bit of a challenge here; I was wondering if it is possible, and if so how difficult it will be. I would like to build a plugin of sorts for my site; it would have a video uploader, a video player, and an album for videos. The idea is that my members would be able to upload videos from their computer, where they would be stored in an album on their profile. I don't have the most extensive knowledge of coding, but I consider myself to be a fairly quick learner. My question is, how difficult would it be to create something of this sort, from scratch? The only plugins I've seen so far have been pretty expensive. Any advice would be greatly appreciated!