Laravel insert array of arrays with foreign keys

Question

I have two tables, news and news_links. The news table looks like this (id, title, body, date_published) and the news_links look like this (id, news_id, url).

I'm trying to build a query where I can insert a news array:

array( 
  array(
    "id" => "123456",
    "title" => "First Title",
    "body" => "First body text",
    "date_published" => "01-01-16"
  )
  array(
    "id" => "22222",
    "title" => "Second Title",
    "body" => "Second body text",
    "date_published" => "01-01-16"
  )
)

This array will contain multiple array, this is just an example.

Links related to these news will also be inserted.

array(
  array(
    "0" => "1",
    "1" => "123456",
    "2" => "img_url"
  )
  array(
    "0" => "2",
    "1" => "123456",
    "2" => "img_url"
  )
  array(
    "0" => "2",
    "1" => "22222",
    "2" => "img_url"
  )
)

Will I have to build a foreach loop and run multiple queries or is there a way to run a single query and insert everything into both news and news_links?

Andrej · Accepted Answer · 2016-08-29 13:18:03Z

1

No, you can't use one query to insert data in two different tables. However, you can combine several inserts for one table in one query. It will look like

INSERT INTO news_links VALUES(1,123456,'url'),(2,123456,'url'),(2,22222,'url');

answered Aug 29, 2016 at 13:18

Andrej

7,5041 gold badge22 silver badges22 bronze badges

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

3 Comments

Jesper Andersen Over a year ago

So I'll have to do some kind of implode() on my array to build the query I take it?

Andrej Over a year ago

In Laravel you can simply do it like \DB::table('table name')->insert([['id' => 1, 'news_id' => 123456, 'url' => 'url'], [], []]) @JesperAndersen

Jesper Andersen Over a year ago

I'll probalby have to use DB::insert() since I'm using "insert ignore into 'table'", but it's good to know I can use Query Builder like that. Thank you!

sanu · Accepted Answer · 2017-03-19 17:11:58Z

0

I think this is a simple solution NewsLink::insert(array);

answered Mar 19, 2017 at 17:11

sanu

1,0883 gold badges15 silver badges29 bronze badges

Collectives™ on Stack Overflow

Laravel insert array of arrays with foreign keys

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related