PHP DBConn::queryFetchRowAssoc Examples

Example #1

File: server.php Project: VINOTH37/Schoolcom

function update_schedule_detail()
{
    $schoolid = $_REQUEST['schoolid'];
    $hw_time = $_REQUEST['hw_time'];
    $att_time = $_REQUEST['att_time'];
    $slip_time = $_REQUEST['slip_time'];
    $non_scheduled_hw = $_REQUEST["non_scheduled_hw"];
    $non_scheduled_att = $_REQUEST["non_scheduled_att"];
    $teacher_hw_time = $_REQUEST["teacher_hw_time"];
    $teacher_att_time = $_REQUEST["teacher_att_time"];
    $send_sms_to_students = $_REQUEST["send_sms_to_students"];
    $output['success'] = 0;
    $res = DBConn::queryFetchRowAssoc("SELECT att_time,hw_time,slip_time FROM tab_sms_schedule WHERE schoolid=" . $schoolid) ? 1 : 0;
    if (!$res) {
        $output['success'] = DBConn::exec("INSERT INTO tab_sms_schedule(SchoolId,att_time,hw_time,slip_time,non_scheduled_hw,non_scheduled_att,teacher_hw_time,teacher_att_time,send_sms_to_students) VALUES ({$schoolid},'{$att_time}','{$hw_time}','{$slip_time}','{$non_scheduled_hw}','{$non_scheduled_att}','{$teacher_hw_time}','{$teacher_att_time}','{$send_sms_to_students}')");
    } else {
        $output['success'] = DBConn::exec("UPDATE tab_sms_schedule SET att_time='{$att_time}',hw_time='{$hw_time}',slip_time='{$slip_time}',non_scheduled_hw='{$non_scheduled_hw}',non_scheduled_att='{$non_scheduled_att}',teacher_att_time='{$teacher_att_time}',teacher_hw_time='{$teacher_hw_time}',send_sms_to_students='{$send_sms_to_students}' WHERE SchoolId={$schoolid}");
    }
    echo json_encode($output);
}