Advertisement
Guest User

Untitled

a guest
Nov 23rd, 2017
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.21 KB | None | 0 0
  1. <?php
  2.  
  3. function conectaDB ()
  4. {
  5. $servername = "localhost";
  6. $username = "root";
  7. $password = "";
  8. $dbname="alumno";
  9.  
  10. //crear conexion
  11. $conn = new mysqli($servername,$username,$password, $dbname);
  12.  
  13. //Comprueba la conexion
  14. if ($conn->connect_error){
  15. return FALSE;
  16. }else{
  17. $conn->set_charset('utf8');
  18. return $conn;
  19. }
  20. }
  21.  
  22. function leetabla($conn, $latabla='')
  23. {
  24. $consulta = "SELECT * FROM $latabla";
  25. $resultado = $conn->query($consulta);
  26.  
  27. if($resultado->num_rows>0)
  28. {
  29. $arraydatos = array();
  30. while($file = $resultado->fetch_assoc()){
  31. $datos = array($file['dni'], $file['nombre'], $file['apellido']
  32. , $file['telefono']);
  33. $arraydatos[] = $datos;
  34. }
  35. return $arraydatos;
  36. }
  37. else return FALSE;
  38. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement