duangongqiong6958
2019-02-21 04:41
浏览 34
已采纳

如何在Codeigniter中搜索数据后检索数据并在文本区域中显示

I am new to Codeigniter. I would like to create a module that after search the id, than it will retrieve data from the database and display the data in the textarea. I have no idea that how to retrieve data from database, and display the data in the textarea after click the 'Search' button. Hope someone can help me. Thank You.

This is the Model:

function search($code){
   $this->db->select('name','telno','address','introducer');
   $this->db->from('customer');
   $this->db->like('code',$code);
   $query = $this->db->get();
   if($query->num_rows() > 0){
    return $query->result();
   }else{
    return $query->result();
   }
}

This is the Controller:

public function searchcus(){ 
    $this->load->model('Ordering_model');
    $pgcode = $this->input->post('search');
    if(isset($code) && !empty($code)){
        $data['customer'] = $this->Ordering_model->search($code);
        $this->load->view('ordering/index',$data);
    }else{
        redirect($this->index());
    }
}

This is the View:

<div class="container">
            <div class="col-md-6">
                <div class="form-group">
                    <div class="col-md-9">
                            <input type="text" class="form-control" name="search" id="search" placeholder="<?php echo "Customer's PG Code";?> " required />
                    </div>
                    <span class="input-group-btn">
                        <button class="btn btn-default" type="submit" name="submit" value="Search" ><span class="glyphicon glyphicon-search"><?php echo "Search"; ?></span></button>
                    </span>
                    </div>
            </div>
            </form><br/>
    </div>
    <table style="width: 2000px;" class="table table-striped">
                 <div class="col-xs-4">
                    <div class="input-group">
                    <span class="input-group-addon">Name</span>
                    <input id="msg" type="text" class="form-control" name="msg" >
                    </div>
                </div>
                <br><br>
                <div class="col-xs-4">
                <div class="input-group">
                    <span class="input-group-addon">Tel</span>
                    <input id="msg" type="text" class="form-control" name="msg" >
                </div>
                </div>
                <br><br>
                <div class="col-xs-4">
                <div class="input-group">
                    <span class="input-group-addon">Introducer</span>
                    <input id="msg" type="text" class="form-control" name="msg" >
                </div>
                </div>
                <br><br>
                <div class="col-xs-4">
                <div class="input-group">
                    <span class="input-group-addon">Address</span>
                    <textarea class="form-control" rows="5" id="address"></textarea>
                </div>
                </div>
                <br>


    </table>
  • 写回答
  • 好问题 提建议
  • 关注问题
  • 收藏
  • 邀请回答

3条回答 默认 最新

  • doukan4039 2019-02-21 11:19
    已采纳

    Use the following code. It works...

    Controller:

     public function searchcus() {
            $pgcode = $this->input->post('search');
            if (isset($pgcode) && !empty($pgcode)) {
                $data['customerr'] = $this->Ordering_model->search($pgcode);
                $this->load->view('viewpage', $data);
            } else {
                redirect($this->index());
            }
        }
    

    Model:

       function search($pgcode) {
            $this->db->select('*');
            $this->db->from('customer');
            $this->db->like('code',$pgcode);
            return $this->db->get()->result();
        }
    

    View page:

    <div class="container">
        <form method="post" action="<?php echo base_url(); ?>index.php/welcome/searchcus">
                <div class="col-md-6">
                    <div class="form-group">
                        <div class="col-md-9">
                                <input type="text" class="form-control" name="search" id="search" placeholder="<?php echo "Customer's PG Code";?> " required />
                        </div>
                        <span class="input-group-btn">
                            <button class="btn btn-default" type="submit" name="submit" value="Search" ><span class="glyphicon glyphicon-search"><?php echo "Search"; ?></span></button>
                        </span>
                        </div>
                </div>
                </form><br/>
        </div>
    <?php if(empty($customerr)) { } else { foreach($customerr as $row) { ?>
        <table style="width: 2000px;" class="table table-striped">
                     <div class="col-xs-4">
                        <div class="input-group">
                        <span class="input-group-addon">Name</span>
                        <input id="msg" type="text" class="form-control" name="msg" value="<?php echo $row->name ?>" >
                        </div>
                    </div>
                    <br><br>
                    <div class="col-xs-4">
                    <div class="input-group">
                        <span class="input-group-addon">Tel</span>
                        <input id="msg" type="text" class="form-control" name="msg" value="<?php echo $row->telno ?>" >
                    </div>
                    </div>
                    <br><br>
                    <div class="col-xs-4">
                    <div class="input-group">
                        <span class="input-group-addon">Introducer</span>
                        <input id="msg" type="text" class="form-control" name="msg" value="<?php echo $row->introducer ?>" >
                    </div>
                    </div>
                    <br><br>
                    <div class="col-xs-4">
                    <div class="input-group">
                        <span class="input-group-addon">Address</span>
                        <textarea class="form-control" rows="5" id="address"> <?php echo $row->address ?></textarea>
                    </div>
                    </div>
                    <br>
    
    
        </table>
    <?php } } ?>
    
    评论
    解决 无用
    打赏 举报
  • 查看更多回答(2条)

相关推荐 更多相似问题