程式設計@筆記

$query_city = "SELECT * FROM city";
$city = $this->db->query($query_city);
foreach($city->result() as $Row){
// do something
}
// As soon as the foreach is reached, the first record is retrieved again.
foreach($city->result() as $Row){
// do something else
}

=====================
設定
=====================
可以在application/config/routes.php
找到 $route['default_controller']

$this->uri->assoc_to_uri()
建立一個關連式陣列來作為輸端並且產生 URI 字串的格式
$array = array('product' => 'shoes', 'size' => 'large', 'color' => 'red');
$str = $this->uri->assoc_to_uri($array);

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

 
//刪除大於一小時 3600秒
$this->db->query('DELETE FROM ci_sessions WHERE timestamp < (UNIX_TIMESTAMP() - 3600)');
$this->db->query('OPTIMIZE TABLE ci_sessions');

===================
設定session數據
===================
$this - > session - > set_userdata('變數','值');
===================
讀取session數據
===================
$_SESSION['item']
或
$this - > session - > item

將Session資料存入資料庫
新增資料表 CI 3.0
CREATE TABLE IF NOT EXISTS `ci_sessions` (
`id` varchar(40) NOT NULL,
`ip_address` varchar(45) NOT NULL,
`timestamp` int(10) unsigned DEFAULT 0 NOT NULL,
`data` blob NOT NULL,
PRIMARY KEY (id),
KEY `ci_sessions_timestamp` (`timestamp`)
);

手動方式
=====================
設定
=====================
可以在application/config/config.php中找到下面這幾行

此範例
$something = $this->input->post('something');
等於
if ( ! isset($_POST['something']))
{
$something = FALSE;
}
else
{
$something = $_POST['something'];
}

動載入資源檔案位置，請開啟 application/config/autoload.php 的檔案
$autoload['libraries'] = array('myclass');

存檔位置
application/libraries 資料夾