This repository create for learn PHP and Laravel framework in 2 + 5 days.
PHP -> LARAVEL -> MySQL/PostgreSQL (backend developer)
-
PHP + MYSQL = 2 DAYS
-
LARAVEL = 5 DAYS
Goal: Local PHP + MySQL + GUI ready করা।
Tools: Herd, DBngin, MySQL, TablePlus
Steps:
-
Herd install করো (Mac users) বা XAMPP/Laragon (Windows)
-
DBngin দিয়ে MySQL server setup করো
-
TablePlus দিয়ে MySQL connect করো → verify server running
-
Create a test database, e.g.,
company_test -
Write a simple PHP script to connect using PDO
<?php $dsn = "mysql:host=127.0.0.1;dbname=company_test"; $pdo = new PDO($dsn, 'root', ''); echo "Connected!";
-
Test that it prints “Connected!” in browser
Tip: আজকে শুধু setup confirm করো। Syntax অনেক গুরুত্বপূর্ণ নয় এখন, connection কাজ করলেই হবে।
Goal: PHP syntax + database connection বোঝা।
Steps:
-
PHP basics: variables, arrays, echo/print, if/else, loops
-
PDO basics: connect, select, insert
-
Practice small CRUD operations in
company_test- Table:
users(id, name, email) - Insert one user, fetch all users, update & delete
- Table:
-
Test queries in TablePlus → see results
Goal: Mini API understanding
Steps:
-
Create
api.phphandling: GET, POST, PUT, DELETE -
Use JSON input/output:
header('Content-Type: application/json'); echo json_encode(['status' => 'ok']);
-
Test API using Postman
-
Practice: GET all users, POST new user
Tip: Employers love candidates who can make API quickly.
Goal: Laravel install + environment ready
Steps:
-
Install Composer (dependency manager)
-
Install Laravel:
composer create-project laravel/laravel laravel-app
-
Set
.envdatabase:DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=company_test DB_USERNAME=root DB_PASSWORD=
-
Test Laravel server:
php artisan serve
→ Open
http://127.0.0.1:8000
Goal: Laravel workflow বোঝা
Steps:
-
Route create করা:
routes/web.phpRoute::get('/hello', function() { return 'Hello Laravel!'; });
-
Controller তৈরি করা:
php artisan make:controller UserController
-
Controller থেকে simple function call করে response দেখাও
Goal: Laravel database operations
Steps:
-
Create migration & model:
php artisan make:model User -m
-
Migration modify করে table columns define করো
-
Run migration:
php artisan migrate -
Eloquent practice: insert, fetch, update, delete
$user = User::create(['name'=>'Mojnu','email'=>'mojnu@example.com']); $users = User::all();
Goal: Ready for job + portfolio-ready
Steps:
-
Mini CRUD API in Laravel (users)
- GET
/api/users→ fetch all - POST
/api/users→ create - PUT
/api/users/{id}→ update - DELETE
/api/users/{id}→ delete
- GET
-
Test everything in Postman
-
Prepare a small demo video/screenshots for employer
-
Review Day 1–6, make sure all commands, syntax, Laravel basics ready
💡 Extra Tips:
- Focus PDO → Laravel Eloquent (query logic same, syntax different)
- Laravel workflow: Routes → Controller → Model → Migration → Views
- Always test on Postman or browser