SHOW:
|
|
- or go back to the newest paste.
| 1 | <?php | |
| 2 | //==========step 1 dapatkan jumlah data yang memiliki tgl yg sama | |
| 3 | - | $sql="select count(id) c from table"; |
| 3 | + | $date=date("Y-m-d");
|
| 4 | - | |
| 4 | + | $sql="select count(id) c from table where date like '$date%'"; |
| 5 | - | //========asumsikan dapat 1 |
| 5 | + | $r=$this->db->query($sql)->row_array(); |
| 6 | - | $nData=1; |
| 6 | + | $nData=$r['c'] + 1; |
| 7 | - | //===tambahkan 1, karena kita adalah posisi selanjutnya |
| 7 | + | //===buat code .. asumsikan nData=2 |
| 8 | - | $nData++; |
| 8 | + | $code=date("ymd").sprintf("%03s",$nData); //140127002 |
