Please everyone, I need a code in PHP that will help me to create a link on post titles after getting the data from database.

This link will now lead to the contents of the post.

Same thing as the homepage of this Nairaland forum.

am so surprised nobody has answered this question since it was posted

demo (not real code but it will help you out):

lets say for example your mysql table for post look like below:

Table : blog_post

-----id---|----title-----|-----content------------------------------------------|-date-------|------author------|

34 | davido hate rice | now is clear that davido hate rice because of stew | 2018-07-23 | aboy_dj


now your php code should be something like this - follow the steps well

1. make connection to database (mysqli or pdo) me i use only pdo beacuse of the ease and advantage
2. prepare and query your dbase for the info use name
example :

sql = "select * from blog_post";


after you fetch and get data you need


loop through you fetched data

and do some thing like this

while(data):

echo "<div><h1>".data["title"]."</h1></div>";



that's it

in order to achieve that you'll need to use url rewrite

example
d link will be something like www.mysite.com/davido-hate-rice

since this url does not exist you have to redirect all request to a particular page where the contents of d url are used to make database lookup

u can achieve this by crrating .htaccess file
and write

FallbackResource /fallbackpage.php