How to execute PDO in a variable PHP

Question

while($row =$result->fetch())
 {
       $output .= ' 
  <tr>  
       <td>' . $row["ID_personne"] . '</td> 
       <td>' . $row["Nom"] . '</td>  
       <td>' . $row["Prenom"] . '</td>  
       <td>' . $row["Telephone"] . '</td>  
       <td>' . $row["Mail"] . '</td>  
       <td>' . $row["Categorie"] . '</td>  
       <td>' . $row["Type"] . '</td>
            '.$q2 = $db->prepare("SELECT * FROM entretiens WHERE ID_entretien=:id");
            $q2->bindValue(":id",$row["Entretien"]);
            $q2->execute();
            $entretien=$q2->fetch().'

       <td>'.$entretien["Date"].'</td>  
       <td width=250>
                <a class="btn btn-primary" href="update_personnes.php?ID_personne='.$row["ID_personne"].'"><span class="glyphicon glyphicon-pencil"></span> Modifier</a>

                <a class="btn btn-danger" href="delete_personnes.php?ID_personne='.$row["ID_personne"].'"><span class="glyphicon glyphicon-remove"></span> Supprimer</a>
        </td>  
  </tr>';
  }
 $output .= '</table>';
 echo $output;

I have always an Error: ( ! ) Catchable fatal error: Object of class PDOStatement could not be converted to string in C:.......... on line 61('.$q2 = $db->prepare("SELECT * FROM entretiens WHERE ID_entretien=:id"); $row["Entretien"] it's a foreign key

Wouldn't it be easier to just use a JOIN inside the original query and retrieve all data at once? It seems you'll issue lots of queries currently depending on the size of the original query. — Sirko
– Sirko, Commented Jul 3, 2018 at 8:42
You'd do yourself a lot of favours by formatting your code and making it neater when you write it. — Script47
– Script47, Commented Jul 3, 2018 at 8:45

Lovepreet Singh · Accepted Answer · 2018-07-03 08:45:03Z

There was some syntax error in your code as $q2 is being concat with html string. Improved code should be:

while ($row = $result->fetch()) {
    $output .= ' 
  <tr>  
       <td>' . $row["ID_personne"] . '</td> 
       <td>' . $row["Nom"] . '</td>  
       <td>' . $row["Prenom"] . '</td>  
       <td>' . $row["Telephone"] . '</td>  
       <td>' . $row["Mail"] . '</td>  
       <td>' . $row["Categorie"] . '</td>
       <td>' . $row["Type"] . '</td>';
    $q2 = $db->prepare("SELECT * FROM entretiens WHERE ID_entretien=:id");
    $q2->bindValue(":id", $row["Entretien"]);
    $q2->execute();
    $entretien = $q2->fetch();

    $output .= '<td>' . $entretien["Date"] . '</td>  
       <td width=250>
                <a class="btn btn-primary" href="update_personnes.php?ID_personne=' . $row["ID_personne"] . '"><span class="glyphicon glyphicon-pencil"></span> Modifier</a>

                <a class="btn btn-danger" href="delete_personnes.php?ID_personne=' . $row["ID_personne"] . '"><span class="glyphicon glyphicon-remove"></span> Supprimer</a>
        </td>  
  </tr>';
}
$output .= '</table>';
echo $output;

Collectives™ on Stack Overflow

How to execute PDO in a variable PHP

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related