时间戳

首页 > 解决方案 > 未添加到数据库的数据

database - 未添加到数据库的数据

问题描述

一直在尝试解决与我的代码有关的问题。好久没有编程codeigniter了。当我单击添加项目按钮时，它只是停留在同一页面上，什么都没有发生。这是我的视图和模型功能：

看法：

    <form action="<?php echo base_url().'item/addItem' ?> " method="post">

                    <div class="form-group">
                        <label>Name of Patient</label>
                        <input type="name" class="form-control" name="patient_name" placeholder="Name Here" value="<?php echo set_value('patient_name'); ?>">
                    </div>

                    <div class="form-group">
                        <label>Age</label>
                        <input type="input" class="form-control" name="age" placeholder="Age Here" value="<?php echo set_value('age'); ?>">
                    </div>

                    <div class="form-group">
                        <label>Date</label>
                        <input type="date" class="form-control" name="date" placeholder="Date" value="<?php echo set_value('date'); ?>">
                    </div>

                    <div class="form-group">
                        <label>Grade/PD</label>
                        <input type="input" class="form-control" name="grade" placeholder="Grade/PD Here" value="<?php echo set_value('grade'); ?>">
                    </div>

                    <div class="form-group">
                        <label>Frame No.</label>
                        <input type="input" class="form-control" name="frame_no" placeholder="Frame No. Here" value="<?php echo set_value('frame_no'); ?>">
                    </div>

                    <div class="form-group">
                        <label>Frame Amount</label>
                        <input type="input" class="form-control" name="frame_amo" placeholder="Frame Amount Here" value="<?php echo set_value('frame_amo'); ?>">
                    </div>

                    <div class="form-group">
                        <label>Lens Type/Amount</label>
                        <input type="input" class="form-control" name="lens_typeamo" placeholder="Lens Type/Amount Here" value="<?php echo set_value('lens_typeamo'); ?>">
                    </div>

                    <div class="form-group">
                        <label>Laboratory</label>
                        <input type="input" class="form-control" name="labo" placeholder="Laboratory Here" value="<?php echo set_value('labo'); ?>">
                    </div>

                    <div class="form-group">
                        <label>Total Amount</label>
                        <input type="input" class="form-control" name="total" placeholder="Total Amount Here" value="<?php echo set_value('total'); ?>">
                    </div>

                    <div class="form-group">
                        <label>Saleslady</label>
                        <input type="input" class="form-control" name="saleslady" placeholder="Saleslady Name Here" value="<?php echo set_value('saleslady'); ?>">
                    </div>

                    <div class="form-group">
                        <label>Doctor</label>
                        <input type="input" class="form-control" name="doctor" placeholder="Doctor Name Here" value="<?php echo set_value('doctor'); ?>">
                    </div>


                    <a href="<?php echo base_url().'item/itemlistadmin'?>" class="btn btn-info " role="button"><span class="glyphicon glyphicon-chevron-left" aria-hidden="true"></span> BACK </a>
                    <button type="submit" class="btn btn-primary"><span class="glyphicon glyphicon-plus" aria-hidden="true"></span> ADD ITEM</button>
                </form>

我不确定我在这个区域输入的内容是否正确：C

模型：

    public function addItem(){

        $patient_name = $this->input->post('patient_name');
        $age = $this->input->post('age');
        $date = $this->input->post('date');
        $grade = $this->input->post('grade');
        $frame_no = $this->input->post('frame_no');
        $frame_amo = $this->input->post('frame_amo');
        $lens_typeamo = $this->input->post('lens_typeamo');
        $labo = $this->input->post('labo');
        $total = $this->input->post('total');                       
        $saleslady = $this->input->post('saleslady');
        $doctor = $this->input->post('doctor'); 


        $item = array(
            'px_name' => $patient_name,
            'px_age' => $age,
            'px_date' => $date,
            'px_grade' => $grade,
            'px_frame_no' => $frame_no,
            'px_frame_amo' => $frame_amo,
            'px_lens_typeamo' => $lens_typeamo,
            'px_labo' => $labo,
            'px_total' => $total,
            'px_saleslady' => $saleslady,
            'px_doctor' => $doctor
        );

    $this->db->insert('tblitem',$item);

}

这是我的数据库：

看到这里 不知道要改变什么了：'<请帮忙。谢谢！

标签： databasecodeigniter

解决方案

尝试这个：

控制器

    public function addItem()
    {
    $item=array(  
        'patient_name' = $this->input->post('patient_name'),
        'age' = $this->input->post('age'),
        'date' = $this->input->post('date'),
        'grade' = $this->input->post('grade'),
        'frame_no' = $this->input->post('frame_no'),
        'frame_amo' = $this->input->post('frame_amo'),
        'lens_typeamo' = $this->input->post('lens_typeamo'),
        'labo' = $this->input->post('labo'),
        'total' = $this->input->post('total'),
        'saleslady' = $this->input->post('saleslady'),
        'doctor' = $this->input->post('doctor'),     
        );
        $this->ModelName->addItem($item); 
    }

模型

    public function addItem($item)
    {  
    $this->db->insert('tblitem', $item);
    $this->db->update('users');
    }

推荐阅读