dev-chiefworks
29 lines
683 B
PHP
29 lines
683 B
PHP
|
|
|
|
<?php if (!defined('BASEPATH')) {
|
|
exit('No direct script access allowed');
|
|
}
|
|
|
|
class Bank_model extends CI_Model
|
|
{
|
|
public function __construct()
|
|
{
|
|
parent::__construct();
|
|
}
|
|
|
|
public function insert($data) {
|
|
$data_insert = array('bank_name' => $data['bank_name']);
|
|
|
|
$sql = $this->db->insert_string('banks', $data_insert)
|
|
. ' ON CONFLICT (bank_name)
|
|
DO UPDATE SET bank_name=EXCLUDED.bank_name
|
|
RETURNING id';
|
|
|
|
return $this->db->query($sql)->result_array()[0]['id'];
|
|
}
|
|
|
|
public function delete($data) {
|
|
$this->db->where('id', $data['bank_id']);
|
|
$this->db->delete('banks');
|
|
}
|
|
} |