Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- COdigo Nombre
- [137,221] Jose Perez
- [127,241] Juan Gomez
- SELECT nombre FROM user WHERE UID='[137,221]';
- try{
- $dbnames= "tubasededatos";
- $host="tuhost";
- $user="usuariodelabd";
- $pass="passdeluser";
- $tabla="nombretabla";
- $dsn = "mysql:dbname=$dbnames;host=$host";
- $pdo = new PDO($dsn, $user, $pass);
- $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- $ssql = "SELECT * FROM $tabla WHERE UID='[127,241]'";
- $rs = $pdo->prepare($ssql);
- $rs->execute();
- while ($fila = $rs->fetchAll(PDO::FETCH_ASSOC)){
- foreach($fila as $row){
- echo "Nombre de usuario: ".$row['Nombre'];
- }
- }
- }catch(PDOException $error){
- echo 'Error de conexión: ' . $error;
- echo "Se ha producido un error y no se han podido bajar los datos de la BD.";
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement