function testselect_dbWeeks()
{
$newWeek = new Week("03-30-14", "Bscah", "Active");
$nd = insert_dbWeeks($newWeek);
$id = "03-30-14";
echo 'will test select_dbWeeks</br>';
$result = select_dbWeeks($id);
if ($result != null) {
echo 'select_dbDates failed</br>';
}
$res = delete_dbWeeks($newWeek);
if ($res == null) {
echo 'Delete failed</br>';
}
}
/**
* retrieves a Week from the database
*
* @param $id = mm-dd-yy of the week to retrieve
*
* @return Week desired week, or null
*/
function get_dbWeeks($id)
{
$result_row = select_dbWeeks($id);
if ($result_row != null) {
$dates = explode("*", $result_row['DATES']);
$d = [];
foreach ($dates as $date) {
$temp = select_dbDates($date);
$d[] = $temp;
}
$w = new Week($d, $result_row['STATUS']);
return $w;
} else {
return null;
}
}
/**
* retrieves a Week from the database
* @param $id = mm-dd-yy of the week to retrieve
* @return the desired week, or null
*/
function get_dbWeeks($id)
{
$result_row = select_dbWeeks($id);
if ($result_row != null) {
$dates = explode("*", $result_row['dates']);
$d = array();
foreach ($dates as $date) {
$d[] = select_dbDates($date);
}
$w = new Week($d, $result_row['venue'], $result_row['status']);
error_log("3");
return $w;
} else {
return null;
}
}
