Guest User

Untitled

a guest
Oct 25th, 2017
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.08 KB | None | 0 0
  1. <?php
  2.  
  3. $host = "localhost";
  4. $db_user = "root";
  5. $db_pass = "123456";
  6. $database = "database";
  7.  
  8. $db = new mysqli($host, $db_user, $db_pass, $database);
  9.  
  10. ?>
  11.  
  12. <?php
  13.  
  14. class Token
  15. {
  16. function usuarioToken($token)
  17. {
  18. include("../modules/config.php");
  19.  
  20. // Seleccion de datos segun token
  21. $sql = "SELECT * FROM `tokens` WHERE `token`='".$token."'";
  22. $db->query($sql);
  23. $buffer = [];
  24. while ($data = $db->fetch_assoc) {
  25. $buffer[] = $data["id"];
  26. }
  27. return $buffer;
  28. }
  29. }
  30.  
  31. ?>
  32.  
  33. <?php
  34.  
  35. include("../classes/token.php");
  36.  
  37. $token = new Token();
  38.  
  39. print_r( $token->usuarioToken($_GET["t"]) );
  40.  
  41. ?>
  42.  
  43. Array ( )
  44.  
  45. class Token
  46. {
  47. function usuarioToken($token)
  48. {
  49. include("../modules/config.php");
  50.  
  51. // Seleccion de datos segun token
  52. $sql = "SELECT * FROM `tokens` WHERE `token`='".$token."'";
  53. $resultado=$db->query($sql); //Resultado de la consulta
  54. $buffer = [];
  55. while ($data = $resultado->fetch_assoc()) { //con ()
  56. $buffer[] = $data["id"];
  57. }
  58. return $buffer;
  59. }
  60. }
  61.  
  62. class Token
  63. {
  64. function usuarioToken($token)
  65. {
  66. include("../modules/config.php");
  67.  
  68. if ($db)
  69. {
  70.  
  71. // Seleccion de datos segun token
  72. $sql = "SELECT id FROM `tokens` WHERE `token`=?"; //Parece que sólo quieres el id
  73.  
  74. $stmt=$db->prepare($sql);
  75.  
  76. if ($stmt){
  77. $stmt->bind_param("s", $token);
  78. $stmt->execute();
  79. $stmt->store_result();
  80. $resultado=$db->query($sql); //Resultado de la consulta
  81. $buffer = [];
  82. while ($data = $resultado->fetch_assoc()) { //con ()
  83. $buffer[] = $data["id"];
  84. }
  85.  
  86. return $buffer;
  87. $stmt->close();
  88.  
  89. }else{
  90.  
  91. echo "Error preparando la consulta";
  92.  
  93. }
  94.  
  95. //Cerrar $db si es preciso
  96.  
  97. }else{
  98.  
  99. echo "Error en la conexión";
  100.  
  101. }
  102.  
  103.  
  104. }
  105. }
Add Comment
Please, Sign In to add comment