Seting CI 3 dengan input ci_session ke database

Wednesday, March 7, 2018

Seting CI 3 dengan input ci_session ke database

Permasalahan yang sering terjadi pada saat awal menggunakan CI 3 / CodeIgniter-3.1.0. Cara yang harus di perhatikan pertama-tama sebeum menggunakan CI 3 adalah sebagai berikut.

failed to open stream: No such file or directory

application/config/config.php

1

//$config['sess_driver'] = 'files';
$config['sess_driver'] = 'database';
$config['sess_cookie_name'] = 'ci_session';
$config['sess_expiration'] = 7200;
//$config['sess_save_path'] = NULL;
$config['sess_save_path'] = 'ci_session'; //table name
$config['sess_match_ip'] = FALSE;
$config['sess_time_to_update'] = 300;
$config['sess_regenerate_destroy'] = FALSE;

Pergunakan setingan tersebut untuk save path ci_session ke database.

Sql Table.

1

-- ----------------------------
-- Table structure for ci_session
-- ----------------------------
DROP TABLE IF EXISTS `ci_session`;
CREATE TABLE `ci_session`  (
  `id` varchar(40) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `ip_address` varchar(45) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `timestamp` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `data` blob NOT NULL,
  INDEX `ci_sessions_timestamp`(`timestamp`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_general_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;