Advertisement
Guest User

Untitled

a guest
Jan 24th, 2017
161
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.61 KB | None | 0 0
  1. <style type="text/css">
  2. .tg {border-collapse:collapse;border-spacing:0;border-color:#999;}
  3. .tg td{font-family:Arial, sans-serif;font-size:14px;padding:10px 5px;border-style:solid;border-width:0px;overflow:hidden;word-break:normal;border-color:#999;color:#444;background-color:#F7FDFA;}
  4. .tg th{font-family:Arial, sans-serif;font-size:14px;font-weight:normal;padding:10px 5px;border-style:solid;border-width:0px;overflow:hidden;word-break:normal;border-color:#999;color:#fff;background-color:#26ADE4;}
  5. .tg .tg-qvbt{color:#3166ff;vertical-align:top}
  6. .tg .tg-yw4l{vertical-align:top}
  7. </style>
  8. <?php
  9.  
  10. $server = "localhost";
  11. $user = "root";
  12. $pass = "";
  13. $bd = "prueba";
  14.  
  15. //Creamos la conexión
  16. $conexion = mysqli_connect($server, $user, $pass,$bd)
  17. or die("Ha sucedido un error inexperado en la conexion de la base de datos");
  18.  
  19. //generamos la consulta
  20. $sql = "SELECT * FROM estudiante";
  21. mysqli_set_charset($conexion, "utf8"); //formato de datos utf8
  22.  
  23. if(!$result = mysqli_query($conexion, $sql)) die();
  24.  
  25. $clientes = array(); //creamos un array
  26.  
  27. while($row = mysqli_fetch_array($result))
  28. {
  29. $id=$row['id'];
  30. $nombre=$row['nombre'];
  31. $apellido=$row['apellido'];
  32.  
  33. $estudiante[] = array('id'=> $id, 'nombre'=> $nombre, 'apellido'=> $apellido);
  34.  
  35. }
  36.  
  37.  
  38. foreach ($estudiante as $key => $value) {
  39. // print_r ($value);
  40.  
  41. echo '<table border="1" class="tg">
  42. <td class="tg-qvbt">'.$value['nombre'].'</td>
  43. <td class="tg-yw4l">'.$value['apellido'].'</td>
  44. </table>';
  45. }
  46.  
  47. //desconectamos la base de datos
  48. $close = mysqli_close($conexion)
  49. or die("Ha sucedido un error inexperado en la desconexion de la base de datos");
  50.  
  51.  
  52.  
  53. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement