web programming

Need a pagination for my website
To output one post only in the home page

Comments

[Paweł Grabowski]

Has your website any CMS? Any framework? What's the technology used to build it?

[Kelvince]

Used php,sql,html,js and css
Only

[Paweł Grabowski]

Don't know, what exactly you need, but maybe a simple slider would work. Get 5 posts from database and use slick for example (kenwheeler.github.io/slick/) with dots (you can style it as numbers).

[Kelvince]

Some sort of that.
Exactly what i need is pagination in php, where it will display one recent post from the database only in the homepage and display the previous post as a link

[Paweł Grabowski]

So the same for me. Get a few posts (or partial of posts like thumb, short description, id and slug), and in a loop make a condition: if first - show article (part of article) and if next - put just links. So you have to generate links by slug or by id (no idea, what your database looks like).

[Kelvince]

Yeah this but display the post body for one post

[Paweł Grabowski]

You will get more content from database, than you need, but if it is just a 5-10 posts, there is completely no problem at all. And to show only one post content you have to make a simple condition like:


for( $x = 0; $x <= 10; $x++ ) {
if( $x == 0 ) {
echo $result[$i]->title;
echo $result[$i]->content;
} else {
echo '<a href="'. $result[$i]->link .'">'. $result[$i]->title .'</a>';
}
}


where $result is data from your database

[Kelvince]

Ok let me work on this,thanks alot

[Paweł Grabowski]

Good luck and if you will have any problems, paste here (or codepen) some part of code you have. It will be easier to help

[Kelvince]

My pleasure

[Kelvince]

Using php,getting the posts from the database

[Kelvince]

mysql_query()

[Kelvince]

Saw the code near to what i wanted,thanks