CodeIgniter Forums
how to generate Custom id in codeigniter - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forum-5.html)
+--- Forum: General Help (https://forum.codeigniter.com/forum-24.html)
+--- Thread: how to generate Custom id in codeigniter (/thread-70783.html)



how to generate Custom id in codeigniter - azmath - 05-29-2018

Code:
$cc = $this->db->count_all('job_card');
$coun = str_pad($cc,4,STR_PAD_LEFT);
$id = "JI"."-";
$d = date('y') ;
$mnth = date("m");
$customid = $id.$d.$mnth.$coun;
Help me: I am generating "JI-18051000" This id. But i need "JI-18050001" this id.


RE: how to generate Custom id in codeigniter - neuron - 05-30-2018

(05-29-2018, 09:49 PM)azmath Wrote:
Code:
$cc = $this->db->count_all('job_card');
$coun = str_pad($cc,4,STR_PAD_LEFT);
$id = "JI"."-";
$d = date('y') ;
$mnth = date("m");
$customid = $id.$d.$mnth.$coun;
Help me: I am generating "JI-18051000" This id. But i need "JI-18050001" this id.

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;