How to perform inline editing in Codeigniter PHP using AJAX?

Question

I saw an example in native PHP which allows inline editing or records and also updates them. PHP Inline Editing Now as per this code i have a ajax function which calls the update file whenever the content is updated below is the script :

    <script src="http://code.jquery.com/jquery-1.10.2.js"></script>
    <script>
    function showEdit(editableObj) {
        $(editableObj).css("background","#FFF");
    } 

    function saveToDatabase(editableObj,column,id) {
        $(editableObj).css("background","#FFF url(<?php echo site_url('img/loaderIcon.gif');?>loaderIcon.gif) no-repeat right");
        $.ajax({
            url: "<?php echo(site_url('Inlinedit/updateDb'));?>",
            type: "POST",
            data:'column='+column+'&editval='+editableObj.innerHTML+'&id='+id,
            success: function(data){
                $(editableObj).css("background","#FDFDFD");
            }        
       });
    }
    </script>

THe Model :

public function inline( $column, $editval, $id )
        {
            $result = mysql_query("UPDATE users set $column = $editval WHERE  id=$id");
        }

the Controller:

<?php

class Inlinedit extends Admin_Controller {

 public function __construct()
 {
    parent::__construct(); 
 }


      public function updateDb()
      {
             $column = $this->input->post('column');
             $editval = $this->input->post('editval');
             $id = $this->input->post('id');

             $this->load->model('user_m');                     
             $this->user_m->inline( $column, $editval, $id );

             return;
      }

}

Abdulla Nilam · Accepted Answer · 2015-09-08 07:26:39Z

2

First of all you should understand you cant call model function bypassing controller. for that what you have to do is

Create a new method in controller.(One time use)
Inside that method just use method calling your model.

ex
In controller

public function just_a_method()
{
    $this->Model_name->inline();/just call method
}

and in view

$.ajax({
    url: "<?php echo base_url()?>controller/just_a_method",

answered Sep 8, 2015 at 7:26

Abdulla Nilam

39.6k18 gold badges85 silver badges114 bronze badges

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

8 Comments

Rajan Over a year ago

So for ajax i must write <?php echo base_url('inlinedit/updateDb');?>

Abdulla Nilam Over a year ago

so your controller name is inlinedit and create new function for ajax call

Rajan Over a year ago

new function for ajax call ? i have a function in my header file function saveToDatabase as shown in question code

Abdulla Nilam Over a year ago

if you have exist one you can use it.but follow my way

Rajan Over a year ago

Thanks Man For Your Efforts and Time :)

|

mayank · Accepted Answer · 2015-09-08 07:20:18Z

1

You cannot update the models directly. Create a controller for updating code.

<?php
   class InlineEditController extends BaseController
   {
          public function updateDb()
          {
                 $column = $this->input->post('column');
                 $editval = $this->input->post('editval');
                 $id = $this->input->post('id');

                 $this->load->model('user_m');                     
                 $this->user_m->inline( $column, $editval, $id );

                 return;
          }
   }

and in the ajax use <?php echo(site_url('InlineEdit/updateDb'));?>

Model must be

public function inline( $column, $editval, $id )
{
    $result = mysql_query("UPDATE users set $column = $editval WHERE  id=$id");
}

edited Sep 8, 2015 at 7:20

answered Sep 8, 2015 at 6:50

mayank

5434 silver badges15 bronze badges

6 Comments

Rajan Over a year ago

Hey your code is logical but some how my ajax code is not working i mean the data is not getting updated i am updating the question code please check

mayank Over a year ago

did you checked if database is returning any error? I think there may not be an issue related to code now.

Rajan Over a year ago

should i be placing the ajax function in header file? or maybe the ajax is not being loaded :(

mayank Over a year ago

better you should add to in $(document).ready(function(){ *your functions* });

Rajan Over a year ago

Let us continue this discussion in chat.

|

Collectives™ on Stack Overflow

How to perform inline editing in Codeigniter PHP using AJAX?

2 Answers 2

8 Comments

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

8 Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related