php - Conditional select from a table using codeigniter -


im trying make select shows information (a conditional select).

i mean, table "usuarios":

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

take look:

enter image description here

my goal make select shows users "type" = 1 , "status" = 1

take look:

enter image description here

i have done select shows every usernames, not validates :/.

my program shows this, , not correct because not validate :/

enter image description here

here code:

my controller file:

    public function edit($id){    $data['usuarios'] = $this->crudmodel->get_usuarios();   $data['record']=$this->crudmodel->get_id_row($id);   $this->load->view('edit',$data);  }

my model file:

          public function get_usuarios() {          $this->db->select('c.*')              ->from('usuarios c');         $q = $this->db->get();            return $q->result(); }

my "edit" file:

    <h2 align="center">update</h2> <form method="post" action='<?php echo site_url('home/saveupdate'); ?>'> <tr>      <td><input type="text" hidden name="txtid" value="<?php echo $record->id ?>"/></td>  </tr> <tr>      <td>         <select name="txtcarr">             <?php foreach($usuarios $item):?>             <option value="<?php echo $item->id;?>"><?php echo $item->username;?></option>              <?php endforeach;?>         </select>     </td> </tr>   <tr>      <td></td>     <td><input type="submit" value="save"/></td>  </tr>

dont know whatto :/

why not select rows want? work expect if put in model? 

public function get_usuarios() {    $this->db->select('id, username')         ->from('usuarios')         ->where(array('status'=>1, 'type'=>1));     $q = $this->db->get();    return $q->result(); }

Comments

Post a Comment

Popular posts from this blog

'hasOwnProperty' in javascript -

i use obj.hasownproperty judge whether object has property, when replaced obj[prop] !== undefined , not normal implementation, ask, why behind method can not use it? object.hasownproperty(prop); object[prop] !== undefined; obj[prop] !== undefined wrong 2 reasons: you can explicitly set property undefined , obj[prop] = undefined; . obj.hasownproperty(prop) return true in case. obj[prop] follow prototype chain, return property that's inherited. obj.hasownproperty(prop) returns true if property exists directly in object, returns false inherited properties.
Read more

python - ValueError: No axis named 1 for object type <class 'pandas.core.series.Series'> -

i´m new programming. i´m trying use scipy minimize, had several issues , gotten through of them. right code, i'm not understanding why i´m getting error. par_opt = so.minimize(fun=fun_obj, x0=par_ini, method='nelder-mead', args=[series_pt_cal, dt, series_caudal_cal]) not enough info given op, somewhere in code it's specified operate data frame column (axis=1) on object pandas series. if code typically works occasional gives errors, check degenerative cases data frame may have 1 row. pandas has nasty habit of guessing want -- may decide reduce 1-row data frame series (e.g., apply() function; can disable using reduce=false in there). add line of code check object isinstance(df, pd.dataframe) or else convert offending pandas series data frame, s.to_frame().t problems had deal with.
Read more

java - How to provide dependency injections in Eclipse RCP 3.x? -

everyone! i'm trying deal eclipse rcp 3.x application. i've read lot of articles dependency injection in rcp e4 applications. can use di in rcp 3.x apps? i found perfect link di in e4. idea how use in rcp 3.x app? first of all, i'm interested in own objects injection (btw, how add own object application context?). best regards in 3.x code can ieclipsecontext necessary use contextinjectionfactory using ieclipsecontext workbenchcontext = platformui.getworkbench().getservice(ieclipsecontext.class); to workbench context. in view or editor can current part context using: ieclipsecontext partcontext = getsite().getservice(ieclipsecontext.class);
Read more