如何使用会话从多个表中检索数据?

mfuanj7w  于 2021-06-20  发布在  Mysql
关注(0)|答案(0)|浏览(320)

我正在做一个动态网站。我的主页左侧显示个人简介,右侧显示他撰写的文章。这是我的主页。当我单击“阅读更多”时,该特定文章应在左侧的新页面中打开,其余由同一个人撰写的文章应显示在右侧。但这里所有的文章都显示了这是我博客页面的图片。我只希望选中的文章显示在左边,其余的文章都显示在右边。
这是我放文章的table。在第一页中,我使用个人id调用右侧的文章。这是我第一页的代码:

  1. <div class="container">
  2. <?php
  3. session_start();
  4. $q = $_SESSION['id'];
  5. $con=mysql_connect("localhost","root","");
  6. mysql_select_db("demo_db",$con);
  7. $sql="select * from person_details where id=$q";
  8. $res=mysql_query($sql);
  9. while($ar=mysql_fetch_array($res))
  10. {
  11. ?>
  12. <div>
  13. <div class="row">
  14. <div style="background-color:rgba(125, 178, 194, 0.43); margin-bottom:10px;" class="col-sm-8 col-md-8 col-lg-8">
  15. <div class="row">
  16. <div class="col-sm-4 col-md-4 col-lg-4">
  17. <img style="margin:20px;" src="uploads/<?php echo $ar[17]; ?>">
  18. </div>
  19. <div class="col-sm-8 col-md-8 col-lg-8">
  20. <h3><b>Mr. <?php echo $ar[1];?></b></h3>
  21. <h5><?php echo $ar[8];?>, <?php echo $ar[12];?></h5>
  22. <h5><?php echo $ar[2];?>, <?php echo $ar[7];?> years of experience</h5>
  23. <p><?php echo $ar[16];?></p>
  24. </div>
  25. </div>
  26. <div style="margin:20px;">
  27. <h4><b>Services</b></h4>
  28. <hr>
  29. <ul>
  30. <li>
  31. <h5><?php echo $ar[18]; ?></h5>
  32. </li>
  33. </ul>
  34. <h4><b>Specialisations</b></h4>
  35. <hr>
  36. <ul>
  37. <li>
  38. <h5><?php echo $ar[2]; ?></h5>
  39. </li>
  40. </ul>
  41. <h4><b>Education</b></h4>
  42. <hr>
  43. <ul>
  44. <li>
  45. <h5><?php echo $ar[8]; ?> - <?php echo $ar[9]; ?> , <?php echo $ar[10]; ?> , <?php echo $ar[11];?></h5>
  46. </li>
  47. </ul>
  48. <ul>
  49. <li>
  50. <h5><?php echo $ar[12]; ?> - <?php echo $ar[13]; ?> , <?php echo $ar[14]; ?> , <?php echo $ar[15];?></h5>
  51. </li>
  52. </ul>
  53. </div>
  54. </div>
  55. <div class="col-sm-4 col-md-4 col-lg-4">
  56. <h3>Articles by Mr. <?php echo $ar[1];?></h3><?php } ?>
  57. <hr>
  58. <?php
  59. $sql1="select * from article_tb where id=$q";
  60. $res1=mysql_query($sql1);
  61. while($ar=mysql_fetch_array($res1))
  62. {
  63. $_SESSION['id'] = $q;
  64. ?>
  65. <h4><b><?php echo $ar[1]; ?></b></h4>
  66. <div class="row">
  67. <div class="col-sm-6 col-lg-6 col-md-6">
  68. <img src="uploads/<?php echo $ar[3]; ?>" width="170px" height="88">
  69. </div>
  70. <div class="col-sm-6 col-md-6 col-lg-6">
  71. <?php echo $ar[5]; ?>
  72. &nbsp; <form action="blog.php">
  73. <input type="submit" class="btn btn-info" name="read" value="read more" />
  74. </form>
  75. </div>
  76. </div>
  77. <hr>
  78. <?php } ?></div>
  79. </div>
  80. </div>

这是我第二页的代码:

  1. <div class="container">
  2. <?php
  3. session_start();
  4. $q = $_SESSION['id'];
  5. $con=mysql_connect("localhost","root","");
  6. mysql_select_db("demo_db",$con);
  7. $sql="select * from article_tb where id=$q";
  8. $res=mysql_query($sql);
  9. while($ar=mysql_fetch_array($res))
  10. {
  11. ?>
  12. <div>
  13. <div class="row">
  14. <div style="border:1px solid #005212;" class="col-sm-8 col-md-8 col-lg-8">
  15. <div class="row">
  16. <center><img style="margin-top:10px;" src="uploads/<?php echo $ar[3]; ?>" /></center>
  17. <div class="col-sm-12 col-md-12 col-lg-12">
  18. <h4><b><?php echo $ar[1]; ?></b></h4>
  19. <p><?php echo $ar[2]; ?></p>
  20. </div>
  21. </div>
  22. </div>
  23. <div class="col-sm-4 col-md-4 col-lg-4">
  24. <h4><b><?php echo $ar[1]; ?></b></h4>
  25. <div class="row">
  26. <div class="col-sm-6 col-lg-6 col-md-6">
  27. <img src="uploads/<?php echo $ar[3]; ?>" width="170px" height="88" />
  28. </div>
  29. <div class="col-sm-6 col-md-6 col-lg-6">
  30. <?php echo $ar[5]; ?>
  31. &nbsp; <form action="blog.php">
  32. <input type="submit" class="btn btn-info" name="read" value="read more" />
  33. </form>
  34. </div>
  35. </div>
  36. <hr>
  37. </div></div></div>
  38. <?php } ?>

有人能帮帮我吗?

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题