Display records from multiple table in PDO mysql

Question

Want to print Participant information like firstName, organization from two different table. Query is working properly as it is giving desired results. But when I try to print fetched data, it returns an error.

function get_all_participant(){
  include 'connection.php';

  $sql = '
select p1.fname
     , p1.organization
     , p1.state
     , p2.created
  from participant p1
     INNER JOIN programme_participant p2 
 ON p1.id = p2.participant_id
';
  try{
    $results = $db->prepare($sql);
    $results->execute();
  } catch (Exception $e){
    echo "Error! " . $e->getMessage() . "<br/>";
    return false;
  }
  return $results->fetch();

}

<?php foreach (get_all_participant() as $item){
         echo $item['fname'];
  }?>

Output(error):

Warning: Illegal string offset 'fname'

you don't understand. What is the result from the array `get_all_participant()` — Rotimi, Apr 18 '17 at 07:11
It returns participant information. `return $results->fetch();` — GKumar, Apr 18 '17 at 07:11
Incidentally, we stopped writing queries this way circa 1992. Join us. — Strawberry, Apr 18 '17 at 07:11

score 0 · Accepted Answer · answered Apr 18 '17 at 07:11

0

Try to use

$result = $results->fetchAll();

if query return multiple records then fetch function will not work

answered Apr 18 '17 at 07:11

jignesh prajapati

77
2
10

Thank you for the quick response. – GKumar Apr 18 '17 at 07:15

Display records from multiple table in PDO mysql

1 Answers1