程式設計@筆記

=================
顯示結果陣列
=================

$sql = "SQL詢查字串";
$query = $this->db->query($sql);
foreach ($query->result_array() as $row)
{
echo $row['title'];
echo $row['name'];
echo $row['body'];
}
=================
顯示結果陣列並判斷是否有資料
=================

$sql = "SQL詢查字串";
$query = $this->db->query($sql);

if ($query->num_rows() > 0)
{
$row = $query->row_array();

echo $row['title'];
echo $row['name'];
echo $row['body'];
}

如果您想要回傳特定的第幾筆資料，可以設定第一個參數為您想要的該筆資料：
$row = $query->row_array(5);

=================
顯示結果筆數
=================

$query = $this->db->query($sql);
return $query->num_rows();

=================
新增資料
=================
$data = array(
'class_major_name' => $this->input->post('class_major_name'),
'class_major_sort' => (int)$this->input->post('class_major_sort'),
'class_major_check' => (int)$this->input->post('class_major_check')
);

$sql = $this->db->insert_string('class_major',$data);
$this->db->query($sql);

=================
修改資料
=================
//取得id
$class_major_id = (int)$this->input->get('class_major_id', TRUE);

//取得post資料陣列
$data = array(
'class_major_name' => $this->input->post('class_major_name'),
'class_major_sort' => (int)$this->input->post('class_major_sort'),
'class_major_check' => (int)$this->input->post('class_major_check')
);

//產生sql字串
$where = "class_major_id = ".$class_major_id;
$sql = $this->db->update_string('class_major', $data, $where);

//執行sql
$this->db->query($sql);