/**
* 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從小到大排序
