CodeIgniter Forums
how to get id from database by link...pls help me...i use this code....but get error undefined rows...... - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Libraries & Helpers (https://forum.codeigniter.com/forumdisplay.php?fid=22)
+--- Thread: how to get id from database by link...pls help me...i use this code....but get error undefined rows...... (/showthread.php?tid=52873)

how to get id from database by link...pls help me...i use this code....but get error undefined rows...... - El Forum - 06-30-2012

[eluser]atulswe1[/eluser]
1.controller

Code:
function abc($id = 0)    
{
     $this->load->model('emp_model');
     $data = $this->emp_model->general();
     $this->load->view('personal_emp',$data);
}

2.models

Code:
function get($id)
{
   $this->load->database();  
   $rows = $this->db->get_where('employee',array('id'=>$id));
   return $rows->row_array();        
}

3.views

Code:
<table border="1" height="200" width="200" bordercolor="#003366" align="center">

<tr>
    <th>ID</th></td>
    <th>NAME</th>
    <th>Fathet Name</th>
    <th>Dob</th>
    <th>Qualification</th>
    <th>Identity Type</th><th>Identity No</th>
    <th>Gender</th>
    <th>Email</th>
    <th colspan='2'>Action</th>
</tr>
&lt;?php foreach($rows as $r)
{
  echo "<tr>";
  echo "<td>". $r->id ."</td>";
  echo "<td>". $r->name ."</td>";
  echo "<td>". $r->father_name ."</td>";
  echo "<td>". $r->dob ."</td>";
  echo "<td>". $r->qualification ."</td>";
  echo "<td>". $r->identity_type ."</td>";
  echo "<td>". $r->identity_no ."</td>";
  echo "<td>". $r->gender ."</td>";
  echo "<td>". $r->email ."</td>";
  echo "<td>". anchor('employee/input/'.$r->id,'Edit') ."</td>";    
  echo "<td>". anchor('employee/del/'.$r->id,'Delete') ."</td>";
  echo "</tr>";
  echo "<br>";
}
?&gt;
</table>


how to get id from database by link...pls help me...i use this code....but get error undefined rows...... - El Forum - 06-30-2012

[eluser]goFrendiAsgard[/eluser]
$rows is not defined, you should fix your controller by writing this:
Code:
$data = array("rows" => $this->emp_model->general());
instead of $data = $this->emp_model->general();

Also, if you use $rows->row_array() in your model,
then you should use $r["id"] instead of $row->id
row_array will return an array, while row will return an object

how to get id from database by link...pls help me...i use this code....but get error undefined rows...... - El Forum - 07-01-2012

[eluser]atulswe1[/eluser]
ERROR SHOW WHAT IS THIS: Trying to get property of non-object



1.controller

Code:
function abc($id = 0)
     {
      $this->load->helper('form');
   $this->load->helper('html');
   $this->load->model('emp_model');
     $data = array("rows" => $this->emp_model->general());  
   if((int)$id > 0)
   {
   $data['rows']=$this->emp_model->info1($id);
      $data['fid']['value'] = $query['id'];
     $data['fname']['value'] = $query['name'];
  $data['ffather_name']['value'] = $query['father_name'];
  $data['fdob']['value'] = $query['dob'];
  $data['fidentity_type']['value'] = $query['identity_type'];
     $data['fidentity_no']['value']= $query['identity_no'];
     $data['femail']['value']= $query['email'];
   }
   $this->load->view('personal_emp',$data);
     }

2.model

Code:
function info1($id)
    {
     $this->load->database();
     $q =$this->db->get_where('employee');        
        
    if($q->num_rows()>0)
           {    
             foreach($q->result() as $rows)
              {      
                $data[]=$rows;
              }
          return $data;
           }
    }

3.views

Code:
<table border="1" height="200" width="200" bordercolor="#003366" align="center">
      <tr><th>ID</th></td><th>NAME</th><th>Fathet Name</th><th>Dob</th><th>Qualification</th><th>Identity Type</th><th>Identity No</th><th>Gender</th><th>Email</th><th colspan='2'>Action</th></tr>
   &lt;?php
      foreach($rows as $r)
  
{
   echo "<tr>";
   echo "<td>". $r->id ."</td>";
   echo "<td>". $r->name ."</td>";
   echo "<td>". $r->father_name ."</td>";
   echo "<td>". $r->dob ."</td>";
   echo "<td>". $r->qualification ."</td>";
   echo "<td>". $r->identity_type ."</td>";
   echo "<td>". $r->identity_no ."</td>";
   echo "<td>". $r->gender ."</td>";
   echo "<td>". $r->email ."</td>";
   echo "<td>". anchor('employee/input/'.$r->id,'Edit') ."</td>";
   echo "<td>". anchor('employee/del/'.$r->id,'Delete') ."</td>";
   echo "</tr>";
   echo "<br>";
}
   ?&gt;
   </table>


how to get id from database by link...pls help me...i use this code....but get error undefined rows...... - El Forum - 07-01-2012

[eluser]InsiteFX[/eluser]
Code:
function abc($id = 0)
{
    $this->load->helper('form');
    $this->load->helper('html');
    $this->load->model('emp_model');

    $data['general'] = $this->emp_model->general();  

    if((int)$id > 0)
    {
        $data['rows']=$this->emp_model->info1($id);
        $data['fid']['value'] = $query['id'];
        $data['fname']['value'] = $query['name'];
        $data['ffather_name']['value'] = $query['father_name'];
        $data['fdob']['value'] = $query['dob'];
        $data['fidentity_type']['value'] = $query['identity_type'];
        $data['fidentity_no']['value']= $query['identity_no'];
        $data['femail']['value']= $query['email'];
    }

    $this->load->view('personal_emp',$data);
}