<html>
<head>
<title></title>
</head>
<body>
<?php
if (isset($_REQUEST['tt']) && isset($_REQUEST['td']) && isset($_REQUEST['cli']) && isset($_REQUEST['dt'])) {
include "district_task.php";
$obj = new district_task();
$task_title = $_REQUEST['tt'];
$task_desc = $_REQUEST['td'];
$clinics = $_REQUEST['cli'];
$date = $_REQUEST['dt'];
$temp = strtotime($date);
$end_date = date('Y-m-d', $temp);
if (!$obj->add_district_task($task_title, $task_desc, $clinics, $end_date)) {
echo "Error adding " . mysql_error();
} else {
echo "Added {$task_title}, {$task_desc}, {$clinics}, {$end_date}";
}
}
?>
<div class="container" id="form">
<form action="add_district_task.php" method="get">
<div>Task Title: <input type="text" name="tt"></div>
<div>Task Description: <textarea name="td"></textarea></div>
<div>Clinics: <input type="text" name="cli"></div>
<div>Date: <input type="text" name="dt"></div>
<div><input type="submit" value="Save" onsubmit = "confirmAdd()"></div>
</form>
*@return bool the result will return true/false whether the sql query is successful
*/
function delete_district_task($id)
{
$str_query = "delete from se_district_tasks where task_id = {$id}";
return $this->query($str_query);
}
/**
*@method boolean search_district_task_by_name() search_district_task_by_name($sn) Searches for the rows with names of district_tasks that match the pattern
*@param int $sn The name of the district_task
*@return boolean
*/
function search_district_task_by_name($sn)
{
$str_query = "select task_id, task_title, task_desc,clinics,due_date from se_district_tasks where task_name like '%{$sn}%'";
return $this->query($str_query);
}
}
/**
* Unit Test and usage
*/
$obj = new district_task();
//$obj->add_district_task('Vacination','vaccination for polio kids in the north','Berekuso clinic', '21/03/2015');
//$obj = new district_task();
$obj->get_district_task(1);
$row = $obj->fetch();
print_r($row);
/*if(){
echo "Task: " .$row ['task_title'];
}*/
echo "hello";
<html>
<head>
<title></title>
</head>
<body>
<?php
date_default_timezone_set('UTC');
if (isset($_REQUEST['fn']) && isset($_REQUEST['sn']) && isset($_REQUEST['pwd']) && isset($_REQUEST['aid'])) {
include "district_task.php";
$obj = new district_task();
$task_title = $_REQUEST['tt'];
$task_desc = $_REQUEST['td'];
$clinics = $_REQUEST['cli'];
$date = $_REQUEST['dt'];
$end_date = date('Y-m-d', strtotime(str_replace('-', '/', $date)));
if (!$obj->add_admin($task_title, $task_desc, $clinics, $end_date)) {
echo "Error adding" . mysql_error();
} else {
echo "Added {$task_title}, {$task_desc}, {$clinics}, {$end_date}";
}
}
?>
<div class="container" id="form">
<form action="add_district_task.php" method="get">
<div>Task Title: <input type="text" name="tt"></div>
<div>Task Description: <textarea name="sn"><textarea></div>
<div>Clinics: <input type="text" name="cli"></div>
<div>Date: <input type="text" name="dt"></div>
<div><input type="submit" value="Save" ></div>
</form>
