Advertisement
Guest User

Untitled

a guest
Mar 5th, 2019
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.77 KB | None | 0 0
  1. COdigo Nombre
  2. [137,221] Jose Perez
  3. [127,241] Juan Gomez
  4.  
  5. SELECT nombre FROM user WHERE UID='[137,221]';
  6.  
  7. try{
  8. $dbnames= "tubasededatos";
  9. $host="tuhost";
  10. $user="usuariodelabd";
  11. $pass="passdeluser";
  12. $tabla="nombretabla";
  13.  
  14. $dsn = "mysql:dbname=$dbnames;host=$host";
  15. $pdo = new PDO($dsn, $user, $pass);
  16. $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  17. $ssql = "SELECT * FROM $tabla WHERE UID='[127,241]'";
  18. $rs = $pdo->prepare($ssql);
  19. $rs->execute();
  20. while ($fila = $rs->fetchAll(PDO::FETCH_ASSOC)){
  21. foreach($fila as $row){
  22. echo "Nombre de usuario: ".$row['Nombre'];
  23. }
  24. }
  25. }catch(PDOException $error){
  26. echo 'Error de conexión: ' . $error;
  27. echo "Se ha producido un error y no se han podido bajar los datos de la BD.";
  28. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement