Dear friend.
This is me, I want to do some changes in databases and adding 3 level of users
administrators, bloggers and joined readers. i am started it newly and i will have many problems firs of all is that in user controller of admin dashboard when I run this query :
$this->db->select('users.user_id,user_info.name,user_info.fam');
$this->db->from('users');
$this->db->join('user_info', 'users.user_id = user_info.user_id');
$data= $this->db->get();
var_dump($data);
the result is :
object(CI_DB_mysql_result)#15 (8) { ["conn_id"]=> resource(34) of type (mysql link) ["result_id"]=> resource(35) of type (mysql result) ["result_array"]=> array(0) { } ["result_object"]=> array(0) { } ["custom_result_object"]=> array(0) { } ["current_row"]=> int(0) ["num_rows"]=> int(2) ["row_data"]=> NULL }
I will be appropriated if you help me to finish these changes.
kindly regards
That 3 Tables are:
CREATE TABLE IF NOT EXISTS user_type
(
user_type
int(4) NOT NULL AUTO_INCREMENT,
type_name
varchar(15) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (user_type
),
UNIQUE KEY user_type
(user_type
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=4 ;
INSERT INTO user_type
(user_type
, type_name
) VALUES
(1, 'Administrator'),
(2, 'Blogger'),
(3, 'User');
CREATE TABLE IF NOT EXISTS users
(
user_id
int(9) NOT NULL AUTO_INCREMENT,
email_add
varchar(35) COLLATE utf8_bin DEFAULT NULL,
password
varchar(128) COLLATE utf8_bin NOT NULL,
last_login
datetime NOT NULL,
usr_typ_id
int(4) DEFAULT NULL,
permissions
varchar(50) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (user_id
),
UNIQUE KEY email_add
(email_add
),
KEY fk_usr_typ_id
(usr_typ_id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=92090005 ;
INSERT INTO users
(user_id
, email_add
, password
, last_login
, usr_typ_id
, permissions
) VALUES
(92090001, '[email protected]', '8389', '2014-01-03 22:45:02', 1, ''),
(92090002, '[email protected]', '9291', '2014-01-03 22:47:27', 2, ''),
(92090003, '[email protected]', '105229', '2014-01-03 22:47:27', 3, ''),
(92090004, '[email protected]', '1052', '2014-01-03 22:47:27', 1, '');
ALTER TABLE users
ADD CONSTRAINT fk_usr_typ_id
FOREIGN KEY (usr_typ_id
) REFERENCES user_type
(user_type
);
CREATE TABLE IF NOT EXISTS user_info
(
id
int(9) NOT NULL AUTO_INCREMENT,
user_id
int(9) DEFAULT NULL,
name
varchar(25) COLLATE utf8_bin NOT NULL,
fam
varchar(45) COLLATE utf8_bin NOT NULL,
cell
varchar(12) COLLATE utf8_bin NOT NULL,
company
varchar(45) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (id
),
UNIQUE KEY user_id
(user_id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=100000003 ;
INSERT INTO user_info
(id
, user_id
, name
, fam
, cell
, company
) VALUES
(100000001, 92090001, 'hamed', 'salim', '09149306211', ''),
(100000002, 92090002, 'reza', 'salim', '09143711256', '');
ALTER TABLE user_info
ADD CONSTRAINT user_info_ibfk_1
FOREIGN KEY (user_id
) REFERENCES users
(User_id
);