on model page : public function create($abc){ $insert = $this->db->prepare('INSERT INTO member_data (`member_id`,`username`,`name`, `password`,`address`,`phone`,`nik_numb`,`gender`,`role`) VALUES(:member_id, :username, :name, :password, :address, :phone, :nik_numb, :gender, :role) '); $insert->execute(array( $id = $this->db->lastInsertId(); ':member_id' => $abc['member_id'], ':username' => $abc['username'], ':name' => $abc['name'], ':password' => $abc['password'], ':address' => $abc['address'], ':phone' => $abc['phone'], ':nik_numb' => $abc['nik_numb'], ':gender' => $abc['gender'], ':role' => $abc['role'] )); ........ and controllers page : $abc['member_id'] = 0 . date('ymdN') . '00' . $id; but i still don't get last insert id... please correct what is wrong..