how to generate Custom id in codeigniter - 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: how to generate Custom id in codeigniter (/showthread.php?tid=70783) |
how to generate Custom id in codeigniter - azmath - 05-29-2018 Code: $cc = $this->db->count_all('job_card'); RE: how to generate Custom id in codeigniter - neuron - 05-30-2018 (05-29-2018, 09:49 PM)azmath Wrote: Do you have id in job_card table? if so get PHP Code: $result = $this->db->select('max("id") as max_id', false)->from('job_card')->get(); $coun = $result['max_id'] + 1; and if your generated id is final value just generate new column in your job_card table and record it there so that you won't regenarate every time. You can also take look at "composite fields" for your db RE: how to generate Custom id in codeigniter - seshagiri - 12-17-2019 $cc = $this->db->count_all('gbp')+1; $coun = str_pad($cc,4,STR_PAD_LEFT); $coo=strrev($coun); $id = "GBP"."-"; $d = date('y') ; $mnth = date("m")."-"; $product_id = $id.$d.$mnth.$coo; echo $product_id; |