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 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",




Read More

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 dropdown box. It populate with data. I need to send selected drop-down value to controller then to model. without refreshing view

my View. : <?php echo base_url(); ?>admin/order/new_order

<form method="post" id="sform" action="">

    <select class="form-control pull-right" name="select_design" style="width: 150px;" required id="select_design" onchange="select_design()">
        <option value="">Select Design..</option>  <?php  foreach ($product2 as $v_product) : ?>
        <option value="<?php echo $v_product->product_code ?>"><?php echo $v_product->product_code ?></option> 

<?php
    endforeach;
?> 
        </select>
    </form>

and i have tried to send selected value using ajax.

<script>

 $("#select_design").change(function() {
     $.ajax({
            url : "<?php echo base_url(); ?>admin/order/new_order", // my controller :<?php echo base_url(); ?>admin/order/new_order
            method: "POST",
            data: "id=" + $(this).val(),
            success: function(response) {
                // handle
            }
      })  
});
</script>

and i tried to access POST value in controller

controller : <?php echo base_url(); ?>admin/order/new_order()

public function new_order()
{
    $select_design=$this->input->post('id'); //

    // and send it to model

    $data['product'] = $this->order_model->get_all_product_info($select_design);
 }

I cant access selected value in controller, please advice. thank you

Answer:

I think You just need to change your Ajax script to something like below code.

  $("#select_design").change(function() {
  var product_code = $("#select_design").val();
  $.ajax({
        type: "POST",
        url: "<?php echo base_url(); ?>" + "admin/order/neworder",
        dataType:'text',
        data:{product_code:product_code},
        success: function() {
        //handle
        }
      });//ajax
 });







AJAX Should be

<script>
    $(function(){
        $("#select_design").change(function()
        {
            var product_code = $("#select_design").val();

            $.ajax(
                {
                    type:"post",
                    url: "<?php echo base_url(); ?>admin/order/new_order",
                    data:{ product_code:product_code},

                    success:function(data)
                    {

                    }
                });
        });
    });
</script>

your url conatin admin/order/new_order
so it measn order contoller is inside admin folder

and in contoller should be

public function new_order()
{
    $select_design=$this->input->post('product_code'); // not id

    $data['product'] = $this->order_model->get_all_product_info($select_design);
 }




Read More

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/index.php/site/about_us

I want it like this

http://oti.nhmp.net/about_us

i have tried URL routing in routes file but it's not working for me here is the code

routes.php

$route['default_controller'] = 'site';
$route['about_us'] = "index.php/site/about_us";
$route['404_override'] = '';
$route['translate_uri_dashes'] = FALSE;

.htaccess

<IfModule mod_rewrite.c>

    RewriteEngine On
    RewriteBase /

    #Removes access to the system folder by users.
    #Additionally this will allow you to create a System.php controller,
    #previously this would not have been possible.
    #'system' can be replaced if you have renamed your system folder.
    RewriteCond %{REQUEST_URI} ^system.*
    RewriteRule ^(.*)$ /index.php?/$1 [L]

    #When your application folder isn't in the system folder
    #This snippet prevents user access to the application folder
    #Submitted by: Fabdrol
    #Rename 'application' to your applications folder name.
    RewriteCond %{REQUEST_URI} ^application.*
    RewriteRule ^(.*)$ /index.php?/$1 [L]

    #Checks to 
    RewriteCond %{REQUEST_FILENAME} !-f
    RewriteCond %{REQUEST_FILENAME} !-d
    RewriteRule ^(.*)$ index.php?/$1 [L]    

</IfModule>

<IfModule !mod_rewrite.c>
    # If we don't have mod_rewrite installed, all 404's
    # can be sent to index.php, and everything works as normal.
    # Submitted by: ElliotHaughin

ErrorDocument 404 /index.php

</IfModule>




Answer:

You have to read user guide carefully.

Add .htaccess

RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ index.php?/$1 [L]

Remove index.php from application/config.php

$config['index_page'] = '';//line 32

And last but not least. You have to decide how is your application gonna work. If you want to route any request with one string to one controller for example: Page.php, you have to add such line in application/routes.php

$route["(:any)"] = "page";

Or you can make controller About_us.php .

Read More