Guest User

Untitled

a guest
Oct 21st, 2013
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <?php
  2.  
  3. session_start();
  4. echo "Tu usuario es: ".$_SESSION['usuario']."</br> Tu contrase&ntildea es: ".$_SESSION['contrasena'];
  5.  
  6. //Crear conexion
  7. $conexion = new PDO('sqlite:favoritos.db');
  8. //Establecer una consulta
  9. $consulta = "SELECT * FROM favoritos WHERE usuario ='xx' AND contrasena ='xx';";
  10. //Ejecutar una consulta
  11. $resultado = $conexion->query($consulta);
  12. //Imprimir la consulta
  13. while($fila = $resultado->fetchArray(SQLITE3_ASSOC)){
  14.     echo $fila['titulo'].$fila['direccion'].$fila['categoria'].$fila['comentario'].$fila['direccion'].$fila['valoracion'];
  15. }
  16. //Cerramos la consulta
  17. $conexion = null;
  18. ?>
Advertisement
Add Comment
Please, Sign In to add comment