How to convert array to string in laravel?

Question

I am getting input from checkbox values in array using bootstrap form. I am using array for storing checkbox values. How i convert this array to string . Because database only take string values.

Here is my code

<div class="form-group col-md-12">
    <div class="custom-control custom-checkbox custom-control-inline">
        <input type="checkbox" id="eduPrimary" name="education[]" 
        class="custom-control-input" value="primary" />
        <label class="custom-control-label" for="eduPrimary">primary</label>
    </div>
</div>
<div class="form-group col-md-12">
    <div class="custom-control custom-checkbox custom-control-inline">
        <input type="checkbox" id="eduSecondary" name="education[]" 
        class="custom-control-input" value="secondary" />
        <label class="custom-control-label" for="eduSecondary">secondary</label>
    </div>
</div>
<div class="form-group col-md-12">
    <div class="custom-control custom-checkbox custom-control-inline">
        <input type="checkbox" id="eduUniversity" name="education[]" 
        class="custom-control-input" value="university" />
        <label class="custom-control-label"for="eduUniversity">university</label>
    </div>
</div>

In backend i am using laravel to store values to database But it run error that storing array to string in mysql.

public function store(Request $request,AdProfile $adprofile)
{
    $adprofile->education = $request->education[];
    $adprofile->save();
    return redirect()->route('adprofile.profilecomplete');
}

Across any programming language, it is impossible to implicitly convert an array to a string. Use the implode() function to iterate through the instances of the array and assign it to a string as @Tarasovych said. — Max Voisard
– Max Voisard, Commented Apr 24, 2019 at 8:15

Karan Sadana · Accepted Answer · 2019-04-24 08:17:45Z

20

You can use php implode for this or you can also use laravel collection for this. heres the exmaple

collect([1, 2, 3, 4, 5])->implode('-');

// '1-2-3-4-5'

see documentation for this Implode

or you can use php function implode

see this

$arr = array('Hello','World!','Beautiful','Day!');
echo implode(" ",$arr);
//Hello World! Beautiful Day!

answered Apr 24, 2019 at 8:17

Karan Sadana

1,3737 silver badges11 bronze badges

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

Comments

flik · Accepted Answer · 2019-04-24 09:59:51Z

9

 print_r($request->education); //It is an array print

$str_json = json_encode($request->education); //array to json string conversion
echo  $str_json; // printing json string

print_r(json_decode($str_json)); //printing array after convert json string to array

exit; // exiting further execution to check resutls

answered Apr 24, 2019 at 9:59

flik

3,6534 gold badges24 silver badges33 bronze badges

1 Comment

Assad Yaqoob Over a year ago

Its working. Thanks @flik for making this easy for me.

Ali_Hr · Accepted Answer · 2020-06-29 12:06:46Z

8

easy way is using json_encode and json_decode php functions.

if you want to store an array in string column you can use:

$adprofile->education = json_encode($array);

and if you want to get that from DB and convert it back to an array use:

$array = json_decode($adprofile->education);

answered Jun 29, 2020 at 12:06

Ali_Hr

4,7253 gold badges30 silver badges35 bronze badges

Comments

Mihir ajagia · Accepted Answer · 2019-04-24 08:22:26Z

3

In your "AdProfile" model add attribute casting variable so laravel will automatically convert array to json and json to array,

Like this

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class AdProfile extends Model
{
    /**
     * The attributes that should be casted to native types.
     *
     * @var array
     */
    protected $casts = [
        'education' => 'array',
    ];
}

answered Apr 24, 2019 at 8:22

Mihir ajagia

1951 silver badge8 bronze badges

Comments

Md. Robi Ullah · Accepted Answer · 2020-03-24 12:47:59Z

2

You can use implode function.

Manual: https://www.php.net/manual/en/function.implode.php

Now, your code will like:

public function store(Request $request,AdProfile $adprofile)
{
    $adprofile->education = implode(',', $request->education[]);
    $adprofile->save();
    return redirect()->route('adprofile.profilecomplete');
}

answered Mar 24, 2020 at 12:47

Md. Robi Ullah

2,1823 gold badges23 silver badges37 bronze badges

1 Comment

Mahdi Safari Over a year ago

I do exact same of your code it gives me FatalThrowableError Cannot use [] for reading what is the problem

Johnwel Pol · Accepted Answer · 2019-04-24 08:20:52Z

1

try this.

$variable = print_r($someArray,1)

answered Apr 24, 2019 at 8:20

Johnwel Pol

773 bronze badges

Comments

helvete · Accepted Answer · 2022-06-30 09:11:19Z

0

Laravel comes with the Illuminate\Support\Arr facade, full of methods for array manipulation.

One of them is join.

/**
 * Join all items using a string. The final items can use a separate glue string.
 *
 * @param  array  $array
 * @param  string  $glue
 * @param  string  $finalGlue
 * @return string
 */
public static function join($array, $glue, $finalGlue = '')

To me, the correct way to convert an array to string with Laravel would be:

\Arr::join($array, ',');

edited Jun 30, 2022 at 9:11

helvete

2,73915 gold badges38 silver badges42 bronze badges

answered Jun 26, 2022 at 21:26

Gaël Duval

751 silver badge8 bronze badges

Comments

kishan maharana · Accepted Answer · 2020-09-15 08:58:28Z

-3

you can do something like this :-

           <?php
            $arr=array("this","is","an","array");
            
            echo "array elements are"."<br>";
            
            foreach($arr as $value)
             echo $value."<br>";
            
            echo "The string is "."<br>";
            ?>
         @foreach($arr as $value)
         {!! $value !!}
         @endforeach

answered Sep 15, 2020 at 8:58

kishan maharana

2222 silver badges5 bronze badges

Collectives™ on Stack Overflow

How to convert array to string in laravel?

8 Answers 8

Comments

1 Comment

Comments

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

8 Answers 8

Comments

1 Comment

Comments

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related