<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use Illuminate\Http\Response;
use Illuminate\Support\Facades\DB;

class Dataentry extends Controller
{
	 public function index(){
	 	return view('dataentry');
	 }

     public function doInsert(Request $req){
  		 $vSQL = ' Insert Into usermaster ';
		 $vSQL .= '(userid, username, password, userlevel, status)';
		 $vSQL .= ' values (?, ?, ?, ?, ?)';

		 $vUserid = $req->input('txtuserid');
		 $vUsername = $req->input('txtusername');
		 $vPass = $req->input('txtpassword');
		 $vLevel = $req->input('txtuserlevel');
		 $vStatus= $req->input('txtstatus');

	     DB::insert($vSQL, [$vUserid, $vUsername, $vPass, $vLevel, $vStatus] );
   		 $page ='dataentry';
		 return redirect($page);
   }
}