Guest User

sqlite:3

a guest
Oct 21st, 2013
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.60 KB | None | 0 0
  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 SQLite3('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('')){
  14.    echo $fila['titulo'].$fila['direccion'].$fila['categoria'].$fila['comentario'].$fila['direccion'].$fila['valoracion'];
  15. }
  16. //Cerramos la consulta
  17. $conexion->close();
  18. ?>
Advertisement
Add Comment
Please, Sign In to add comment