How to insert raw data in mysql database in laravel

Question

I am new in laravel development. I use the mysql database, and want to insert the raw data in the database. I add the column with $table->binary(). And how can I insert the data to the column.

Schema::table('users', function($table)
{
    $table->binary('raw');
});

Answer 1

Try this:

Suppose you have the following tables (called 'users')

id|user|fname|lname|email|etc..
-------------------------
1|niroj|niroj|nirojdey@example.com|blah....

DB::table('users')->insert(
    array('user' => 'niroj',
          'fname' => 'niroj',
          'lname' => 'dey',
          'email' => 'niroj dey@example.com')
);

The insert() accepts multiple array (which in turns can be mapped to individual columns in your table).