/** * Run the database seeds. * * @return void */ public function run() { // \App\Models\Data::truncate(); //清掉資料 $faker = \Faker\Factory::create('zh_TW'); foreach (range(1, 10) as $number) { //建立隨機變數數值 $datas = new Data(); $id = rand(1, 10); $datas->user_name = \APP\Models\Myuser::find($id)->users_name; // $data->user_name = $faker->name; // $data->data; $datas->description = $faker->text; $datas->save(); } }
// 也可使用:DB::select('select * from users'); return $users; }]); // function(){ // $email = $_POST['usernames']; // $password = $_POST['pwd']; //// $sql = "INSERT INTO users (username,password) VALUES ('$username','$password')"; // $sql = DB::insert('insert into users (email, password) values (?, ?)'),[$email, $password]; // return '登入成功'; //}); Route::get('dataInputMulti/{data} - {data2}', ["as" => "dataInputMulti", function ($data, $data2) { return "你輸入的是:{$data} , {$data2}"; }]); Route::get('API/user_id={users_id}', ["as" => "API/user_id=", function ($users_id) { //"as" => "API"設定暱稱 function設定變數 return \App\Models\Myuser::find($users_id); //找uses_id顯示出資訊 // return \App\Models\User::all()->where('email','like','%');//找出指定位置顯示出來 // return \App\Models\User::all();//顯示全部資料 }]); Route::get('API/all', ["as" => "API/all", function () { //"as" => "API"設定暱稱 function設定變數 return \App\Models\Myuser::all(); //找出指定位置顯示出來 }]); Route::get('API/email', ["as" => "API/email", function () { //"as" => "API"設定暱稱 function設定變數 // return \App\Models\User::where('email','like','%yahoo%')->get(); // return \App\Models\User::where('email','like','%yahoo%')->get()->toJson();//找出指定email關鍵字,將位置用json顯示出來 return \App\Models\Myuser::where('email', 'like', '%gmail%')->orderBy('email', 'asc')->get(); //desc從大到小排序 //asc從小到大排序