php - Passing data from View to Controller for sql statement in Model in CI -

-

hi have simple form of images user can click on , depending on image clicked on modal dialog appear list of data database. have working 1 whereby state specific column name in mysql statement not via variable. able know how/where pass value of image input view controller can used in mysql statement in view..i pass mysql statement controller model view. below code. appreciated brand new ci , abit confused.thanks!

controller:

      <?php if ( ! defined('basepath')) exit('no direct script access allowed');      class app extends my_controller {  function __construct() {     parent::__construct();      log_message('debug', 'app controller has been initialized'); }  public function toolsmodal() {     $dept = $this->input->post('submit');     //echo $dept;     $this->load->model('tools_model');     $tools = $this->tools_model->gettools($dept);     $data['tools'] = $tools;     $data['view'] = 'datatables';     $this->load->view('templates/default', $data); }  public function index() {       $data['view'] = 'datatables';     $this->load->view('templates/default', $data);   }  public function welcome() {     $data['view'] = 'welcome';     $this->load->view('templates/default', $data); }  public function datatables() {     // can safely delete method.  example.     $data['view'] = 'datatables';     $this->load->view('templates/default', $data);  }       }

model: 

      class tools_model extends ci_model       { public function gettools($dept) {        //$query = $this->db->query("select rname,decription,dri,developer, golive web.reportdash applestore = 'yes'");     $this->db->select('rname, decription, dri, developer, golive');     $this->db->where($dept, 'yes');     $query = $this->db->get('web.reportdash');      $tools = array();      foreach ($query->result() $row) {         $tools[] = $row;     }      return $tools; }

} ?>

view: 

     <table>       <tr>  <td style="text-align:center;font-weight:bold;width:300px;font-size:14px;color:       #ffffff;"><input type='image' id='filters-trigger-applestore' src="<? echo             base_url("/_assets/img/store.png"); ?>" name='submit' value='store'>      <br>applestore</td>     <td style="text-align:center;font-weight:bold;width:300px;font-size:14px;color:    #ffffff;">                 <input type='image' id='filters-trigger-storef' src="<? echo   base_url("/_assets/img/finance.png"); ?>"   name='submit' value='finance'><br>finance</td>    <td style="text-align:center;font-weight:bold;width:300px;font-size:14px;color: #ffffff;"><input type='image' id='filters-trigger-storel' src="<? echo base_url("/_assets/img/logistics.png"); ?>" name='submit' value='logistics'>     <br>logistics</td>   </tr> <tr></tr> <tr> <td style="text-align:center;font-weight:bold;width:300px;font-size:14px;color: #ffffff;"><input type='image' id='filters-trigger-storeman' src="<? echo base_url("/_assets/img/manufacturing.jpg"); ?>" name='submit' value='manufacturing'><br>manufacturing</td> <td style="text-align:center;font-weight:bold;width:300px;font-size:14px;color: #ffffff;"><input type='image' id='filters-trigger-storect' src="<? echo base_url("/_assets/img/control.jpg"); ?>" name='submit' value='controltower'><br>control tower</td> <td style="text-align:center;font-weight:bold;width:300px;font-size:14px;color: #ffffff;"><input type='image' id='filters-trigger-storeom' src="<? echo base_url("/_assets/img/om.jpg"); ?>" name='submit' value='ordermanagement'><br>order management</td> </tr> 

<td style="text-align:center;font-weight:bold;width:300px;font-size:14px;color: #ffffff;">  <input type='image' id='filters-trigger-stores' src="<? echo base_url("/_assets/img/sales.jpg"); ?>"                name='submit' value='sales'><br>sales</td>  </tr> </table> </form>   </div>   <div class="container">   <div class="filters-trigger-applestorem not-displayed modal1 hide fade in" style="overflow:auto;"> <button type="button" id='close' class="close" data-dismiss="filters-trigger-applestorem">×</button>    <table class="table table-bordered smaller-font margin-top-medium" style="margin: 0;"> <thead> <tr> <td>report name</td> <td>description</td> <td>dri</td> <td>developer</td> </tr> </thead> <tbody>                 <?php foreach($tools $tool):                 ?>                     <tr class="padding-larger-right table-header"><td><?= $tool->rname; ?>    </td>                     <td class="smaller-padding vertical-centred"><?= $tool->decription; ?></td>                     <td class="smaller-padding vertical-centred"><?= $tool->dri; ?></td>                     <td class="smaller-padding vertical-centred"><?= $tool->developer; ?></td>                 <?php                 endforeach ?>                    </tbody>             </table>    </div>

hi modify model, loop in model $tool array have last row every time on write old array here modified 

    class tools_model extends ci_model       { public function gettools($dept) {        //$query = $this->db->query("select rname,decription,dri,developer, golive web.reportdash applestore = 'yes'");     $this->db->select('rname, decription, dri, developer, golive');     $this->db->where($dept, 'yes');     $query = $this->db->get('web.reportdash');      return $query->result();  }  } ?>

you can loop in view now


Comments

Post a Comment

Popular posts from this blog

java - Jmockit String final length method mocking Issue -

-
using jmockit 1.2 jar, trying mock string's length method getting unexpected invocation exception: failed: test java.lang.illegalstateexception: missing invocation mocked type @ point; please make sure such invocations appear after declaration of suitable mock field or parameter @ stringdemo.testa$1.<init>(testa.java:17) @ stringdemo.testa.test(testa.java:13) i using testng: @test public void test() throws exception { new expectations() { @mocked("length") string astring; { astring.length(); result = 2; } }; system.out.println(a.showa("test")); } } actual class a: public class { public static int showa(string str){ int a= str.length(); return a; } } this wrong way of recording expected results. shouldn't mock , record string's length() method, record showa() instead. here solution @suppresswarnings("unused...
Read more

What is the difference between data design and data model(ERD) -

-
i have google question , find answer in day. know, data design many many table have list column,and mark pk , fk. why er-diagram have find this? data design process of designing database. main output of data design detailed logical data model of database. some people data design includes of needed logical , physical design choices , physical storage parameters needed generate design in data definition language. technically, database analysis, database analysts (dbas) trained do. while person can both data design , database analysis, these 2 different tasks. data design models data. database analysis takes model , applies 1 or more database engines (relational, hierarchical, nosql). a logical data model 1 of main outputs of data design. data model represented entity relationship diagram, or er diagram.
Read more

ios - Can NSManagedObject conform to NSCoding -

-
i need transfer single object across device. right converting nsmanagedobject dictionary , archiving , sending nsdata. upon receiving unarchiving it. transfer nsmanagedobject archiving , unarchiving instead of creating intermediate data object. @interface test : nsmanagedobject<nscoding> @property (nonatomic, retain) nsstring * title; @end @implementation test @dynamic title; - (id)initwithcoder:(nscoder *)coder { self = [super init]; if (self) { self.title = [coder decodeobjectforkey:@"title"]; //<crash } return self; } - (void)encodewithcoder:(nscoder *)coder { [coder encodeobject:self.title forkey:@"title"]; } @end nsdata *archivedobjects = [nskeyedarchiver archiveddatawithrootobject:testobj]; nsdata *objectsdata = archivedobjects; if ([objectsdata length] > 0) { nsarray *objects = [nskeyedunarchiver unarchiveobjectwithdata:objectsdata]; } the problem above code is. crashes @ self.title in initwithcoder sa...
Read more