Image Post php

Updated: 02 Sep, 2021 • 0 • min read

Table of Contents

Alhamdulllilah... Baru bisa menulis kembali
Seperti biasa saya menjalankan code php dengan cara yang sudah sering sayang post pada awal membangun proyek.
Php Mysql server localhost 5.1.62 PhpMyAdmin versi 3. 5.3
Perlu di ingat berbeda versi tentu berbeda source code
aplikation dan untuk menikmati code cangih segera update versi terbaru dari PhpMyAdmin
Topic pembahasan kali ini Gallery php
Yang akan membedakan pada image post php kali ini adalah
membuat input image pada user/penguna kedalam daftar Gallery foto, user dan memangil data tetsebut muncul pada halaman home.php/rumah.
setiap user/penguna, tamu
dapat melihat ini.

Komentar, tombol suka, dan jumlah pasang mata mereka semua dapat melihat itu dan untuk respon image dapat melakukan seperti komentar dan mengarahkan suka jika sudah melakukan sebagai user/member.
Untuk membuat ini dapat bekerja mebutuhkan file
berikit ini
Membuat ruang khusus sepagai user aktif terlihat tempat privasi untuk memulai menulis kedalam table database segai diri sendiri sebut saja ini adalah
📄myprofile.php

<?php include 'components/authentication.php' ?> <?php include 'components/session-check.php' ?> <?php include 'controllers/base/head.php' ?> <?php include 'controllers/navigation/first-navigation.php' ?> <?php include 'controllers/base/style.php' ?> <?php $current_user = $_SESSION['user_username']; $user_username = mysqli_real_escape_string($database,$_REQUEST['user_username']); $profile_username=$rws['user_username']; ?> <?php $url = 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['PHP_SELF']; ?> <div class="profile"> <div class="row clearfix"><div class="profile"> <div class="fluid-container"> <?php include'images.php'?> <div id="navigation-input-group-addon" class="navbar-input-group-addon"> 🕵 </a> </div><div class="navbar-collapse collapse" id="navbar-collapse1"> <ul class="nav navbar-nav"><li> </li></ul> <center> <div class="media-body"><a class="pull-left" href="userfiles/avatars/<?php echo $rws['user_avatar'];?>"> </a> <div class="media-body"><div class="media-helding"><div class="list-group"><a href="#" class="list-group-item active"> Profil info</a> <a href="#" class="list-group-item"> Name    <?php echo $rws['user_username'];?> </a> <a href="#" class="list-group-item"> Kota: <?php echo $rws['user_country'];?> </a> <a href="#" class="list-group-item"> Rumah   <?php echo $rws['user_address'];?> </a> <a href="#" class="list-group-item"> gender   <?php echo $rws['user_gender'];?></a> <a href="#" class="list-group-item"> Bio    <?php echo $rws['user_dob'];?></a> </div></div></div><li class="dropdown"> <a href="#" class="dropdown-toggle" data-toggle="dropdown"> </a> <ul class="dropdown-menu"><li> </li></ul></li> </ul></div></div></div> <?php $sql="SELECT * FROM video_file WHERE video_created ='$user_username' 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); $rws_search_username= mysqli_fetch_array($result_search_username); $temp_video_id_reply= $rws['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); $temp_video_eye_id_reply= $rws['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); $temp_video_like_id_reply= $rws['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); $temp_video_diclike_id_reply= $rws['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); ?> <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; " > <a href="userfiles/avatars/<?php echo $rws_search_username['user_avatar'];?>"> <img class="img-circle" src="userfiles/avatars/<?php echo $rws_search_username['user_avatar'];?>" class="" alt="<?php echo $rws_search_username['user_username'];?> <?php echo $rws_search_username['user_lastname'];?>alt="Generic placeholder image" style=" width: 37px; height: 37px;"></a> <a href="profile.php?user_username= <?php echo $rws_search_username['user_username'];?> "><?php echo $rws_search_username['user_username'];?></a> <?php echo $rws_search_username['user_country']?></a> <?php echo $rws['video_time']; ?> <a href="video_dellet.php?video_id=<?php echo $rws['video_id'];?>"> 🗑️ Edit</a> <a href=""> 🗑️ Edit</a> <?php echo $rws['video_body']?> <form action="video_eye.php?video_id=<?php echo $rws['video_id'];?>" method="post" enctype="multipart/form-data" id="UploadForm"> <input type="hidden" name="video_eye_by_id" value="<?php echo $rws['video_id']?>"/> <input type="hidden"name="video_eye_name" value="<?php echo $rws['video_created']?>"/> <input type="hidden" name="video_eye_body" value="<?php echo $rws['video_body']?>"/> <---button type="submit" name="submit_button" id="submit" style=" background-color: #ffffff; size-fint:18px;"> <?php if($rws['video_image']) { ?> <div><--video class="img-responsive thumbnail" style=" width: 330px; height: 330px;" controls> <---source src="/userfiles/videos/<?php echo $rws['video_image'];?>"type="video/mp4"> <source src="<?php echo $rws['video_image'];?>" type="video/mp4" >Video <?php echo $rws['user_username'];?> </video> </a> </---button> </form> <?php } ?> Post <?php if($rws['video_link']) { ?> <a href="<?php echo $rws['video_link'];?>"class ="fa fa-angle-double-right"> </a> <?php } ?> <?php echo " ".$rws_search_video_eye_id_reply['count']." ️"; ?> </a> <a href="#" class="dropdown-toggle" data-toggle="dropdown"style="font-size: 15px"style="box-shadow:1px 3px 2px 1px #C0C0C0; border: 1px solid; background: #00FFFF;"/> <?php echo "👍 ".$rws_search_video_like_id_reply['count']." ️"; ?> </a> <?php $temp_video_like_id_reply= $rws['video_id']; $sql_search_video_like_id_reply= "SELECT * 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); $rws_search_video_like_id_reply = mysqli_num_rows($result_search_video_like_id_reply); while($rws_search_video_like_id_reply_like= mysqli_fetch_array($result_search_video_like_id_reply)){ $temp_user_username_reply = $rws_search_video_like_id_reply_like['video_like_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_like= mysqli_fetch_array($result_search_username_reply); ?> <a href="userfiles/avatars/<?php echo $rws_search_username_reply_like['user_avatar'];?>"> <img class="img-circle" src="userfiles/avatars/<?php echo $rws_search_username_reply_like['user_avatar'];?>" class="class="dropdown-group-addon"" alt="<?php echo $rws_search_username_reply_like['user_username'];?> <?php echo $rws_search_username_reply_like['user_lastname'];?>"alt="Generic placeholder image" style=" width: 28px; height: 28px;"> </a> <a href="profile.php?user_username=<?php echo $rws_search_username_reply_like['user_username'];?>"> <?php echo $rws_search_username_reply_like['user_username'];?> </a> </a> <?php } ?> </ul> <a href="#" class="dropdown-toggle" data-toggle="dropdown"style="font-size: 15px"style="box-shadow:1px 3px 2px 1px #C0C0C0; border: 1px solid; background: #00FFFF;"/> 👎 <?php echo $rws_search_video_diclike_id_reply['count']; ?> </a> <?php $temp_video_diclike_id_reply= $rws['video_id']; $sql_search_video_diclike_id_reply= "SELECT * 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); $rws_search_video_diclike_id_reply = mysqli_num_rows($result_search_video_diclike_id_reply); while($rws_search_video_diclike_id_reply_diclike = mysqli_fetch_array($result_search_video_diclike_id_reply)){ $temp_user_username_reply = $rws_search_video_diclike_id_reply_diclike['video_diclike_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_diclike= mysqli_fetch_array($result_search_username_reply); ?> <a href="userfiles/avatars/<?php echo $rws_search_username_reply_diclike['user_avatar'];?>"> <img class="img-circle" src="userfiles/avatars/<?php echo $rws_search_username_reply_diclike['user_avatar'];?>" class="" alt="<?php echo $rws_search_username_reply_diclike['user_username'];?> <?php echo $rws_search_username_reply_diclike['user_lastname'];?>"alt="Generic placeholder image" style=" width: 28px; height: 28px;"> </a> <a href="profile.php?user_username=<?php echo $rws_search_username_reply_diclike['user_username'];?>"> <?php echo $rws_search_username_reply_diclike['user_username'];?> </a> </a> <?php } ?> </ul> <a href="#" class="dropdown-toggle" data-toggle="dropdown"style="font-size: 15px"style="box-shadow:1px 3px 2px 1px #C0C0C0; border: 1px solid; background: #00FFFF;"/> 💬 <?php echo $rws_search_video_id_reply['count']; ?> </a> <?php $temp_video_id_reply= $rws['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 href="userfiles/avatars/<?php echo $rws_search_username_reply['user_avatar'];?>"> <img class="img-circle" src="userfiles/avatars/<?php echo $rws_search_username_reply['user_avatar'];?>" class="" alt="<?php echo $rws_search_username_reply['user_username'];?> <?php echo $rws_search_username_reply['user_lastname'];?>"alt="Generic placeholder image" style=" width: 28px; height: 28px;"> </a> <a href="profile.php?user_username=<?php echo $rws_search_username_reply['user_username'];?>"> <?php echo $rws_search_username_reply['user_username'];?> </a> <?php echo $rws_search_video_id_reply['video_reply_body'];?> <?php if($rws_search_video_id_reply['video_reply_image']){ ?> <a href="userfiles/uploads/<?php echo $rws_search_video_id_reply['video_reply_image'];?>"> <img src="userfiles/uploads/<?php echo $rws_search_video_id_reply['video_reply_image'];?>" class="img-responsive thumbnail"></a> <?php } ?> <a href="video_dellet_reply.php?video_reply_id=<?php echo $rws_search_video_id_reply['video_reply_id'];?>=<?php echo $rws['video_id'];?>">🗑️</a> </a> </a> <?php } ?> </ul> </div></div><?php ?> </div></div></div></div></div></div></div></div><?php } ?> <?php $sql="SELECT * FROM forum_topic WHERE forum_topic_created_by ='$user_username' ORDER BY forum_topic_time DESC"; $result = mysqli_query($database,$sql); while($rws = mysqli_fetch_array($result)){ $temp_user_username= $rws['forum_topic_created_by']; $sql_search_username = "SELECT * FROM user WHERE user_username = '$temp_user_username'"; $result_search_username = mysqli_query($database,$sql_search_username); $rws_search_username= mysqli_fetch_array($result_search_username); $temp_forum_topic_by_id_reply= $rws['forum_topic_id']; $sql_search_forum_topic_by_id_reply = "SELECT count(*) as count from forum_topic_reply where forum_topic_reply_topic_id = '$temp_forum_topic_by_id_reply'"; $result_search_forum_topic_by_id_reply= mysqli_query($database,$sql_search_forum_topic_by_id_reply) or die(mysqli_error($database)); $rws_search_forum_topic_by_id_reply = mysqli_fetch_array($result_search_forum_topic_by_id_reply); $temp_user_eye_id_reply= $rws['forum_topic_id']; $sql_search_user_eye_id_reply= "SELECT count(*) as count from user_eye where user_eye_by_id = '$temp_forum_topic_by_id_reply'"; $result_search_user_eye_id_reply= mysqli_query($database,$sql_search_user_eye_id_reply) or die(mysqli_error($database)); $rws_search_user_eye_id_reply = mysqli_fetch_array($result_search_user_eye_id_reply); $temp_forum_like_id_reply= $rws['forum_topic_id']; $sql_search_forum_like_id_reply= "SELECT count(*) as count from forum_like where forum_like_by_id = '$temp_forum_topic_by_id_reply'"; $result_search_forum_like_id_reply= mysqli_query($database,$sql_search_forum_like_id_reply) or die(mysqli_error($database)); $rws_search_forum_like_id_reply = mysqli_fetch_array($result_search_forum_like_id_reply); $temp_forum_diclike_id_reply= $rws['forum_topic_id']; $sql_search_forum_diclike_id_reply= "SELECT count(*) as count from forum_diclike where forum_diclike_by_id = '$temp_forum_topic_by_id_reply'"; $result_search_forum_diclike_id_reply= mysqli_query($database,$sql_search_forum_diclike_id_reply) or die(mysqli_error($database)); $rws_search_forum_diclike_id_reply = mysqli_fetch_array($result_search_forum_diclike_id_reply); ?> <div class="panel-body"> <div class="row clearfix"> <div class="col-md-12 column"style=" border: 1px solid; background: #00FFFF; " ><a href="userfiles/avatars/<?php echo $rws_search_username['user_avatar'];?>"> <img class="img-circle" src="userfiles/avatars/<?php echo $rws_search_username['user_avatar'];?>" class="" alt="<?php echo $rws_search_username['user_username'];?> <?php echo $rws_search_username['user_lastname'];?>"alt="Generic placeholder image" style=" width: 37px; height: 37px;"> </a> <a href="profile.php?user_username= <?php echo $rws_search_username['user_username'];?> "><?php echo $rws_search_username['user_username'];?></a> <?php echo $rws['forum_topic_time']; ?> <a href="dellet.php?forum_topic_id=<?php echo $rws['forum_topic_id'];?>"> 🗑️ Edit</a> <form action="user_eye.php?forum_topic_id=<?php echo $rws['forum_topic_id'];?>" method="post" enctype="multipart/form-data" id="UploadForm"> <input type="hidden" name="user_eye_by_id" value="<?php echo $rws['forum_topic_id']?>"/> <input type="hidden"name="user_eye_name" value="<?php echo $rws['forum_topic_created_by']?>"/> <input type="hidden" name="user_eye_body" value="<?php echo $rws['forum_topic_body']?>"/> <div><?php echo $rws['forum_topic_body'];?></div><---button type="hidden" name="submit-button"class="group-addon" id="submit" style=" background: #00FFFF;"> <?php if($rws ['forum_topic_image']){?> <a href="userfiles/uploads/<?php echo $rws ['forum_topic_image']?>"> <img src="userfiles/uploads/<?php echo $rws ['forum_topic_image']?>"class="img-responsive thumbnail" style=" width: 330px; height: 330px;" > <?php } ?> </a> </---button> </form><div/> <?php echo "👁️ ".$rws_search_user_eye_id_reply['count']." ️"; ?> <?php echo "👍 ".$rws_search_forum_like_id_reply['count']." ️"; ?> <?php echo "👎 ".$rws_search_forum_diclike_id_reply['count']." ️"; ?> <a href="#" class="dropdown-toggle" data-toggle="dropdown"style="font-size: 15px"/> 💬 <?php echo $rws_search_forum_topic_by_id_reply['count']; ?> </a> <?php $temp_forum_topic_id_reply= $rws['forum_topic_id']; $sql_search_forum_topic_id_reply= "SELECT * FROM forum_topic_reply where forum_topic_reply_topic_id = '$temp_forum_topic_id_reply' order by forum_topic_reply_time LIMIT 25"; $result_search_forum_topic_id_reply = mysqli_query($database,$sql_search_forum_topic_id_reply); $rws_search_forum_topic_id_reply = mysqli_num_rows($result_search_forum_topic_id_reply); while($rws_search_forum_topic_id_reply= mysqli_fetch_array($result_search_forum_topic_id_reply)){ $temp_user_username_reply = $rws_search_forum_topic_id_reply['forum_topic_reply_created_by']; $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 href="userfiles/avatars/<?php echo $rws_search_username_reply['user_avatar'];?>"> <img class="img-circle" src="userfiles/avatars/<?php echo $rws_search_username_reply['user_avatar'];?>" class="" alt="<?php echo $rws_search_username_reply['user_username'];?> <?php echo $rws_search_username_reply['user_lastname'];?>"alt="Generic placeholder image" style=" width: 28px; height: 28px;"> </a> <a href="profile.php?user_username=<?php echo $rws_search_username_reply['user_username'];?>"> <?php echo $rws_search_username_reply['user_username'];?> </a> <?php echo $rws_search_forum_topic_id_reply['forum_topic_reply_body'];?> <?php if($rws_search_forum_topic_id_reply['forum_topic_reply_image']){ ?> <img src="userfiles/uploads/<?php echo $rws_search_forum_topic_id_reply['forum_topic_reply_image'];?>" class="img-responsive thumbnail"> <?php } ?> </a> </a> <?php } ?> </ul> </div></div><?php ?> </div></div></div></div></div></div></div></div><?php } ?>

membuat panggilan magic include
sebagai input image post
pada baris berikut ini.
meletakan pada file myprofile.php

📄images.php

<?php $sql = "SELECT * FROM user where user_username='$user_username'"; $result = mysqli_query($database,$sql) or die(mysqli_error($database)); $roos= mysqli_fetch_array($result); ?> </head> <body> <?php require '_database/database.php'; if($_SESSION['user_username']){ ?> Upload Myfhoto <form action="upload.php" method="post" enctype="multipart/form-data" id="UploadForm"><input type="hidden"name="user_username" value="<?php echo $roos['user_username']?>"/> <div class="input-group"> <input name="user_image_name"type="text" id="user_image_name"class="input-group-addon"placeholder="🖼️Album"/> <input name="BackgroundImageFile" type="file" id="uploadBackgroundFile" class="btn btn-default" name="user-messagess-attachment"style="width: 80px; height: 32px;"/> <--button type="submit" class="btn btn-primary" name="submit_button" id="submit_button"/> Kirim </---button> </form></div><?php } else{ ?> <?php } ?>Fhoto <?php echo $rws['user_username'];?> <hr/><?php include '_database/database.php'; $sql = "SELECT * FROM images WHERE user_username='$user_username' ORDER BY user_date DESC"; $result = mysqli_query($database,$sql); while($root= mysqli_fetch_array($result)){ ?> <a class="addon" rel="group-addon" href="userfiles/profilpotos/ <?php echo $root['user_foto'];?>"> <img src="userfiles/profilpotos/<?php echo $root['user_foto'];?>" alt="" alt="" style="padding: 5px; border: dotted 1px #0000; margin: 5px; border-radius: 10px; width: 100px; height: 100px;"/></a> <?php } ?>

images.php
Input image terlihat dengan pagilan magic terdiri dari input data
memangil data dari table images berdasarkan username
menarik data didalam folder :
src="userfiles/profilpotos/myimage.png/jpg"
📁userfile
📁profilepotos
🖼️myimage.png/jpg

📄upload.php

<?php ini_set("display_errors",1); session_start(); $current_user=$_SESSION['user_username']; if($_SERVER['REQUEST_METHOD'] == 'POST'){ require '_database/database.php'; $user_username=$_REQUEST['user_username']; $user_image_name=$_REQUEST['user_image_name']; $Destination = 'userfiles/profilpotos'; 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 images( user_username, user_image_name, user_date, user_foto) VALUES ( '$user_username', '$user_image_name', CURRENT_TIMESTAMP, '$BackgroundNewImageName')"; mysqli_query($database,$sql)or die(mysqli_error($database)); header("location:my-profile.php?user_username=$user_username&request=my-profile&status=success"); } ?>

insert for table image upload.php berdasarkan username dan id masing-masing user
sebagi destinasti folder file
$Destination = 'userfiles/profilpotos';

📄images.sql

membuat table database images
📄images_eye.sql

membuat table database images_eye
📄images_like.sql

membuat table database images_like
📄images_diclike.sql

membuat table database images_diclike
hapus tak br
upload kedalam database

Daftar file
📁root folder
📄 eye_images. php

melempar input untuk table image
📄images_eye. php

<?php include 'components/authentication.php' ?> <?php include 'controllers/base/head.php' ?> <?php require '_database/database.php'; if($_SESSION['user_username']){ ?> <?php include 'controllers/navigation/first-navigation.php' ?> <?php } else{ ?> <?php include 'controllers/navigation/index-before-login-navigation.php' ?> <?php } ?> <?php $current_user = $_SESSION['user_username']; $user_id = mysqli_real_escape_string($database,$_REQUEST['user_id']); $sql = "SELECT * FROM images where user_id = '$user_id'"; $result = mysqli_query($database,$sql); $rws = mysqli_fetch_array($result); $temp_user_username = $rws['user_username']; $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); $temp_user_id_reply= $rws['user_id']; $sql_search_user_id_reply= "SELECT count(*) as count from images_reply where images_reply_by_id = '$temp_user_id_reply'"; $result_search_user_id_reply= mysqli_query($database,$sql_search_user_id_reply) or die(mysqli_error($database)); $rws_search_user_id_reply = mysqli_fetch_array($result_search_user_id_reply); $temp_images_eye_id_reply=$rws['user_id']; $sql_search_images_eye_id_reply= "SELECT count(*) as count from images_eye where images_eye_by_id = '$temp_user_id_reply'"; $result_search_images_eye_id_reply= mysqli_query($database,$sql_search_images_eye_id_reply) or die(mysqli_error($database)); $rws_search_images_eye_id_reply = mysqli_fetch_array($result_search_images_eye_id_reply); $temp_images_like_id_reply= $rws['user_id']; $sql_search_images_like_id_reply= "SELECT count(*) as count from images_like where images_like_by_id = '$temp_user_id_reply'"; $result_search_images_like_id_reply= mysqli_query($database,$sql_search_images_like_id_reply) or die(mysqli_error($database)); $rws_search_images_like_id_reply = mysqli_fetch_array($result_search_images_like_id_reply); $temp_images_diclike_id_reply= $rws['user_id']; $sql_search_images_diclike_id_reply= "SELECT count(*) as count from images_diclike where images_diclike_by_id = '$temp_user_id_reply'"; $result_search_images_diclike_id_reply= mysqli_query($database,$sql_search_images_diclike_id_reply) or die(mysqli_error($database)); $rws_search_images_diclike_id_reply = mysqli_fetch_array($result_search_images_diclike_id_reply); ?> <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;"><a href="userfiles/avatars/<?php echo $rws_search_username_reply['user_avatar'];?>"> <img class="img-circle" src="userfiles/avatars/<?php echo $rws_search_username['user_avatar'];?>" class="" alt="<?php echo $rws_search_username['user_username'];?>"alt="Generic placeholder image" style="width: 37px;height: 37px;"></a> <a href="profile.php?user_username= <?php echo $rws_search_username['user_username'];?> "><?php echo $rws_search_username['user_username'];?></a> <?php echo $rws_search_username['user_country']?></a> <?php echo $rws['user_date']; ?> </div><div class="col-md-6 column"style=" box-shadow:1px 3px 2px 1px #C0C0C0; border: 1px solid; background: #00FFFF;"> <?php echo $rws['user_image_name']?> <?php if($rws['user_foto']) { ?> <img src="userfiles/profilpotos/<?php echo $rws['user_foto'];?>" class="Generic placeholder image" style="width:300px; height: 330px;"/> <?php echo $rws_search_username['user_username'];?> </a> <?php } ?> </div><div class="col-md-12 column"style=" box-shadow:1px 1px 1px 1px #C0C0C0; border: 1px solid; background: #00FFFF;"> <?php echo " ".$rws_search_images_eye_id_reply['count']." ️"; ?> <form action="images_diclike.php?user_id=<?php echo $rws['user_id'];?>" method="post" enctype="multipart/form-data" id="UploadForm"> <input type="hidden" name="forum_diclike_by_id" value="<?php echo $rws['user_id']?>"/> <input type="hidden"name="images_diclike_name" value="<?php echo $rws['user_username']?>"/> <input type="hidden" name="images_diclike_body" value="<?php echo $rws['user_image_name']?>"/> <?php require '_database/database.php'; if($_SESSION['user_username']){ ?> <button type="submit" class="primary" name="submit_button" id="submit" style=" color: #333333; background-color: #ffffff; display: inline-block; font-size: 0.85em; letter-spacing: 0.25px; line-height: 1.3em; border-radius: 5px; text-decoration: none; border:none; text-transform: uppercase; font-weight: bold;"> <?php echo "👎 ".$rws_search_images_diclike_id_reply['count']." ️"; ?></button> </form><?php } else{ ?> <?php } ?> <form action="images_like.php?user_id=<?php echo $rws['user_id'];?>" method="post" enctype="multipart/form-data" id="UploadForm"> <input type="hidden" name="images_like_by_id" value="<?php echo $rws['user_id']?>"/> <input type="hidden"name="images_like_name" value="<?php echo $rws['user_username']?>"/> <input type="hidden" name="images_like_body" value="<?php echo $rws['user_image_name']?>"/> <?php require '_database/database.php'; if($_SESSION['user_username']){ ?> <button type="submit" class="primary" name="submit_button" id="submit" style=" color: #333333; background-color: #ffffff; display: inline-block; font-size: 0.85em; letter-spacing: 0.25px; line-height: 1.3em; border-radius: 5px; text-decoration: none; border:none; text-transform: uppercase; font-weight: bold;"> <?php echo "👍 ".$rws_search_images_like_id_reply['count']." ️"; ?> </button> </form> <?php } else{ ?> <?php } ?> <?php $sql_reply = "SELECT * FROM images_reply where images_reply_by_id = '$user_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['images_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); ?> <?php if($rws_reply_count > 0){ ?> </div><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'];?> <?php echo $rws_search_username_reply['user_lastname'];?>alt="Generic placeholder image" style=" width: 37px; height: 37px; " > <?php echo " <img src='../assets/img/ajax-loader.gif'alt='Generic placeholder image'style=' width: 3px; height: 3px; '/>"; ?> <a href="profile.php?user_username=<?php echo $rws_reply['images_reply_name'];?> "> <?php echo $rws_reply['images_reply_name'];?> </a> <?php echo $rws_reply['images_reply_title'];?> <?php echo $rws_reply['images_reply_body'];?> <?php echo $rws_reply['images_reply_time'];?> <?php if($rws_reply['images_reply_image']){ ?> <img src="userfiles/imgreply/<?php echo $rws_reply['images_reply_image'];?>" class="img-responsive thumbnail"> <?php } ?> </div><?php } ?> </div> <?php } ?> </div></div></div></div><?php require '_database/database.php'; if($_SESSION['user_username']){ ?> <div class="container"> <div class="row clearfix"><?php include 'controllers/form/images-reply-form.php' ?> </div></div></div></div></div><?php } else{ ?> <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 } ?> </body> </html>

membuat pada satu file menunjukan keseluruhan data images berdasarkan id dan username, respon images seperti images_reply,
images_like,
images_diclike
dan jumlah pasang mata akan terlihat.
semua data dari table images_reply/komentar pada image berdasarkan id dari images_reply_by_id yang diambil dari user_id dari table images.
untuk melunakan data masing masing table dan menyusun dalam satu file disini mengunkan code berikut

$temp_user_id_reply= $rws['user_id'];

user_id dari table images menentukan nilai asli nomer urut database table
peran sangat penting untuk mengenal masing-masing data,
untuk membuat data dari table images dapat membaca username menambahkan perintah berikut ini.

$temp_user_username = $rws['user_username'];

membuat user_username dari table images sama dengan user_username dari table user
untuk masing-masing data dapat mengenal username.
images_eye. php
memiliki banyak tugas seperti input data respon user
image_like,
image_diclike,
sudah terdapat didalam file dan bersembunyi didalam button jebakan dalam keranjang
untuk memastikan jebakan didalam button seperti
images_like dan images_diclike
akan terlihat seperti ini
A. 📄images_like

<form action="images_like.php?user_id=<?php echo $rws['user_id'];?>" method="post" enctype="multipart/form-data" id="UploadForm"> <input type="hidden" name="images_like_by_id" value="<?php echo $rws['user_id']?>"/> <input type="hidden"name="images_like_name" value="<?php echo $rws['user_username']?>"/> <input type="hidden" name="images_like_body" value="<?php echo $rws['user_image_name']?>"/> <?php require '_database/database.php'; if($_SESSION['user_username']){ ?> <---button type="submit" class="primary" name="submit_button" id="submit" style=" color: #333333; background-color: #ffffff; display: inline-block; font-size: 0.85em; letter-spacing: 0.25px; line-height: 1.3em; border-radius: 5px; text-decoration: none; border:none; text-transform: uppercase; font-weight: bold;"> <?php echo "👍 ".$rws_search_images_like_id_reply['count']." ️"; ?> </---button> </form> <?php } else{ ?> <?php } ?>

Arah jalur tautan
" method="post" enctype="multipart/form-data" id="UploadForm"---/>
Mengikat tautan dengan user_id dari table images
📄images_like. php

B. 📄images_diclike

<form action="images_diclike.php?user_id=<?php echo $rws['user_id'];?>" method="post" enctype="multipart/form-data" id="UploadForm"> <input type="hidden" name="forum_diclike_by_id" value="<?php echo $rws['user_id']?>"/> <input type="hidden"name="images_diclike_name" value="<?php echo $rws['user_username']?>"/> <input type="hidden" name="images_diclike_body" value="<?php echo $rws['user_image_name']?>"/> <?php require '_database/database.php'; if($_SESSION['user_username']){ ?> <---button type="submit" class="primary" name="submit_button" id="submit" style=" color: #333333; background-color: #ffffff; display: inline-block; font-size: 0.85em; letter-spacing: 0.25px; line-height: 1.3em; border-radius: 5px; text-decoration: none; border:none; text-transform: uppercase; font-weight: bold;"> <?php echo "👎 ".$rws_search_images_diclike_id_reply['count']." ️"; ?></---button> </form><?php } else{ ?> <?php } ?>

penting untuk menambahkan SESSION['user_username']
hal ini mencegah seseorang yang baru saja melihat halaman untuk merespon post.
sebagai tamu dapat melihat tetapi dengan menambahkan SESSION['user_username'] tidak bisa menulis dan mengarahkan kedalam suka/diclike
mereka dapat meninggalkan jejak setelah terdaftar kedalam database situs.

📁controllers
📁form
📄images-reply-form.php

<?php $user_id = mysqli_real_escape_string($database,$_REQUEST['user_id']); $sql_img = "SELECT * FROM images where user_id = '$user_id'"; $result_img= mysqli_query($database,$sql_img); $rws_img = mysqli_fetch_array($result_img); $temp_user_username = $rws_img['user_username']; $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); ?> <---form action="components/images_reply.php?user_id=<?php echo $rws_img['user_id'];?>" method="post" enctype="multipart/form-data" id="UploadForm"> <input type="hidden" class="form-control" placeholder="<?php echo $rws_img['user_id'];?>" name="images_reply_by_id" value="<?php echo $rws_img['user_id'];?>"> <input type="hidden" class="form-control" placeholder="<?php echo $rws_img['user_image_name'];?>" name="images_reply_body" value="<?php echo $rws_img['user_image_name'];?>"> <---textarea id="images-reply-titel" class="form-control" placeholder="Tex" name="images_reply_title" alt="text" ></---textarea> <input name="BackgroundImageFile" type="file" id="uploadBackgroundFile" class="btn btn-default" name="forum-topic-attachment"alt="Generic placeholder image"style=" width: 90px;"> <---button type="submit" name="submit_button" id="submit_button" " > Reply</---button--> </form>

📁componets
📄images_reply. php

<?php ini_set("display_errors",1); session_start(); if($_SERVER['REQUEST_METHOD'] == 'POST'){ require '../_database/database.php'; $user_id = mysqli_real_escape_string($database,$_REQUEST['user_id']); $user_id_temp = $user_id; $user_username=$_SESSION['user_username']; $images_reply_title=$_REQUEST['images_reply_title']; $Destination = '../userfiles/imagesimg'; 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 images_reply( images_reply_by_id, images_reply_name, images_reply_body, images_reply_title, images_reply_time, images_reply_image) VALUES ( '$user_id', '$user_username', '$images_reply_body', '$images_reply_title', CURRENT_TIMESTAMP, '$BackgroundNewImageName')"; mysqli_query($database,$sql)or die(mysqli_error($database)); header('Location: ../images_eye.php?user_id='.$user_id); } ?>

Menghapus tak br pada setiap file code.
Masih dalam pengijian
Unduh lengkap code webmaster v1. 0
akan saya tulis lain waktu terimaksih

Gelora

Image Post php

Posting Komentar