PHP Manual

啟動PHP項目

php artisan serve --host=127.0.0.1 --port=9000

1. Test the database from Laravel

登錄page之前測試數據庫

php artisan tinker DB::connection()->getPdo();

2. PHP Extension

DB::connection()->getPdo(); PDOException with message 'could not find driver'

php -m | findstr /I "pdo mysql"

3. Find php.ini

php --ini

4. Enable MySQL PDO

5. Check what Laravel is actually using

6. Clean

php artisan config:clear php artisan cache:clear

7. 測試兩個Password相同

程序與配置文件中的密碼是一樣的

config('database.connections.mysql.password') === env('DB_PASSWORD')

8. CMD 測試MySQL

mysql.exe -h 127.0.0.1 -P 3308 -u wehea*** -p

9. 測試數據庫是否正常

php tests/test-db.php

<?php $pdo = new PDO( 'mysql:host=127.0.0.1;port=3307;dbname=_db', 'username', 'password', [ PDO::MYSQL_ATTR_SSL_CA => 'D:/workspace/vh/證書e.pem', PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT => false, ] ); echo "Connected to MySQL successfully!\n";

10. 啟動或者關閉Debug模式

查看PHP配置信息 php --ini

[ffi] zend_extension="D:\php_xdebug.dll" [xdebug] xdebug.mode=debug xdebug.start_with_request=yes xdebug.client_host=127.0.0.1 xdebug.client_port=9003