StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POPHP Fatal error: Call to undefined method stdClass::num_rows() in (...) line 36
primarykey
Id
14920900
data
AcceptedAnswerId
0
AnswerCount
6
ClosedDate
CommentCount
6
CommunityOwnedDate
CreationDate
2013-02-17T12:06:32.030
FavoriteCount
1
LastActivityDate
2017-05-07T14:52:24.637
LastEditDate
LastEditorUserId
0
OwnerUserId
2080328
ParentId
0
PostTypeId
1
Score
0
ViewCount
14801
LastEditorDisplayName
text
Body
<p>Here my first question . I'm a newbie in PHP and CI but i want to learn :)</p> <p>First my model : </p> <blockquote> <p>class Login_model extends MY_Model {</p> <pre><code>protected $table = 'users'; protected $primary = 'user_id'; function __construct() { parent::__construct(); } public function validate() { // Récupère le POST du login $user_mail = $this->input->post('user_mail'); $password = sha1($this->input->post('user_mail') . $this->input->post('password')); //Execution de la requete $query = $this->users_m->get(array('user_mail' => $user_mail)); // Verification qu'il existe un enregistrement var_dump($query); if($query->num_rows() == 1) { // If there is a user, then create session data $row = $query->row(); $data = array( 'userid' => $row->userid, 'fname' => $row->fname, 'lname' => $row->lname, 'username' => $row->username, 'validated' => true ); $this->session->set_userdata($data); return true; // } // Si le login ne se valide pas // return false. return false; } } } </code></pre> </blockquote> <p>This model extends My_model MY_MODEL.PHP</p> <pre><code><?php if (!defined('BASEPATH')) exit('No direct script access allowed'); /** * MY_Model */ class MY_Model extends CI_Model { /** * Connexion à la BDD * * @var object */ protected $link; /** * Groupe de connexion BDD * * @var string */ protected $db_group = 'default'; /** * Table de la BDD * * @var string */ protected $table = ''; /** * Clé(s) primaire(s) * * @var string/array */ protected $primary = 'id'; /** * Déclanche une exception * * @var boolean */ private $_throw_exception = TRUE; /** * Constructeur */ public function __construct() { parent::__construct(); if ($this->table != '') { $this->_set_link(); } } /** * Connexion à la BDD */ private function _set_link() { $this->link = $this->load->database($this->db_group, TRUE); } /** * Active la gestion des exceptions */ public function enable_exception() { $this->_throw_exception = TRUE; } /** * Desactive la gestion des exceptions */ public function disable_exception() { $this->_throw_exception = FALSE; } /** * Récupère un enregistrement unique * * @param array $where * @return boolean * @throws Exception */ public function get($where = array()) { if (is_array($where) && $where) { foreach ($where as $key => $value) { $this->link->where($key, $value); } } $query = $this->link->get($this->table); /* Traitement de la requete */ $data = FALSE; if (is_object($query)) { if ($query->num_rows() == 1) { $result = $query->result(); $data = $result[0]; } else if ($this->_throw_exception) { throw new Exception($query->num_rows(), 11); } } else { throw new Exception($this->link->_error_number() . ":" . $this->link->_error_message(), 10); } return $data; } /** * Liste des enregistrements de la table * * @param array $orders * @return array */ public function get_all($where = array(), $orders = array(), $limit = NULL, $offset = NULL) { /* Conditions */ if (is_array($where) && $where) { foreach ($where as $key => $value) { $this->link->where($key, $value); } } /* Tris */ if (is_array($orders) && $orders) { foreach ($orders as $order) { $this->link->order_by("$this->table.$order"); } } else if ($orders) { $this->link->order_by("$this->table.$orders"); } else if (is_array($this->primary)) { foreach ($this->primary as $order) { $this->link->order_by("$this->table.$order"); } } else { $this->link->order_by("$this->table.$this->primary"); } /* Requete */ $query = $this->link->get($this->table, $limit, $offset); /* Traitement de la requete */ $data = array(); if (is_object($query)) { if ($query->num_rows() > 0) { $data = $query->result(); } } else if ($this->_throw_exception) { throw new Exception($this->link->_error_number() . ":" . $this->link->_error_message(), 10); } /* Retour */ return $data; } /** * Nombre d'enregistrements de la table * * @return integer */ public function count($where = array()) { if (is_array($where) && $where) { foreach ($where as $key => $value) { $this->link->where($key, $value); } } $this->link->from($this->table); return $this->link->count_all_results(); } /** * Insertion dans la BDD * * @param array $data * @return boolean * @throws Exception */ public function insert($data = array()) { $insert = FALSE; if ($this->link->insert($this->table, $data)) { if (is_array($this->primary)) { $insert = TRUE; } else if (isset($data[$this->primary])) { $insert = $data[$this->primary]; } else { $insert = $this->link->insert_id(); } } else if ($this->_throw_exception) { throw new Exception($this->link->_error_number() . ":" . $this->link->_error_message(), 20); } return $insert; } /** * Insertion de masse dans une base de donnée * * @param array $data * @return boolean * @throws Exception */ public function insert_batch($data) { $insert = FALSE; if ($this->link->insert_batch($this->table, $data)) { $insert = TRUE; } else if ($this->_throw_exception) { throw new Exception($this->link->_error_number() . ":" . $this->link->_error_message(), 20); } return $insert; } /** * Mise à jour d'enregistrements de la BDD * * @param array $data * @param array $where * @return boolean * @throws ExceptionModel */ public function update($data = array(), $where = array()) { $update = FALSE; if (is_array($where) && $where) { foreach ($where as $key => $value) { $this->link->where($key, $value); } } if ($this->link->update($this->table, $data)) { $update = TRUE; } else if ($this->_throw_exception) { throw new Exception($this->link->_error_number() . ":" . $this->link->_error_message(), 30); } return $update; } /** * Suppression d'enregistrements de la BDD * * @param array $where * @return boolean * @throws Exception */ public function delete($where = array()) { $delete = FALSE; if (is_array($where) && $where) { foreach ($where as $key => $value) { $this->link->where($key, $value); } } if ($this->link->delete($this->table)) { $delete = TRUE; } else if ($this->_throw_exception) { throw new Exception($this->link->_error_number() . ":" . $this->link->_error_message(), 40); } return $delete; } } /* End of file MY_Model.php */ /* Location: ./application/core/MY_Model.php */ </code></pre> <p>I have my controller : Accueil ( will be the default route )</p> <p>The method login() call the view login.php</p> <p>ACCUEIL.PHP : </p> <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'); $this->load->library('form_validation'); $this->load->helper(array('form', 'url')); $this->load->library('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() { // Chargement du model de login $this->load->model('login_model'); // Validation que l'user puisse se connecter $result = $this->login_model->validate(); // Verification du résultat if (!$result) { // Pas de validation on renvoit vers l'index $msg = '<font color=red>Nom d\'utilisateur ou mot de passe incorrect(s).</font><br />'; $this->index($msg); } else { // Si validation ok, // On l'envoit vers la partie "protégée" redirect('home'); } } } </code></pre> <p>Finally the view : LOGIN.PHP</p> <pre><code> <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <title>connexion</title> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta name="description" content=""> <meta name="author" content="kliklipse">  <link rel="stylesheet" href="<?php echo css_url('bootstrap.min'); ?>"> <style> body { padding-top: 40px; padding-bottom: 40px; background-color: #f5f5f5; } .form-signin { max-width: 300px; padding: 19px 29px 29px; margin: 0 auto 20px; background-color: #fff; border: 1px solid #e5e5e5; -webkit-border-radius: 5px; -moz-border-radius: 5px; border-radius: 5px; -webkit-box-shadow: 0 1px 2px rgba(0,0,0,.05); -moz-box-shadow: 0 1px 2px rgba(0,0,0,.05); box-shadow: 0 1px 2px rgba(0,0,0,.05); } .form-signin .form-signin-heading, .form-signin .checkbox { margin-bottom: 10px; } .form-signin input[type="text"], .form-signin input[type="password"] { font-size: 16px; height: auto; margin-bottom: 15px; padding: 7px 9px; } </style> <link rel="stylesheet" href="<?php echo css_url('bootstrap-responsive.min'); ?>"> <link rel="stylesheet" href="<?php echo css_url('main'); ?>">    <link rel="apple-touch-icon-precomposed" sizes="144x144" href="../assets/ico/apple-touch-icon-144-precomposed.png"> <link rel="apple-touch-icon-precomposed" sizes="114x114" href="../assets/ico/apple-touch-icon-114-precomposed.png"> <link rel="apple-touch-icon-precomposed" sizes="72x72" href="../assets/ico/apple-touch-icon-72-precomposed.png"> <link rel="apple-touch-icon-precomposed" href="../assets/ico/apple-touch-icon-57-precomposed.png"> <link rel="shortcut icon" href="../assets/ico/favicon.png"> </head> <body> <div class="container"> <form class="form-signin" action="<?php echo base_url();?>accueil/login" method="post" name="process"> <h2 class="form-signin-heading">Identifiez vous</h2> <br /> <?php if(! is_null($msg)) echo $msg;?> <input type="text" name="user_mail" id="user_mail" class="input-block-level" placeholder="Adresse Email"> <input type="password" name="password" id="password" class="input-block-level" placeholder="Mot de passe"> <label class="checkbox"> <input type="checkbox" value="remember-me"> Se souvenir de moi </label> <button class="btn btn-large btn-primary" type="submit">Se connecter</button> </form> </div>  <div id="footer"> <div class="container-narrow"> <p>&copy; Kliklipse 2013 <a href="<?php echo base_url(); ?>">Gestion des utilisateur & groupes</a></p> </div> </div> <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.0/jquery.min.js"></script> <script src="<?php echo js_url('bootstrap.min'); ?>"></script> <script src="<?php echo js_url('sorttable'); ?>"></script> <script>var base_url = <?php echo base_url(); ?></script>  </body> </html> </code></pre> <p>I get the error with num_rows() that its a undefined method... just dont know why..</p> <p>If any questions, ask me ( and sorry for my english ^^)</p>
Tags
<php><codeigniter><activerecord><login-control>
Title
PHP Fatal error: Call to undefined method stdClass::num_rows() in (...) line 36
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
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. PO
  singulars
  PostTypePostTypeId
  PTAnswer
2. PO
  singulars
  PostTypePostTypeId
  PTAnswer
3. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  POPHP Fatal error: Call to undefined method stdClass::num_rows() in (...) line 36
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTDownMod
2. VO
  singulars
  PostPostId
  POPHP Fatal error: Call to undefined method stdClass::num_rows() in (...) line 36
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
CommentsPostId

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.