Array to String in Laravel Ajax Data

Question

I am sending my data to a controller by Ajax, but on the back-end, I'm getting Array to string conversion.

Controller

<?php

public function updateimages(Request $request){
    $updateDetails=array(
        'image_alt' => $request->get('image_alt')
    );

    $updateIds=array(
        'id' => $request->get('id')
    );

    $images = DB::table('photos')
        ->where([$updateIds])
        ->update([$updateDetails]);

    return response()->json(['updated' => $images], 200);
}

Ajax

<script type="text/javascript">
  $(document).ready(function() {
      $(".SaveImage").on('click', function(e) {
          e.preventDefault();
          e.stopPropagation();

          var idmess= [];
          $(".photohe").each(function(){
            idmess.push($(this).val());
          });

          var image_alt= [];
          $(".image_alt").each(function(){
            image_alt.push($(this).val());
          });

          console.log(idmess);
          console.log(image_alt);
          $.ajax({
              url: '{{ url('admin/savemulti') }}',
              type: 'POST',
              dataType: "JSON",
              data: {
                  "id": idmess,
                  "image_alt": image_alt,
                  "_method": 'POST',
                  "_token": "{{ csrf_token() }}",
              },
              success:function(data) {
                var message = "Image Updated successfully!"
                $('.saved').append(message);
              }
          });
      });
  });
</script>

Here is how my controller dd gets the data:

array:4 [
  "id" => array:2 [
    0 => "1045"
    1 => "1046"
  ]
  "image_alt" => array:2 [
    0 => "mage 1"
    1 => "image 2"
  ]
  "_method" => "POST"
  "_token" => "SParC5rwYy0KLLhwa0km7fcZvodSqrzhvyqZUqk3"
]

It's supposed to update it like:

1045 = mage 1
1046 = image 2

Any idea how to fix it?

Are you getting array to string conversion error ?

Sagar Gautam
– Sagar Gautam

2018-11-28 02:14:27 +00:00
Commented Nov 28, 2018 at 2:14 — Sagar Gautam
– Sagar Gautam, Commented Nov 28, 2018 at 2:14
@SagarGautam yes

mafortis
– mafortis

2018-11-28 02:16:29 +00:00
Commented Nov 28, 2018 at 2:16 — mafortis
– mafortis, Commented Nov 28, 2018 at 2:16

Sagar Gautam · Accepted Answer · 2018-11-28 02:33:27Z

1

You can't do multiple updates with the way you are doing in above code. You are adding of ids and data to be updated separately in two arrays.

You have to change your code something like this.

public function updateimages(Request $request){
    $ids = $request->get('id');
    $updateImages = $request->get('image_alt');

    foreach($ids as $key => $value){
        DB::table('photos')
          ->where('id',$value)
          ->update(['image_alt'=>$updateImages[$key]]);
    }

    return DB::table('photos')->whereIn('id',ids)->get();
}

edited Nov 28, 2018 at 2:33

answered Nov 28, 2018 at 2:25

Sagar Gautam

9,4099 gold badges62 silver badges95 bronze badges

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

4 Comments

mafortis Over a year ago

i'm getting this now SQLSTATE[42S22]: Column not found: 1054 Unknown column '0' in 'field list' (SQL: update photos` set 0 = mage 1 where id = 1045)`

mafortis Over a year ago

I think it's getting 0 from array 0 => 1045 my console return this as front-end results (2) […] 0: "1045" 1: "1046" (2) […] 0: "mage 1" 1: "image 2"

Sagar Gautam Over a year ago

@mafortis With $key=>$value it should work I think, let me see

Sagar Gautam Over a year ago

@mafortis My bad, while updating we have to give column name and value, i'd missed that. Now try the updated one.

Collectives™ on Stack Overflow

Array to String in Laravel Ajax Data

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related