[ea_bootstrap width=”100%” scroll_off=”true” layout_cols=”2″]
[insert_php]

$servername = “db719171194.db.1and1.com”;
$username = “dbo719171194”;
$password = “zJErKZDpFJrsqRthDbnc”;
$dbname = “db719171194”;

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die(“Connection failed: ” . $conn->connect_error);
}

//$sql = “SELECT DATE_FORMAT(aa.created, ‘%d/%m/%Y’) AS data_creat, DATE_FORMAT(aa.date, ‘%d/%m/%Y’) AS data_reserva, al.name AS nom_hotel, ass.name AS nom_servei, ast.name AS nom_massatgista FROM aOjJOCXWea_appointments AS aa INNER JOIN aOjJOCXWea_locations AS al ON aa.location = al.id INNER JOIN aOjJOCXWea_staff AS ast ON aa.worker = ast.id INNER JOIN aOjJOCXWea_services AS ass ON aa.service = ass.id WHERE aa.location = 15”;

$sql = “SELECT DATE_FORMAT(aa.created, ‘%d/%m/%Y’) AS data_creat, DATE_FORMAT(aa.date, ‘%d/%m/%Y’) AS data_reserva, al.name AS nom_hotel, ass.name AS nom_servei, ast.name AS nom_massatgista, af.value AS habitacio FROM aOjJOCXWea_appointments AS aa INNER JOIN aOjJOCXWea_locations AS al ON aa.location = al.id INNER JOIN aOjJOCXWea_staff AS ast ON aa.worker = ast.id INNER JOIN aOjJOCXWea_fields AS af ON aa.id = af.app_id INNER JOIN aOjJOCXWea_services AS ass ON aa.service = ass.id WHERE af.field_id = 5 ORDER BY data_reserva ASC”;

$sql_from = “SELECT DATE_FORMAT(aa.created, ‘%d/%m/%Y’) AS data_creat, DATE_FORMAT(aa.date, ‘%d/%m/%Y’) AS data_reserva, al.name AS nom_hotel, ass.name AS nom_servei, ast.name AS nom_massatgista, af.value AS habitacio FROM aOjJOCXWea_appointments AS aa INNER JOIN aOjJOCXWea_locations AS al ON aa.location = al.id INNER JOIN aOjJOCXWea_staff AS ast ON aa.worker = ast.id INNER JOIN aOjJOCXWea_fields AS af ON aa.id = af.app_id INNER JOIN aOjJOCXWea_services AS ass ON aa.service = ass.id WHERE af.field_id = 5 AND aa.date >= CURDATE() ORDER BY data_reserva ASC”;

$result = $conn->query($sql);
$result_from = $conn->query($sql_from);

echo ‘

‘;
echo ‘

‘;

if ($result_from->num_rows > 0) {

// output data of each row
$array_dates_from = array();
$cont_from = 0;
while($row_from = $result_from->fetch_assoc()) {
$array_dates_from[] = $row_from[“booking_date”];

echo ‘

  • ‘.$row_from[“data_reserva”].’

    Hotel: ‘ . utf8_encode($row_from[“nom_hotel”]). ‘
    Habitación: ‘ .utf8_encode($row_from[“habitacio”]). ‘
    Servicio: ‘ .utf8_encode($row_from[“nom_servei”]). ‘
    Masajista: ‘ .utf8_encode($row_from[“nom_massatgista”]). ‘
    Reserva hecha el ‘.$row_from[“data_creat”].’

  • ‘;

    $cont_from++;
    }
    } else {
    echo “

    No hay reservas.

    “;
    }

    echo ‘

    ‘;

    echo ‘

    ‘;
    echo ‘

    ‘;

    if ($result->num_rows > 0) {

    // output data of each row
    $array_dates = array();
    $cont = 0;
    while($row = $result->fetch_assoc()) {
    $array_dates[] = $row[“booking_date”];

    echo ‘

  • ‘.$row[“data_reserva”].’

    Hotel: ‘ . utf8_encode($row[“nom_hotel”]). ‘
    Habitación: ‘ .utf8_encode($row[“habitacio”]). ‘
    Servicio: ‘ .utf8_encode($row[“nom_servei”]). ‘
    Masajista: ‘ .utf8_encode($row[“nom_massatgista”]). ‘
    Reserva hecha el ‘.$row[“data_creat”].’

  • ‘;

    $cont++;
    }
    } else {
    echo “

    No hay reservas.

    “;
    }

    echo ‘

    ‘;

    $conn->close();

    [/insert_php]