codeigniter:使用会话从另一个表更新表 [英] codeigniter: Update table from another table with session

问题描述

我在更新表时遇到了一些挑战，该表与来自另一个表的会话userdata联接在一起.每次运行时，它都会显示未定义的函数.请让我知道我在哪里弄错了，可以解决它.请抽出时间对其进行检查 我是新手. 这是控制器

I'm having some challenge updating table a form joined with session userdata from another table. Each time I run, it displays undefined function. Please let me know where I'm getting it wrong so could fix it.Please find time to review it I'm a newbie. Here's the controller

 public function index()
    {

        if ( $this->session->userdata('logged_in') )
        {

            $id = $this->session->userdata('id');
            $this->load->model('Userinfo_model');
            $data['result'] = $this->Userinfo_model->get_users($id);

            $this->load->view("usermain_info", $data);

        }
    }
    public function update_user (){
        $data = $this->input->post('userId');
        $id = array(
            'balance' => $this->input->post('balance'),
            'id' => $this->input->post('id')
        );
        $this->Userinfo_model->update_user($id, $data);
        $this->index();
    }

模型

function get_users($userid)
    {

        if (isset($this->session->userdata['logged_in'])) {

            $userid = ($this->session->userdata['logged_in']['id']);
        } else {
            header("location: nwpgroup/nwp2/index.php");
        }

        /* all the queries relating to the data we want to retrieve will go in here. */

        $query = $this->db->query("SELECT * FROM walletbalance WHERE userId='$userid'");


        return $query;
    }
    function update_user($id,$data){
        if (isset($this->session->userdata['logged_in'])) {

            $data = ($this->session->userdata['logged_in']['id']);
        } else {
            header("location: nwpgroup/nwp2/index.php");
        }
        $this->db->where('userId', $data);
        $this->db->update('walletbalance', $id);
    }

查看

<form method="post" action="<?php echo base_url() . "index.php/userinfo/update_user"?>">
            <?php if($result->num_rows() == 0){
                echo 'No user found';
            }
            else {
                foreach ( $result->result_array() as $new_user ){ ?>
                    <h4>Your name:<input value=" <?php echo $new_user['balance'] ?>" type="text" /> </h4><br />
                    <h4>Your name:<input value=" <?php echo $new_user['id'] ?>" type="text"/> </h4><br/>
                    <h4>Your name: <input value="<?php echo $new_user['userId'] ?>" type="hidden"/> </h4>
                    <input type="submit" id="submit" name="dsubmit" value="Update">
                <?php   }
            }
            ?>

错误消息

Message: Undefined property: Userinfo::$Userinfo_model

和

Message: Call to a member function update_user() on null

谢谢，我很感激

推荐答案

按如下所示更改视图:

<form method="post" action="<?php echo base_url() . "index.php/userinfo/update_user"?>">
        <?php if($result->num_rows() == 0){
            echo 'No user found';
        }
        else {
            foreach ( $result->result_array() as $new_user ){ ?>
                <h4>Your name:<input value=" <?php echo $new_user['balance'] ?>" type="text" name="balance" /> </h4><br />
                <h4>Your name:<input value=" <?php echo $new_user['id'] ?>" type="text" name="id" /> </h4><br/>
                <h4>Your name: <input value="<?php echo $new_user['userId'] ?>" type="hidden" name="userId"/> </h4>
                <input type="submit" id="submit" name="dsubmit" value="Update">
            <?php   }
        }
     ?>
</form>

仅当元素具有名称时，表单才会将数据发送到服务器

form will send data to server only if the element has a name

，并且您不能多次提交表单.上面的代码将为每一行创建更新按钮.因此，如果要一次更新所有记录，请在codeigniter中使用update_batch().并按如下所示更改视图:

and you cannot submit a form multiple times. The above code will create update button for each row. So if you want to update all the records in a single updation, use update_batch() in codeigniter. and change view as follows :

foreach ( $result->result_array() as $new_user ){ ?>
                <h4>Your name:<input value=" <?php echo $new_user['balance'] ?>" type="text" name="balance" /> </h4><br />
                <h4>Your name:<input value=" <?php echo $new_user['id'] ?>" type="text" name="id" /> </h4><br/>
                <h4>Your name: <input value="<?php echo $new_user['userId'] ?>" type="hidden" name="userId"/> </h4>

            <?php   } ?>
<input type="submit" id="submit" name="dsubmit" value="Update">

供参考: https://www.codeigniter.com/userguide3/database/query_builder.html#updating-data

这篇关于codeigniter:使用会话从另一个表更新表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！