private function send_msg($table, $value)
{
$query_add = new mysqlQuery();
if ($query_add->insert($table, $value, $row = null) == true) {
} else {
echo 'not entered';
}
}
private function add($table, $values)
{
//echo implode(',',$values);
$query_add = new mysqlQuery();
if ($query_add->insert($table, $values, $row = null) == true) {
} else {
echo "not insert";
}
}
private function deleteStudent($table, $where)
{
$dlt = new mysqlQuery();
if ($dlt->delete($table, $where)) {
echo "Student Information Deleted";
} else {
echo "Student not deleted";
}
}
private function deleteLec($table, $where)
{
$dlt = new mysqlQuery();
if ($dlt->delete($table, $where)) {
echo "Lecturer Information Deleted";
} else {
echo "Lecturer not deleted";
}
}
private function addAtten($table, $val)
{
$query = new mysqlQuery();
if ($query->insert($table, $val, $row = null) == true) {
// echo "Data Enetered";
include "../../view/admin_staff/attendance_add.php";
} else {
echo "Data not entered";
}
}
private function add($table, $values)
{
//echo implode(',',$values);
$query_add = new mysqlQuery();
if ($query_add->insert($table, $values, $row = null) == true) {
// echo '<p style="color:#2122e4; margin-left: 20px; text-align:center; font-family: Century Gothic; font-size:20px;background-color: #e2ebff;padding: 25px;margin: 25px; border-style: solid; border-color:#3c94dd ">Data Inserted</p>';
} else {
echo '<p style="color:#e40005; margin-left: 20px; text-align:center; font-family: Century Gothic; font-size:22px;background-color: #ffebe8;padding: 25px;margin: 25px; border-style: solid; border-color:#dd3c10 ">Data Not Inserted</p>';
}
}
private function add($table, $values)
{
//echo implode(',',$values);
$query_add = new mysqlQuery();
if ($query_add->insert($table, $values, $row = null) == true) {
echo "data insert ";
include "../../view/admin_staff/student_reg.php";
} else {
echo "not insert";
}
}
private function addMarks($s_id, $sub_num, $mark)
{
$course_ID = $this->cID($s_id);
$result = $this->markResults($mark);
$values = array('', $sub_num, $s_id, $result, $mark, $course_ID);
$query = new mysqlQuery();
if ($query->insert("marks", $values, $row = null) == true) {
$this->m_count++;
//echo "results entered";
} else {
echo "not entered";
}
}
private function deleteCourse($table, $where)
{
$dlt = new mysqlQuery();
if ($dlt->delete($table, $where)) {
$qury = "ajaxPost1('/ACTA_project/view/admin_staff/courses.php',\$('#c_id'))";
echo "<div class='panel_upper'>\n <div class='p0'>\n <label class='p2'> Course Deleted Successfully..!!</label>";
echo "<td><input class='input data' type='hidden' name='c_id' id='c_id' value=''></td>";
echo "<td><input class='button1' type='button' name='views' id='views' value='OK' onclick=" . $qury . "></td>";
echo "</div></div>";
} else {
// echo "Student not deleted";
}
}
$pregSql = "SELECT COUNT(DISTINCT fhsis.patient_id) AS total FROM m_dental_fhsis AS fhsis WHERE indicator = 10";
$totalSql = "SELECT COUNT(DISTINCT fhsis.patient_id) AS total FROM m_dental_fhsis AS fhsis JOIN m_patient AS p ON p.patient_id = fhsis.patient_id WHERE ROUND((to_days(fhsis.date_of_consultation)-to_days(p.patient_dob))/365,1) BETWEEN {$startAge} AND {$endAge} AND fhsis.date_of_consultation BETWEEN '{$startDate}' AND '{$endDate}' AND fhsis.indicator = 1 AND fhsis.indicator_qualified = 'YES'";
$otherMaleSql = "SELECT COUNT(DISTINCT fhsis.patient_id) AS total FROM m_dental_fhsis AS fhsis WHERE indicator = 10";
$otherFemaleSql = "SELECT COUNT(DISTINCT fhsis.patient_id) AS total FROM m_dental_fhsis AS fhsis WHERE indicator = 10";
$indicator = "ofc";
break;
default:
die("Error");
break;
}
$this->displayQuery($maleSql, $femaleSql, $pregSql, $totalSql, $otherMaleSql, $otherFemaleSql, $i, $indicator);
}
}
}
}
$query = new mysqlQuery();
}
?>
</head>
<body>
<form name='ohc' method='GET' action=''>
<?php
echo "FROM ";
echo "<select name='startMonth'>";
$nameMonth = 'startMonth';
$query->disMonth($nameMonth);
echo "</select>";
echo " TO ";
echo "<select name='endMonth'>";
$nameMonth = 'endMonth';
$query->disMonth($nameMonth);