C:\laragon\www\crud-lab(main -> origin)
λ :: ========================================
C:\laragon\www\crud-lab(main -> origin)
λ :: CEK VERSI PHP DAN LARAVEL
C:\laragon\www\crud-lab(main -> origin)
λ :: ========================================
C:\laragon\www\crud-lab(main -> origin)
λ php -v
PHP 8.4.5 (cli) (built: Mar 12 2025 12:17:53) (NTS Visual C++ 2022 x64)
Copyright (c) The PHP Group
Zend Engine v4.4.5, Copyright (c) Zend Technologies
with the ionCube PHP Loader v15.5.0, Copyright (c) 2002-2026, by ionCube Ltd.
C:\laragon\www\crud-lab(main -> origin)
λ
C:\laragon\www\crud-lab(main -> origin)
λ :: Cek versi Laravel
C:\laragon\www\crud-lab(main -> origin)
λ php artisan --version
Laravel Framework 10.50.2
C:\laragon\www\crud-lab(main -> origin)
λ
C:\laragon\www\crud-lab(main -> origin)
λ :: Cek ekstensi PHP yang aktif
C:\laragon\www\crud-lab(main -> origin)
λ php -m
[PHP Modules]
bcmath
calendar
Core
ctype
curl
date
dom
exif
fileinfo
filter
gd
hash
iconv
intl
ionCube Loader
json
libxml
mbstring
mysqli
mysqlnd
openssl
pcre
PDO
pdo_mysql
Phar
random
readline
Reflection
session
SimpleXML
SPL
standard
tokenizer
xml
xmlreader
xmlwriter
xsl
zip
zlib
[Zend Modules]
the ionCube PHP Loader
C:\laragon\www\crud-lab(main -> origin)
λ :: ========================================
C:\laragon\www\crud-lab(main -> origin)
λ :: MANAJEMEN DATABASE
C:\laragon\www\crud-lab(main -> origin)
λ :: ========================================
C:\laragon\www\crud-lab(main -> origin)
λ :: Lihat konfigurasi database
C:\laragon\www\crud-lab(main -> origin)
λ php artisan db:show
Inspecting database information requires the Doctrine DBAL (doctrine/dbal) package. Would you like to install it? (yes/no) [no]
❯
C:\laragon\www\crud-lab(main -> origin)
λ :: Buat migrasi tabel baru
C:\laragon\www\crud-lab(main -> origin)
λ php artisan make:migration create_products_table
INFO Migration [C:\laragon\www\crud-lab\database\migrations/2026_06_15_073938_create_products_table.php] created successfully.
C:\laragon\www\crud-lab(main -> origin)
λ
C:\laragon\www\crud-lab(main -> origin)
λ :: Jalankan migrasi
C:\laragon\www\crud-lab(main -> origin)
λ php artisan migrate
INFO Running migrations.
2026_06_15_073938_create_products_table ................................................................. 10ms FAIL
Illuminate\Database\QueryException
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'products' already exists (Connection: mysql, SQL: create table `products` (`id` bigint unsigned not null auto_increment primary key, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci')
at vendor\laravel\framework\src\Illuminate\Database\Connection.php:829
825▕ $this->getName(), $query, $this->prepareBindings($bindings), $e
826▕ );
827▕ }
828▕
➜ 829▕ throw new QueryException(
830▕ $this->getName(), $query, $this->prepareBindings($bindings), $e
831▕ );
832▕ }
833▕ }
1 vendor\laravel\framework\src\Illuminate\Database\Connection.php:587
PDOException::("SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'products' already exists")
2 vendor\laravel\framework\src\Illuminate\Database\Connection.php:587
PDOStatement::execute()
C:\laragon\www\crud-lab(main -> origin)
λ
C:\laragon\www\crud-lab(main -> origin)
λ :: Reset database (hapus semua tabel & migrasi ulang)
C:\laragon\www\crud-lab(main -> origin)
λ php artisan migrate:fresh
Dropping all tables ..................................................................................... 93ms DONE
INFO Preparing database.
Creating migration table ................................................................................ 18ms DONE
INFO Running migrations.
2014_10_12_000000_create_users_table .................................................................... 44ms DONE
2014_10_12_100000_create_password_reset_tokens_table .................................................... 12ms DONE
2019_08_19_000000_create_failed_jobs_table .............................................................. 29ms DONE
2019_12_14_000001_create_personal_access_tokens_table ................................................... 50ms DONE
2026_06_08_095513_add_role_to_users_table ................................................................ 9ms DONE
2026_06_08_230256_create_products_table ................................................................. 57ms DONE
2026_06_15_073938_create_products_table .................................................................. 1ms FAIL
Illuminate\Database\QueryException
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'products' already exists (Connection: mysql, SQL: create table `products` (`id` bigint unsigned not null auto_increment primary key, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci')
at vendor\laravel\framework\src\Illuminate\Database\Connection.php:829
825▕ $this->getName(), $query, $this->prepareBindings($bindings), $e
826▕ );
827▕ }
828▕
➜ 829▕ throw new QueryException(
830▕ $this->getName(), $query, $this->prepareBindings($bindings), $e
831▕ );
832▕ }
833▕ }
1 vendor\laravel\framework\src\Illuminate\Database\Connection.php:587
PDOException::("SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'products' already exists")
2 vendor\laravel\framework\src\Illuminate\Database\Connection.php:587
PDOStatement::execute()
C:\laragon\www\crud-lab(main -> origin)
λ
C:\laragon\www\crud-lab(main -> origin)
λ :: Hapus semua tabel di database
C:\laragon\www\crud-lab(main -> origin)
λ php artisan db:wipe
INFO Dropped all tables successfully.
C:\laragon\www\crud-lab(main -> origin)
λ