PHP mySQL Sort post by date

Question

I'm trying to create a website where anyone can post anything to it without creating an account, long as its just text. My problem is because every time I start the website and post something. Its sent to the bottom, where oldest posts are at the top and new posts are sent to the top. I want to see the new posts on top instead. This is my first time working with PHP, mySQL and databases in general so my code might look bad. Tell me if more information / code is needed. Thank you for your time.

<?php
function setPosts($conn){
    if(isset($_POST['postSubmit'])){
        $pid = $_POST['pid'];
        $date = $_POST['date'];
        $message = $_POST['message'];

        $sql= "INSERT INTO post(pid, date ,message) VALUES ('$pid', '$date', '$message');";
        $result = mysqli_query($conn, $sql);
    }
}

function getPosts($conn){
    $sql = "SELECT * FROM post";
    $result = mysqli_query($conn, $sql);
    while($row = $result->fetch_assoc()){
        echo "<div class='post-box'>";
        echo $row['date']."<br>";
        echo nl2br($row['message'])."<br><br>";
        echo "</div>";
    }
}

Type "mysql sort" into Google, and you got the answer ...

C3roe
– C3roe

2017-10-14 05:43:39 +00:00
Commented Oct 14, 2017 at 5:43 — C3roe
– C3roe, Commented Oct 14, 2017 at 5:43

Death-is-the-real-truth · Accepted Answer · 2017-10-14 07:58:24Z

2

You need to add "ORDER BY" to your "SELECT" to sort it.

$sql = "SELECT * FROM post ORDER BY date DESC";

The "DESC" is there so that new posts will be on top. We'd use "ASC" if we wanted older posts on top.

edited Oct 14, 2017 at 7:58

Death-is-the-real-truth

72.3k10 gold badges59 silver badges105 bronze badges

answered Oct 14, 2017 at 5:44

azbatuk

2931 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Death-is-the-real-truth · Accepted Answer · 2017-10-14 08:07:22Z

2

You need to use ODRER BY clause like below :-

$sql = "SELECT * FROM post ORDER BY date DESC";

Reference:- ODRER BY clause

Note:- Your insersion code is wide open for SQL Injection. Use mysqli prepared statements to prevent from it.

Reference:- mysqli::prepare

edited Oct 14, 2017 at 8:07

answered Oct 14, 2017 at 5:43

Death-is-the-real-truth

72.3k10 gold badges59 silver badges105 bronze badges

3 Comments

Space Octopus Over a year ago

Wow that makes me feel really stupid. But thank you for taking the time to read this and answer my question.

Strawberry Over a year ago

@SpaceOctopus or you can order the array in php, or, my preferred method, handle the display order with a bit of JavaScript.

Death-is-the-real-truth Over a year ago

@SpaceOctopus glad to help you :):). Please take care of note section too

Death-is-the-real-truth · Accepted Answer · 2017-10-14 07:57:51Z

1

You need to sort mysql result by date and order it in descending order.replace mysql query to this

$sql = "SELECT * FROM post SORT BY date order BY DESC";

edited Oct 14, 2017 at 7:57

Death-is-the-real-truth

72.3k10 gold badges59 silver badges105 bronze badges

answered Oct 14, 2017 at 5:46

Harry baldaniya

1671 silver badge11 bronze badges

Comments

Ravi Chauhan · Accepted Answer · 2017-10-14 06:07:11Z

0

function getPosts($conn){
    $sql = "SELECT date,message FROM post ORDER BY date DESC";
    $result = mysqli_query($conn, $sql);
    while($row = $result->fetch_assoc()){
        echo "<div class='post-box'>";
        echo $row['date']."<br>";
        echo nl2br($row['message'])."<br><br>";
        echo "</div>";
    }
}

answered Oct 14, 2017 at 6:07

Ravi Chauhan

1,53513 silver badges30 bronze badges

Collectives™ on Stack Overflow

PHP mySQL Sort post by date

4 Answers 4

Comments

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related