php - Error trying to fetch data codeigniter -


i got 2 tables , gotta fetch information, tables:

cursadas" includes:(id, user_id[is foreign key column "id" of table "usuarios"], subject_id[is foreign key column "id" of table "materias"], grade, date)

"usuarios" includes:(id,username,name,lastname,password,type,status,date)

"materias" includes:(id, career_id, name, description, hours)

i need this:

enter image description here

this error get:

enter image description here

my view file:

    <html>      <head>        </head>  <body>      <div class="container">      <div class="row">     <div class="col-md-12">          <h2 align="center">table:study</h2>          <input id="busqueda_tabla" type="text">             <table class="table table-hover" align="center" border="1" cellspacing="0" cellpadding="0" width="700" id="tabla_busqueda">                 <thead>                     <th>id</th>                     <th>user</th>                     <th>subject</th>                     <th>grade</th>                     <th>date</th>                     <th>action</th>                 </thead>  <tbody>     <?php      if (count($records) > 0 && $records != false) {         foreach($records $record) {              echo "<tr>                       <td>".$record['id']."</td>                       <td>".$record['user']."</td>                       <td>".$record['subject']."</td>                       <td>".$record['grade']."</td>                       <td>".$record['date']."</td>                       <td align='center'>                           <button type='button' class='btn btn-primary'>editar</button></a> |                           <button type='button' class='btn btn-danger'>borrar</button></a>                    </tr>";         }         }     ?>  </tbody>      </table>          </div>         </div>         </div>  </body> </html>

my controller file (home):

    <?php      class home extends ci_controller{           public function __construct(){              parent::__construct();               $this->load->model("crudmodel");          }    public function index(){      # data in study table     $selectstudys = $this->crudmodel->selectstudys();       foreach ($selectstudys $key => $study)      {         # usernames         $user = $this->crudmodel->getname($study['user_id']);          #get subject names         $subject = $this->crudmodel->getsubname($study['subject_id']);           #append both new values same array          if(!empty($user[0]['username'])){         $data[$key]['user_id'] = $user[0]['username'];         // main problem can this. may not getting value query why have put validation on model function , error handler condition here         }else{          $data[$key]['user_id'] = ''; // or else condition can use error handler          }         if(!empty($subject[0]['name'])){         $data[$key]['subject_id'] = $subject[0]['name'];         // main problem can this. may not getting value query why have put validation on model function , error handler condition here         }else{            $data[$key]["subject_id"] = "";           // or can use error handler         }      }       $data['records'] = $selectstudys;     $this->load->view('home', $data);  }  } ?>

crudmodel:

       class crudmodel extends ci_model{          public function __construct(){          parent::__construct();           $this->load->database();          }           function selectstudys() {     $query= $this->db->query("select * cursadas");     if($query->num_rows()>0){        $result = $query->result_array();      }else{       $result = "";           // or can use error handler       return $result;     } }  function getname($name) {     $query= $this->db->query("select username usuarios id = $name ");     if($query->num_rows()>0){     $result = $query->result_array();     }else{     $result = "";           // or can use error handler     return $result;   } }

hope can me :/

i have updated controller , model:

updated controller file (home):

<?php  class home extends ci_controller{      public function __construct(){         parent::__construct();          $this->load->model("crudmodel");      }       public function index(){          # data in study table         $selectstudys = $this->crudmodel->selectstudys();           $data['records'] = $selectstudys;         $this->load->view('home', $data);      }  }

updated model:

class crudmodel extends ci_model {      public function __construct(){         parent::__construct();          $this->load->database();      }       function selectstudys()     {         $this->db->select('cursadas.id, cursadas.user_id, usuarios.username user, cursadas.subject_id, materias.name subject, cursadas.grade, cursadas.date');         $this->db->from('cursadas');         $this->db->join('usuarios', 'usuarios.id=cursadas.user_id', 'left');         $this->db->join('materias', 'materias.id=cursadas.subject_id', 'left');         $query = $this->db->get();         return $query->result_array();     }      function getname($name)     {         $query= $this->db->query("select username usuarios id = $name ");         if($query->num_rows()>0){         $result = $query->result_array();         } else {         $result = "";             // or can use error handler         return $result;       }     } }

Comments

Post a Comment

Popular posts from this blog

inversion of control - Autofac named registration constructor injection -

does autofac support specifying registration name in components' constructors? example: ninject's namedattribute . you need use autofac.extras.attributed package on top achieve this so let's have 1 interface , 2 classes: public interface ihello { string sayhello(); } public class englishhello : ihello { public string sayhello() { return "hello"; } } public class frenchhello : ihello { public string sayhello() { return "bonjour"; } } then have consumer class, in want select instance injected: public class helloconsumer { private readonly ihello helloservice; public helloconsumer([withkey("en")] ihello helloservice) { if (helloservice == null) { throw new argumentnullexception("helloservice"); } this.helloservice = helloservice; } public string sayhello() { return this.helloservice.sayhello()...
Read more

verilog - Systemverilog dynamic casting issues -

i've code snippet following in testbench function void write_to_port( my_data_type_base data ); my_data_type_extended data_ext; if(!$cast(data_ext, data)); `uvm_error(get_type_name(), "failed cast"); `uvm_info(get_name(), $psprintf("data_ext :\n%s", data_ext.sprint()), uvm_medium) // write data_ext out port.... endfunction when run it, i'm getting uvm_error "failed cast." i'm not quire sure why $cast not returning 1. can see, i'm printing out extended class data item after casting uvm_info. can see it's being cast properly. if don't use $cast if condition, don't runtime error. isn't coding practice use if dynamic cast check if $cast returning 1 ? what might reason behind cast not returning 1 in above case? i think semicolon on line 'if' not belong? i think consumes if statement, , uvm_error executes regardless of how if evaluates: if(!$cast(data_ext, data)); <- no semico...
Read more

ios - Change Storyboard View using Seague -

i have following code checks connection server, , depending on want change views if no connection found. nsstring *connect = [nsstring stringwithcontentsofurl:[nsurl urlwithstring:@"http://myserver.com"] encoding:nsutf8stringencoding error:nil]; if (connect == null) { [self performseguewithidentifier:@"network_failure" sender:self]; } else { // other code here } my problem not change views. have added storyboard segue between 2 views identifier of network_failure . not have navigation controller or that, problem? thanks help! no not problem. first of all, in objectivec exists nil object oriented null . must use that. so: if(connect == nil) or better: if(!connect) so due fact nil not same of null , probably code does't enter in if scope . you have been able discover breakpoint. anyway: be sure set trigger segue (line) 2 view controller , , name network_failure (that not best name. should instead view1toview2 ) as, m...
Read more