Advertisement
Guest User

consulta.php

a guest
Mar 6th, 2016
116
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.59 KB | None | 0 0
  1. <?php
  2. $nivel_usuario = 1;
  3.  
  4. $mysql_db_hostname = "sql103.byethost13.com";
  5. $mysql_db_user = "b13_17571428";
  6. $mysql_db_password = "**********";
  7. $mysql_db_database = "b13_17571428_app";
  8.  
  9. $con = @mysqli_connect($mysql_db_hostname, $mysql_db_user, $mysql_db_password, $mysql_db_database);
  10.  
  11. $var = array();
  12.  
  13. $sql = "SELECT nome,preco FROM produto WHERE id_acesso = $nivel_usuario";
  14.  
  15. $result = mysqli_query($con, $sql);
  16.  
  17. while($obj = mysqli_fetch_object($result)) {
  18.  
  19. $var[] = $obj;
  20.  
  21. }
  22.  
  23. header('Content-Type: application/json; charset=UTF-8');
  24. echo '{"produtos":'.json_encode($var).'}';
  25. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement