Advertisement
Guest User

Untitled

a guest
Jun 19th, 2019
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.81 KB | None | 0 0
  1. public function Traer($array){
  2. $SQL = 'SELECT po.Locacion, po.nombre_usuario, po.id, ur.url FROM usuarios po LEFT JOIN imgperfil ur ON po.id=ur.id WHERE po.Locacion=:Locacion';
  3. $stmt= $this->pdo->prepare($SQL);
  4. $stmt->fetch(PDO::FETCH_ASSOC);
  5. $stmt->execute($array);
  6. return $stmt->fetchAll();
  7. }
  8.  
  9. $Locacion = $_SESSION['Lugar'];
  10.  
  11. $Resultado = $FunctionTraer->Traer([':Locacion' => $Locacion]);
  12.  
  13. print_r($Resultado);
  14. ?>
  15.  
  16. <?php foreach ($Resultado as $key => $value) { ?>
  17.  
  18. <div class="ContainerUserChat" onclick="Funct(<?php echo $value['id']; ?>)">
  19. <div class="DatosUser">
  20. <div class="ImgUpload">
  21. <img src="<?php echo $value['url']; ?>">
  22. </div>
  23. <p class="NameUser">
  24. <?php echo $value['nombre_usuario']; ?>
  25. </p>
  26. <small> <?php echo $value['Locacion']; ?></small>
  27. </div>
  28. </div>
  29.  
  30. <?php } ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement