Guest User

Untitled

a guest
Jun 23rd, 2018
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.24 KB | None | 0 0
  1. public function getAlL(){
  2. try{
  3.  
  4. $sql = " SELECT tbl_abstract.abstract_id, tbl_abstract.first_name, tbl_abstract.last_name,tbl_abstract.content, tbl_author.afirst_name, tbl_author.alast_name, tbl_author.aaffilition FROM tbl_abstract INNER JOIN tbl_author ON tbl_abstract.abstract_id = tbl_author.abstract_id GROUP BY tbl_abstract.abstract_id " ;
  5.  
  6. $stmt= $this->pdo->prepare($sql);
  7. $stmt->execute();
  8. $count = $stmt ->rowCount();
  9. while($row = $stmt->fetch(PDO::FETCH_ASSOC)){
  10. ?>
  11.  
  12. <table class="table" >
  13. <tr>
  14. <td align="center" >
  15. //data from tbl_abstract
  16. <?php echo $row["abstract_id"]; ?>. <?php print($row["abstract_title"]); ?>
  17. <?php echo $row["first_name"].'&nbsp;'.$row["last_name"]; ?>,
  18.  
  19. //data from tbl_author
  20. <?php echo $row["afirst_name"].'&nbsp;'.$row["alast_name"];?>
  21. </td>
  22. </tr>
  23. <tr>
  24. <td align="center" ">
  25. //data from tbl_abstract
  26. <?php print($row["content"]); ?>
  27. </td>
  28. </tr>
  29.  
  30. </table>
  31. <?php
  32. }
  33. }catch(PDOException $e){
  34. echo $e->getMessage();
  35. return false;
  36. }
Add Comment
Please, Sign In to add comment