} else { $sql->execute(array($categorie)); } if ($useSQLite === TRUE) { $buffer = array(); foreach ($sql as $row) { $buffer[] = $row; } $counter = count($buffer); } else { $counter = $sql->rowCount(); } echo '<div class="col-xs-12 col-sm-6 col-md-4">'; echo '<div class="text-left rounded border boxer">'; echo '<a href="./?categorie=' . $categorie . '" style="text-decoration: none;">'; echo '<img class="img-thumbnail" src="' . getImageByName("img/", $categorie, 1) . '" alt="' . $categorie . '" >'; echo '<div class="regions">'; echo '<p>' . $categorie . ' <span class="badge pull-right">' . $counter . '</span></p>'; echo '</div>'; echo '</a>'; echo '</div>'; echo '</div>'; } catch (PDOException $e) { $message = ' <pre> Unable to query database ... Error code: ' . $e->getCode() . ' Error file: ' . $e->getFile() . ' Error line: ' . $e->getLine() . ' Error data: ' . $e->getMessage() . ' </pre>
// $object_uuid = $row->object_uuid; $categorie_name = $row->categorie_name; $http_server_url = $row->http_server_url; $agents_online = $row->agents_online; // $locX = $row['locX']; // $locY = $row['locY']; // $sizeX = $row['sizeX']; // $sizeY = $row['sizeY']; // $aera = $sizeX * $sizeY; $local_position = $row->local_position; $region_aera = 65536; $last_update = $row->date; echo '<div class="col-md-6">'; echo '<div class="text-left rounded border boxer">'; echo '<a href="secondlife://' . $region_name . '/' . $local_position . '" target="_self" style="text-decoration: none;">'; echo '<img class="img-thumbnail" src="' . getImageByName("img/", $region_name, 1) . '" alt="' . $region_name . '" >'; echo '</a>'; echo '</div>'; echo '</div>'; echo '<div class="col-md-6">'; echo '<div class="regiondetails rounded border">'; echo '<p>'; echo $region_name . ' <span class="pull-right">' . $region_aera . ' m²</span><br />'; echo 'Owner name : <span class="pull-right">' . $owner_name . '</span><br />'; echo 'Agents online : <span class="badge pull-right">' . $agents_online . '</span><br />'; echo 'Categorie name : <span class="pull-right">' . $categorie_name . '</span><br />'; echo 'Last Update : <span class="pull-right">' . $last_update . '</span><br />'; echo 'Terminal Name : <span class="pull-right">' . $object_name . '</span><br />'; echo 'Local Position : <span class="pull-right">' . $local_position . '</span><br />'; echo '</p>'; echo '<form class="form-horizontal" role="form" action="?refresh=' . $region_name . '&url=' . base64_encode($http_server_url) . '" method="post">';
$query->execute(); /* SQLITE */ if ($useSQLite === TRUE) { $buffer = array(); foreach ($query as $row) { $buffer[] = $row; } $counter = count($buffer); } else { $counter = $query->rowCount(); } echo '<div class="regionspics shadows radius">'; echo '<div class="boxer radius">'; echo '<hr class="up"><hr class="down">'; echo '<a href="destinations.php?categorie=' . $categorie_number . '" target="_self" style="text-decoration: none;">'; echo '<img class="" src="' . getImageByName("../img/", $categorie_name, 2) . '" alt="' . $categorie_name . '" >'; echo '<div class="regions">'; echo '<hr class="up">'; echo '<hr class="down">' . $categorie_name; echo '<span>' . $counter . '</span>'; echo '<hr class="up">'; echo '<hr class="down">'; echo '<hr class="up">'; echo '<hr class="down">'; echo '</div>'; echo '</a>'; echo '</div>'; echo '</div>'; } echo '</div>'; echo '</div>';