Advertisement
Guest User

Untitled

a guest
Jan 27th, 2016
165
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.08 KB | None | 0 0
  1. <?php
  2. $user = "root";
  3. $password = "";
  4. $db = "angulardb";
  5. $host = "localhost";
  6. $con = mysqli_connect("localhost", $user, $password, $db);
  7.  
  8. if (mysqli_connect_errno()){
  9. echo "Failed to connect to MySQL: " . mysqli_connect_error();
  10. }
  11.  
  12. $usuario = mysqli_query($con, "SELECT * FROM users");
  13.  
  14. if (!$usuario) {
  15. echo "Não foi possível executar a consulta no banco de dados: " . mysql_error();
  16. exit;
  17.  
  18. }
  19.  
  20. $return = array();
  21.  
  22. while ($dados = mysqli_fetch_assoc($usuario)) {
  23. $return[] = $dados;
  24.  
  25. }
  26. header('Content-Type: application/json');
  27. echo json_encode($return);
  28.  
  29. ?>
  30. Database:
  31.  
  32. CREATE TABLE IF NOT EXISTS `users` (
  33. `id` int(6) NOT NULL AUTO_INCREMENT,
  34. `nome` varchar(50) NOT NULL,
  35. `email` varchar(50) NOT NULL,
  36. `pass` varchar(50) NOT NULL,
  37. PRIMARY KEY (`id`)
  38. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
  39.  
  40. INSERT INTO `users` (`id`, `nome`, `email`, `pass`) VALUES
  41. (2, 'João Silva', 'joao.silva@angular.com', '123456'),
  42. (3, 'Mario de Almeida', 'mario.almeida@angular.com', '123456');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement