Share Public Post Freen php

Hay gaess....

Selamat Hari Raya Idul Fitri Mohon maaf lahir dan batin .

Langsung saja.

Kamu yang barusaja menemukan artikel ini

baca

Menjalankan Kode html/php Secara manual localhost

baru

Server websit Localhos hp andeoid via penguin server

Semua code script,php dan html componen websit pemula

unduh simpan gratis.

Apa yang saya tulis diaini sudah saya uji dan beejalan dengan baik.

Untuk teman-teman yang baru belajar seperti saya.

Komentar dan saran saya terima dengan senang hati.

Lanjut.

1.Share Public Post Freen php

Yang dimaksut Share Public Post Freen

adalah

Membagikan artikel/post konten deri daftar shut/teman yang kamu ikuti, yang dapat melihat konten ,termasuk shuters/pengikut dan user count/member database websit.
Untuk Opsi shared Video_file.

A.Membuat table shared_public_freen.sql
Contoh:

shared_public_freen.sql

2.input tabel shared_public_freen

Tipuan input hidden text didalam button (🔀) in button

akan tetap bisa bekerja tanpa terlihar

Contoh

code input shared_public_freen

<form action="components/share_public_freen.php?video_id=<?php echo $rws_search_username['video_id'];?>
" method="post" enctype="multipart/form-data" id="UploadForm"> 
<input type="hidden" class="form-control" placeholder="<?php echo $rws_search_username['video_id'];?>" name="share_public_freen_by_id" value="<?php echo $rws_search_username['video_id'];?>"> 
<input type="hidden" class="form-control" placeholder="<?php echo $rws_search_username['video_created'];?>" 
name="share_public_freen_username" value="<?php echo $rws_search_username['video_created'];?>"> 
</a> 
<input type="hidden" class="form-control" placeholder="<?php echo $rws_search_username['video_body'];?>" name="share_public_freen_body" value="<?php echo $rws_search_username['video_body'];?>"> 
 
<input type="hidden" class="form-control" placeholder="<?php echo $rws_search_username['video_image'];?>" name="share_public_freen_file" value="<?php echo $rws_search_username['video_image'];?>"> 
<//--button type="submit" class="primary" name="submit_button" id="submit" style=" float: left; 
 width: 80px;
 height: 28px;"/>🔀 <?php 
if($rws_search_share_id_reply['count']){?> 
<?php 
echo
$rws_search_share_id_reply['count'];?> 
<?php
}
?> 
<//--button> 
</form>
//--Hapus Tak

letakan code pada bagian post konten yang mudah terlihat
membiarkan code pada tempat aslinya mungkin akan terlihat seperti ini dari contoh code.

Lemparan tautan untuk table shared_public_freen

("action="./share_public_freen.php?video_id=video_id")

membuat nama file sama dan meletakan kedalam folder yang berbeda.

Tiang landasan untuk pasport masuk INSERT table shared_public_freen,

mengunakan id dari table video_file.

B.INSERT Shared_public_freen

Contoh:

💻Root folder

home/input_shared_public_freen

📂components

add-new-video-post-form.php

<?php
 ini_set("display_errors",1);
 session_start();
 $user_username=$_SESSION['user_username'];
 if($_SERVER['REQUEST_METHOD'] == 'POST'){
 require '../_database/database.php';
$video_id = mysqli_real_escape_string($database,$_REQUEST['video_id']);
$video_id_temp = $video_id; 
$share_public_freen_by_id=$_REQUEST['share_public_freen_by_id'];

$share_public_freen_username=$_REQUEST['share_public_freen_username'];
$share_public_freen_body=$_REQUEST['share_public_freen_body'];
$share_public_freen_file=$_REQUEST['share_public_freen_file'];

$sql="INSERT INTO share_public_freen(
share_public_freen_by_id,
share_public_freen_created, 
share_public_freen_username,
share_public_freen_body,
share_public_freen_file,
share_public_freen_date) VALUES (
'$video_id',
'$user_username',
'$share_public_freen_username',
'$share_public_freen_body',
'$share_public_freen_file',
CURRENT_TIMESTAMP)";
 mysqli_query($database,$sql)or die(mysqli_error($database));
header('Location: ../home.php?user_username='.$user_username);
 } 
?>//Hapus Tak

Jika berhasil menulis kedalam database,header lokasi melempar kedapam halaman rumah.

3.Memangil Data Dan Mod Style/Boostrap Drobdown

Rws== temp Pelunak data

include_shared.php

<?php
require '_database/database.php';
$temp_share_id_reply= $rws_search_username['video_id'];
$sql_search_share_id_reply= "SELECT count(*) as count from share_public_freen where share_public_freen_by_id = '$temp_share_id_reply'";
$result_search_share_id_reply= mysqli_query($database,$sql_search_share_id_reply) or die(mysqli_error($database));
$rws_search_share_id_reply = mysqli_fetch_array($result_search_share_id_reply);

$temp_user_share_id= $rws_search_username['video_id'];
$sql_search_share_id = "SELECT * FROM share_public_freen WHERE share_public_freen_by_id = '$temp_user_share_id'";
$result_search_share_id = mysqli_query($database,$sql_search_share_id); 
$rws_search_share_id= mysqli_fetch_array($result_search_share_id);

$temp_user_share_created = $rws['user_follow_video_username'];
$sql_search_share_created = "SELECT * FROM share_public_freen WHERE share_public_freen_created = '$temp_user_share_created' ORDER BY share_public_freen_date DESC";  
$result_search_share_created = mysqli_query($database,$sql_search_share_created);
  $rws_search_share_created = mysqli_num_rows($result_search_share_created);
   while($rws_search_share_created= mysqli_fetch_array($result_search_share_created)){

$temp_user_share_created_reply = $rws_search_share_created['share_public_freen_created'];
$sql_search_share_created_reply = "SELECT * FROM user WHERE user_username = '$temp_user_share_created_reply'";
$result_search_share_created_reply = mysqli_query($database,$sql_search_share_created_reply); 
$rws_search_share_created_reply= mysqli_fetch_array($result_search_share_created_reply);

$temp_user_share_username_reply = $rws_search_share_created['share_public_freen_username'];
$sql_search_share_username_reply = "SELECT * FROM user WHERE user_username = '$temp_user_share_username_reply'";
$result_search_share_username_reply = mysqli_query($database,$sql_search_share_username_reply); 
$rws_search_share_username_reply= mysqli_fetch_array($result_search_share_username_reply);
$temp_share_by_id_reply= $rws_search_username['video_id'];
$sql_search_share_by_id_reply= "SELECT count(*) as count from share_public_freen where share_public_freen_by_id = '$temp_share_by_id_reply'";
$result_search_share_by_id_reply= mysqli_query($database,$sql_search_share_by_id_reply) or die(mysqli_error($database));
$rws_search_share_by_id_reply = mysqli_fetch_array($result_search_share_by_id_reply);
?> 
 
<?php if($rws_search_share_created['share_public_freen_file'])
{
?> 
<div class="container">
 <div class="no-gutter row">
 <div class="col-md-12">
 <div class="panel panel-default" id="sidebar">
 <div class="panel-body">
 
<?php
 if ($rws_search_report_conten_id['report_conten_background']){
?> 
<style>
 report{

background: linear-gradient( rgba(0, 0, 0, 0.0), rgba(0, 0, 0, 0.0) ), url("./userfiles/report_conten_background/<?php echo $rws_search_report_conten_id['report_conten_background']; ?>");
 background-repeat: no-repeat !important;
 background-attachment: fixed !important;
 background-size: 357px !important;
 margin-top: 0px !important;
 display: block !important;
body;
 }
 </style> 
<?php if($rws_search_report_conten_id['report_conten_background'])
{
?> 
<report class="container"style="
"> 
<report class="no-gutter row"style="" > 
<report class="col-md-12"> 
<report class="panel panel-default" id="sidebar"> 
<report class="panel-body"style="" > 
 
<?php
}
?> 
 
<?php
}
?> 
 
<a href="#" class="dropdown-toggle" data-toggle="dropdown"> 
<img class="" src="userfiles/avatars/<?php echo $rws_search_share_created_reply['user_avatar'];?>" class="" alt="<?php echo $rws_search_share_created_reply['user_username'];?>" 
style="width: 37px;height: 37px;"> 
<?php echo $rws_search_share_created_reply['user_username'];?> 
🔀 Shared 
<?php 
echo $rws_search_share_created['share_public_freen_date']; 
?> 
</a> 
 
 
</a> 
 
 
<div/> 
 
</a> 
 
 
 
 
</a> 
 
 
</ul>
 
 
 
<a href="userfiles/avatars/<?php echo $rws_search_share_created_reply['user_avatar'];?>"> 
 
<img class="img-circle" src="userfiles/avatars/<?php echo $rws_search_share_created_reply['user_avatar'];?>" class="" alt="<?php echo $rws_search_share_created_reply['user_username'];?>"alt="Generic placeholder image" style="width: 37px;height: 37px;"></a> 
 
<a href="profile.php?user_username=
<?php echo $rws_search_share_created_reply['user_username'];?>"><?php echo $rws_search_share_created_reply['user_username'];?></a> 
 
<?php echo $rws_search_share_created_reply['user_country']?></a> 
 
<?php 
echo $rws_search_share_created['share_public_freen_date']; 
?> 
 
 
 
 
🔀 
<img class="img-circle" src="userfiles/avatars/<?php echo $rws_search_share_username_reply['user_avatar'];?>" class="" alt="<?php echo $rws_search_share_username_reply['user_username'];?>"alt="Generic placeholder image" style="width: 37px;height: 37px;"></a> 
 
<a href="profile.php?user_username=
<?php echo $rws_search_share_username_reply['user_username'];?>"><?php echo $rws_search_share_username_reply['user_username'];?></a> 
 
 
 
<?php 
require '_database/database.php';
if($_SESSION['user_username']=$row['user_username']=$rws_search_share_created['share_public_freen_created']){
?> 
<a href="dellet_user_share.php?share_public_freen_id=<?php echo $rws_search_share_created['share_public_freen_id']?> 
🗑️ 
</a> 
<?php
}
?> 
</a> 
 
 
 
<?php echo $rws_search_share_created['share_public_freen_body']?> 
 
<div/><<?php 
if ($rws_search_report_conten_id['report_conten_background']){
?>//---<?php
}
?>form action="video_eye.php?video_id=<?php echo $rws_search_username['video_id'];?>" method="post" enctype="multipart/form-data" id="UploadForm"> 
<input type="hidden" name="video_eye_by_id" value="<?php echo $rws_search_username['video_id']?>"/> 
<input type="hidden"name="video_eye_name" value="<?php echo $rws_search_username['video_created']?>"/> 
<input type="hidden" name="video_eye_body" value="<?php echo $rws_search_username['video_body']?>"/> 
<button type="submit" name="submit_button" id="submit" id="report"> 
<?php if($rws_search_share_created['share_public_freen_file'])
{
?> 
<video alt="Generic placeholder image"
 style="width:358px;
 height: 300px;"<?php 
if ($rws_search_report_conten_id['report_conten_background']){
?>/><?php
}
?>controls> 
<source src="/userfiles/uploads/<?php echo $rws_search_share_created['share_public_freen_file'];?>"type="video/mp4"> 
<source src="<?php echo $rws_search_share_created['share_public_freen_file'];?>" type="video/mp4" 
>Video 
<?php echo $rws_search_share_created['share_public_freen_file'];?> 
</video> 
</a> 
<?php
 if ($rws_search_report_conten_id['report_conten_background']){
?><div/><a href="report_conten.php?user_username=<?php echo $user_username;?>"> 
 
<img class="img-circle" src="userfiles/report_conten_background/<?php echo $rws_search_report_conten_id['report_conten_background']?>"/> 
</a> 
<?php
}
?> 
</button> 
</form>
 
 
 
 
<?php if($rws_search_username['video_link'])
{
?> 
<a href="<?php echo $rws_search_username['video_link'];?>"class 
="fa fa-angle-double-right"> 
<?php
} 
?> 
 
</a> 
 
 
<?php 
if($rws_search_video_eye_id_reply['count']){?> 
<?php 
echo $rws_search_video_eye_id_reply['count'];
?> 
<?php
}
?> 
 
 
 
 
 
<?php 
if($rws_search_video_like_id_reply['count']){?>👍 
<?php 
echo
$rws_search_video_like_id_reply['count'];
?> 
<?php
}
?> 
 
 
 
 
 
<?php 
if($rws_search_video_diclike_id_reply['count']){?>👎 
<?php 
echo
$rws_search_video_diclike_id_reply['count'];
?> 
<?php
}
?> 
 
 
 
<a href="#" class="dropdown-toggle" data-toggle="dropdown"style="font-size: 15px"
 background: #00FFFF;"> 
 
 
<a href="#" class="dropdown-toggle" data-toggle="dropdown"style="font-size: 15px"
 background: #00FFFF;"> 
 
<?php 
if($rws_search_video_id_reply['count']){?>💬 
<?php 
echo
$rws_search_video_id_reply['count'];?> 
<?php
}
?> 
<form action="components/share_public_freen.php?video_id=<?php echo $rws_search_share_created['share_public_freen_by_id'];?>
" method="post" enctype="multipart/form-data" id="UploadForm"> 
 
<input type="hidden" class="form-control" placeholder="<?php echo $rws_search_share_created['share_public_freen_by_id'];?>" name="share_public_freen_by_id" value="<?php echo $rws_search_share_created['share_public_freen_by_id'];?>"> 
 
<input type="hidden" class="form-control" placeholder="<?php echo $rws_search_share_username_reply['user_username'];?>" 
name="share_public_freen_username" value="<?php echo $rws_search_share_username_reply['user_username'];?>"> 
</a> 
<input type="hidden" class="form-control" placeholder="<?php echo $rws_search_share_created['share_public_freen_body'];?>" name="share_public_freen_body" value="<?php echo $rws_search_share_created['share_public_freen_body'];?>"> 
<input type="hidden" class="form-control" placeholder="<?php echo $rws_search_share_created['share_public_freen_file'];?>" name="share_public_freen_file" value="<?php echo $rws_search_share_created['share_public_freen_file'];?>"> 
<//--button type="submit" class="primary" name="submit_button" id="submit" style=" float: left; 
 width: 80px;
 height: 28px;"/>🔀 <?php 
if($rws_search_share_by_id_reply['count']){?> 
<?php 
echo
$rws_search_share_by_id_reply['count'];?> 
<?php
}
?> 
<//--button> 
</form>
<form action="components/video_reply.php?video_id=<?php echo $rws_search_username['video_id'];?>
" method="post" enctype="multipart/form-data" id="UploadForm"> 
<input type="hidden" class="form-control" placeholder="<?php echo $rws_search_username['video_id'];?>" name="video_reply_by_id" value="<?php echo $rws_search_username['video_id'];?>"> 
<input type="hidden" class="form-control" placeholder="<?php echo $rws_search_username['video_body'];?>" name="video_reply_body" value="<?php echo $rws_search_username['video_body'];?>"> 
<//--textarea id="user-messages" 
rows="4" placeholder="Tulis Pesan" name="video_reply_title"style="
 width: 95px;
 height: 28px;"/><//--textarea> 
 
<//--button type="submit" class="primary" name="submit_button" id="submit" style=" float: left; 
 width: 80px;
 height: 28px;"/> Kirim <//---button> 
</form>
<a href="profile.php?user_username=<?php echo
$rws_search_username_reply_reply['user_username'];?>"> 
</a> 
 
<?php
$temp_video_id_reply= $rws_search_username['video_id'];
 $sql_search_video_id_reply= "SELECT * FROM video_reply where video_reply_by_id = '$temp_video_id_reply' order by video_reply_time LIMIT 25";
 $result_search_video_id_reply = mysqli_query($database,$sql_search_video_id_reply);
 $rws_search_video_id_reply = mysqli_num_rows($result_search_video_id_reply);
 while($rws_search_video_id_reply= mysqli_fetch_array($result_search_video_id_reply)){
 $temp_user_username_reply = $rws_search_video_id_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);
?> 
 
</a> 
 
 
<img src="userfiles/avatars/<?php echo $rws_search_username_reply['user_avatar'];?>"alt="Generic placeholder image" 
style="width: 18px;height: 18px;"> 
 
<a href="profile.php?user_username=<?php echo $rws_search_username_reply['user_username'];?>"> 
<?php echo $rws_search_username_reply['user_username'];?></a>: 
<a href="video_myeye.php?video_id=<?php echo $rws_search_username['video_id'];?>"> 
<?php echo $rws_search_video_id_reply['video_reply_title'];?> 
</a> 
 
<a href="userfiles/videosimg/<?php echo $rws_search_video_id_reply['video_reply_image'];?>"> 
 
<?php if($rws_search_video_id_reply['video_reply_image']){
?> 
<img src="userfiles/videosimg/<?php echo $rws_search_video_id_reply['video_reply_image'];?>" alt="Generic placeholder image" 
style=" 
height: 32px;"> 
</a> 
<?php
 }
}
?> 
<div/> 
 
</a> 
 
 
 
 
</a> 
 
 
</ul>
 
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php
 
 }
?> 
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php
 }
}
?> 
</div>
</div>
</div>
</div>
</div>
</div>
</div>
 
<?php
?>

Termasuk dalam contoh diatas menghitung jumlah

Count for table = id

$temp_share_by_id_reply= $rws_search_username['video_id'];
$sql_search_share_by_id_reply= "SELECT count(*) as count from share_public_freen where share_public_freen_by_id = '$temp_share_by_id_reply'";
$result_search_share_by_id_reply= mysqli_query($database,$sql_search_share_by_id_reply) or die(mysqli_error($database));
$rws_search_share_by_id_reply = mysqli_fetch_array($result_search_share_by_id_reply);

echo $rws_search_share_by_id_reply['count]; 🔀1

$temp_video_eye_id_reply= $rws_search_username['video_id'];

$sql_search_video_eye_id_reply= "SELECT count(*) as count from video_eye where video_eye_by_id = '$temp_video_id_reply'";
$result_search_video_eye_id_reply= mysqli_query($database,$sql_search_video_eye_id_reply) or die(mysqli_error($database)); $rws_search_video_eye_id_reply = mysqli_fetch_array($result_search_video_eye_id_reply);

echo $rws_search_video_eye_id_reply['count'];👁️

$temp_video_like_id_reply= $rws_search_username['video_id'];
$sql_search_video_like_id_reply= "SELECT count(*) as count from video_like where video_like_by_id = '$temp_video_id_reply'";
$result_search_video_like_id_reply= mysqli_query($database,$sql_search_video_like_id_reply) or die(mysqli_error($database));
$rws_search_video_like_id_reply = mysqli_fetch_array($result_search_video_like_id_reply);

echo $rws_search_video_like_id_reply['count']; 👍

$temp_video_diclike_id_reply= $rws_search_username['video_id'];
$sql_search_video_diclike_id_reply= "SELECT count(*) as count from video_diclike where video_diclike_by_id = '$temp_video_id_reply'";
$result_search_video_diclike_id_reply= mysqli_query($database,$sql_search_video_diclike_id_reply) or die(mysqli_error($database)); $rws_search_video_diclike_id_reply = mysqli_fetch_array($result_search_video_diclike_id_reply);

echo $rws_search_video_diclike_id_reply['count']; 👎

$temp_video_id_reply= $rws_search_username['video_id'];

$sql_search_video_id_reply= "SELECT count(*) as count from video_reply where video_reply_by_id = '$temp_video_id_reply'";
$result_search_video_id_reply= mysqli_query($database,$sql_search_video_id_reply) or die(mysqli_error($database)); $rws_search_video_id_reply = mysqli_fetch_array($result_search_video_id_reply);

echo rws_search_video_id_reply['count']; 💬

4.Dellet shared public freen =id

dellet_user_share.php

href="dellet_user_share.php?share_public_freen_id=echo $rws_search_share_created['share_public_freen_id'];🗑️

Table Database terhubung

Struktur table

1.user

2.user_follow

3.share_public_freen

4.video_file

5.video_eye

6.video_like