see more[indeed_popups id=2]

OPINIONES HOTEL REGIO 2

Conozca las diferentes opiniones y comentarios del Hotel Regio 2. Aquí encontrará fácilmente, todas las reseñas que algunos de nuestros huéspedes han querido dejarnos tras su paso por nuestro hotel. Descubra sus opiniones y valoraciones sobre el Hotel Regio 2 y haga su reserva con plena confianza.

connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "SELECT * FROM opiniones WHERE validado=0"; $result = $conn->query($sql); $totalResultados = $result->num_rows; $rowsperpage = 6; $totalpages = ceil($totalResultados / $rowsperpage); if (isset($_GET['currentpage']) && is_numeric($_GET['currentpage'])) { // cast var as int $currentpage = (int) $_GET['currentpage']; } else { // default page num $currentpage = 1; } // end if // if current page is greater than total pages... if ($currentpage > $totalpages) { // set current page to last page $currentpage = $totalpages; } // end if // if current page is less than first page... if ($currentpage < 1) { // set current page to first page $currentpage = 1; } // end if $offset = ($currentpage - 1) * $rowsperpage; ?> connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "SELECT AVG(limpieza),AVG(ubicacion),AVG(servicios),AVG(personal),AVG(precio) FROM opiniones WHERE validado =0"; $result = $conn->query($sql); if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { //$mediaLimpieza = $row["AVG(limpieza)"]; $mediaLimpieza = round($row["AVG(limpieza)"], 1, PHP_ROUND_HALF_UP); $mediaUbicacion = round($row["AVG(ubicacion)"], 1, PHP_ROUND_HALF_UP); $mediaServicios = round($row["AVG(servicios)"], 1, PHP_ROUND_HALF_UP); $mediaPersonal = round($row["AVG(personal)"], 1, PHP_ROUND_HALF_UP); $mediaPrecio = round($row["AVG(precio)"], 1, PHP_ROUND_HALF_UP); } } else { echo "0 results"; } $conn->close(); ?>
  • Excelente
  • Sobre opiniones
    connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "SELECT * FROM opiniones WHERE validado =0 LIMIT $offset , $rowsperpage"; $result = $conn->query($sql); if ($result->num_rows > 0) { $contador = 0; while($row = $result->fetch_assoc()) { /*echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "
    ";*/ $comentario = strip_tags($row["comentario"]); if (strlen($comentario) > 150) { // truncate string $stringCut = substr($comentario, 0, 150); // make sure it ends in a word so assassinate doesn't become ass... $comentario = substr($stringCut, 0, strrpos($stringCut, ' '))."... Leer Mas"; $comentario = $comentario . ""; //$modal = ""; } echo "
    • " . ($row["limpieza"]+$row["ubicacion"]+$row["servicios"]+$row["personal"]+$row["precio"])/5 . "
    • ". $row["pais"] .", " .$row["publicado"] . "" . $comentario . "
  • "; $contador++; } } else { /*echo "0 results";*/ } $conn->close(); ?>
    1) { // show << link to go back to page 1 //echo " << "; // get previous page num $prevpage = $currentpage - 1; // show < link to go back to 1 page //echo " < "; } // end if // loop to show links to range of pages around current page for ($x = ($currentpage - $range); $x < (($currentpage + $range) + 1); $x++) { // if it's a valid page number... if (($x > 0) && ($x <= $totalpages)) { // if we're on current page... if ($x == $currentpage) { // 'highlight' it but don't make a link /*echo " [$x] ";*/ echo "
  • $x
  • "; // if not current page... } else { // make it a link echo "
  • $x
  • "; } // end else } // end if } // end for // if not on last page, show forward and last page links if ($currentpage != $totalpages) { // get next page $nextpage = $currentpage + 1; // echo forward link for next page //echo " > "; // echo forward link for lastpage //echo " >> "; } // end if /****** end build pagination links ******/ ?>