DAFTAR REFERENSI LENGKAP DAN SUMBER BELAJAR

MATA KULIAH PEMROGRAMAN WEBSITE 2

Program Studi Informatika - UIN K.H. Abdurrahman Wahid Pekalongan

Daftar referensi ini disusun berdasarkan referensi yang digunakan secara langsung pada setiap pertemuan (P1-P16) mata kuliah Pemrograman Website 2.

1. BUKU TEKS

1.1 PHP and MySQL Web Development (Digunakan: P1)

• Penulis: Luke Welling & Laura Thomson
• Edisi: 5th Edition (2016)
• Penerbit: Addison-Wesley Professional
• ISBN: 978-0321833891

Deskripsi: Buku klasik yang menghubungkan PHP dan MySQL secara komprehensif. Sangat relevan untuk Fase 1 perkuliahan (PHP Native + MySQL). Membahas cara membangun aplikasi web dinamis dari nol.

Chapter Relevan:

• Part I: Using PHP (Basics, variables, arrays, functions)
• Part II: Using MySQL (Database design, SQL, PHP-MySQL integration)
• Part III: E-Commerce & Security (Sessions, authentication, form security)

Link:

• Amazon: https://www.amazon.com/PHP-MySQL-Web-Development-5th/dp/0321833899 (opens in a new tab)

1.2 Laravel: Up & Running (Digunakan: P1, P9)

• Penulis: Matt Stauffer
• Judul Lengkap: Laravel: Up & Running - A Framework for Building Modern PHP Apps
• Edisi: 3rd Edition (2023)
• Penerbit: O'Reilly Media
• ISBN: 978-1098153267

Deskripsi: Buku terbaik untuk mempelajari Laravel secara mendalam. Mencakup seluruh aspek framework Laravel: routing, controllers, Blade, Eloquent ORM, authentication, hingga deployment.

Chapter Relevan:

• Chapter 1: Why Laravel?
• Chapter 3: Routing and Controllers
• Chapter 4: Blade Templating
• Chapter 5: Databases and Eloquent
• Chapter 6: Collecting and Handling User Data (Forms)
• Chapter 9: Authentication and Authorization

Link:

• Amazon: https://www.amazon.com/Laravel-Running-Framework-Building-Modern/dp/109815326X (opens in a new tab)

1.3 Learning PHP, MySQL & JavaScript (Digunakan: P4)

• Penulis: Robin Nixon
• Edisi: 6th Edition (2021)
• Penerbit: O'Reilly Media
• ISBN: 978-1492093824

Deskripsi: Buku all-in-one yang membahas PHP dari dasar termasuk arrays dan functions.

Chapter Relevan:

• Chapters 3-5: PHP Strings, Arrays, Functions
• Chapters 8-10: MySQL and PHP-MySQL integration
• Chapters 11-13: Form handling, sessions, security

Link:

• Amazon: https://www.amazon.com/Learning-PHP-MySQL-JavaScript-Javascript/dp/1492093823 (opens in a new tab)

1.4 PHP & MySQL: Novice to Ninja (Digunakan: P4)

• Penulis: Tom Butler & Kevin Yank
• Edisi: 6th Edition (2017)
• Penerbit: SitePoint
• ISBN: 978-0994346988

Deskripsi: Buku step-by-step membangun aplikasi web dynamic menggunakan PHP dan MySQL dari nol. Pendekatan project-based sangat cocok untuk pembelajaran praktis.

Chapter Relevan:

• Chapter 2-3: PHP Arrays, Functions
• Chapter 4-6: PHP-MySQL Integration

Link:

• Amazon: https://www.amazon.com/PHP-MySQL-Novice-Ninja-Get/dp/0994346980 (opens in a new tab)

1.5 Modern PHP: New Features and Good Practices (Digunakan: P4)

• Penulis: Josh Lockhart
• Edisi: 1st Edition (2015)
• Penerbit: O'Reilly Media
• ISBN: 978-1491905012

Deskripsi: Membahas PHP modern - namespaces, traits, Composer, dan PSR standards. Penting untuk memahami fondasi yang digunakan oleh Laravel dan framework modern.

Chapter Relevan:

• Chapter 3-4: Functions & Closures, Namespaces
• Chapter 7: Composer and Autoloading
• Chapter 8: PSR Standards

Link:

• Amazon: https://www.amazon.com/Modern-PHP-Features-Good-Practices/dp/1491905018 (opens in a new tab)

1.6 Laravel: From Apprentice to Artisan (Digunakan: P9)

• Penulis: Taylor Otwell (pencipta Laravel)
• Penerbit: Leanpub (2013, tersedia gratis online)
• URL: https://leanpub.com/laravel (opens in a new tab)

Deskripsi: Buku klasik dari pencipta Laravel yang membahas clean architecture, IoC container, dan design patterns dalam Laravel.

Chapter Relevan:

• Chapter 1-2: Dependency Injection & IoC Container
• Chapter 3: Interface Contracts
• Chapter 4-5: Repository Pattern, Service Layer

2. DOKUMENTASI RESMI PHP

2.1 PHP Manual

• URL Utama: https://www.php.net/manual/en/ (opens in a new tab)
• Digunakan di: P1, P3, P4, P5, P7, P8

Halaman Spesifik yang Dirujuk:

3. DOKUMENTASI RESMI LARAVEL

3.1 Laravel 12.x Documentation

• URL Utama: https://laravel.com/docs/12.x (opens in a new tab)
• Digunakan di: P9, P10, P11, P12, P13, P14, P15, P16

Halaman Spesifik yang Dirujuk:

4. DOKUMENTASI RESMI MYSQL

4.1 MySQL 8.0 Reference Manual

• URL Utama: https://dev.mysql.com/doc/refman/8.0/en/ (opens in a new tab)
• Digunakan di: P1, P6, P7, P16

5. TUTORIAL DAN REFERENSI ONLINE

5.1 W3Schools - PHP Tutorial (P1, P4, P7)

• URL: https://www.w3schools.com/php/ (opens in a new tab)
• PHP Arrays: https://www.w3schools.com/php/php_arrays.asp (opens in a new tab)
• PHP Functions: https://www.w3schools.com/php/php_functions.asp (opens in a new tab)
• PHP MySQL Intro: https://www.w3schools.com/php/php_mysql_intro.asp (opens in a new tab)

5.2 W3Schools - SQL Tutorial (P6)

• URL: https://www.w3schools.com/sql/ (opens in a new tab)

5.3 MySQL Tutorial (P6)

• URL: https://www.mysqltutorial.org/ (opens in a new tab)
• Panduan lengkap MySQL dengan contoh query yang mudah dipahami

5.4 SQLBolt - Interactive SQL Exercises (P6)

• URL: https://sqlbolt.com/ (opens in a new tab)
• Latihan SQL interaktif — sangat baik untuk berlatih query MySQL secara bertahap

5.5 SQLZoo - SQL Practice (P6)

• URL: https://sqlzoo.net/ (opens in a new tab)

5.6 TutorialRepublic - PHP MySQL CRUD (P7)

• URL: https://www.tutorialrepublic.com/php-tutorial/php-mysql-crud-application.php (opens in a new tab)
• Tutorial langkah demi langkah membuat aplikasi CRUD dengan PHP Native dan MySQL

5.7 WebsiteBeaver - Prepared Statements Guide (P7)

• URL: https://websitebeaver.com/prepared-statements-in-php-mysqli-to-prevent-sql-injection (opens in a new tab)
• Panduan detail prepared statements untuk mencegah SQL Injection

5.8 TutorialsPoint - PHP (P4)

• PHP Arrays: https://www.tutorialspoint.com/php/php_arrays.htm (opens in a new tab)
• PHP Functions: https://www.tutorialspoint.com/php/php_functions.htm (opens in a new tab)

6. KEAMANAN WEB

6.1 OWASP (Open Web Application Security Project) (P7, P14)

• SQL Injection: https://owasp.org/www-community/attacks/SQL_Injection (opens in a new tab)
• Web Security Testing Guide: https://owasp.org/www-project-web-security-testing-guide/ (opens in a new tab)
• URL Utama: https://owasp.org (opens in a new tab)

7. TOOLS DAN SOFTWARE

7.1 XAMPP (P1, P8)

• URL: https://www.apachefriends.org (opens in a new tab)
• Paket server lokal (Apache + PHP + MySQL + phpMyAdmin) untuk Fase 1
• Dokumentasi: https://www.apachefriends.org/docs/ (opens in a new tab)

7.2 phpMyAdmin (P6, P9)

• URL: https://www.phpmyadmin.net/ (opens in a new tab)
• GUI berbasis web untuk manajemen database MySQL

7.3 MySQL Workbench (P6)

• URL: https://www.mysql.com/products/workbench/ (opens in a new tab)
• GUI profesional untuk MySQL: desain skema visual, SQL editor, administration
• Dokumentasi: https://dev.mysql.com/doc/workbench/en/ (opens in a new tab)

7.4 dbdiagram.io (P6, P10)

• URL: https://dbdiagram.io/ (opens in a new tab)

7.5 Draw.io / Diagrams.net (P6)

• URL: https://app.diagrams.net/ (opens in a new tab)

7.6 Laravel Schema Designer (P10)

• URL: https://laravelsd.com/ (opens in a new tab)
• Tool visual untuk merancang schema database Laravel (migration-friendly)

7.7 Regex101 (P13)

• URL: https://regex101.com/ (opens in a new tab)
• Tool online untuk testing dan debugging regular expressions

7.8 Regular-Expressions.info (P13)

• URL: https://www.regular-expressions.info/ (opens in a new tab)
• Referensi lengkap syntax dan penggunaan regular expressions

8. LIBRARY DAN FRAMEWORK FRONTEND

8.1 Bootstrap 5 (P8, P11, P12, P15)

• Dokumentasi: https://getbootstrap.com/docs/5.3/ (opens in a new tab)
• Bootstrap Icons: https://icons.getbootstrap.com/ (opens in a new tab)

8.2 SweetAlert2 (P12, P15)

• URL: https://sweetalert2.github.io/ (opens in a new tab)
• Library JavaScript untuk dialog konfirmasi dan notifikasi
• Digunakan pada form delete dan konfirmasi transaksi peminjaman/pengembalian

8.3 Chart.js (P15)

• URL: https://www.chartjs.org/ (opens in a new tab)
• Library JavaScript untuk grafik di browser (line, pie, bar chart)
• Digunakan pada dashboard admin untuk visualisasi statistik perpustakaan

8.4 Flatpickr (P13)

• URL: https://flatpickr.js.org/ (opens in a new tab)
• Date picker JavaScript yang ringan dan customizable
• Digunakan pada form input tanggal lahir anggota

9. LARAVEL PACKAGES

9.1 Laravel Debugbar (P15)

• GitHub: https://github.com/barryvdh/laravel-debugbar (opens in a new tab)
• Package debugging Laravel — tampilkan query, request info, timing di toolbar browser
• Install: composer require barryvdh/laravel-debugbar --dev

9.2 Laravel IDE Helper (P15)

• GitHub: https://github.com/barryvdh/laravel-ide-helper (opens in a new tab)
• Meningkatkan IDE autocomplete untuk Facades dan Eloquent
• Install: composer require barryvdh/laravel-ide-helper --dev

9.3 Laravel Excel (Maatwebsite) (P15)

• URL: https://laravel-excel.com/ (opens in a new tab)
• Package untuk export file Excel/CSV di Laravel
• Dokumentasi: https://docs.laravel-excel.com/ (opens in a new tab)

9.4 Carbon (P13)

• URL: https://carbon.nesbot.com/docs/ (opens in a new tab)
• Library PHP untuk manipulasi tanggal dan waktu — sudah terintegrasi di Laravel

10. PLATFORM BELAJAR

10.1 Laracasts (P9, P15, P16)

• URL: https://laracasts.com (opens in a new tab)
• Platform video tutorial #1 untuk Laravel dan PHP modern

10.2 Laravel Daily (P1, P9, P15, P16)

• URL: https://laraveldaily.com/ (opens in a new tab)

10.3 Laravel News (P9, P15, P16)

• URL: https://laravel-news.com/ (opens in a new tab)

11. YOUTUBE CHANNELS

12. KOMUNITAS

12.1 Laravel Indonesia Telegram (P16)

• URL: https://t.me/laravelindonesia (opens in a new tab)

12.2 Laravel Facebook Group (P16)

• Nama: Laravel Indonesia

12.3 Laravel Discord

• URL: https://discord.gg/laravel (opens in a new tab)

12.4 Stack Overflow

• URL: https://stackoverflow.com (opens in a new tab)
• Tag relevan: [php], [mysql], [laravel], [eloquent], [mysqli]

13. REFERENSI PER PERTEMUAN (RINGKASAN CEPAT)

End of Reference List

Compiled by: Mohammad Reza Maulana, M.Kom Program Studi Informatika Fakultas Sains dan Teknologi UIN K.H. Abdurrahman Wahid Pekalongan February 2026