Codeigniter Question - Solve your codeigniter question

  • Home
  • Business
    • Internet
    • Market
    • Stock
  • Parent Category
    • Child Category 1
      • Sub Child Category 1
      • Sub Child Category 2
      • Sub Child Category 3
    • Child Category 2
    • Child Category 3
    • Child Category 4
  • Featured
  • Health
    • Childcare
    • Doctors
  • Home
  • Business
    • Internet
    • Market
    • Stock
  • Downloads
    • Dvd
    • Games
    • Software
      • Office
  • Parent Category
    • Child Category 1
      • Sub Child Category 1
      • Sub Child Category 2
      • Sub Child Category 3
    • Child Category 2
    • Child Category 3
    • Child Category 4
  • Featured
  • Health
    • Childcare
    • Doctors
  • Uncategorized

Thứ Ba, 8 tháng 9, 2015

How to perform inline editing in Codeigniter PHP using AJAX?

 Unknown     21:42     No comments   

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;
      }
}

Answer:
First of all you should understand you cant call model function bypassing controller. for that what you have to do is
  1. Create a new method in controller.(One time use)
  2. 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",


  • Share This:  
  •  Facebook
  •  Twitter
  •  Google+
  •  Stumble
  •  Digg
Gửi email bài đăng nàyBlogThis!Chia sẻ lên XChia sẻ lên Facebook
Bài đăng Mới hơn Bài đăng Cũ hơn Trang chủ

0 nhận xét:

Đăng nhận xét

Popular Posts

  • MongoWriteConcernException. the (immutable) field '_id' was found to have been altered to _id
    while making updat in mongodb in codeigniter I have the following error plz help me to solve this issue, Type: MongoWriteConcernException ...
  • How to perform inline editing in Codeigniter PHP using AJAX?
    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 h...
  • How to select data from 4 tables
    I want to select data from 4 tables using the Codeigniter framework. The 4 tables have a similar column structure. I want to get the table...
  • Codeigniter URL Routing Issue
    I'm new to codeigniter and want to set my URLs on website currently I'm using version 3.0.1 URL looks like http : //oti.nhmp.net...
  • Query database in helper file Codeigniter 3
    I was trying to add a function to a helper file to collect extra info from the Db. This got errors as the the document id I am trying to u...
  • codeigniter drop down value send view to controller and display results
    I am working with codeigniter project and I have a problem. I have tried several times but still not have a solution. My view has dropdo...

Recent Posts

Unordered List

Pages

  • Trang chủ

Text Widget

Blog Archive

  • ▼  2015 (7)
    • ▼  tháng 9 (7)
      • How to select data from 4 tables
      • MongoWriteConcernException. the (immutable) field ...
      • Query database in helper file Codeigniter 3
      • MySql select field_1 where X = field_2 for all sup...
      • How to perform inline editing in Codeigniter PHP u...
      • codeigniter drop down value send view to controlle...
      • Codeigniter URL Routing Issue

Giới thiệu về tôi

Unknown
Xem hồ sơ hoàn chỉnh của tôi
Được tạo bởi Blogger.

Sample Text

Copyright © Codeigniter Question - Solve your codeigniter question | Design by PHP Tutorial