<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use App\Http\Controllers\USerController;
class SUserController extends Controller
{
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
echo "hello world";
//
// $res=DB::table('users')->where('id','=',2)->get();
// dd($res);
}
/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
public function create()
{
//
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
//
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
//
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
//
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
//
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
//
}
public function login(){
return view('login');
}
// public function loginCheck(){
// $data=$request->all();
// $username=$request->input('username');
// $password=$request->input('password');
// //dd($data,$username);
// $res=DB::table('users')
// ->where('username',$username)
// ->where('password',$password)
// ->first();
// dd($res);
// }
}
<?php
namespace App\Http\Controllers;
use Illuminate\Support\Facades\DB;
use Illuminate\Http\Request;
use App\Http\Controllers\Student;
class UserController extends Controller
{
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$res=DB::insert('insert into users (id, name,email,password) values (?,?,?,?)', [1, '毕志慧','123@qq.com','Dayle']);
dd($res);
// $name = "毕志慧";
// $age =20;
// $students=$this->students;
// $students = Student::$students;
// return view('school')->with(compact('name','age','students'));
// dd("hhh");
// $res=DB::select('select * from users');
// $res=DB::table('users')->where('id','=',2)->get();
// dd($res);
}
/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
public function create()
{
dd("creat");
$res=DB::insert('inset into users(name,email,password) values(?,?,?)',['殷素素','yin@qq.com','123']);
dd($res);
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
//
// dd($request->all());
$data = $request->except('_token');
// dd($data);
return view('store',compact('data'));
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
$res=DB::table('users')->where('id',$id)->value('name');
dd($res);
// $res=DB::delete('delete from users where id =?',[$id]);
// dd($res);
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
//
// return view('edit',compact('id'));
$res=DB::select('update ',[$id]);
dd($res);
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
//
$data = $request->all();
dd($data,$id);
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
//
}
public function showSome(){
$names="毕志慧";
return view('admin.login')->with('name',$names)->with('age',20);
}
public function login(){
return view('login');
}
// public function loginCheck(){
// $data=$request->all();
// $username=$request->input('username');
// $password=$request->input('password');
// //dd($data,$username);
// $res=DB::table('users')
// ->where('username',$username)
// ->where('password',$password)
// ->first();
// dd($res);
// }
public function loginCheck(Request $request){
$data = $request->all();
$username = $request->input('username');
$password = $request->input('password');
$res = DB::table('users')
->where('name',$username)
->where('password',$password)
->first();
dd($res);
dd($data,$username, $password);
}
public function regist(){
return view('regist');
}
}
Route::resource('/user',UserController::class);
Route::get('/login',[UserController::class,'login']);
Route::get('/regist',[UserController::class,'regist']);
Route::post('/loginCheck',[UserController::class,'loginCheck']);