HotelDruid

Hi

I understand php coding quite a bit but you have named your tables in some other language so it will be really great if you can help me out with what each table is meant to me.

Actually i am trying to make a car rental system based your apartment booking. Apartment = cars

I am quite confused how you are determining whether an apartment in available on a particular time period . Can you please explain me based on which information you are making this query.

I understand this is the part of the code that is doing the trick please can you explain me how

---------------------------------
if ($verificare != "NO") {
for ($num1 = $idinizioperiodo[$n_t]; $num1 <= $idfineperiodo[$n_t]; $num1 = $num1 + 1) {
$prenotazioni = esegui_query("select * from $tableprenota where iddatainizio <= $num1 and iddatafine >= $num1");
$numprenotazioni = numlin_query($prenotazioni);
$rigasettimana = esegui_query("select * from $tableperiodi where idperiodi = '$num1' ");
if ($numprenotazioni >= $numappartamenti) {
if (!$mostra_quadro_disp) $verificare = "NO";
$inizioperiodopieno = risul_query($rigasettimana,0,'datainizio');
$inizioperiodopieno_f = formatta_data($inizioperiodopieno,$stile_data);
$fineperiodopieno = risul_query($rigasettimana,0,'datafine');
$fineperiodopieno_f = formatta_data($fineperiodopieno,$stile_data);
if ($mostra_giorni_pieni == "SI") echo "$fr_parola_La $fr_parola_settimana $fr_dal $inizioperiodopieno_f $fr_al $fineperiodopieno_f $fr_est $fr_piena".".<br>";
} # fine if ($numprenotazioni >= $numappartamenti)
} # fine for $num1
if ($verificare == "NO" and $mostra_giorni_pieni != "SI") {
echo "$fr_Non_c_e_piu_disponibilita_nel_periodo_richiesto";
if ($verificare == "NO" and $num_tipologie > 1) echo " ($n_t)";
if ($verificare == "NO") echo ".<br>";
} # fine if ($verificare == "NO" and $mostra_giorni_pieni != "SI")
} # fine if ($verificare != "NO")
-------------------------------

Reservations are inserted in prenotaXXXX (XXXX = year) tables. Each reservation (row) has the ids of apartment (idappartamenti referring to appartamenti table), starting date (iddatainizio referring to periodiXXXX table) and ending date (iddatafine referring to periodiXXXX table), availability is calculated from these data. The code to calculate availability is in the liberasettimane function (in file includes/liberasettimane.php).

Marco