store array inside database column - laravel 5

Question

My controller is:

public function store()
{
    $links = array();
    $html = new \Htmldom('http://randomsite.org');

    foreach($html->find('a') as $a) 
    {
        $links[] = $a->href;
    }

}

and i have the database table called result with field:

id
name
url (i want to put the array here)
desc

what I want is multiple records as number links

Serialize it php.net/manual/en/function.serialize.php

Seva Kalashnikov
– Seva Kalashnikov

2016-04-29 21:12:37 +00:00
Commented Apr 29, 2016 at 21:12 — Seva Kalashnikov
– Seva Kalashnikov, Commented Apr 29, 2016 at 21:12

Murlidhar Fichadia · Accepted Answer · 2016-04-29 21:33:32Z

2

If I am right. You need the solution to store data into database.

foreach($links as $link)
{
  $result= new Result;        //here Result is the model name for the table result
  $result->id =  $link[0];  //id
  $event->name = $link[1];  //name
  $event->url =  $link[2];  //url
  $event->desc = $link[3];  //desc
  $event->save();
}

Here you loop through each array of items and insert multiple rows in the table

answered Apr 29, 2016 at 21:33

Murlidhar Fichadia

2,6298 gold badges47 silver badges104 bronze badges

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

1 Comment

user0111001101 Over a year ago

Thank you man, you save me! i do a foreach and $result->url and stop, thank you again!

Collectives™ on Stack Overflow

store array inside database column - laravel 5

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related