Creating Database & Reading Records - RESTful API with Laravel - 02

[@SHAJ.T3CH]

awesome, waiting for the next one

[@AtifNaseem]

Thank you

[@kamrankhan-py9ug]

Excellent work atif bhai.....the way you explain things is awesome!! You make difficult concepts quite easy to understand.... You are a God Gifted Teacher.....Great presentation skills....Great Videos.... Allah Bless You

[@AtifNaseem]

Thank you kamran khan. ALLAH bless you.

[@ehabelshimi9473]

the best of video "السلام عليكم" thanks

[@AtifNaseem]

Glad you like it :-)

[@aosky6168]

thanks for your helpful content. I have a question concerning getting list from database, how can I get list with filter for a specific value of a field, for example I want to get list with just the persons which their names = "jamal"?

[@AtifNaseem]

select * from table_name where name = 'jamal'

[@jelbinthomas9559]

can you tell me which link you are copy for the migration???

[@AtifNaseem]

its in the description of the video.

[@imranshabbir3517]

Hi, can you please explain, why you used api/country in URL to access the webpage, as i see that in API routing file you were used (country) only in the get method, so I am confused how api word comes in the URL?

[@AtifNaseem]

Yes, correct To change it we just go to the RouteServiceProvider.php file in the app/Providers folder Then in the mapApiRoutes method function section, we can eliminate the prefix (‘api’) protected function mapApiRoutes() { Route::prefix('api') ->middleware('api') ->namespace($this->namespace) ->group(base_path('routes/api.php')); } So that the function becomes as follows protected function mapApiRoutes() { Route::middleware('api') ->namespace($this->namespace) ->group(base_path('routes/api.php')); }

[@supunmaththanagoda9082]

Did you store all County names in the _z_country table? 🤔 How did you get data without saving data in table?

[@AtifNaseem]

The link of the table is in the description of the video.

[@charlesessien3676]

Illuminate\Contracts\Container\BindingResolutionException Target class [App\Http\Controllers\CountryController] does not exist. i keep getting this error, please what could be wrong?

[@AtifNaseem]

1. Run composer dump-autoload command. composer dump-autoload 2. Run the config command. php artisan config:clear

[@donaldmjbart-williams3144]

Hello Atif. Thanks for a great tutorial. Can you make a single video explaining the migration file?

[@AtifNaseem]

Yes, soon. Thanks Donald MJ

[@JavedKhan-gp1nj]

Illuminate\Contracts\Container\BindingResolutionException Target class [Country\CountryController] does not exist. ye error de raha hai sir

[@AtifNaseem]

Check the controller exists in the folder Country

[@calligraphywithshohely117]

Same error showing to me. Can you solve this issue? Please help me

[@sapsirre]

hello good sir, when i open 127.0.0.1:8000/api/country it says that Illuminate\Database\QueryException could not find driver (SQL: select * from `_z_country`) i already uncomment pdo MySQL in PHP.ini but it doesn't seem to work

[@AtifNaseem]

php.ini? in laravel have you set db in .env file?

[@sapsirre]

@@AtifNaseem yes i have, also if its not maybe the error its different

[@yehiakadah2070]

Iam used xampp when i go to the database i found 3 table only what is the problem ?

[@AtifNaseem]

Please open .sql file in notepad++ and copy everything from there and paste in phpmyadmin (after selecting a database)

[@roshankc6044]

Why we use this code the output is same using protected $fillable = [ 'id', 'iso', 'name', 'dname', 'iso3', 'position', 'numcode', 'phonecode', 'created', 'register_by', 'modified', 'modified_by', 'record_deleted', ]; or Not using This

[@AtifNaseem]

will helpful on saving the data

[@vishwakirtivardhan2691]

Hi buddy, I am still getting same error while migrate the db, which is mention in video, I do all possible hack which you discribe in video. Help me out pls.

[@vishwakirtivardhan2691]

And one more thing,What is relevance of 99 or 199 in defaultstringlength function ?

[@AtifNaseem]

share errors.

[@AtifNaseem]

its default string length, set 99 if its enough

[@obentabiayuk4780]

please how did you know that the that the url will be localhost:8000/api/country ???

[@AtifNaseem]

Once you execute "php artisan serve" you can use this route.

[@bouhadadouasma966]

I get an error when I run php artisan migrate can you help me ? Fatal error: Uncaught Error: Class 'Illuminate\Foundation\Application' not found in C:\xampp64\php\www\Think\bootstrap\app.php:14

[@AtifNaseem]

execute these commands composer dump-autoload composer install --no-scripts composer update

[@kalyanipriyadarsini]

$apitoken = $request->header('APP_KEY'); itis not displaying apitoken value from header in postman api

[@AtifNaseem]

use APPKEY instead

[@mythilim4751]

Awesome .... Thank you sir .

[@AtifNaseem]

Most welcome

[@fauzanramadhan3916]

why i just have 3 table without relationship?

[@AtifNaseem]

Open sql file in notepad++ and check all the queries. I think there are many tables with data.

[@VaVathana-co3nh]

me too

[@AhfazMalik]

Sir meri nai chalrai API ? PLZZ HELP

[@AtifNaseem]

No porblem, share errors.

[@AhfazMalik]

@@AtifNaseem he said , model not found , And i mention my model in controller . Like use\app\models\CountryModel

[@musyafamuhammad5467]

Assalamualaikum, how to read more than 1 table in the database?

[@musyafamuhammad5467]

Should i create more models?

[@AtifNaseem]

Yes one model for one table and then create relationship.

[@AtifNaseem]

You can create select query and get data from various tables.

[@musyafamuhammad5467]

@@AtifNaseem and for controller too?

[@samuelandrian4025]

in my case the url will be 127.0.0.1:8000/country, did i miss any configuration here?, how can the url become 127.0.0.1:8000/api/country ?

[@AtifNaseem]

Make sure you created route in api and not in web, then check url with /api/country

[@samuelandrian4025]

@@AtifNaseem thankyou very much sir

[@MrFranciscoooooo]

2:52, you didn't explain why you did this step..

[@AtifNaseem]

you mean php artisan migrate, actually after resolving the defaultstring error, we created all the tables

[@MrFranciscoooooo]

@@AtifNaseem no.. why that defaultstring? never got that in my migrations.

[@BaoNguyen-de5du]

dear sir, i got only 3 tables how did you got 20 tables ? how to fix it ? Thank

[@AtifNaseem]

In migration file: 2018_09_26_163300_student_register.php you can see that we have alot of tables. Check if any error is preventing it.

[@TanPham-of4bt]

you must change file name 2018_09_26_163300_student_register.php.txt to 2018_09_26_163300_student_register.php

[@CloudTechExpert]

SOOOOOOOOOOOOOOOOOO AMAZING BRO.

[@AtifNaseem]

Thank you so much 😀

[@777Vasya77]

6:27 use protected $guarded = ['id']

[@AtifNaseem]

Thank you so much. You can use after this line protected $table = 'country'; protected $guarded = ['id']; * B U T * Laravel already makes everything guarded by default: protected $guarded = ['*']; As a result, there's no need to specify the id when it's already guarded. When you override that property, you are telling Laravel, "Actually, don't guard everything. Only guard the properties that I specify." So essentially, you are unguarding other properties. Also, if you are manually going to assign properties like this: $model = new CountryModel; $model->id = 1; $model->name = 'Example'; $model->save(); The $guarded / $fillable properties never kick in. They kick in when you use methods like create, update, fill, etc.

[@cattalkhablandogato367]

Use Route::get('country', [CountryController::class, 'country']); to avoid target problem

[@AtifNaseem]

Thanks alot

[@Arnold3976]

it fixed my problem, Thank You

[@calligraphywithshohely117]

Illuminate\Contracts\Container\BindingResolutionException Target class [CountryController] does not exist. i have this problem. please help me

[@calligraphywithshohely117]

Finally solve this issue Alhamdulillah! Thank you!

[@SorrowBee_2]

why i keep getting error

[@kutimanu6082]

Target class country\countrycontroller does not exist Illuminate/contracts/container/bimdingresolutionexception

[@The_Lik_96]

Did you fix that error?

[@AtifNaseem]

Target class error: check your controller.

[@AtifNaseem]

Check controller name or namespace etc.

[@The_Lik_96]

@@AtifNaseem everything checked and fix that! Thx for replying!

[@SorrowBee_2]

Illuminate\Contracts\Container\BindingResolutionException Target class [CountryController] does not exist. i have this problem. please help me

[@AtifNaseem]

here is complete migration file github.com/anajetli/android_login_registration_via_api/tree/master/migrations you may create resource controller for CountryController

[@shoukathali1710]

laravel version ????

[@AtifNaseem]

You can do in any version. This is general.

[@desunnet]

Good work.

[@AtifNaseem]

Thank you

[@arsalanpices]

i got only 3 tables how did you got 20 tables

[@AtifNaseem]

If you open migration file you will see there many tables with data.

[@zhapp3114]

Illuminate \ Database \ QueryException (1049) SQLSTATE[HY000] [1049] Unknown database 'laravel' (SQL: select * from `_z_country`) Previous exceptions SQLSTATE[HY000] [1049] Unknown database 'laravel' (1049) I get this error

[@AtifNaseem]

check .env file and check database settings.

[@gkemoji]

Nice video.plz upload react js video

[@AtifNaseem]

Thanks, will do.

[@hamzashan8349]

Sir 3 more Api banae get, post, put, patch, delete with relationship

[@AtifNaseem]

step by step... :)

[@arunraj362]

Tq bro nice

[@AtifNaseem]

Thanks

[@denizgolbas9691]

Aleykum selam from Turkey

[@AtifNaseem]

My pleasure Deniz Gölbaş

[@mohammadalabd189]

Very good

[@AtifNaseem]

Thank you.

[@okan85100]

perfect :D

[@AtifNaseem]

Thanks okan sari

[@darlansyah8856]

nice

[@AtifNaseem]

Thanks

[@usmanali-ed7xj]

hello sir, i am computer science student of 7th semester i belong to swat pakistan , my project is teacher evaluation websites in php , i search about php but php not give best security , then i decide i do my project in php framework laravel, about 30 lecture of laravel ( become a master) i cover , in your laravel playlist(become a master ) leacture so clear , i like very much , it so easy and mostly understanable , but some lecture have api , which is use read , delete , and edit data between client and server , now i confuse that i do my project only in laravel or i use api also , sir if you give a time to discuss our project , and please mention your gmail id , to discuss our project problem darictley, i shall be very thankful

[@AtifNaseem]

complete your web project using laravel only. use api when you decide to share data with your mobile applicaiton

[@rahmadikaaa]

Waalaikumsalam..

[@AtifNaseem]

Thanks

[@stevemasaki]

Your title should be, importing a database not creating.

[@AtifNaseem]

You may create database, watch series.

[@jorgeleon9212]

si jala

[@AtifNaseem]

si jala ?