HTML textbox is not updated after form submitted update database record

Question

I am using CodeIgniter. in application/views/abc.php

<input type="text" name="company_profit" id="company_profit" value="<?php echo $form_data['company_profit']; ?>" >

in application/controller/Cde.php

$data['form_data'] = $form_data = $this->common->getOneRow("tbl_psb_setting","WHERE id=1");

if(isset($_POST) && count($_POST) > 0)
{   
    if($this->form_validation->run())       
    {   
        $up_data['company_profit'] = $this->input->post('company_profit');
        $this->common->updateRecord('tbl_psb_setting',$up_data,"id=1"); 
    }
}

When i click submit button, html form submitted, database record success updated. But why HTML textbox "company_profit" value is not updated? I need to press F5 refresh page then only I can see textbox value is updated.

I can see page is refresh when i click "submit" button, which mean html form submitted auto refresh page, so I guess mysql retrieve data from database assign to textbox is too fast before new record updated into database? So I try code php sleep(3); wait 3 seconds then only start retrieve data from database assign into textbox value, but fail, textbox still showing old value. Any idea?

yes i tried that. It works, but when i redirect, other page content all refreshed and disappear. I want to keep other content on page, so I can't use redirect solution. — Michelle Lidz
– Michelle Lidz, Commented May 17, 2021 at 18:15
There is no reason why other content should disappear. You are doing st. wrong. — pavel
– pavel, Commented May 17, 2021 at 18:16
other content just match calculating numbers get total by javascript show on textbox when hit the form submit button, if refresh page, all javascript result are disappear. — Michelle Lidz
– Michelle Lidz, Commented May 17, 2021 at 19:20

LIGHT · Accepted Answer · 2021-05-17 18:17:55Z

1

You are fetching the data before updating it. Just move the fetch below like this:

if(isset($_POST) && count($_POST) > 0)
{   
    if($this->form_validation->run())       
    {   
        $up_data['company_profit'] = $this->input->post('company_profit');
        $this->common->updateRecord('tbl_psb_setting',$up_data,"id=1"); 
    }
}

$data['form_data'] = $form_data = $this->common->getOneRow("tbl_psb_setting","WHERE id=1");

answered May 17, 2021 at 18:17

LIGHT

5,72011 gold badges39 silver badges79 bronze badges

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

Comments

Adnan Siddique · Accepted Answer · 2021-05-17 18:13:58Z

0

Redirect back to the same page for it to get refreshed on submit.

answered May 17, 2021 at 18:13

Adnan Siddique

4428 silver badges11 bronze badges

Collectives™ on Stack Overflow

HTML textbox is not updated after form submitted update database record

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related