通过单击行的标题链接显示表的整行？

Question

The thing I want to is like the job done in many news websites. Suppose I have a table of news. Each news have title and full text. So I want to show the news in a page. I want to limit the news displayed in a page to for example three news per page (using the limit query which is easy) and I want to show only the titles. But I want the titles to be a link to the full text news. I mean when a user clicks on it, a new page shows up with the full text of that news. So what should I do?

Answer 1

news_titles.php:

 <?php
 //connection; then simple mysql_query and fetch (mysql is deprecated, so reconstruct it with another lib
 $sql = "SELECT id, news_content, news_title FROM news;";
 $result = mysql_query($sql);
 while ($row = mysql_fetch_assoc($result)) {
    ?>
  <a href="news.php?id=<?=$row['id']; ?>"><?= $row['news_title']; ?></a>
 <?php

 }   
 ?>

then create news.php:

 <?php
 //connection; then simple mysql_query and fetch (mysql is deprecated, so reconstruct it with another lib
 $sql = "SELECT id, news_content, news_title FROM news WHERE id = ". $_GET['id'] . ";";
 $result = mysql_query($sql);
 while ($row = mysql_fetch_assoc($result)) {
   ?>
 <p><?= $row['news_content']; ?>
 <?php

  }
 ?>

It will create you hyperlinks with news title's leading to news id and showing news_content in it. It will access news.php via i.e. news.php?id=5

If you get the idea, you may change some things for more security, clean and fresh code, and design