Laravel database insert query

Question

I'm trying to do simple insertion in database and im getting the following error

call_user_func_array() expects parameter 1 to be a valid callback, no array or string given

The insertion code look like this

DB::insert('insert into users (id, name) values (?, ?)', array(1, 'Dayle'));

It's a basic query for laravel, but it won't work why?

Try DB::table('users')->insert(array(1, 'Dayle')); insert uses an array for the values and you need to specify the table to do the insert on. — Matt Burrow
– Matt Burrow, Commented Dec 11, 2014 at 12:57
did ur database connect with the laravel and do u have users table inside that database ? — Kalhan
– Kalhan, Commented Dec 11, 2014 at 12:57
I was experimenting something with codeception the tool for testing. I found the mistake, i was using the wrong database, in video tutorial for codeception they don't use laravel. So problem is wrong database. Thank you for your reply. — Vesko Vujovic
– Vesko Vujovic, Commented Dec 11, 2014 at 13:00
I recommend to read the documentation: laravel.com/docs/4.2/queries#inserts — Pᴇʜ
– Pᴇʜ, Commented Dec 11, 2014 at 13:02

Joe · Accepted Answer · 2016-03-15 11:44:23Z

41

DB::table('users')->insert(
     array(
            'id'     =>   '1', 
            'name'   =>   'Dayle'
     )
);

or

$values = array('id' => 1,'name' => 'Dayle');
DB::table('users')->insert($values);

But why are you inserting an ID? Should this not be an auto incremented value?

edited Mar 15, 2016 at 11:44

answered Dec 11, 2014 at 13:01

Joe

4,7583 gold badges31 silver badges35 bronze badges

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

Comments

Nipun Tharuksha · Accepted Answer · 2022-05-02 05:10:58Z

1

$user['id'] = 1;
$user['name'] = 'dale';

DB::table('users')->insert($user);

edited May 2, 2022 at 5:10

Nipun Tharuksha

2,5654 gold badges19 silver badges44 bronze badges

answered Aug 23, 2021 at 8:04

fahad sulaiman

736 bronze badges

2 Comments

Ghost Over a year ago

While this code may solve the question, including an explanation of how and why this solves the problem would really help to improve the quality of your post, and probably result in more up-votes. Remember that you are answering the question for readers in the future, not just the person asking now. Please edit your answer to add explanations and give an indication of what limitations and assumptions apply.

Ghost Over a year ago

Please take a moment to read through the editing help in the help center. Formatting on Stack Overflow is different than other sites.

Harlan SR · Accepted Answer · 2022-05-26 08:10:42Z

0

You can make simple like this

$val={
    'id_user' => '< ID_USER >',
    'title' => '< TITLE >',
    'body' => '< BODY >',
} 

Forum::create($val);

And its work

edited May 26, 2022 at 8:10

answered May 26, 2022 at 8:09

Harlan SR

11 bronze badge

1 Comment

Community Over a year ago

As it’s currently written, your answer is unclear. Please edit to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

Laravel database insert query

3 Answers 3

Comments

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related