Advertisement
Fendhio

Laravel Raw SQL

Nov 12th, 2021
175
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
HTML 5 0.60 KB | None | 0 0
  1.             $sql = DB::select(DB::raw("
  2.                 select fn_insert_pelamar_data_pribadi_pertanyaan
  3.                 (
  4.                     :v_nik, :v_kd_pert, :v_nm_pert, :v_jawaban, :v_jwb_detail, :v_nm_ins, :v_id
  5.                 )
  6.             "), [
  7.                 "v_nik"         => $request->nik,
  8.                 ":v_kd_pert"    => $request->kode_pertanyaan,
  9.                 ":v_nm_pert"    => $request->nama_pertanyaan,
  10.                 ":v_jawaban"    => $request->jawaban,
  11.                 ":v_jwb_detail" => $request->jawaban_detail,
  12.                 ":v_nm_ins"     => $request->nik
  13.             ]);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement