Public Post

Berakar dari table penguna
bebrapa langka sebelum dibentuk mereka melalui tahap-tahap
1.Daftar
2.login
sucsses akses
berikut ini yang akan dihamparkan beberapa file sebagai pondasi proyek ini misalnya

home.php

first-navigation.php
umumnya user bersarang pada rumah public
current user
melihat,membaca megisi pesan dan
komentar post dan menampilkan sumua table penguna untuk permuda oprasi mendukung bootstrap seperti first-navigation icone serta dropdown smotcontrol dan peralatan lain sudah tersedia
A.Kerangka rumah

public

_database

assets

css

font

img

components

controllers

base

footer

form

navigation

first-navigation.php

table

tour

userfiles

avatars

imgmessages

imgreply

home.php

profile.php

my_profile.php

forum-topic.php

forum.php

logout.php

dellet.php

edit-profile.php

add-new-forum-post.php

fetch.phpphp

body.php

hendler.php

images.php

index.php

search-result.php

update-bio-after-regiter.php

update-profile-after-registration.php

sql.php

upload.php

user_messages.php

user_new_messages.php

user_view_messages.php
mendapatkan didalam rumah seperti
ini ada home
a.view forum_topic/home.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' ?>
<?php
    session_start();
    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
    }
?></head>
<body>
<?php
    session_start();
    require '_database/database.php';
   $sql_asu="SELECT * FROM forum_topic WHERE forum_topic_id ORDER BY forum_topic_time DESC";
   $result_asu= mysqli_query($database,$sql_asu);
   $row_count = mysqli_num_rows($result_asu);
   while($rws= mysqli_fetch_array($result_asu)){

$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">
                <span class="panel-body">

<img src="userfiles/avatars/<?php echo $rws_search_username['user_avatar'];?>" class="" alt="<?php echo $rws_search_username['user_firstname'];?> 
<?php echo $rws_search_username['user_lastname'];?>"
 style="position: absolute;
    margin: -4px 0 0 0;
 width: 60px;
 height: 48px;
 padding: 1px;">            
<a href="profile.php?user_username=<?php echo $rws_search_username['user_username'];?> " style="font-size: 36px;co
or: black"/> 
<?php echo $rws_search_username['user_firstname'];?>
 <?php echo $rws_search_username['user_lastname'];?>
 <i class="fa fa-map-marker" style="font-size:14px;color:black;"/> 
 <?php echo $rws_search_username['user_country']?></i>
                    <div class="well" >
                        <div class="row clearfix">
                            <div class="col-md-12 column">
                                <a href="forum-topic.php?forum_topic_id=<?php echo $rws['forum_topic_id'];?>"> 
<i span class=""style="font-size: 32px;color:black;"/>  
<?php echo $rws['forum_topic_name'];?>
<?php echo $rws['forum_topic_body'];?><br/></a> 
<?php if($rws ['forum_topic_image']){?>   
   <img src="userfiles/uploads/<?php echo $rws ['forum_topic_image']?>" style='width='480' height='320'border:1px dotted #444;'>

<?php
                   }
                     ?> 
                        </div>
<div class="col-md-11 column">
 
                               
                             </div>
</div>
</span>
                      <br> 
                    </div>
<i span class=""style="font-size: 10px;color:black;"/>  
<?php   
echo $rws['forum_topic_time']; 
?> </i>
<a href=# id="calculate"> <br/>
 </a>
                <span class="panel panel-default">
                    <span class="panel-heading">
                       <?php echo $notice_id; ?>
                           <th scope="row"> 
                        </th>                                
<span class="fa fa-comments">
</div>
</div>
</div>
<?php
    }
?>
            
<?php
    session_start();
    require '_database/database.php';
    if($_SESSION['user_username']){
?>
                    <br>
                    <div class="container">
                        <div class="row clearfix">
                        </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
}
?>

Contoh : forum.sql
dan forum _topic_reply
tunjukan bagaimana mereka bekerja
seperti ini misalnya

view forum topic

"SELECT * FROM forum_topic WHERE forum_topic_id ORDER BY forum_topic_time DESC";
perintah tegas tampilkan semua data dari table forum_topic berdasarkan waktu penulisan
ini contohnya

public seseorang melirik dari
arah mana saja dapat meliht ini
untuk membaca,tidak diberikan kebebasan khusus
untuk tamu
bisa saja mereka meninggalkan tulisan jika sudah melakukan pedaftaran.

Input forum topic
saya hampir lupa untuk menulis input data untuk table forum_topic dan forum_topic _reply
contoh input forum topic

add-new-forum-post.php

hamparan pangilan magice includ "controllest/form/add-new-forum-post-form.php"

add-new-forum-post-form.php

<form action="components/add-new-forum-post.php" method="post" enctype="multipart/form-data" id="UploadForm">
  <?php
    $current_user = $_SESSION['user_username'];
    $sql = "SELECT * FROM user WHERE user_username='$current_user'";
    $result = mysqli_query($database,$sql);
    while($row = mysqli_fetch_array($result,MYSQLI_BOTH)) {
?>
<div class="form-group">
        <label for="forum-topic-name"></label> 
<img src="userfiles/avatars/<?php echo $row['user_avatar'];?>" style="height: 32px;
 width: 32px;
     font-size: 37px">
 <?php echo $row['user_username'];?> 
<?php echo $row['user_firstname'];?>
        <input type="text" class="form-control" id="forum-topic-name" name="forum_topic_name" placeholder="Nama topik" style="height: 32px;
 width: 260px;" />
    </div>
<div class="form-group">
        <label for="forum-topic-body"></label>
        <***textarea id="forum-topic-body" rows="9" class="form-control" placeholder="Jelaskan" name="forum_topic_body"  required /><***/textarea>
    </div>
<div class="form-group">
        <label for="forum-topic-notice">Pilih Salah-satu(s)</label>
        <br>
        <label class="checkbox-inline" for="notis-inline-checkbox1"><input type="checkbox" id="notice-inline-checkbox1" name="forum_topic_notice[]" value="Reviw"> Reviw</label>
        <label class="checkbox-inline" for="notice-inline-checkbox2"><input type="checkbox" id="notice-inline-checkbox2" name="forum_topic_notice[]" value="Hiburan"> Hiburan</label>
        <label class="checkbox-inline" for="notice-inline-checkbox3"><input type="checkbox" id="notice-inline-checkbox3" name="forum_topic_notice[]" value="Tekno"> Tekno</label>
        <label class="checkbox-inline" for="notice-inline-checkbox4"><input type="checkbox" id="notice-inline-checkbox4" name="forum_topic_notice[]" value="Hobi"> Hobi</label>
        <label class="checkbox-inline" for="notice-inline-checkbox5"><input type="checkbox" id="notice-inline-checkbox5" name="forum_topic_notice[]" value="Cinta"> Cinta</label>
        <label class="checkbox-inline" for="notice-inline-checkbox6"><input type="checkbox" id="notice-inline-checkbox6" name="forum_topic_notice[]" value="Sex"> Sex</label>
        <label class="checkbox-inline" for="notice-inline-checkbox7"><input type="checkbox" id="notice-inline-checkbox7" name="forum_topic_notice[]" value="Kencan"> Kencan</label>
        <label class="checkbox-inline" for="notice-inline-checkbox8"><input type="checkbox" id="notice-inline-checkbox8" name="forum_topic_notice[]" value="Teman"> Teman </label>
    </div>
<hr>
    <label for="forum-topic-attachment"></label>
    <input name="BackgroundImageFile" type="file" id="uploadBackgroundFile" class="btn btn-default" name="forum-topic-attachment"/>  
    <hr>
    <button type="submit" class="btn btn-primary" name="submit_button" id="submit_button">Submit</button>
</form>
<?php 
}
?>

memili beberapa baris dan mengelopokan
serta menampilkan
misalnya judul,materi dan penulis
seperti ini

forum post Cotoh

forum-table.php
$sql = "SELECT * FROM forum_topic where forum_topic_notice LIKE '%$forum_topic_notice_id%' ORDER BY forum_topic_time";
like % lebih lentur untuk mengikat mereka
melewati lebih luas area lingkaran penyebaran arry guery
akan tetap patuh pada baris perintah

<div class="container">
<?php
        include'_database/database.php';
            $sql = "SELECT * FROM forum_topic where forum_topic_notice LIKE '%$forum_topic_notice_id%' ORDER BY forum_topic_time";
            $result = mysqli_query($database,$sql);
            $rws_count= mysqli_num_rows($result);
?>
                <div class="panel panel-default">
                    <div class="panel-heading">
                        <h3 class="panel-title">
<i class="fa fa-group"style="font-size:80;color:green"></i><?php echo $rws['forum_topic_notis'];?></h3>
</div>
<?php
                if($rws_count == 0){          
?>
                    <h4 class="text-center">
</h4>
<i class="" style="font-size:32px;font-color:black;">
                </div>
<?php
                }
                else{          
?>
                    <table class="table table-bordered">
                        <thead>
<tr>                             
                                <th>Topic </th>
                                <th>Post by</th>
                            </tr>
</thead>
<?php                   
                    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) or die(mysqli_error($database));
                        $rws_search_username = mysqli_fetch_array($result_search_username);
?>
<tbody> <thead>
<tr>
<td><?php if($rws['forum_topic_image']){?><img src="userfiles/uploads/<?php echo $rws['forum_topic_image'];?>" style="width: 90px;height: 75px;border: none;box-shadow:3px 3px#ADC2B3;">

<?php } ?> <a href="forum-topic.php?forum_topic_id=<?php echo $rws['forum_topic_id'];?>"> <i class=''style='font-size:32px;font-color:black;'> <?php echo $rws['forum_topic_name'];?></a>

<?php

echo " <i class=''style='font-size:32px;font-color:black;'>".$rws['count']."</i>";
 ?><hr/>
</td>
<td><?php echo $rws_search_username['user_firstname'];?> <?php echo $rws_search_username['user_lastname'];?></td>
</tr>
</thead>
</tbody>
<?php  
}
?>
</table>
</div>
<?php      
}
?></i>
    </div>

pangilan includ yang lain bisa kamu melihat pada post terdahulu
next>>
Rumah

Unduh Code Lengkap

DATA BARU

Public Post

Posting Komentar untuk "Public Post"

Menu Halaman Statis