duangongqiong6958 2019-02-20 20: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 03: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条)
编辑
预览

报告相同问题?

悬赏问题

  • ¥15 VAE代码如何画混淆矩阵
  • ¥15 求遗传算法GAMS代码
  • ¥15 雄安新区高光谱数据集的下载网址打不开
  • ¥66 android运行时native和graphics内存详细信息获取
  • ¥100 求一个c#通过CH341读取数据的Demo,能够读取指定地址值的功能
  • ¥15 rk3566 Android11 USB摄像头 微信
  • ¥15 torch框架下的强化学习DQN训练奖励值浮动过低,希望指导如何调整
  • ¥35 西门子博图v16安装密钥提示CryptAcquireContext MS_DEF_PROV Error of containger opening
  • ¥15 mes系统扫码追溯功能
  • ¥40 selenium访问信用中国
手机看
程序员都在用的中文IT技术交流社区

程序员都在用的中文IT技术交流社区

专业的中文 IT 技术社区,与千万技术人共成长

专业的中文 IT 技术社区,与千万技术人共成长

关注【CSDN】视频号,行业资讯、技术分享精彩不断,直播好礼送不停!

关注【CSDN】视频号,行业资讯、技术分享精彩不断,直播好礼送不停!

客服 返回
顶部