<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\Http\Controllers\Student;
use Illuminate\Support\Facades\DB;
class UserController extends Controller
{
public function index(){
//$student=$this->stu;
// $student=Student::$stu;
// return view('hello',compact('student'));
//1
// $users=DB::table('users')->get();
// dd($users);
//2
$users=DB::table('users')->where('id','>',1)->get();
dd($users);
}
public function show($id){
//dd('show:'.$id);
// $data=['id'=>$id,'name'=>'张三'];
// $w=1;
// // return view('info')->with('id',$id)->with('data',$data);
// return view('info')->with(compact('data','id','w'));
// $student=Student::$stu;
// $item=null;
// foreach ($student as $value) {
// // code...
// if($id==$value['xh']){
// $item=$value;
// }
// }
// return view('detail',compact('item'));
//$user=DB::select('select * from users where id='.$id);
// $user=DB::select('select * from users where id=?',[$id]);
//$res=DB::delete('delete from users where id=?',[$id]);
//查询指定的
//1
// $res=DB::table('users')->where('id','=',$id)->first();
// dd($res);
//2
$users=DB::table('users')->find(1);
dd($users);
// $users = DB::table('users')->select('name', 'email as user_email')->get();
// dd($user);
}
//七种方法
public function showSome(){
//dd('showSome');
//return view('admin/login');
$name='老师';
return view('admin.login')->with('name',$name)->with('age',31);
}
public function create(){
// $message="信息正确";
// return view('create',compact('message'));
$res=DB::insert('insert into users(name,email,password) value(?,?,?)',['殷素素','yin@qq.com','123']);
dd($res);
}
public function store(Request $request){
//dd($request->all());
$data=$request->except("_token");
//dd($data);
return view('store',compact('data'));
}
public function edit($id)
{
// return view('edit',compact('id'));
//DB::update('update users set password=?,')
}
public function login(){
return view('login');
}
public function loginCheck(Request $request){
$data=$request->all();
$username=$request->input('username');
$password=$request->input('password');
//dd($data,$username);
$res=DB::table('users')->where('name',$username)->where('password',$password)->first();
//dd($res);
if($res){
echo "登录成功！";
}else{
echo "登录失败！";
}
}
}
?>
