I want to create a new row using the following SQL instead of eloquent
the code I am trying with :
$create_transections = DB::table('package_plan_fees')
->create([
'paid_amount' => $post_data['total_amount'],
'enroll_able' => $post_data['enrollable'],
'user_id' => $post_data['user_id'],
'package_id' => $post_data['package_id'],
'plan_id' => $post_data['plan_id'],
'status' => $post_data['status']
]);
You need to use insert instead of create.
You can check Insert Statements from Laravel documentation.
Your code needs to be like this:
$create_transections = DB::table('package_plan_fees')
->insert([
'paid_amount' => $post_data['total_amount'],
'enroll_able' => $post_data['enrollable'],
'user_id' => $post_data['user_id'],
'package_id' => $post_data['package_id'],
'plan_id' => $post_data['plan_id'],
'status' => $post_data['status']
]);
But because you said you want to get inserted row's id, you can use insertGetId method which described in Auto-Incrementing IDs section of Laravel Documentation.
$inserted_rows_id = DB::table('package_plan_fees')
->insertGetId([
'paid_amount' => $post_data['total_amount'],
'enroll_able' => $post_data['enrollable'],
'user_id' => $post_data['user_id'],
'package_id' => $post_data['package_id'],
'plan_id' => $post_data['plan_id'],
'status' => $post_data['status']
]);
insertGetId method. Just replace insert on my answer with insertGetId and it will return inserted row's id value. To make it work the package_plan_fees table must have an auto-incrementing id field.id and it shows after that on listing. It is not a problem, happy to solve your problem.There is no create method. You need to use insert. Relevant documentation page is here.
DB::table('package_plan_fees')
->insert([
'paid_amount' => $post_data['total_amount'],
'enroll_able' => $post_data['enrollable'],
'user_id' => $post_data['user_id'],
'package_id' => $post_data['package_id'],
'plan_id' => $post_data['plan_id'],
'status' => $post_data['status']
]);
create_transections = DB::table('package_plan_fees')
->insertGetId([
'paid_amount' => $post_data['total_amount'],
'enroll_able' => $post_data['enrollable'],
'user_id' => $post_data['user_id'],
'package_id' => $post_data['package_id'],
'plan_id' => $post_data['plan_id'],
'status' => $post_data['status']
]);
In order to insert & get inserted id back, you need to use insertGetId() method.
