Edit multiple values in ajax

Question

I am trying to edit two columns using ajax and php.My code currently edits one values(name) in my table and saves it to my database.When i add the second variable (p) my ajax call it updates both columns p and y with the same value.How do i edit the third value and assign it a different value from y.I want the two different columns to have different values in my db(columns:name and capacity)

This code edits and updates two values:

 <script type="text/javascript">
jQuery(document).ready(function() {  
        $.fn.editable.defaults.mode = 'popup';
        $('.xedit').editable();     
        $(document).on('click','.editable-submit',function(){
            var x = $(this).closest('td').children('span').attr('id');
            var y = $('.input-sm').val();
            var z = $(this).closest('td').children('span');
            $.ajax({
                url: "process.php?id="+x+"&data="+y,
                type: 'GET',
                success: function(s){
                    if(s == 'status'){
                    $(z).html(y);}
                    if(s == 'error') {
                    alert('Error Processing your Request!');}
                },
                error: function(e){
                    alert('Error Processing your Request!!');
                }
            });
        });
});
</script>

And this is what i tried to edit three values:

     <script type="text/javascript">
jQuery(document).ready(function() {  
        $.fn.editable.defaults.mode = 'popup';
        $('.xedit').editable();     
        $(document).on('click','.editable-submit',function(){
            var x = $(this).closest('td').children('span').attr('id');
            var y = $('.input-sm').val();
            var p = $('.input-sm').val();
            var z = $(this).closest('td').children('span');
            $.ajax({
                url: "process.php?id="+x+"&data="+y+"&capacity="+y,
                type: 'GET',
                success: function(s){
                    if(s == 'status'){
                    $(z).html(y);
                    $(z).html(p);}
                    if(s == 'error') {
                    alert('Error Processing your Request!');}
                },
                error: function(e){
                    alert('Error Processing your Request!!');
                }
            });
        });
});
</script>

And heres my php file(process.php)

    <?php
include("connect.php");
if
    ($_GET['id'],$_GET['capacity'] and $_GET['data'])
{
    $id = $_GET['id'];
    $data = $_GET['data'];
    $capacity = $_GET['capacity'];
    if(mysqli_query($con,"update mytable set name='$data',capacity='$data' where id='$id'")){

        echo "success";
    }

else{
echo 'failed';
}

}
?>

And my table in index.php

 <tbody>
                    <?php
                    $query = mysqli_query($con,"select * from mytable");
                    $i=0;
                    while($fetch = mysqli_fetch_array($query))
                    {
                        if($i%2==0) $class = 'even'; else $class = 'odd';

                        echo'<tr class="'.$class.'">

                            <td><span class= "xedit external-event bg-brown" id="'.$fetch['id'].'">'.$fetch['name'].'</span></td>

                            <td><span class= "xedit external-event bg-brown" id="'.$fetch['id'].'">'.$fetch['capacity'].'</span></td>

                        </tr>';                         
                    }
                    ?>
                    </tbody>

Answer 1

1) your just typo error : capacity=$data look this line and change it to capacity=$capacity :

if(mysqli_query($con,"update mytable set name='$data',capacity='$capacity' where id='$id'"))

2) And take look in If condition too .finally your code should be like this .

        <?php

        include("connect.php");
        if($_GET['id'] && $_GET['capacity'] && $_GET['data'])
        {
            $id = $_GET['id'];
            $data = $_GET['data'];
            $capacity = $_GET['capacity'];
            if(mysqli_query($con,"update mytable set name='$data',capacity='$capacity' where id='$id'"))
            {

                echo "success";
            }
            else
            {
                echo 'failed';
            }

        }

        ?>

Answer 2

You have error in your sql query. As you not passing correct parameters. Please see below code.

$id = $_GET['id'];
$data = $_GET['data'];
$capacity = $_GET['capacity'];

// Check Sql
$query = "update mytable set name='$data',capacity='$capacity' where id='$id'";
if(mysqli_query($con,$query)){

  echo "success";
} else{
    echo 'failed';
}