Reserve now

Check In
Check Out
Rooms:
Adult Nº room 1
Child Nº room 1
Promo code:

REVIEWS HOTEL REGIO 2

Know the different reviews and comments of the Regio 2 Hotel . Here you will find easily, all the reviews that some of our guests have wanted to leave us after visiting our hotel.
Discover your reviews and ratings on Regio 2 Hotel and make your reservation with full confidence.

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();

?>

  • Excelent
  • On reviews
 

 

 

 

 

 
 
 
    • 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 “

“;
} // 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 ******/
?>

 



[/raw]