Retrieve All data from a table<\/p>\n\n\n\n
Create the Controller: php artisan make:Controller Country\\CountryController;
Here is creating the controller in the Country Folder. Then create the route.
Create the route: Go to routes>api.php
Route::get(‘country’, ‘Country\\CountryController@country’);
Model File : CountryModel
We have to create a Model who is communicate with the Database table ‘_z_country’;
So, Creating a Country Model in the Model folder.
php artisan make:Model Model\\CountryModel;
Adding a line to communicate with ‘_z_country’ table:
class CountryModel extends Model {
protected $table = ‘_z_country’;
}<\/p>\n\n\n\n
Before creating the ‘country’ method in the ‘ Country\\CountryController ‘
We have to add the created CountryModel at the top of the Country\\CountryController : use App\\Model\\CountryModel;
Now we will create the ‘country’ method at Country\\CountryController .
public function country(){
return response()->json(CountryModel::get(), 200);
}<\/p>\n\n\n\n
Retrieve Data by ID from a Table:<\/p>\n\n\n\n
Route:
Route::get(‘country\/{id}’, ‘Country\\CountryController@countryById’);
countryById Method at Controller:
public function countryById($id){
return response()->json(CountryModel::find($id), 200);
}<\/p>\n\n\n\n
Insert A Record :
Route::post(‘country’, ‘Country\\CountryController@countrySave);<\/p>\n\n\n\n
CountryModel file : We have to some modification at CountryModel File.
class CountryModel extends Model{
protected $table = ‘_z_country’;
protected $fillable = [ \/\/ all fields of the table
‘iso’,
‘countryname’,
‘dname’,
…
….
….
…..
];
}
We have to add another line in the model just before the protected $fillable
public $timestamps = false;
Country\\CountryController File :
public function saveCountry(Request $request){
$country = CountryModel::create($request->all());
return $response->json($country, 201);
}<\/p>\n\n\n\n
Updating Data:<\/p>\n\n\n\n
Route::put(‘country\/{country}’, ‘ Country\\CountryController@countryUpdate’);
CountryController countryUpdate Method:
public function countryUpdate(Request $request, CountryModel $country){
$country->update($request->all());
return response()->json($country, 200);
}
<\/p>\n","protected":false},"excerpt":{"rendered":"
Retrieve All data from a table Create the Controller: php artisan make:Controller Country\\CountryController; Here is creating the controller in the Country Folder. Then create the route.Create the route: Go to routes>api.php Route::get(‘country’, ‘Country\\CountryController@country’); Model File…<\/p>\n","protected":false},"author":2,"featured_media":244,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[35],"tags":[],"_links":{"self":[{"href":"http:\/\/www.texeltech.com\/index.php?rest_route=\/wp\/v2\/posts\/242"}],"collection":[{"href":"http:\/\/www.texeltech.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.texeltech.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.texeltech.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.texeltech.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=242"}],"version-history":[{"count":4,"href":"http:\/\/www.texeltech.com\/index.php?rest_route=\/wp\/v2\/posts\/242\/revisions"}],"predecessor-version":[{"id":248,"href":"http:\/\/www.texeltech.com\/index.php?rest_route=\/wp\/v2\/posts\/242\/revisions\/248"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.texeltech.com\/index.php?rest_route=\/wp\/v2\/media\/244"}],"wp:attachment":[{"href":"http:\/\/www.texeltech.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=242"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.texeltech.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=242"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.texeltech.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=242"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}