从数据库中获取时,我在CodeIgniter中收到“未定义的变量”错误

手Vellingiri

从数据库中获取代码时,我在codeigniter中遇到错误。

这是我的错误:

遇到PHP错误

消息:未定义的变量:结果

行号:122

这是我的代码:

  <?php $via = $this->session->userdata('firm_name');
if(!isset($firm_name)){ redirect ('Welcome');}
?>      
<link href="<?php echo base_url("assets/css/radiostyle.css"); ?>" rel="stylesheet">
<style type="text/css">
              .page-heading {
            border-top: 0;
            padding: 0px 10px 10px 10px;
        }
        input, button, select, textarea{
          margin: 10px;
        }
              .ibox-content {
          background-color: #ffffff;
          color: inherit;
          padding: 15px 20px 20px 20px;
          border-color: #e7eaec;
          border-image: none;
          border-style: none; 
          border-width: 1px 0px;
      }
      </style>
      
            <div class="row wrapper border-bottom white-bg page-heading">
                <div style="float: left;" class="col-lg-4">
                    <img style="    width: 90px;
    height: 90px;     padding-top: 5px;" src="http://www.miisky.com/ci/GST.png" alt="GST Logo">
                    
                </div>
                <div class="col-lg-4 text-center">
                    <h1 style="    padding-top: 7px;
    padding-right: 20%;">Know Your Customers</h1>
                    
                </div>
                <div style="float: right;" class="col-lg-4">
                    <h1 style="padding-top:9px"><?php echo "Date: ". date("d/m/Y");?></h1>
                    
                </div>
            </div>
            <br><div style="text-align: center;"> 
            <label class="control control--radio">Manufacture
      <input type="radio" onclick="document.location='#';" name="radio" checked="checked"/>
      <div class="control__indicator"></div>
    </label>
    <label class="control control--radio">Service
      <input type="radio" onclick="document.location='#';" name="radio" />
      <div class="control__indicator"></div>
    </label>
     <label class="control control--radio">Trading
      <input type="radio" onclick="document.location='#';" name="radio" />
      <div class="control__indicator"></div>
    </label>
    <label class="control control--radio">Others
      <input type="radio" onclick="document.location='#';" name="radio" />
      <div class="control__indicator"></div>
    </label>
   
    
  
    </div>
            <div class="fh-breadcrumb">

                <div class="full-height">
                    <div class="full-height-scroll white-bg border-left">
                      <?php echo $this->session->flashdata('msg'); ?>
                        <div class="element-detail-box">

                            <div class="tab-content">
                               <div class="ibox-content">
            
                            <div class="form-group">

                                <div class="col-lg-12">
                                    <div class="row">
                                    
                                    <?php $this->load->helper('form'); ?>
                                    <?php $attributes = array("name" => "Categoryform","autocomplete"=>"off");
                                    echo form_open("Gst_customer/customersearch/", $attributes);?>
                                                <div class="col-lg-6">
                                                        <input name="CustomerName" type="text" placeholder="CustomerName" value="<?php echo set_value('CustomerName'); ?>" class="form-control" required>
                                                        <span class="text-danger"><?php echo form_error('CustomerName'); ?></span>
                                                    </div>
                                                    
                                                    
                                                    <div class="col-lg-12">
                                                       <?php echo form_submit('Search', 'Search','class="btn btn-info"'); ?>
                                                    </div> 
                                                    
                                      <?php echo form_close(); ?>

                                    </div>
                                    
                                </div>
                            </div>
                     
            </div>

                               

                                
                                
                            </div>

                        </div>

                    </div>
                </div>
<div class="full-height">
                      <div class="full-height-scroll white-bg border-left">
                         <?php echo $this->session->flashdata('message'); ?>
                          <div class="element-detail-box">
                            <div class="table-responsive">
              <?php if(isset($results)){ ?>
<table class='table table-bordered'>
                    <thead>
                      <tr>
                      <th> Customer Name </th>
                      <th> Customer Id</th>
                      <th> Customer Code</th>
                      </tr>
                    </thead>
                      <tbody>
                          <?php foreach($results as $row){ ?>
                                    <tr>
                                         <td><?php echo $row->CustomerName;?></td>
                                         <td><?php echo $row->CustomerID;?></td>
                                         <td><?php echo $row->CustomerCode;?></td>
                                    </tr>

                          <?php } ?>


                      </tbody>
                  </table>
     <?php } ?>             

                  </tbody>
              </table>
          
                                      
                                 
                           
                       
           

                                 

                                  
                                  
                            
                          </div>
                          </div>

                      </div>
                  </div>


            </div>

这是我的控制器文件:

<?php
class Gst_customer extends CI_Controller
{
    public function __construct()
    {
        parent::__construct();
        $this->load->helper(array('url','html'));
        $this->load->library('session');
        $this->load->database();
        $this->load->model('user_model');
        
    }   
    
    function index()
    {
        $details = $this->user_model->get_user_by_id($this->session->userdata('id'));
                
        $data['firm_name'] = $details[0]->firm_name;
        $data['email'] = $details[0]->email;
        $data['vault_no'] = $details[0]->vault_no;
        $data['active'] = 'know_your_customer';
        $data['mobile'] = $details[0]->mobile;
        
        $this->load->view('view_header', $data);
        $this->load->view('view_menu', $data);
        $this->load->view('gst_customer_view', $data);
        $this->load->view('view_footer');
    }

     function customersearch()
    {
        $CustomerName    =   $this->input->post('CustomerName');
        $data['results']    =   $this->user_model->search($CustomerName);
        $results = $data['results'];
       $this->load->view('view_header', $data);
        $this->load->view('view_menu', $data);
        $this->load->view('gst_customer_view', $data);
        $this->load->view('view_footer');
    }

    function logout()
    {
    $user_data = $this->user_model->get_user_by_id($this->session->userdata('id'));
        foreach ($user_data as $key => $value) {
            if ($key != 'session_id' && $key != 'ip_address' && $key != 'user_agent' && $key != 'last_activity') {
                $this->session->unset_userdata($key);
            }
        }
    $this->session->sess_destroy();
    
    redirect('Welcome', 'refresh');
    }
}

这是我的模型:module.php

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

    class User_model extends CI_Model
    {
        function __construct()
        {
            parent::__construct();
        }
            
        

function search($CustomerName,$CustomerID)
    {
        $this->db->like('CustomerName',$CustomerName);
        $this->db->like('CustomerID',$CustomerID);
        $query  =   $this->db->get('gst_customermaster');
        return $query->result();
    }
    
    }?>
德赛

获取索引中的所有数据。试试这个:

module.php

class User_model extends CI_Model
{
    function __construct()
    {
        parent::__construct();
    }

    function search($CustomerName)
    {
        $this->db->like('CustomerName',$CustomerName);
        $query  =   $this->db->get('gst_customermaster');
        return $query->result();
    }

    function getAll()
    {            
        $query  =   $this->db->get('gst_customermaster');
        return $query->result();
    }

}?>`enter code here`

控制器文件:

 <?php
class Gst_customer extends CI_Controller
{
    public function __construct()
    {
        parent::__construct();
        $this->load->helper(array('url','html'));
        $this->load->library('session');
        $this->load->database();
        $this->load->model('user_model');

    }   

function index()
    {
        $details = $this->user_model->get_user_by_id($this->session->userdata('id'));

        $data['firm_name'] = $details[0]->firm_name;
        $data['email'] = $details[0]->email;
        $data['vault_no'] = $details[0]->vault_no;
        $data['active'] = 'know_your_customer';
        $data['mobile'] = $details[0]->mobile;
        //$data['results']  =   $this->user_model->getAll();
        $data['results']  =   array();
        $this->load->view('view_header', $data);
        $this->load->view('view_menu', $data);
        $this->load->view('gst_customer_view', $data);
        $this->load->view('view_footer');
    }

     function customersearch()
    {
         $results = $this->user_model->get_user_by_id($this->session->userdata('id'));
         $data['firm_name'] = $results[0]->firm_name;
           $id = $this->input->post('id');
       $data['results']=array();
        $CustomerName    =   $this->input->post('CustomerName');
       if(trim($CustomerName) != "")
       {
        $data['results']    =   $this->user_model->search($CustomerName);
       }
        $results = $data['results'];
       $this->load->view('view_header', $data);
        $this->load->view('view_menu', $data);
        $this->load->view('gst_customer_view', $data);
        $this->load->view('view_footer');
    }

    function logout()
    {
    $user_data = $this->user_model->get_user_by_id($this->session->userdata('id'));
        foreach ($user_data as $key => $value) {
            if ($key != 'session_id' && $key != 'ip_address' && $key != 'user_agent' && $key != 'last_activity') {
                $this->session->unset_userdata($key);
            }
        }
    $this->session->sess_destroy();

    redirect('Welcome', 'refresh');
    }
}

本文收集自互联网,转载请注明来源。

如有侵权,请联系 [email protected] 删除。

编辑于
0

我来说两句

0 条评论
登录 后参与评论

相关文章

我收到以下错误;未定义的变量,在 codeigniter 中

我正在尝试使用sails js从数据库中的相关表中获取数据。但我总是收到未定义的错误。谢谢

Laravel 7-从数据库中获取数据时出现未定义偏移错误

在codeigniter中获取未定义变量的错误?

CodeIgniter 4中的错误验证时未定义的变量

获取未定义的属性:projekti 在尝试打印从数据库中获取的字段时

从数据库中获取数据时出错,并且未定义索引

类型错误:无法读取未定义的属性“包括”(从数据库中获取反应)

为什么我收到错误“未定义的变量数据”?

当我尝试从数据库中提取数据时,PHP未定义变量

使用AJAX和JSON从数据库中获取和显示数据时,在innerHTML中变得未定义

收到错误的PHP注意:未定义的变量:我的php代码中的do_not_compress

未定义的数据库变量

为什么我在 EJS 中收到“未定义”错误?

尝试从数据库中回显值时,为什么会出现错误(通知:未定义的索引)?

未定义变量:标签,在引导模式上显示数据库中的数据

如果Firebase数据库部分中的数据未定义,我该如何更新Profile?

PHP未定义的变量-mysql数据库中的表

我正在从我的 nodejs 中获取动态数据到 reactjs,但我收到一条错误消息,提示“POST 未定义”

值未从输入错误插入数据库:phonegap中未定义

初始化连接到数据库时SQLX中的未定义'err'

尝试显示数据库中的数字时未定义的索引

我在尝试从 CloudKit 公共数据库中删除记录时收到错误

在html中获取数据属性时,我得到了未定义的数据集

从PHP中的表单获取值时发生未定义的变量错误

收到类型错误,提示我的websocket变量未定义

尝试在Rails中访问我的静态变量时获取“未定义的方法”

我的脚本中存在未定义变量的错误

提交表单时在节点js中获取表单数据:未定义错误