function retrieve_dbMonths($id) { connect(); $query = 'SELECT * FROM dbMonths WHERE id = "' . $id . '"'; $result = mysql_query($query); // can't find month with id if (mysql_num_rows($result) != 1) { mysql_close(); return newMonth($id); } $result_row = mysql_fetch_assoc($result); $theMonth = new Month($result_row['id'], $result_row['status']); return $theMonth; }
function testdbMonthsModule() { //creates an empty dbMonths table //$this->assertTrue(create_dbMonths()); // create a month to add to the table $m1 = new Month("13-10-foodbank", "unpublished"); // test the insert function $this->assertTrue(insert_dbMonths($m1)); // test the retrieve function $this->assertEqual(retrieve_dbMonths($m1->get_id())->get_id(), "13-10-foodbank"); $this->assertEqual(retrieve_dbMonths($m1->get_id())->get_status(), "unpublished"); $this->assertEqual(retrieve_dbMonths($m1->get_id())->get_group(), "foodbank"); $this->assertEqual(retrieve_dbMonths($m1->get_id())->get_end_of_month_timestamp(), mktime(0, 0, 0, 10, 31, 2013)); // testing generation of a new calendar month from the master schedule $this->assertTrue(newMonth("13-10-foodbank")); // test the update function $m1->set_status("published"); $this->assertTrue(update_dbMonths($m1)); $this->assertEqual(retrieve_dbMonths($m1->get_id())->get_status(), "published"); // tests the delete function $this->assertTrue(delete_dbMonths($m1)); echo "\ntestdbMonths complete\n"; }
$id = $_GET['monthid']; $month = retrieve_dbMonths($id); if ($month) { if ($month->get_status() == "unpublished" || $month->get_status() == "archived") { delete_dbMonths($month); add_log_entry('<a href=\\"personEdit.php?id=' . $_SESSION['_id'] . '\\">' . $_SESSION['f_name'] . ' ' . $_SESSION['l_name'] . '</a> removed the month of <a href=\\"calendar.php?id=' . $month->get_id() . '&edit=true&group=' . $_SESSION['mygroup'] . '\\">' . $month->get_name() . '</a>.'); echo "<p>Month \"" . $month->get_name() . "\" removed.<br>"; } else { echo "<p>Month \"" . $month->get_name() . "\" is published, so it cannot be removed.<br>"; } include 'addMonth.inc'; } } else { if (!array_key_exists('_submit_check_newmonth', $_POST)) { include 'addMonth.inc'; } else { $month_id = $_POST['_new_month_timestamp']; // add the newe month to the database and refresh the view newMonth($month_id); include 'addMonth.inc'; } } } ?> <?php include 'footer.inc'; ?> </div> </div> </body> </html>