Share Public Post Freen php

Table of Contents

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

<br />phpMyAdmin SQL Dump<br />-- version 3.5.3<br />-- http://www.phpmyadmin.net<br />--<br />-- Host: localhost<br />-- Generation Time: May 23, 2020 at 01:47 AM<br />-- Server version: 5.1.62<br />-- PHP Version: 5.4.8<br /><br />-- --------------------------------------------------------<br /><br />--<br />-- Table structure for table `share_public_freen`<br />--<br /><br />CREATE TABLE IF NOT EXISTS `share_public_freen` (<br />`share_public_freen_id` int(11) NOT NULL AUTO_INCREMENT,<br />`share_public_freen_by_id` varchar(100) NOT NULL,<br />`share_public_freen_created` varchar(300) NOT NULL,<br />`share_public_freen_username` varchar(200) NOT NULL,<br />`share_public_freen_body` varchar(4000) NOT NULL,<br />`share_public_freen_file` varchar(300) NOT NULL,<br />`share_public_freen_date` date NOT NULL,<br />PRIMARY KEY (`share_public_freen_id`)<br />) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=55 ;<br />//Hapus Tak <br /><br /><br />

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

<br /><br /><form action="components/share_public_freen.php?video_id=<?php echo $rws_search_username['video_id'];?>" method="post" enctype="multipart/form-data" id="UploadForm"><br /><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'];?>"><br /><input type="hidden" class="form-control" placeholder="<?php echo $rws_search_username['video_created'];?>"<br />name="share_public_freen_username" value="<?php echo $rws_search_username['video_created'];?>"><br /></a><br /><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'];?>"><br /><br /><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'];?>"><br /><//--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']){?><br /><?php echo $rws_search_share_id_reply['count'];?><br /><?php } ?><br /><//--button><br /></form>//--Hapus Tak <br /><br />

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 <br />

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

<br /><?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); ?><br /><br /><?php if($rws_search_share_created['share_public_freen_file']) { ?><br /><div class="container"> <div class="no-gutter row"> <div class="col-md-12"> <div class="panel panel-default" id="sidebar"> <div class="panel-body"><br /><?php if ($rws_search_report_conten_id['report_conten_background']){ ?><br /><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; } 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><br /><?php if($rws_search_report_conten_id['report_conten_background']) { ?><br /><report class="container"style=" "><br /><report class="no-gutter row"style="" ><br /><report class="col-md-12"><br /><report class="panel panel-default" id="sidebar"><br /><report class="panel-body"style="" ><br /><br /><?php } ?><br /><br /><?php } ?><br /><span class="dropdown-group-addon"style=""><br /><a href="#" class="dropdown-toggle" data-toggle="dropdown"><br /><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'];?>"<br />style="width: 37px;height: 37px;"><br /><?php echo $rws_search_share_created_reply['user_username'];?><br />🔀 Shared<br /><?php echo $rws_search_share_created['share_public_freen_date']; ?><br /></a><br /><span class="dropdown-menu"><br /><span><br /></a> <br /><span class="input-group"><br /><span class="input-group"><br /><div/><i class=""><br /></i><br /></a><br /><span><br /><br /><i class=""><br /></i><br /></a><br /></span><br /></span><br /></ul></span><br /><br /><i class="" style="font-size: 18px;co or: black;"> <br /><a href="userfiles/avatars/<?php echo $rws_search_share_created_reply['user_avatar'];?>"><br /><i style="font-size: 18px;"><br /><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><br /><i style="font-size: 18px;color:black;"><br /><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><br /><i class="" style="font-size: 10px;co or: black;"> <br /><?php echo $rws_search_share_created_reply['user_country']?></i></a> <br /><i class="" style="font-size: 10px;co or: black;"> <br /><?php echo $rws_search_share_created['share_public_freen_date']; ?><br /></i> <br /><br /><br /><i class="" style="font-size: 18px;co or: black;"><br />🔀<br /><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><br /><i style="font-size: 18px;color:black;"><br /><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><br /><i span class=""style="font-size: 8px;color:black;"><br /><i class="" style="font-size: 10px;co or: black;"><br /></i><br /><?php require '_database/database.php'; if($_SESSION['user_username']=$row['user_username']=$rws_search_share_created['share_public_freen_created']){ ?><br /><a href="dellet_user_share.php?share_public_freen_id=<?php echo $rws_search_share_created['share_public_freen_id']?><br /><i style="font-size: 10px;color: black;">🗑️<br /></a></i><br /><?php } ?><br /></a><br /><br /><br /><i style="font-size: 18px;color: black;"> <br /><?php echo $rws_search_share_created['share_public_freen_body']?><br /></i><br /><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"><br /><input type="hidden" name="video_eye_by_id" value="<?php echo $rws_search_username['video_id']?>"/><br /><input type="hidden"name="video_eye_name" value="<?php echo $rws_search_username['video_created']?>"/><br /><input type="hidden" name="video_eye_body" value="<?php echo $rws_search_username['video_body']?>"/> <br /><button type="submit" name="submit_button" id="submit" id="report"><br /><?php if($rws_search_share_created['share_public_freen_file']) { ?><br /><video alt="Generic placeholder image" style="width:358px; height: 300px;"<?php if ($rws_search_report_conten_id['report_conten_background']){ ?>/><?php } ?>controls><br /><source src="/userfiles/uploads/<?php echo $rws_search_share_created['share_public_freen_file'];?>"type="video/mp4"><br /><source src="<?php echo $rws_search_share_created['share_public_freen_file'];?>" type="video/mp4"<br />>Video<br /><?php echo $rws_search_share_created['share_public_freen_file'];?> <br /></video><br /></i></a><br /><?php if ($rws_search_report_conten_id['report_conten_background']){ ?><div/><a href="report_conten.php?user_username=<?php echo $user_username;?>"><br /><br /><img class="img-circle" src="userfiles/report_conten_background/<?php echo $rws_search_report_conten_id['report_conten_background']?>"/><br /></a><br /><?php } ?><br /></button><br /></form></i><br /></i><br /><br /><br /><?php if($rws_search_username['video_link']) { ?><br /><a href="<?php echo $rws_search_username['video_link'];?>"class<br />="fa fa-angle-double-right"><br /><?php } ?><br /><i class="class ="fa fa-angle-double-right"> <br /></a></i><br /><i style=""><br /><br /><?php if($rws_search_video_eye_id_reply['count']){?><i class="fa fa-eye"><br /><?php echo $rws_search_video_eye_id_reply['count']; ?><br /><?php } ?><br /><br /></i><br /><br /><i style=""><br /><i class='' style='font-size:15px;'><br /><?php if($rws_search_video_like_id_reply['count']){?>👍<br /><?php echo $rws_search_video_like_id_reply['count']; ?><br /><?php } ?><br /><br /></i><br /><br /><i style=""><br /><i class='' style='font-size:15px;'><br /><?php if($rws_search_video_diclike_id_reply['count']){?>👎<br /><?php echo $rws_search_video_diclike_id_reply['count']; ?><br /><?php } ?><br /><br /></i><br /><span class="dropdown-group-addon"style=""><br /><a href="#" class="dropdown-toggle" data-toggle="dropdown"style="font-size: 15px" background: #00FFFF;"><br /><br /><span class="dropdown-group-addon"style=""><br /><a href="#" class="dropdown-toggle" data-toggle="dropdown"style="font-size: 15px" background: #00FFFF;"><br /><br /><?php if($rws_search_video_id_reply['count']){?>💬<br /><?php echo $rws_search_video_id_reply['count'];?><br /><?php } ?><br /><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"><br /><br /><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'];?>"><br /><br /><input type="hidden" class="form-control" placeholder="<?php echo $rws_search_share_username_reply['user_username'];?>"<br />name="share_public_freen_username" value="<?php echo $rws_search_share_username_reply['user_username'];?>"><br /></a><br /><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'];?>"><br /><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'];?>"><br /><//--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']){?><br /><?php echo $rws_search_share_by_id_reply['count'];?><br /><?php } ?><br /><//--button><br /></form><form action="components/video_reply.php?video_id=<?php echo $rws_search_username['video_id'];?>" method="post" enctype="multipart/form-data" id="UploadForm"><br /><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'];?>"><br /><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'];?>"><br /><//--textarea id="user-messages" rows="4" placeholder="Tulis Pesan" name="video_reply_title"style=" width: 95px; height: 28px;"/><//--textarea><br /><br /><//--button type="submit" class="primary" name="submit_button" id="submit" style=" float: left; width: 80px; height: 28px;"/> Kirim <//---button><br /></form><a href="profile.php?user_username=<?php echo $rws_search_username_reply_reply['user_username'];?>"><br /></a><br /><span class="dropdown-menu" style="font-size: 15px; border: px solid; background: #00FFFF;"><br /><?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); ?><br /><span><br /></a> <br /><span class="input-group"style="font-size: 15px; border: px solid; background: #00FFFF;"><br /><span class="input-group"style="font-size: 15px; border: px solid; background: #00FFFF;"><br /><img src="userfiles/avatars/<?php echo $rws_search_username_reply['user_avatar'];?>"alt="Generic placeholder image"<br />style="width: 18px;height: 18px;"><br /><br /><a href="profile.php?user_username=<?php echo $rws_search_username_reply['user_username'];?>"> <br /><?php echo $rws_search_username_reply['user_username'];?></a>: <br /><a href="video_myeye.php?video_id=<?php echo $rws_search_username['video_id'];?>"><br /><?php echo $rws_search_video_id_reply['video_reply_title'];?><br /></a></span> <br /><br /><a href="userfiles/videosimg/<?php echo $rws_search_video_id_reply['video_reply_image'];?>"><br /></span><br /><?php if($rws_search_video_id_reply['video_reply_image']){ ?><br /><img src="userfiles/videosimg/<?php echo $rws_search_video_id_reply['video_reply_image'];?>" alt="Generic placeholder image" <br />style="<br />height: 32px;"><br /></a> <br /><?php } } ?><br /><div/><i class=""><br /></i><br /></a><br /><span><br /><br /><i class=""><br /></i><br /></a><br /></span><br /></span><br /></ul></span> <br /></div></div></div></div></div></div></div><?php } ?><br /></div></div></div></div></div></div></div><?php } } ?> <br /></div></div></div></div></div></div></div><br /><?php ?> <br /><br /><br /><br /><br />

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

<?php require '_database/database.php'; $share_public_freen_id = mysqli_real_escape_string($database,$_REQUEST['share_public_freen_id']); $share_public_freen_by_id = mysqli_real_escape_string($database,$_REQUEST['share_public_freen_by_id']); $current_user = mysqli_real_escape_string($database,$_REQUEST['user_username']); $share_public_freen_id_temp = $share_public_freen_id; $share_public_freen_by_id_temp = $share_public_freen_by_id; $curren_user_temp = $user_username; $sql = "SELECT * FROM share_public_freen where share_public_freen_id = '$share_public_freen_id'"; $result = mysqli_query($database,$sql); $rws = mysqli_fetch_array($result); $query = "DELETE FROM share_public_freen WHERE share_public_freen_id='".$share_public_freen_id."'"; $sql= mysqli_query($database, $query); if($sql){ header('Location: home.php?user_username='.$username); } ?>//Hapus Tak <br/>

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

7.video_diclike

8.video_reply

9.report_conten

Unduh Semua Table database
Untuk menghamparkan semua kode
gunakan text editor

Terimakasi.