php artisan make:model ModelName -mc (this will make the model called ModelName and the migration and the controller all at once.
{{isset($org_id) ? route('gauges.show', $org_id) : route('gauges.index')}}
--------------------Migrating specific tables-------------------

After creating a test folder in migrations folder. Place migration scripts into the test folder and run below command in your terminal/cmd like:
php artisan migrate:refresh --path=/database/migrations/migrations_to_not_refresh_each_time/2014_10_12_100000_create_password_resets_table.php
php artisan migrate:refresh --path=/database/migrations/2020_09_28_224702_create_addresses_table.php
php artisan migrate:refresh --path=/database/migrations/2020_09_28_224628_create_buildings_table.php
php artisan migrate:refresh --path=/database/migrations/2020_09_28_225820_create_current_devices_table.php
php artisan migrate:refresh --path=/database/migrations/2021_02_25_001508_create_departments_table.php
php artisan migrate:refresh --path=/database/migrations/2020_09_28_225834_create_floorplans_table.php
php artisan migrate --path=/database/migrations/2023_04_17_213215_create_y2022_floorplans_table.php
php artisan migrate:refresh --path=/database/migrations/2020_09_28_230002_create_floorplan_machines_table.php
php artisan migrate --path=/database/migrations/2023_04_17_213216_create_y2022_floorplan_machines_table.php
php artisan migrate:refresh --path=/database/migrations/2021_02_07_215602_create_fyer_groups_table.php
php artisan migrate:refresh --path=/database/migrations/2021_02_16_212357_create_machines_table.php
php artisan migrate:refresh --path=/database/migrations/2021_01_20_223011_create_machine_archive_table.php
php artisan migrate:refresh --path=/database/migrations/2020_09_28_230141_create_machine_statuses_table.php
php artisan migrate --path=/database/migrations/2023_04_17_213218_create_y2022_machine_statuses_table.php
php artisan migrate:refresh --path=/database/migrations/2020_09_28_230155_create_machine_types_table.php
php artisan migrate:refresh --path=/database/migrations/2020_09_28_230210_create_meters_table.php
php artisan migrate --path=/database/migrations/2023_04_17_213214_create_y2022_meters_table.php
php artisan migrate:refresh --path=/database/migrations/2020_09_28_223924_create_organizations_table.php
php artisan migrate:refresh --path=/database/migrations/2023_09_30_130233_create_copex_trade_data.php

php artisan migrate:refresh --path=/database/migrations/2023_10_31_130340_create_renumber_temp_table.php

php artisan migrate --path=/database/migrations/2023_10_14_142121_create_annual_report_pages_completed_table.php
php artisan migrate --path=/database/migrations/2023_10_15_213401_create_responsibility_types_table.php
php artisan migrate --path=/database/migrations/2023_10_15_213957_create_spc_users_x_responsibility_types_table.php

/********begin vendor bid tables*********/
php artisan migrate:refresh --path=/database/migrations/2023_11_03_185036_create_vb_phase.php
php artisan migrate:refresh --path=/database/migrations/2023_11_03_184916_create_vb_client_consideration.php
php artisan migrate:refresh --path=/database/migrations/2023_11_03_184944_create_vb_count_fyers.php
php artisan migrate:refresh --path=/database/migrations/2023_11_03_185021_create_vb_email_settings.php
php artisan migrate:refresh --path=/database/migrations/2023_11_03_185003_create_vb_cpc_range.php

php artisan migrate:refresh --path=/database/migrations/2023_11_03_185152_create_vendor_bid_audit.php
php artisan migrate:refresh --path=/database/migrations/2023_11_03_185208_create_vendor_bid_bcp.php
php artisan migrate:refresh --path=/database/migrations/2023_11_03_185225_create_vendor_bid_blkphc.php
php artisan migrate --path=/database/migrations/2023_11_03_185305_create_vendor_bid_building_list.php
php artisan migrate:refresh --path=/database/migrations/2023_11_03_185314_create_vendor_bid_building_list_2.php
/********end vendor bid tables*********/




php artisan migrate --path=/database/migrations/2023_10_12_134258_create_us_states_table.php
php artisan migrate:refresh --path=/database/migrations/2023_08_09_154243_create_report_recipients_table.php
php artisan migrate:refresh --path=/database/migrations/2020_09_28_230256_create_spc_users_table.php
php artisan migrate:refresh --path=/database/migrations/2023_05_04_193617_cost_compare_yearly_totals.php
php artisan migrate:refresh --path=/database/migrations/migrations_to_not_refresh_each_time/2014_10_12_000000_create_users_table.php
php artisan migrate:refresh --path=/database/migrations/2020_09_28_224642_create_phones_table.php
php artisan migrate:refresh --path=/database/migrations/2020_09_28_230312_create_school_years_table.php
php artisan migrate:refresh --path=/database/migrations/2021_02_08_011823_create_tbl_what_ifs_table.php
php artisan migrate:refresh --path=/database/migrations/2021_02_13_222248_create_y2019_floorplan_machines_table.php
php artisan migrate --path=/database/migrations/2021_01_20_195116_y2019_machine_status.php
php artisan migrate:refresh --path=/database/migrations/2022_01_29_172323_create_contacts_table.php
php artisan migrate --path=/database/migrations/2022_01_29_174808_create_email_group_titles_table.php
php artisan migrate --path=/database/migrations/2022_01_29_225230_create_contacts_x_buildings_table.php
php artisan migrate --path=/database/migrations/2020_09_28_230524_alter_tables_after_creation.php
php artisan migrate:refresh --path=/database/migrations/2023_09_08_160236_create_user_positions_table.php

refresh after 2/2/2022
php artisan migrate:refresh --path=/database/migrations/2020_09_28_224628_create_buildings_table.php
php artisan migrate --path=/database/migrations/2023_04_17_213217_create_y2022_buildings_table.php
php artisan migrate:refresh --path=/database/migrations/2020_09_28_224609_create_organization_types_table.php
php artisan migrate:refresh --path=/database/migrations/2020_09_28_224702_create_addresses_table.php
php artisan migrate:refresh --path=/database/migrations/2021_02_25_001508_create_departments_table.php
php artisan migrate:refresh --path=/database/migrations/2022_02_16_191833_create_floorplan_machines_table.php

php artisan migrate --path=/database/migrations/2023_08_09_161416_create_report_params_table.php
php artisan migrate:refresh --path=/database/migrations/2021_02_16_212357_create_machine_specs_table.php
php artisan migrate:refresh --path=/database/migrations/2021_02_07_215602_create_fyer_groups_table.php
php artisan migrate:refresh --path=/database/migrations/2022_02_18_200727_create_fyers_table.php
php artisan migrate --path=/database/migrations/2022_06_20_001000_y2019_model_details.php


php artisan migrate --path=/database/migrations/2022_06_24_111224_create_y2018_buildings_table.php
php artisan migrate --path=/database/migrations/2022_06_24_111225_create_y2018_floorplan_machines_table.php
php artisan migrate --path=/database/migrations/2022_06_24_111226_y2018_model_details.php
php artisan migrate --path=/database/migrations/2022_06_24_111227_create_y2018_floorplans_table.php
php artisan migrate --path=/database/migrations/2022_06_24_111228_create_y2018_meters_table.php
php artisan migrate --path=/database/migrations/2022_06_24_111229_create_y2018_machine_statuses_table.php

php artisan migrate --path=/database/migrations/2022_08_20_111222_create_y2019_departments_table.php
php artisan migrate --path=/database/migrations/2022_08_21_111223_create_y2018_departments_table.php

php artisan migrate --path=/database/migrations/2022_08_24_111224_create_y2019_organizations_table.php
php artisan migrate:refresh --path=/database/migrations/2022_08_24_111225_create_org_year_specific_data_table.php
php artisan migrate --path=/database/migrations/2022_09_30_111230_create_selectable_options_table.php


php artisan migrate --path=/database/migrations/2023_05_07_212023_create_zip_codes_table.php
php artisan migrate --path=/database/migrations/2023_05_07_213401_create_communication_types_table.php
php artisan migrate --path=/database/migrations/2023_05_07_213957_create_contacts_x_communication_types_table.php
php artisan migrate --path=/database/migrations/2023_05_07_224609_create_y2023_model_details_table.php
php artisan migrate --path=/database/migrations/2023_05_07_224554_create_y2023_departments_table.php

users table already exists
php artisan migrate:refresh --path=/database/migrations/2014_10_12_000000_create_users_table.php

index not created
php artisan migrate:refresh --path=/database/migrations/2021_02_19_181445_create_y2019_meters.php



path=/database/migrations/2020_05_31_220916_create_y2018_floorplan_machines_table.php




 
To get a list on the command line of all routes, get, post, etc
 E:\myPrograms\laragon\www\cms
λ php artisan route:list

--------------------Passing values to the route--------------------
The names of variables passed to methods MUST be identical to the variable names in the route:list


--------------------Custom Requests--------------------
php artisan make:request Posts/UpdatePostRequest
php artisan make:request Posts/CreatePostRequest //This will create a request file in a new folder Posts

Go into controller and inject this request into the method(store).
public function store(CreatePostsRequest $request){
}

to see request data
dd($request->image->store('posts'));

--------------------Public Files--------------------
making files like images public so we can show them to users is in Part 3-30 Storing posts of the tutorial
go into cms/.env and add this line
FILESYSTEM_DRIVER=public

This will upload images to the new posts folder in the public one
E:\myPrograms\laragon\www\cms\storage\app\public\posts

php artisan storage:link ,!--this will copy the files up to the www\cms\public\storage\posts folder from the www\cms\storage\app\public\posts folder.
This is necessary to display to public

the src for img element doesn't work with just posts/myImageFileName. I had to add the storage dir to the path. Both examples work.
<img src="storage/{{($post->image)}}" alt="{{$post->title}}" width="80px" height="80px">
<td><img src="{{asset('storage/' . $post->image)}}" alt="{{$post->title}}" width="80px" height="80px"></td>


--------------------Get data from a table--------------------

Post::all(); /*gets all data from the Post model*/

/*Get all records, even those that have been soft-deleted(trashed)*/
$trashed = Post::withTrashed()->get();

/*Two ways to return the posts.index view with the data from the post model*/
		return view('posts.index')->with('posts', $trashed);
		return view('posts.index')->withPosts($trashed);
		
/*using WHERE criteria*/
    where('id', $id) means where id = id. 
    $post = Post::withTrashed()->where('id', $id)->firstOrFail();

/*For inequalities like (where id < $id) use*/
    where('id', '<', $id)
    where('id', '>=', $id)
    where('id', 'LIKE', $id)


/*Select all from Organization model*/
return view('contacts')->with('orgs', Organization::all());

/*Order by*/
return view('contacts')->with('orgs', Organization::orderBy('org_name')->get());

/*Order by with WHERE criteria*/
return view('contacts')->with('orgs', Organization::orderBy('org_name')->get()->where('client_status', 'A'));
--------------------Misc Notes--------------------

to see which version of laravel is installed
php artisan --version
composer update

protected $table = 'school_years';
protected $fillable= ['category_name'];


to rename the id column that laravel expects to our own primary key column:
add this to the model

class Post extends Model
{
	protected $primaryKey = "vehicle_id";
}

BEWARE of comments. php code within the html (signalled by @) is PHP CODE. Comments must be in php syntax, not html.
php artisan tinker - opens a command line that can work directly within the application. User::all(); will return all records in the users table