EVOLUTION-NINJA

Edit File: Certificate.php

<?php

namespace App\Controllers;

use CodeIgniter\Controller;

class Certificate extends Controller
{
    public function __construct()
    {
        $this->db = \Config\Database::connect();
    }

public function get_certificate_data() {
        $admission_no = $this->request->getGet('admission_no');
    
        $builder = $this->db->table('student_list');
        $builder->select('student_list.*, header_value.value_name, header_value.id');
        $builder->join('header_value', 'header_value.id = student_list.value_name', 'left'); 
        $builder->where('student_list.admission_no', $admission_no);
        
        $data = $builder->get()->getRow();
        return view('certificate/certificate_page', ['data' => $data]);

}
    public function get_admission_no()
    {
        if ($this->request->isAJAX()) {
            $query = $this->request->getGet('query');

// print_r($query);die();
    
            $db = \Config\Database::connect();
            $builder = $db->table('student_list');
    
            $users = $builder->select('id, admission_no')
                             ->like('admission_no', $query)
                             ->limit(10) // Limit results for performance
                             ->get()
                             ->getResultArray();
    
            return $this->response->setJSON($users);
        }
    }

}