auto incremental registration number not working

auto incremental registration number not working - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24)
+--- Thread: auto incremental registration number not working (/showthread.php?tid=78874)

auto incremental registration number not working - gidgor256 - 03-21-2021

following youtube tots

i want to auto increase registration number

model code

Code:
public function auto() {

        $registerNO = "SPPS";

        $query = 'select max(registerNO) as registerNO_auto from student';

        $data = $this->db->query($query)->row_array();

        $max_registerNO = $data['registerNO_auto'];

        $max_registerNO2 = (int)substr($max_registerNO,7,3);

        $registerNOcount = $max_registerNO2+1;

        $registerNO_auto = $registerNO."-".sprintf('%03s', $registerNOcount+1);

        return $registerNO_auto;

    }

view code

Code:
<?php

                             $registerNO = $this->student_m->auto();

                            echo form_input([

                                'name'=> 'registerNO',

                                'class'=>'form-control',

                                'value'=>set_value('registerNO', $registerNO),

                                'readonly'=>'true'

                            ]);

                            ?>

my output is static as "SPPS-0001" there is no increament whenever i try adding new member