I have problem with showing posts from database and pagination
I have this tables in database
admin (for admin login)
articles (for articles) In articles i have
id, title, srtext (short text), lgtext (longtext) and time
Now i want to display that in index.php page, but i have problems.. I tried to download some simple php blogs, but there is no blogs in PHP5, all are the older versions
I tried something like this
<?php
error_reporting(0);
include_once ('admin/includes/config.php');
$sql="SELECT * FROM articles ORDER BY id ASC";
$result = mysqli_query($con, $sql) or die("Error: ".mysqli_error($con));
while($row = mysqli_fetch_array($result))
{
echo strtoupper($row['title']);
}
echo '
<center>
<div class="article">
<h1><?php echo strtoupper($row["title"]); ?></h1>
<p><small>Published: 7/9/2015</small></p>
<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod
tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo
consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse
cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non
proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>
<div class="more">
<button>Read more</button>
</div>
</div>
</center>
';
?>
But dont work..
I forgot to say, i want that when someone press button "read more" to move him to page where is title, time and long text (lgtext in db), can someone help me with this
