Mengatur Ulang Post Update

Table of Contents

Mengatur Ulang Post Update
Menulis update status menggambarkan peraasan,kegiatan ,bisnis dan hal-hal lain dalam keseharian disekitar
Seringkali data yang sudah kita imput kedalam database, dan ingin mengubah dengan text dan gambar yang lain.
Sebelum Melanjutkan
Baca terlebih dahulu artikel dibawah ini
Imput Publis Post
Disini saya akan menyematkan pengaturan untuk menulis ulang imput kedalam database
Sebagai acuan buatlah table Publis Post
dan menambahkan botstrap dropdown
sebagai wadah pengaturan
dan melatakan tautan pengaturan ulang Publis Post
Contoh
htdocs

---

      public_post.php
    Letakan code dianatara $rws            ['forum_topic_created_by']
           <?php require '_database/database.php'; if($row['user_username']){ ?> <span class="dropdown"> <a href="#" class="dropdown-toggle" data-toggle="dropdown"style="font-size: 10px;col or: orange"/> <i class="fa fa-bars" style="font-size: 1.0em;color: orange;"></i> </a> <span class="dropdown-menu" style="font-size: 1.0em;co or: orange"/> <span> <a href="edit-post.php?forum_topic_id=<?php echo $rws['forum_topic_id'];?>"> <i class=""></i>Edit</a><div><span> <a href=""><i class=""></i>Hapus</a> </span> </span> </ul></span> <?php } else{ ?> <?php } ?></div></i>
  code lengkap dengan meletakan pengaturan bootstrap dropdown
      Contoh:
      public_post.php
          ?php include 'body.php' ?> <script src='assets/js/base/jquery.min.js'></script> <?php include 'components/authentication.php' ?> <?php include 'controllers/base/head.php'?> <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 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']; $forum_topic_id = mysqli_real_escape_string($database,$_REQUEST['forum_topic_id']); $sql = "SELECT * FROM forum_topic where forum_topic_id = '$forum_topic_id'"; $result = mysqli_query($database,$sql); $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) or die(mysqli_error($database)); $rws_search_username = mysqli_fetch_array($result_search_username); ?> <div class="container"> <div class="panel panel-default"> <div class="panel-body"> <br> <div class="well"> <div class="row clearfix"> <div class="col-md-1 column"> </div><div class="col-md-11 column"> <div class="topic-user-name"> </div><hr> <div class="topic-body"> </div><div class="forum-attachment"> ?> <hr> <div class="col-md-3 column"> </div><?php include 'controllers/form/edit-post-form.php' ?> </div></div></div></div>

---

     Letakan file diluar folder dan didalam root folder
      edit-post.php
           <?php include 'body.php' ?> <script src='assets/js/base/jquery.min.js'></script> <?php include 'components/authentication.php' ?> <?php include 'controllers/base/head.php'?> <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 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']; $forum_topic_id = mysqli_real_escape_string($database,$_REQUEST['forum_topic_id']); $sql = "SELECT * FROM forum_topic where forum_topic_id = '$forum_topic_id'"; $result = mysqli_query($database,$sql); $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) or die(mysqli_error($database)); $rws_search_username = mysqli_fetch_array($result_search_username); ?> <div class="container"> <div class="panel panel-default"> <div class="panel-body"> <br> <div class="well"> <div class="row clearfix"> <div class="col-md-1 column"> </div><div class="col-md-11 column"> <div class="topic-user-name"> </div><hr> <div class="topic-body"> </div><div class="forum-attachment"> ?> <hr> <div class="col-md-3 column"> </div><?php include 'controllers/form/edit-post-form.php' ?> </div></div></div></div>

---

    code yang bertugas menyampaikan kedalam database
    components

          <?php ini_set("display_errors",1); session_start(); $temp=$_SESSION['user_username']; if(isset($_POST)){ require '../_database/database.php'; $Destination = '../userfiles/uploads'; if(!isset($_FILES['BackgroundImageFile']) || !is_uploaded_file($_FILES['BackgroundImageFile']['tmp_name'])){ $BackgroundNewImageName= 'default-background.jpg'; 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"); } $sql1="UPDATE forum_topic SET forum_topic_image='$BackgroundNewImageName' WHERE forum_topic_created_by = '$temp'"; $sql2="INSERT INTO forum_topic (forum_topic_image) VALUES ('$BackgroundNewImageName') WHERE forum_topic_created_by = '$temp'"; $result = mysqli_query($database,"SELECT * FROM forum_topic WHERE forum_topic_created_by = '$temp'"); if( mysqli_num_rows($result) > 0) { if(!empty($_FILES['BackgroundImageFile']['name'])){ mysqli_query($database,$sql1)or die(mysqli_error($database)); header("location:../edit-post.php?user_username=$temp"); } } else { mysqli_query($database,$sql2)or die(mysqli_error($database)); header("location:../edit-post.php?user_username=$temp"); } $forum_topic_name=$_REQUEST['forum_topic_name']; $forum_topic_body=$_REQUEST['forum_topic_body']; $forum_topic_time=$_REQUEST['forum_topic_time']; $forum_topic_created_by=$_REQUEST['forum_topic_created_by']; $forum_topic_semester=$_REQUEST['forum_topic_semester']; $forum_topic_image=$_REQUEST['forum_topic_image']; $sql3="UPDATE forum_topic SET forum_topic_name='$forum_topic_name' ,forum_topic_body='$forum_topic_body' ,forum_topic_time=',CURRENT_TIMESTAMP,' ,forum_topic_created_by='$forum_topic_created_by' ,forum_topic_semester='$forum_topic_semester' WHERE forum_topic_created_by = '$temp'"; mysqli_query($database,$sql3)or die(mysqli_error($database)); header("location:../home.php?user_username=$temp&request=edit-post&status=success"); } ?>

---

   code edit input data
 controllest
         form
              <----form action="components/edit-post.php" method="post" enctype="multipart/form-data" id="UploadForm"---_-> <!-- Nav tabs --> <ul class="nav nav-tabs"><li class="active"><a href="#general" data-toggle="tab">General</a></li><li><a href="#personal" data-toggle="tab">Personal</a></li><li><a href="#customize" data-toggle="tab">Customize</a></li></ul><!-- Tab panes --> <div class="tab-content"> <div class="tab-pane fade in active" id="general"> <div class="col-md-6"> <div class="form-group float-label-control"> <label for="">Forum Name</label> <-----input type="text" class="form-control" placeholder="<?php echo $rws['forum_topic_name'];?>" name="forum_topic_name" value="<?php echo $rws['forum_topic_name'];?>"------> </div><div class="form-group float-label-control"> <-----input type="hidden" class="form-control" placeholder="<?php echo $rws['forum_topic_created_by'];?>" name="forum_topic_created_by" value="<?php echo $rws['forum_topic_created_by'];?>"-----> </div><div class="form-group float-label-control"> <----input name="BackgroundImageFile" type="file" id="uploadBackgroundFile"------/> <div class="col-md-6"> <div class="shortpreview"> <label for="">Previous Background Picture </label> <br> <a href="userfiles/uploads/<?php echo $rws['forum_topic_image'];?>"> <img src="userfiles/uploads/<?php echo $rws['forum_topic_image'];?>" class="img-responsive"> </a> </div></div><div class="col-md-6"> <div class="shortpreview" id="uploadBackgroundImagePreview"> <label for="">Current Uploaded Avatar </label> <br> <div id="imageBackgroundPreview"> </div></div></div></div></div></a> </div><div class="form-group float-label-control"> <----input type="text" class="form-control" placeholder="<?php echo $rws['forum_topic_body'];?>" name="forum_topic_body" value="<?php echo $rws['forum_topic_body'];?>"------> </div><div class="form-group float-label-control"> </div></div></div><div class="tab-pane fade" id="personal"> <div class="col-md-6"> <div class="form-group float-label-control"> </div><div class="form-group float-label-control"> </div><div class="form-group float-label-control"> </div><label for="">Gender</label> <div class="form-group float-label-control"> <div class="radio-inline"> <label> </div><div class="radio-inline"> <label> </div></div><div class="form-group float-label-control"> </div></div><div class="col-md-6"> <div class="form-group float-label-control"> </div><div class="input-group"> </div></div><div class="form-group float-label-control"> </div></div></div><div class="tab-pane fade" id="customize"> <div class="col-md-6"> <div class="form-group float-label-control"> <div class="col-md-6"> <div class="shortpreview"> </div></div></div></div></div></div></div><br> <div class="submit"> <center> <-----button class="btn btn-primary ladda-button" data-style="zoom-in" type="submit" id="SubmitButton" value="Upload" />Save Your Profile</button-----> </center></div></form>

---

     Code lengkap tentang input database dan table forum_topik/public_post baca disini Publis Post
Apa yang terdapat didalam artikel merupakan gambaran saja
tentu teman-teman memiliki gagasan dan pemikiran yang berbeda
menambahkan beberapa hala yang menarik jika diperluka.
Seberapa panjang sebuah artikel tidak akan membantu seseorang coding
jika apa yang mereka tulis setengah-setengah dan menyimpan sebuah file kedalam penyimpana pihak ketiga
buat saya itu sangat merepotkan dan hal yang dibenci pembaca.

saran dan komentar sangat saya butuhkan