Hjælp til at forstår opbygning af tabel med database udtræk
Prøver at lave en table med tid, hvor der skal udtrækkes fra databasen, hvis tiden og datoen passer. Har indtil videre lavet dette script, men får en fejl ved min while function og ved derfor ikke om det overhoved virker på denne måde :o)Får denne fejl syntax error, unexpected '{'
$bookings = db_query($database_name, $sql);
while($bookings_ = fetch_array($bookings){ //fejl?
$day_name_ = date("D", strtotime($bookings_["book_start"]));
$day_time_ = date("H:i", strtotime($bookings_["book_start"]));
if($day_name_==$day_name && $day_time_==$show_time){
$user_id = $bookings_["user_id"];
$sql = "SELECT first_name, last_name, email ";
$sql .="FROM rs_data_users ";
$sql .="INNER JOIN rs_data_bookings.user_id ON rs_data_users.user_id ";
$sql .="WHERE user_id = '" . $user_id . "' ";
$temp = db_query($database_name, $sql);
$temp_ = fetch_array($temp);
$first_name = $temp_["first_name"];
$last_name = $temp_["last_name"];
$email = $temp_["email"];
$show_day .= "<td><div class="show_bookings">" $first_name . $last_name . $email . "</div></td></tr>";
}
Hele scriptet....
// Funtion to show day bookings
// Show Monday
function show_monday() {
// finds monday of the selected week & year
$current_day = strtotime("01/01/" . $_REQUEST["year"]);
while(date("w", $current_day) != 1 || date("W", $current_day) != $_REQUEST["week"]) { $current_day += 86400; }
$monday = date("Y-m-d", $current_day);
$stamp = strtotime($monday);
$day_name = date("D", $stamp);
// extracts hours of activity start, end and step
$start_hour = param_extract("activity_start"); // ex. 09:30
$end_hour = param_extract("activity_end"); // ex. 17:30
$activity_step = param_extract("activity_step")*60; // ex. 15 * 60
$activity_start = strtotime("1970-01-01 " . $start_hour);
$activity_end = strtotime("1970-01-01 " . $end_hour);
// start table and show day
$show_day = "<table><tr><td> Tid </td><td> $day_name </td></tr>";
// show time
for($t=$activity_start; $t<=$activity_end; $t+=$activity_step){
$day_time = date("H:i", $t);
$show_day .= "<tr><td><div class='show_time'> $day_time </div></td>";
}
// show booking after show time
// extracts the bookings for the selected week
$sql = "SELECT book_id, book_start, book_end, user_id, misc_info, validated ";
$sql .= "FROM rs_data_bookings ";
$sql .= "WHERE family_id = " . $_REQUEST["family_id"] . " ";
$sql .= "AND ((book_start >= '" . date("Y-m-d", $stamp) . "' ";
$sql .= "AND book_start < '" . date("Y-m-d", ($stamp + 604800)) . "') ";
$sql .= "OR (book_end >= '" . date("Y-m-d", $stamp) . "' ";
$sql .= "AND book_end < '" . date("Y-m-d", ($stamp + 604800)) . "') ";
$sql .= "OR (book_start <= '" . date("Y-m-d", $stamp) . "' ";
$sql .= "AND book_end >= '" . date("Y-m-d", $stamp) . "'));";
$bookings = db_query($database_name, $sql);
while($bookings_ = fetch_array($bookings){
$day_name_ = date("D", strtotime($bookings_["book_start"]));
$day_time_ = date("H:i", strtotime($bookings_["book_start"]));
if($day_name_==$day_name && $day_time_==$show_time){
$user_id = $bookings_["user_id"];
$sql = "SELECT first_name, last_name, email ";
$sql .="FROM rs_data_users ";
$sql .="INNER JOIN rs_data_bookings.user_id ON rs_data_users.user_id ";
$sql .="WHERE user_id = '" . $user_id . "' ";
$temp = db_query($database_name, $sql);
$temp_ = fetch_array($temp);
$first_name = $temp_["first_name"];
$last_name = $temp_["last_name"];
$email = $temp_["email"];
$show_day .= "<td><div class="show_bookings">" $first_name . $last_name . $email . "</div></td></tr>";
}
else{
$show_day .= "<td><div class="no_bookings"></div></td></tr>";
}
return $show_day;
}
