Advertisement
Guest User

Untitled

a guest
Dec 3rd, 2016
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.91 KB | None | 0 0
  1. <?php
  2.  
  3. global $link;
  4.  
  5. function get_data() {
  6.     global $link;
  7.  
  8.     $databaseHost = '127.0.0.1';
  9.     $databaseName = '';
  10.     $databaseUser = '';
  11.     $databasePassword = '';
  12.  
  13.     $link = mysqli_connect($databaseHost, $databaseUser, $databasePassword, $databaseName);
  14.  
  15.     $query = "SELECT * FROM tabla";
  16.  
  17.     $results = mysqli_query($link, $query) or die('Error querying database.');
  18.  
  19.     $data = array();
  20.  
  21.     while ($row = mysqli_fetch_array($results) ) {
  22.  
  23.         $data[ $row['posicion'] ] = $row;
  24.     }
  25.  
  26.     return $row;
  27. }
  28.  
  29. $data = get_data();
  30. $maxDivs = 100;
  31.  
  32. for ($i = 1; $i <= $maxDivs; $i++) {
  33.     if (isset($data[$i]) ) {
  34.         $row = $data[$i];
  35.  
  36.         print '<div>';
  37.         print $row['posicion'];
  38.         print '<br>';
  39.         print $row['nombre'];
  40.         print '<br>';
  41.         print $row['descripcion'];
  42.         print '<br>';
  43.         print $row['fecha'];
  44.         print '<br>';
  45.         print '</div>';
  46.  
  47.  
  48.     } else {
  49.         print '<div>EMPTY DIV</div>';
  50.     }
  51. }
  52.  
  53. mysqli_close($link);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement