Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- global $link;
- function get_data() {
- global $link;
- $databaseHost = '127.0.0.1';
- $databaseName = '';
- $databaseUser = '';
- $databasePassword = '';
- $link = mysqli_connect($databaseHost, $databaseUser, $databasePassword, $databaseName);
- $query = "SELECT * FROM tabla";
- $results = mysqli_query($link, $query) or die('Error querying database.');
- $data = array();
- while ($row = mysqli_fetch_array($results) ) {
- $data[ $row['posicion'] ] = $row;
- }
- return $row;
- }
- $data = get_data();
- $maxDivs = 100;
- for ($i = 1; $i <= $maxDivs; $i++) {
- if (isset($data[$i]) ) {
- $row = $data[$i];
- print '<div>';
- print $row['posicion'];
- print '<br>';
- print $row['nombre'];
- print '<br>';
- print $row['descripcion'];
- print '<br>';
- print $row['fecha'];
- print '<br>';
- print '</div>';
- } else {
- print '<div>EMPTY DIV</div>';
- }
- }
- mysqli_close($link);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement