Send variable value from view to mysql

Question

In my cart I have a value that I need send to order_items, I have sent my variable to view and it's displaying correctly, but when save order, the value return NULL. I have checked all data, but probably the problem is how I'm sending.

Controller:

$dataProdutos['detalhesEstoque'] = $this->produtos_model->detalhesEstoque('23');

View: Displaying correctly.

<?= $detalhesEstoque[0]->codprod ?>

How I'm trying to send to MySQL using this variable:

$detalhesEstoque[0]->codprod;

Yes, I tried using _POST['codprod'] that is my input, that receive my value =$detalhesEstoque[0]->codprod; but, not work. — Everton Thomazi
– Everton Thomazi, Commented Jan 9, 2020 at 23:27
that's the way to do it, but you need to get the names right: the name field of the form element (e.g. input) needs to match your database table column field, to keep it as simple as possible — Vickel
– Vickel, Commented Jan 9, 2020 at 23:33

Agung Widhiatmojo · Accepted Answer · 2020-01-10 15:25:08Z

2

You can send variable data from your view to controller then save to database using POST method

for example at view

    <form action="<?php echo site_url('datasave/save_action'); ?>" method="post">
           <input type="text" class="form-control" name="codprod" id="codprod" value="<?php echo $detalhesEstoque[0]->codprod; ?>" readonly ?>
    </form>

at controller

       public function save_action() 
         {
              $data= array(
               'codprod' => $this->input->post('codprod',TRUE),
                );

       $this->Codprod_model->insert($data);

at model

function insert($data)
{
    $this->db->insert('codprodtable', $data);
}

answered Jan 10, 2020 at 15:25

Agung Widhiatmojo

1841 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Send variable value from view to mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related