Video Pos And Show Video Source in Websit

Sudah Tahu Belum bagai mana membuat table video untuk Post artikel.
Pasti Teman-teman sudah banyak yang tahu.
Tidak ada kata terlamabat untuk Memulai membuat sebuah hasil karya.
Langkah awal membentuk kerangka dan struktur pondasi jika seseorang tiba-tiba menemukan artikel ini
sebagai landasan ikuti langka-langkah sebagai berikut
1.Belajar Dengan Papan Percobaan/Server Localhost
2.Membentuk User Dan Sisytem Database Pengguna
1.Struktur Folder/file Root Server File Manager

🗄️Semua File Components,controlest, Termasuk Asset Bostrap Unduh dan Simpan
Apa bila Sudah mengerti ayo kita membuat Landasan sebagai pondasi database table

video_file

Table Video_file
Terdiri sebagai berikut
Menulis Nama pembuat
Tentang video/video_body text
menarik file dalam folder yang sudah ditentukan

video_eye

Table video_eye
Menghitung jumlah pasang mata untuk menonton

video_reply

Table video_reply
Mencatat komentar user
termasuk didalamya comment file jpg/png

Untuk hasil yang baik saya sarankan untuk melihat Struktur file
Struktur Folder Dan File

Cara input data menyampaikan kedalam table video_file
Conroh

forum.php

Arah jalur tautan

add-new-video-post.php

Gunakan Panggilan magic include
didalam file add-new-video-post.php
melewatu dua ruang folder tersebut berada pada
💻Root folder
📂controllers
📂form

add-new-video-post-form.php

<br />
<br />
<?php
    $sql = "SELECT * FROM user where user_username='$user_username'";
    $result = mysqli_query($database,$sql) or die(mysqli_error($database)); 
    $row = mysqli_fetch_array($result);
?>             <br />
<form action="components/add-new-video-post.php" method="post" enctype="multipart/form-data" id="UploadForm">
  <br />
<div class="form-group">
        <label for="video-created"></label> <br />
<//---img src="userfiles/avatars/<?php echo $row['user_avatar'];?>" style="height: 32px;<br />
width: 32px;<br />
font-size: 37px"><br />
<?php echo $row['user_username'];?> <br />
<?php

?><br />
</div>
<div class="form-group">
        <label for="video-link"></label><br />
<div class="form-group">
<label for="video-name"></label><br />
<input name="video_created" type="hidden" id="video_created"class="btn btn-default"value="
 <?php echo $row['user_username'];?>"/> <br />
</div>
<div class="form-group">
        <label for="video-body"></label><br />
<textarea id="video-body" rows="9" class="form-control" placeholder="Jelaskan" name="video_body"/><br />
<//----textarea><br />
</div>
<label for="video-link"></label><br />
<input name="video_link"type="text" id="video_link"class="btn btn-default"value=""/><br />
</div>
<div id="imagePreview">
 <input name="BackgroundImageFile" type="file" id="uploadBackgroundFile"/>    <br />
<//__button type="submit" class="btn btn-primary" name="submit_button" id="submit_button">Submit<//---button
    style=" float: left; 
 width: 80px;
 height: 32px;"/><br />
</form>
</div>
</div>
</div>
<br />

Conroh Input data

Menulis kedalam database table video_file

melempar tautan sebagi berikut
contoh
💻Root folder
📂components

add-new-video-post-form.php

<br />
<?php
    ini_set("display_errors",1);
    session_start();
    $user_username=$_SESSION['user_username'];
    if($_SERVER['REQUEST_METHOD'] == 'POST'){
        require '../_database/database.php';
$video_link=$_REQUEST['video_link'];
$video_body=$_REQUEST['video_body'];

$Destination = '../userfiles/videos';
        if(!isset($_FILES['BackgroundImageFile']) || !is_uploaded_file($_FILES['BackgroundImageFile']['tmp_name'])){
            $BackgroundNewImageName= '';
move_uploaded_file($_FILES['BackgroundImageFile']['tmp_name'], "$Destination/$BackgroundNewImageName");
        }
        else{
            $RandomNum = rand(0, 9999999999);
            $ImageName = str_replace(' ','-',strtolower($_FILES['BackgroundImageFile']['name']));
            $ImageType = $_FILES['BackgroundImageFile']['type'];
            $ImageExt = substr($ImageName, strrpos($ImageName, '.'));
            $ImageExt = str_replace('.','',$ImageExt);
            $ImageName      = preg_replace("/\.[^.\s]{3,4}$/", "", $ImageName);
            $BackgroundNewImageName = $ImageName.'-'.$RandomNum.'.'.$ImageExt;
move_uploaded_file($_FILES['BackgroundImageFile']['tmp_name'], "$Destination/$BackgroundNewImageName");
        }
        $sql="INSERT INTO video_file(
video_created,

video_link,
video_body,
video_time,
video_image
) VALUES (
'$user_username', 
'$video_link',
'$video_body',
 CURRENT_TIMESTAMP,
'$BackgroundNewImageName')";
        mysqli_query($database,$sql)or die(mysqli_error($database));
        header("location:../forum-topic.php?forum_topic_id=".mysqli_insert_id($database)."&request=add-new-forum-post&status=success");
    }    
?><br />
<br />

Locasi destinasi Folder/file
💻Root folder
📂userfiles

📂videos
📽️Youvideo
Untuk hasil baik perhatikan besar dan kecil file video
dapat merubah code apa bila didalam server PhpMyadmin config untuk Memiliki akses kesan lain waktu kita akan membahas itu.
batas maksimal Uplod +-10Mb

Cara kerja untuk mengetahui jumlah penonton video atau
Menghitung Jumlah Pengunjung halaman
Atau lihat code home.php meletakan button sebagai tipuan video

Contoh code

home.php

<br />
<br />
<?php
    $sql = "SELECT * FROM video_file ORDER BY video_time DESC";
    $result = mysqli_query($database,$sql);
    while($rws = mysqli_fetch_array($result)){
        $temp_user_username = $rws['video_created'];
        $sql_search_username = "SELECT * FROM user WHERE user_username = '$temp_user_username'";
        $result_search_username = mysqli_query($database,$sql_search_username) or die(mysqli_error($database));
        $rws_search_username = mysqli_fetch_array($result_search_username);
?>     <br />
<//---img class="img-circle" src="userfiles/avatars/<?php echo $rws_search_username['user_avatar'];?>" class="" alt="<?php echo $rws_search_username['user_usernamr'];?> <br />
<?php echo $rws_search_username['user_lastname'];?>alt="Generic placeholder image" style="<br />
width: 37px;<br />
height: 37px;<br />
box-shadow:3px 3px 3px 3px #00FFFF;      <br />
left: calc(50% - 7px);<br />
top: calc(50% - 6px);<br />
border: 2px solid;<br />
background: #C0C0C0;<br />
" ><br />
<a href="profile.php?user_username=<?php echo $rws_search_username['user_username'];?> " style="font-size: 10px;co<br />
or: black"/><br />
<?php echo $rws_search_username['user_username'];?><br />
</a><br />
<i class=""  style="font-size: 10px;co
or: black;">           <br />
<?php echo $rws_search_username['user_country']?></i></a><br />
</div>
<div id="logo_title">
</div>
<div id="logo_slogan">
<form action="video_eye.php?video_id=<?php echo $rws['video_id'];?>
" method="post" enctype="multipart/form-data" id="UploadForm"><br />
<input type="hidden" name="video_eye_by_id" value="<?php echo $rws['video_id']?>"/><br />
<input type="hidden"name="video_eye_name" value="<?php echo  $rws['video_created']?>"/><br />
<input type="hidden" name="video_eye_body" value="<?php echo $rws['video_body']?>"/><br />
<//--button type="submit" class="primary" name="submit_button" id="submit"/><br />
<div class="well">
<div class="row clearfix"style="box-shadow:1px 3px 2px 1px #ADC2B3;border: 1px solid;">
<hr class=""  style="font-size: 18;color: black;"/>
  <br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<?php echo $rws['video_body']?><br />
<br />
<br />
<?php                           if($rws['video_image'])
{
?><br />
<//---video width="320" height="240" controls> <br />
<source src="/userfiles/videos/<?php echo $rws['video_image'];?>"type="video/mp4"><br />
<source src="<?php echo $rws['video_image'];?>" type="video/mp4">Video<br />
<?php echo $rws_search_username['user_username'];?> <br />
</video><br />
<?php
}
?><br />
<?php                           if($rws['video_link'])
{
?><br />
<a href="<?php echo $rws['video_link'];?>"class<br />
="fa fa-angle-double-right"><br />
</a><br />
<?php
}
?><br />
<br />
<//----button><br />
</form>
<div/><?php
}
?><br />

Show video Current user

Mengandung button input data for table
video_eye yang tersembunyi didalam
tipuan code tak buton

terlihat seperti ini arah jalur tautan

menjaga nilai asli id berdasarkan table video_file /video_id

Menyampaikan jumlah pengunjung kedalam database

video_eye.php

Lenparan arah jalurur button pada halam /file home.php
kedalam file video_eye.php
Siapa saja yang melihat dari mana-mana akan terhitung kedalam database sebagai anonim user tamu jika meraka membuka video

arah jalur lemparan pada file video_eye.php setelah berhasil menulis
video_id dari table video_file sebagai pemain dan menjaga nilai asli id meraka masing-masing

header('Location: video_myeye.php?video_id='.$video_id);
Finising code yang menunjukan jumlah penonton ,comentar ,penguna mereka disana.
Contoh

video_myeye.php

<br />
<br />
<?php include 'components/authentication.php' ?>    <br />
<?php include 'controllers/base/head.php' ?><br />
<?php

require '_database/database.php';
    if($_SESSION['user_username']){
?><br />
<?php include 'controllers/navigation/first-navigation.php' ?><br />
<?php
    }
    else{
?><br />
<?php include 'controllers/navigation/index-before-login-navigation.php' ?><br />
<?php
    }
?><br />
<?php

$current_user = $_SESSION['user_username'];
    $video_id = mysqli_real_escape_string($database,$_REQUEST['video_id']);
    $sql = "SELECT * FROM video_file where video_id = '$video_id'";
    $result = mysqli_query($database,$sql);
    $rws = mysqli_fetch_array($result);
                    
    $temp_user_username = $rws['video_created'];
    $sql_search_username = "SELECT * FROM user WHERE user_username = '$temp_user_username'";
    $result_search_username = mysqli_query($database,$sql_search_username) or die(mysqli_error($database));
    $rws_search_username = mysqli_fetch_array($result_search_username);
?><br />
<body style="
 box-shadow:1px 3px 2px 1px #C0C0C0;
 border: 1px solid;
" ><br />
<div class="container">
            <div class="panel panel-default">
                <div class="panel-body"style="
 box-shadow:1px 3px 2px 1px #00FFFF;

border: 1px solid;

" >
              <br />
<div class="panel-body">
                        <div class="row clearfix">
                            <div class="col-md-12 column"style="
 box-shadow:1px 3px 2px 1px #C0C0C0;

border: 1px solid;
 background: #00FFFF;
" >
<img class="img-circle" src="userfiles/avatars/<?php echo $rws_search_username['user_avatar'];?>" class="" alt="<?php echo $rws_search_username['user_usernamr'];?> <br />
<?php echo $rws_search_username['user_lastname'];?>alt="Generic placeholder image" style="<br />
width: 37px;<br />
height: 37px<br />
box-shadow:3px 3px 3px 3px #00FFFF;      <br />
left: calc(50% - 7px);<br />
top: calc(50% - 6px);<br />
border: 2px solid;<br />
background: #C0C0C0;<br />
" ><br />
<a href="profile.php?user_username=<?php echo $rws_search_username['user_username'];?> " style="font-size: 20px;"/><br />
<?php echo $rws_search_username['user_username'];?><br />
</a><br />
</div>
</i><i class=""  style="font-size: 1.0em;"><br />
</i><br />
</div>
<hr/><?php echo $rws['video_body'];?><br />
<div class="forum-attachment">
                                    <?php
                                        if($rws['video_image']){
                                    ?><br />
<br />
<div class="col-md-3 column">
                                       <br />
<br />
<br />
<br />
<?php                           if($rws['video_image'])
{
?><br />
<video width="320" height="240" controls> <br />
<source src="/userfiles/videos/<?php echo $rws['video_image'];?>"type="video/mp4"><br />
<source src="<?php echo $rws['video_image'];?>" type="video/mp4">Video<br />
<?php echo $rws_search_username['user_username'];?> <br />
</video><br />
<?php
}
}
?><br />
<br />
</div>
<div/><br />
<br />
<?php
$servername = "localhost"; 
$username = "root"; 
$password = "kangdeny11";
$dbname = "userprofile";
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error)<br />
{ die("Connection failed: " . $conn->connect_error); <br />
} <br />
$sql = "SELECT count(*) as count from video_eye where video_eye_by_id = '$video_id'";<br />
$result = $conn->query($sql); <br />
if ($result->num_rows > 0) { <br />
$row = $result->fetch_assoc(); <br />
?><br />
</div>
</div>
<?php
echo" <i class='fa fa-eye' style='font-size:19px;'> ".$row['count']."</i>";<br />
}<br />
else { echo "0 results";<br />
}<br />
$conn->close()<br />
?>          <br />
</i>   <br />
<?php 
    $sql_reply = "SELECT * FROM video_reply where video_reply_by_id = '$video_id'";
    $result_reply = mysqli_query($database,$sql_reply);
    $rws_reply_count = mysqli_num_rows($result_reply);
    while($rws_reply = mysqli_fetch_array($result_reply)){
        
        $temp_user_username_reply = $rws_reply['video_reply_name'];
        $sql_search_username_reply = "SELECT * FROM user WHERE user_username = '$temp_user_username_reply'";
        $result_search_username_reply = mysqli_query($database,$sql_search_username_reply); 
        $rws_search_username_reply = mysqli_fetch_array($result_search_username_reply);

?><br />
<br />
<?php
        if($rws_reply_count > 0){<br />
?><br />
<div class="container" style="
background-image:!important;
">
                         <div class="row clearfix">
              <div class="panel-body"style="
 box-shadow:1px 3px 2px 1px #00FFFF;

border: 1px solid;

" >
<img class="img-circle" src="userfiles/avatars/<?php echo $rws_search_username_reply['user_avatar'];?>" class="" alt="<?php echo $rws_search_username_reply['user_usernamr'];?> <br />
<?php echo $rws_search_username_reply['user_lastname'];?>alt="Generic placeholder image" style="<br />
width: 37px;<br />
height: 37px;<br />
" ><br />
<?php
echo "
<img src='assets/img/ajax-loader.gif'alt='Generic placeholder image'style='
    width: 3px;
 height: 3px;
'/>";<br />
?>    <br />
<br />
<a href="profile.php?user_username=<?php echo $rws_reply['video_reply_name'];?> "><i  style="font-size: 18px;"><br />
<?php echo $rws_reply['video_reply_name'];?><br />
</a> <br />
<?php echo $rws_reply['video_reply_title'];?></i><br />
<i  style="font-size: 8px;"><br />
<?php echo $rws_reply['video_reply_time'];?></i><br />
<?php                   if($rws_reply['video_reply_image']){
                                    ?><br />
<img src="userfiles/videos/<?php echo $rws_reply['video_reply_image'];?>"  class="img-responsive thumbnail"><br />
<br />
<?php
}
?><br />
</div>
<?php
}
?>    <br />
</div>
</div>
<?php
}
?>            <br />
</div>
</div>
<br />
<?php
  
    require '_database/database.php';
    if($_SESSION['user_username']){
?><br />
<br />
<br />
<div class="container">
                        <div class="row clearfix">
<?php include 'controllers/form/video_reply.php' ?><br />
</div>
</div>
</div>
</div>
</div>
<?php
    }
    else{
?><br />
<div class="well">
                        <div class="row clearfix">
                            <div class="col-md-12 column">
                                <h3 class="text-center">
You need to <a href="login.php">Log In</a> or <a href="register.php">Register</a> to post comments.</h3>
</div>
</div>
</div>
<?php
    }
?><br />
<br />
<br />

Banya code perlu ditambahkan
ini semua merupakan sebuah contoh
jika memiliki cara lain tentu akan lebih baik .

input komentar

Bisa memangil dengan metode includ panggilan magic
💻Root folder
📂controlers

📂form

video_reply.php

<br />
<?php
 $video_id = mysqli_real_escape_string($database,$_REQUEST['video_id']);
    $sql = "SELECT * FROM video_file where video_id = '$video_id'";
    $result = mysqli_query($database,$sql);
    $rws = mysqli_fetch_array($result);
    $temp_user_username = $rws['video_created'];
    $sql_search_username = "SELECT * FROM user WHERE user_username = '$temp_user_username'";
    $result_search_username = mysqli_query($database,$sql_search_username) or die(mysqli_error($database));
    $rws_search_username = mysqli_fetch_array($result_search_username);
?><br />
<form action="components/video_reply.php?video_id=<?php echo $rws['video_id'];?>
" method="post" enctype="multipart/form-data" id="UploadForm"><br />
<input type="hidden" class="form-control" placeholder="<?php echo $rws['video_body'];?>" name="video_reply_body" value="<?php echo $rws['video_body'];?>"><br />
<//__textarea id="video-reply-titel" rows="4" class="form-control" placeholder="Comment" name="video_reply_title" alt="Comment" style="
    width: 300px;
 height: 30px;
" ><//___textarea><br />
<input name="BackgroundImageFile" type="file" id="uploadBackgroundFile" class="btn btn-default" name="forum-topic-attachment"alt="Generic placeholder image" style="
    width: 200px;
 height: 37px;
 box-shadow:3px 3px 3px 3px #ADC2B3;   
 border: 2px solid;
 background: none;
" ><br />
<//__button type="submit"  name="submit_button" id="submit_button" alt="Generic placeholder image" style="
    width: 100px;
 height: 37px
 box-shadow:3px 3px 3px 3px #ADC2B3; 
 border: 2px solid;
 background: gren;
" ><br />
Post<//__button><br />
</form>

Menggunakan cara yang hampir sama dengan .
Reply Comment
Sembunyikan username dengan metode text="hidden"
menja nilai asli dari id,username
melempar tautan

💻Root folder
📂components

video_reply.php

Tandatangan seperti pengikatv
$ideo_id
$username
Benar Menulis mereka dan pertahankan nilai asli dari table video_file berdasarkan video_id dn username masing-masing .
$video_id = mysqli_real_escape_string($database,$_REQUEST['video_id']);
$video_id_temp = $video_id;
$user_username=$_SESSION['user_username'];
Menarik dan menyimpan file sebagai destinasi
kedalam folder
$Destination = '../userfiles/videosimg';
💻Root folder
📂userfiles

📂videosimg

DATA BARU

Video Pos And Show Video Source in Websit

Posting Komentar untuk "Video Pos And Show Video Source in Websit"

Menu Halaman Statis