我正在嘗試為我的表制作一個(gè)代碼生成器這是我的模型：public function buat_kode() { $this->db->table('RIGHT(proses_cutting.kode_packing_list,6) as kode', FALSE); $this->builder()->orderBy('kode_packing_list','DESC'); $this->builder()->limit(1); $query = $this->db->table('proses_cutting'); //cek dulu apakah ada sudah ada kode di tabel. if ($query->num_rows() <> 0){ //jika kode ternyata sudah ada. $data = $query->row(); $kode = intval($data->kode) + 1; } else { //jika kode belum ada $kode = 1; } $kodemax = str_pad($kode, 6, "0", STR_PAD_LEFT); // angka 4 menunjukkan jumlah digit angka 0 $kodejadi = "PLIK059".$kodemax; // hasilnya ODJ-9921-0001 dst. return $kodejadi; }控制器 ：public function create(){ session(); $data = [ 'main' => 'prosescutting/create', 'validation' => \Config\Services::validation(), 'title' => 'Form Tambah Proses Cutting', 'kodeunik' => $this->pcuttingModel->buat_kode(), 'kode_packing_list' => $kodePackingSekarang, ]; return view('template/template', $data);}和我的桌子： 桌子我想做的是為 nama_barang 的每個(gè)項(xiàng)目制作一個(gè) kode_packing_list 生成器，這樣當(dāng)我輸入另一件 Renata Blouse 時(shí)，它會(huì)自動(dòng)填充PLIK059000007但是當(dāng)我嘗試運(yùn)行它時(shí)，它向我顯示了以下錯(cuò)誤：錯(cuò)誤調(diào)用未定義的方法 CodeIgniter\Database\MySQLi\Builder::num_rows() APPPATH\Models\PcuttingModel.php 第 33 行第 33 行是if ($query->num_rows() <> 0){
1 回答
搖曳的薔薇
TA貢獻(xiàn)1793條經(jīng)驗(yàn) 獲得超6個(gè)贊
您使用了錯(cuò)誤的數(shù)據(jù)庫(kù)表函數(shù)，請(qǐng)嘗試以下操作：
$db = \Config\Database::connect(); // optional; init database if not created yet
$builder = $db->table('proses_cutting');
$builder->select('RIGHT(proses_cutting.kode_packing_list,6) as kode');
$builder->orderBy('kode_packing_list','DESC');
$builder->limit(1);
if($builder->countAllResults() > 0) {
? ? $query = $builder->get();
? ? $result = $query->getResult(); // Result as objects eg; $result->kode
? ? $kode = $result->kode;
}
// Other option: I believe you can do this too
$builder = $db->table('proses_cutting');
$builder->select('RIGHT(proses_cutting.kode_packing_list,6) as kode');
$builder->orderBy('kode_packing_list','DESC');
$builder->limit(1);
$query = $builder->get();
$result = $query->getResult('array');
if(is_array($result) && count($array) > 0) {
? ? $kode = $result['kode'];
}
- 1 回答
- 0 關(guān)注
- 115 瀏覽
添加回答
舉報(bào)
0/150
提交
取消