Route::namespace('Api')->prefix('v1')->group(function () {
Route::get('/query','UserController@query')->name('users.query');
});
use Illuminate\Support\Facades\DB;
class UserController extends Controller
{
//
public function index(){
return 'duanshuilu.com';
}
public function query()
{
$student=DB::select("select * from book ");
//var_dump($student);
//dd()是laravel提供的方法,可以将一个数组以节点树的形式展示出来。
//dd($student);
$json = json_encode(array(
"result"=>200,
"message"=>"登录成功!",
"data"=>$student
),JSON_UNESCAPED_UNICODE);
echo($json);
}
public function add()
{
$bool=DB::insert("insert into book(book_name,book_mark)
values(?,?)",['一本书','备注']);
var_dump($bool);
}
public function add()
{
$bool=DB::insert("insert into book SET `book_name` = '10'");
var_dump($bool);
}
public function delete($id)
{
$num=DB::delete('delete from book where id= ?',[$id]);
echo $num;
}
Route::get('/delete/{id}', 'UserController@delete')->name('users.delete');
public function update()
{
$bool = DB::update('update book set book_name= ? where id= ? ', ["222", 5]);
echo $bool;
}
public function mypost()
{
$student=DB::select("select * from book");
//var_dump($student);
//dd()是laravel提供的方法,可以将一个数组以节点树的形式展示出来。
//dd($student);
$json = json_encode(array(
"result"=>200,
"message"=>"登录成功!",
"data"=>$student
),JSON_UNESCAPED_UNICODE);
echo($json);
}
Route::post('mypost', 'UserController@mypost')->name('users.mypost');
onShow() {
uni.request({
// url: 'https://duanshuilu.com/wxusertest/',
url: 'http://localhost/api/v1/mypost',
data: {
"myuserinfo": 0
},
method: 'POST',
header: { "Content-Type": "application/x-www-form-urlencoded" },
success: res => {
console.log("收到后端发来的api接口中的数据",res.data);
},
fail: res => {
console.log("请求失败");
}
});
}