1#@!#!123s

: / home / schoolcampuserp / erp.bnninternationalschool.com / application / models /

Filename : section_class.php

back

<?php
include 'connection.php';


     $this->db->select('class_sections.id,class_sections.section_id,sections.section');
            $this->db->from('class_sections');
            $this->db->join('sections', 'sections.id = class_sections.section_id');
            $this->db->where('class_sections.class_id',16);
            $this->db->order_by('class_sections.id');
            $query = $this->db->get();
            $result = $query->result_array();
    // $result = $con->query($query);
    //->fetch_all(MYSQLI_ASSOC);
$row = $result;
    if (empty($row)) {
        $response = array("status" => "0", "message" => "No records found for the student ID");
    } else {
        $response = array("status" => "1", "message" => "Data retrieved successfully","class_sections" => $row);
        }


echo json_encode($response);



?>