Laravel DB插入错误500

Question

Unable to insert into database in a Laravel controller. Below is the controller. I keep getting an error highlight in Dreamweaver at the following line:

$users = DB::table('records')->insert([
    'product' => '[e-mail]',
    'name' => '[e-mail]',
    'email' => '[e-mail]'
]);

I keep getting error 500

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\View;
use Illuminate\Support\Facades\DB;

class create extends Controller
{
    //
    public function createRecord(Request $request){
        json_decode($request->getContent(), true);

        //return $request;
        //$something ='asdf';
        //return $something;

        $users = DB::table('records')->insert([
            'product' => '[e-mail]',
            'name' => '[e-mail]',
            'email' => '[e-mail]'
        ]);
    }
}

Answer 1

I don't really see anything wrong with this. Have you ensured that the data type matches in the database to what you are inserting? It's hard to really gather this when you haven't provided the 500 error you are receiving.

Try the following instead:

1. Create your model. php artisan make:model Record

2. Instantiate a new instance of that model. $record = new \App\Record;

3. Add your data using the Eloquent ORM.

   $record->product = "[e-mail]";
   $record->name = "[e-mail]";
   $record->email = "[e-mail]";
   

4. Finally, save it: $record->save();

So, in full this would look like the following:

 $record = new \App\Record;
 $record->product = "[e-mail]";
 $record->name = "[e-mail]";
 $record->email = "[e-mail]";
 $record->save();

See if that works for you.