Updating value on page from database using ajax

Question

I am updating the database whenever a user clicks the like button. The update is successfully done but the problem is in updating the new fetched value from the database.

Control Function on which ajax is posting data :

public function plusrepo()
{
    if($this->input->is_ajax_request())
    {
        $this->load->model('themodel');
        $rep['updated'] = $this->themodel->addrepo($this->input->post('resid'));
        echo $rep['updated'][0]." <span>Reputation</span>";
    }
}

This is how i am selecting from table and returning the result array.

$this->db->select('repo');
$this->db->from('restaurants');
$this->db->where('id', $id);
$result = $this->db->get();
return $result->result_array();

My Ajax function on success does this :

success: function(){
         alert("Success");
         $(this).addClass('.up_arrow').removeClass('.up_arrowed');
         $('.rep_count').html(data);
         }

What is wrong? I'm confused.

Edited This is the complete function for ajax

$('.up_arrow').each(function() {
    $(this).click(function(event) {
        event.preventDefault();
        var resid = $(this).attr('name');

        var post_data = {
            'resid' : resid,
            '<?php echo $this->security->get_csrf_token_name(); ?>' : '<?php echo $this->security->get_csrf_hash(); ?>'
        };

        if(resid){
            $.ajax({
                type: 'POST',
                url: "/ci_theyaw/restaurants/plusrepo",
                data: post_data,
                success: function(data){
                    console.log(data);
                    // alert(data);
                    // $(this).addClass('.up_arrow').removeClass('.up_arrowed');
                    // $('.rep_count').html(data);
                },
                error: function (xhr, ajaxOptions, thrownError) {
                    alert(xhr.status);
                    console.log(xhr.responseText);
                    alert(thrownError);
                }
            });
        }
    });
});

Is your current problem coming from your server side or your front end? Does the .success handler gets called (ie your alert() gets called)? Or does your controller echo the right data? It is best to isolate the problem. — JofryHS
– JofryHS, Commented Sep 18, 2013 at 11:58
No the alert is not getting called. The problem is i think on the server side. — Dangling Cruze
– Dangling Cruze, Commented Sep 18, 2013 at 12:02
If you are using Chrome you can open your console (F12 on Windows), go to Network tab, and see the request/response. Click on your response which will show up as soon as you click the button that initiates AJAX call, and check the 'Preview' — JofryHS
– JofryHS, Commented Sep 18, 2013 at 12:06
I did that and i'm getting an error right there POST http://localhost/ci_theyaw/restaurants/plusrepo jquery.js:8526 send jquery.js:8526 jQuery.extend.ajax jquery.js:7978 (anonymous function) restaurants:456 jQuery.event.dispatch jquery.js:3074 elemData.handle — Dangling Cruze
– Dangling Cruze, Commented Sep 18, 2013 at 12:07

Roy M J · Accepted Answer · 2013-09-18 12:46:49Z

1

You need to pass data to success function like this :

success: function(data){

So full ajax success callback function would be :

success: function(data){
     alert("Success");
     $(this).addClass('.up_arrow').removeClass('.up_arrowed');
     $('.rep_count').html(data);
}

Also :

$this->db->select('repo');
$this->db->from('restaurants');
$this->db->where('id', $id);
$this->db->limit(1);
$result = $this->db->get();
print_r($result);//For testing
//echo $result['repo']; // For working code

edited Sep 18, 2013 at 12:46

answered Sep 18, 2013 at 11:47

Roy M J

6,9367 gold badges54 silver badges79 bronze badges

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

5 Comments

Dangling Cruze Over a year ago

did this still no luck?

Roy M J Over a year ago

what do you get while alert(data); ?

Dangling Cruze Over a year ago

The error part of my ajax function is returning the alert(xhr.status) or alert(thrownError) as 0.

Roy M J Over a year ago

@Cruze : Try altering the php section as i did and also alerting the data obtained. Also try alerting resid

Dangling Cruze Over a year ago

The problem is that success function is not getting executed and every time the xhr.status returns 0 which is in the error function. I think the server is not able to generate the response which it should.

Anshad Vattapoyil · Accepted Answer · 2013-09-18 11:55:24Z

1

Change,

$this->db->select('repo');
$this->db->from('restaurants');
$this->db->where('id', $id);
$result = $this->db->get();
return $result->result_array();

To,

$this->db->select('repo');
$this->db->from('restaurants');
$this->db->where('id', $id);
$result = $this->db->get();
$row=$result->result_array();
return $row['repo'];

And,

     success: function(){
       alert("Success");
       $(this).addClass('.up_arrow').removeClass('.up_arrowed');
       $('.rep_count').html(data);
     }

To,

     success: function(data){
       alert("Success");
       $(this).addClass('.up_arrow').removeClass('.up_arrowed');
       $('.rep_count').html(data);
     }

Here you forgot to pass data to success function.

edited Sep 18, 2013 at 11:55

answered Sep 18, 2013 at 11:44

Anshad Vattapoyil

23.5k19 gold badges90 silver badges134 bronze badges

7 Comments

Dangling Cruze Over a year ago

I think this will return what i need but still no luck with the updating on page.

Dangling Cruze Over a year ago

Yes noticed that but still the error part of my ajax is returning 0 as xhr.status / thrownerror

Anshad Vattapoyil Over a year ago

Try to log your data to console using console.log(data) from success function. What is the output?

Dangling Cruze Over a year ago

error: function (xhr, ajaxOptions, thrownError) {                         alert(xhr.status);                         console.log(xhr.responseText);                         alert(thrownError);                     }

Dangling Cruze Over a year ago

This handles the error.. so i'm just getting 0 as an alert. Success part isnt executing.

|

Nil'z · Accepted Answer · 2013-09-18 12:34:36Z

1

Try:

$this->db->select('repo');
$this->db->from('restaurants');
$this->db->where('id', $id);
$result = $this->db->get()->row_array();
return $result['repo'];

echo $rep['updated']." <span>Reputation</span>";

Change :

url: "<?=base_url('restaurants/plusrepo')?>",

edited Sep 18, 2013 at 12:34

answered Sep 18, 2013 at 11:47

Nil'z

7,4831 gold badge20 silver badges28 bronze badges

1 Comment

Nil'z Over a year ago

Edited the above answer try once changing it

Collectives™ on Stack Overflow

Updating value on page from database using ajax

3 Answers 3

5 Comments

7 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

5 Comments

7 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related