AJAX没有将数据传递给CodeIgniter Controller

Question

Greeting StackOverflow! I am trying to pass data to controller using AJAX, but for some reasons it doesn't.

Controller:

public function updateSocial($key){
        if($key != null){
            list($name, $address) = explode("&&", $key);
            $this->db->query("UPDATE social SET address = '" . $address . "' WHERE name = '" . $name . "'");
            echo "Affected rows: " . $this->db->affected_rows();
        }
    }

Ajax:

function updateSocial(name){
                var address = $("#" + name).val();
                var key = name +"&&"+ address;
                //alert(key);
                $.ajax({
                    type: "GET",
                    url: "<?php echo base_url(); ?>controller/updatesocial", 
                    data: key,
                    dataType: "text",  
                    cache:false,
                    success: 
                        function(data){
                            alert(data);  //as a debugging message.
                        }

                });
            }

and HTML:

                <div class="row">
                    <div class="col-lg-10 col-md-10 col-sm-12 col-xs-12">
                        <label for="{name}">{name}</label>
                        <input id="{name}" class="form-control" name="{name}"value="{address}"/>
                    </div>
                    <div class="col-lg-2 col-md-2 col-sm-12 col-xs-12">
                        <div class="clearfix">&nbsp;</div>
                        <input type="submit" class="btn btn-material-green pull-right" onclick="updateSocial('{name}')"/>
                    </div>
                </div>

I've searched for solutions here on StackOverflow, tried everything and couldn't solve it.

If I manually enter values in url as following:

www.domain.com/controller/updatesocial/something&&another_something

it works, so the problem is not PHP-side.

What I'm trying to do: I have multiple input fields that needs to be modified individually, and I want to use AJAX to do so.

I'm sorry if same problem has been posted, but I couldn't find it. I've tried everything I could find and it doesn't work.

Answer 1

function updateSocial(name){
            var address = $("#" + name).val();
            var key = name +"&&"+ address;
            //alert(key);
            $.ajax({
                type: "GET",
                url: "<?php echo base_url(); ?>controller/updatesocial/"+key, 
                dataType: "text",  
                cache:false,
                success: 
                    function(data){
                        alert(data);  //as a debugging message.
                    }

            });
        }

You are sending data using GET method so you have to send it by appending url and your controller will be

public function updateSocial(){
    $key = $this->uri_segment(3);
    if($key != null){
        list($name, $address) = explode("&&", $key);
        $this->db->query("UPDATE social SET address = '" . $address . "' WHERE name = '" . $name . "'");
        echo "Affected rows: " . $this->db->affected_rows();
    }
}