2
votes

I'm facing a rather strange problem with this..

I'm working on a Yellowpages website using Code Igniter and MySQL. Everything works fine on my local machine, but I face a problem when uploaded to my server.

The only problem being:

When I make change some changes and press the update button, the changes are immediately shown in the view (Have also checked that it gets updates in the Database). However, if I press the 'Edit' button again within say 5-10 seconds the changes are undone.

The most interesting fact being, even if I press update with the old changes...come and check in a few hours. I see the new values again.

I really don't know whats wrong.

Here are my codes :

Controller


    function customerList()
    {
        $data = array();
        $data = $this->footer_images();

        $this->load->library('pagination');

        if($this->session->userdata('user_role') == "Admin" || $this->session->userdata('user_role') == "Employee")
        {
            if($this->session->userdata('user_role') == "Admin")
                $cond = array('enabled' => 1,'approve' => 1);
            else if($this->session->userdata('user_role') == "Employee")
                $cond = array('enabled' => 1,'approve' => 1,'branch' => $this->session->userdata('branch'));

            $config = array();

            $config["base_url"] = base_url() . "home/customerList";
            $config["total_rows"] = $this->companies->count_entry($cond,"companies");
            $config["per_page"] = 10;
            $config["uri_segment"] = 3;
            $config["num_links"] = 3;
            $config["full_tag_open"] = '';
            $config["full_tag_close"] = '';
            $config["cond"]=$cond;

            $this->pagination->initialize($config);

            $off=$this->uri->segment(3);

            if($off=="" && !isset($_POST['off']))
                $off=0;
            else if(isset($_POST['off']))
                $off=$this->input->post("off");
            else
                $off=$this->uri->segment(3);

            $data["customers"] = $this->companies->get_data_with_cond_page($config["per_page"], $off, $config["cond"]); 


            $content_data['content'] = $this->load->view("customerList",$data,TRUE);

            if($this->session->userdata('user_role') == "Admin")
                $this->load->view('masterTemplate/adminTemplate',$content_data);                
            else if($this->session->userdata('user_role') == "Employee")
                $this->load->view('masterTemplate/employeeTemplate',$content_data);
        }
        else
        {
            $data['signup_error'] = "OK";
            $content_data['content'] = $this->load->view("home",$data,TRUE);
            $this->load->view("masterTemplate/template",$content_data);
        }
    }


    function editCompany()
    {

        $data = array();
        $data = $this->footer_images();

        $slno = $this->uri->segment(3);

        $cond = array('slno' => $slno);
        $data['results'] = $this->companies->get_data_with_cond($cond);
        $data['category'] = $this->category->get_all_data();
        //// $data['subcategory'] = $this->subcategories->get_all_data();

        /*  $data['makeColumns'] = $this->makeColumns1();
        $data['getTotalData'] = $this->getTotalData("category","");
        $data['perPage'] = $this->perPage(); */
        $data['category'] = $this->category->get_all_data();

        if($this->session->userdata('user_role') == "Admin")
        {
            $this->load->view('template/Admin/header');
            $this->load->view("edit_company",$data);
            $this->load->view('template/Admin/footer',$data);
        }

    }

    function updateCompany()
    {
        $this->form_validation->set_rules('company_name', 'Company Name', 'required');
        $this->form_validation->set_rules('category', 'Category', 'required');

        if ($this->form_validation->run() == FALSE)
        {
            $sl = $this->input->post('slno');
            redirect("home/editCompany/$sl?stat=err");          
        }
        else
        {
                $data = array(
                                'company_name' => $this->input->post('company_name'),
                                'contact_person' => $this->input->post('contact_person'),
                                'address' => $this->input->post('address'),
                                'city' => $this->input->post('city'),
                                'state' => $this->input->post('state'),
                                'landmarks' => $this->input->post('landmarks'),
                                'pincode' => $this->input->post('pincode'),
                                'std_code' => $this->input->post('std_code'),
                                'mobile' => $this->input->post('mobile'),
                                'phone' => $this->input->post('phone'),
                                'fax' => $this->input->post('fax'),
                                'cmail' => $this->input->post('cemail'),
                                'website' => $this->input->post('website'),
                                'category_name' => $this->input->post('category')
                            );

                $cond = array(
                            'slno' => $this->input->post('slno')
                         );




                        if($this->companies->update_data($cond,$data))
                        {
                            redirect("home/customerList?stat=ok");
                        }
                        else
                        {
                            redirect("home/customerList?stat=nok");
                        }

        }
    }

Model


    function update_data($cond,$data)
    {
        $this->db->where($cond)->update('companies',$data);
        return true;
    }

An early help will be truly appreciated. Thanks! :)

2
show us your view (form) html...bipen
looks like server side issue... Clear with server configuration...Learner

2 Answers

1
votes

It seems I had a problem with the Page Cache. Once I used the no-cache formula...it worked. Now, Running good too.

0
votes

Try to press control+f5 to refresh cache after an update