StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
14944875
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-02-18T20:37:39.623
FavoriteCount
0
LastActivityDate
2013-02-18T20:37:39.623
LastEditDate
LastEditorUserId
0
OwnerUserId
2080328
ParentId
14920900
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
I found where was the error. <pre><code>if ($query->num_rows() == 1) </code></pre> is not the correct syntax <pre><code>if ($query->num_rows == 1) </code></pre> is the correct one. $query->num_rows value is "1" finally the solution i choose is : my user_model.php (for database operation with users ) <pre><code>class Users_model extends MY_Model { protected $table = 'users'; protected $primary = 'user_id'; public function liste() { $this->link->select('user_id'); $this->link->select('user_name'); $this->link->select('user_mail'); $this->link->select("GROUP_CONCAT(group_name ORDER BY group_name SEPARATOR ' ') AS user_groups", FALSE); $this->link->join('groups_users', 'users_user_id=user_id', 'left'); $this->link->join('groups', 'group_id=groups_group_id', 'left'); $this->link->group_by('user_id'); return parent::get_all(array(), array('user_name ASC')); } public function validate($mail, $password) { $pass_hashed = sha1($mail . $password); return parent::get(array('user_mail' => $mail, 'user_password' => $pass_hashed)); } } /* End of file users_model.php */ /* Location: ./application/models/users_model.php */ </code></pre> The validate method is more simple, and i dont do any controls in it. Just Db operations. Now my controller accueil.php <pre><code><?php if (!defined('BASEPATH')) exit('No direct script access allowed'); class Accueil extends MY_Controller { public function __construct() { parent::__construct(); $this->load->model('users_model', 'users_m'); // Chargement model $this->load->library('form_validation'); // Librairie validation $this->load->helper(array('form', 'url')); // helpers $this->load->library('template'); // Librairie template } public function index($msg = NULL) //msg en cas d'erreur , NULL si pas d'erreur { $data['msg'] = $msg; $this->load->view('login', $data); } public function login() { try { $user = $this->users_m->validate($this->input->post('user_mail'), $this->input->post('password')); $this->session->set_userdata(array( 'user_id' => $user->user_id, 'user_mail' => $user->user_mail, 'validated' => TRUE )); redirect('users'); } catch (Exception $e) { // Pas de validation on renvoit vers l'index avec un message d'erreur $msg = 'Nom d\'utilisateur ou mot de passe incorrect(s). '; $this->index($msg); } } } /* End of file accueil.php */ /* Location: ./application/controllers/accueil.php */ </code></pre> My view is still the same , no changes. I think i have wrote the code more correctly this time. Separate the DB operations , with the controls. Feel free to comments.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POPHP Fatal error: Call to undefined method stdClass::num_rows() in (...) line 36
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USKliklipse
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.