PhpStorm 2016.3版本釋出了!


PhpStorm是目前PHP開發工具中最強也最完整的一套,11/24推出2016.3的正式版本了!

  • 工具和框架:在遠程解釋程序中支持 Docker、支持 PHPSpec 測試框架、自動檢測和配置 PHPUnit、Behat 和 composer.json 內的 PHPSpec、在一個框架中打開多個項目,以及支持 Codeigniter 代碼風格。
  • 新的編輯體驗:語意突顯變量和參數、無需函數和 var 關鍵字即可完成重載方法和屬性,以及改進對 PSR-0/PSR-4 的支持。
  • 代碼質量分析:項目範圍的 PHP 7 嚴格類型、新的命名約定檢查,並改進運行時錯誤預防。

該版本還對頂尖 web 技術的支持進行了重大改進,如:支持流(flow)、改進對 TypeScript 的支持、支持 PostCSS、Stylelint 等。

原始連結: https://blog.jetbrains.com/phpstorm/2016/11/phpstorm-2016-3-is-now-released/

下載: https://www.jetbrains.com/phpstorm/download/#section=windows-versionphpstorm_debugging2x

Laravel 5.3 連接 SQL Server

一、下載 https://github.com/superlevin/xamppforlaravel

二、config/database.ph的connections增加

'sqlsrv' => [
    'driver' => 'sqlsrv',
    'host' => env('DB_HOST', 'localhost'),
    'database' => env('DB_DATABASE', 'dbname'),
    'username' => env('DB_USERNAME', 'dbuser'),
    'password' => env('DB_PASSWORD', 'dbpassword'),
    'charset' => 'utf8',
    'prefix' => '',
],

三、.env修改連線

DB_CONNECTION=sqlsrv
DB_HOST=localhost
DB_PORT=1433
DB_DATABASE=dbname
DB_USERNAME=dbuser
DB_PASSWORD=dbpassword

四、測試是否可以產生
routes/web.php

Route::get('/', function () {
    var_dump( DB::table('tablename')->first() );
});

PHP教學 – 這學期教的laravel 5.3課程內容

上個學期是教Codeigniter,這學期開始也要進入Laravel了!內容大致如下面~
Laravel介紹
MVC架構解說
Git版本控制介紹與安裝
Composer套件管理

Laravel安裝

Package安裝及使用
Route路由
Migrations/Seed 資料的遷移與填充

Eloquent ORM資料庫互動

View與Blade模板引擎
Controller實戰

CRUD 綜合運用

表單與驗證技巧
會員認證
網站安全性

Windows安裝Xampp、Composer、laravel

1.安裝Composer
https://getcomposer.org/
Windows版本直接下載
2.下載XAMPP(解壓縮版),解壓縮到D:\xampp
XAMPP
XAMPP直接下載
3.新增PHP到系統變數

set PATH=%PATH%;d:\xampp\php

另外修改:

extension_dir = “d:\xampp\php\ext”

browscap = “d:\xampp\php\extras\browscap.ini”

4.更新Composer版本

D:\xampp\php>php.exe c:\programdata\composersetup\bin\composer.phar self-update

5.在xampp裡建立一個新的專案叫laraveltest
D:\xampp\htdocs>composer create-project laravel/laravel laraveltest

D:\xampp\htdocs>composer create-project laravel/laravel laraveltest
Installing laravel/laravel (v5.2.0)
– Installing laravel/laravel (v5.2.0)
Downloading: 100%

Created project in laraveltest
> php -r “copy(‘.env.example’, ‘.env’);”
Loading composer repositories with package information
Installing dependencies (including require-dev)
– Installing vlucas/phpdotenv (v2.2.0)
Downloading: 100%

– Installing symfony/polyfill-mbstring (v1.1.0)
Downloading: 100%

– Installing symfony/var-dumper (v3.0.2)
Downloading: 100%

– Installing symfony/translation (v3.0.2)
Downloading: 100%

– Installing symfony/routing (v3.0.2)
Downloading: 100%

– Installing symfony/process (v3.0.2)
Downloading: 100%

– Installing symfony/polyfill-util (v1.1.0)
Downloading: 100%

– Installing symfony/polyfill-php56 (v1.1.0)
Downloading: 100%

– Installing psr/log (1.0.0)
Downloading: 100%

– Installing symfony/debug (v3.0.2)
Downloading: 100%

– Installing symfony/http-foundation (v3.0.2)
Downloading: 100%

– Installing symfony/event-dispatcher (v3.0.2)
Downloading: 100%

– Installing symfony/http-kernel (v3.0.2)
Downloading: 100%

– Installing symfony/finder (v3.0.2)
Downloading: 100%

– Installing symfony/console (v3.0.2)
Downloading: 100%

– Installing swiftmailer/swiftmailer (v5.4.1)
Downloading: 100%

– Installing jakub-onderka/php-console-color (0.1)
Downloading: 100%

– Installing jakub-onderka/php-console-highlighter (v0.3.2)
Downloading: 100%

– Installing dnoegel/php-xdg-base-dir (0.1)
Downloading: 100%

– Installing nikic/php-parser (v2.0.0)
Downloading: 100%

– Installing psy/psysh (v0.6.1)
Downloading: 100%

– Installing paragonie/random_compat (v1.2.0)
Downloading: 100%

– Installing nesbot/carbon (1.21.0)
Downloading: 100%

– Installing mtdowling/cron-expression (v1.1.0)
Downloading: 100%

– Installing monolog/monolog (1.17.2)
Downloading: 100%

– Installing league/flysystem (1.0.16)
Downloading: 100%

– Installing jeremeamia/superclosure (2.2.0)
Downloading: 100%

– Installing doctrine/inflector (v1.1.0)
Downloading: 100%

– Installing classpreloader/classpreloader (3.0.0)
Downloading: 100%

– Installing laravel/framework (v5.2.14)
Downloading: 100%

– Installing fzaninotto/faker (v1.5.0)
Downloading: 100%

– Installing hamcrest/hamcrest-php (v1.2.2)
Downloading: 100%

– Installing mockery/mockery (0.9.4)
Downloading: 100%

– Installing sebastian/version (1.0.6)
Downloading: 100%

– Installing sebastian/global-state (1.1.1)
Downloading: 100%

– Installing sebastian/recursion-context (1.0.2)
Downloading: 100%

– Installing sebastian/exporter (1.2.1)
Downloading: 100%

– Installing sebastian/environment (1.3.3)
Downloading: 100%

– Installing sebastian/diff (1.4.1)
Downloading: 100%

– Installing sebastian/comparator (1.2.0)
Downloading: 100%

– Installing symfony/yaml (v3.0.2)
Downloading: 100%

– Installing doctrine/instantiator (1.0.5)
Downloading: 100%

– Installing phpdocumentor/reflection-docblock (2.0.4)
Downloading: 100%

– Installing phpspec/prophecy (v1.5.0)
Downloading: 100%

– Installing phpunit/php-text-template (1.2.1)
Downloading: 100%

– Installing phpunit/phpunit-mock-objects (2.3.8)
Downloading: 100%

– Installing phpunit/php-timer (1.0.7)
Downloading: 100%

– Installing phpunit/php-token-stream (1.4.8)
Downloading: 100%

– Installing phpunit/php-file-iterator (1.4.1)
Downloading: 100%

– Installing phpunit/php-code-coverage (2.2.4)
Downloading: 100%

– Installing phpunit/phpunit (4.8.23)
Downloading: 100%

– Installing symfony/css-selector (v3.0.2)
Downloading: 100%

– Installing symfony/dom-crawler (v3.0.2)
Downloading: 100%

symfony/var-dumper suggests installing ext-symfony_debug ()
symfony/translation suggests installing symfony/config ()
symfony/routing suggests installing symfony/config (For using the all-in-one rou
ter or any loader)
symfony/routing suggests installing symfony/expression-language (For using expre
ssion matching)
symfony/routing suggests installing doctrine/annotations (For using the annotati
on loader)
symfony/routing suggests installing symfony/dependency-injection (For loading ro
utes from a service)
symfony/event-dispatcher suggests installing symfony/dependency-injection ()
symfony/http-kernel suggests installing symfony/browser-kit ()
symfony/http-kernel suggests installing symfony/class-loader ()
symfony/http-kernel suggests installing symfony/config ()
symfony/http-kernel suggests installing symfony/dependency-injection ()
psy/psysh suggests installing ext-pcntl (Enabling the PCNTL extension makes PsyS
H a lot happier :))
psy/psysh suggests installing ext-posix (If you have PCNTL, you’ll want the POSI
X extension as well.)
psy/psysh suggests installing ext-readline (Enables support for arrow-key histor
y navigation, and showing and manipulating command history.)
psy/psysh suggests installing ext-pdo-sqlite (The doc command requires SQLite to
work.)
paragonie/random_compat suggests installing ext-libsodium (Provides a modern cry
pto API that can be used to generate random bytes.)
monolog/monolog suggests installing graylog2/gelf-php (Allow sending log message
s to a GrayLog2 server)
monolog/monolog suggests installing raven/raven (Allow sending log messages to a
Sentry server)
monolog/monolog suggests installing doctrine/couchdb (Allow sending log messages
to a CouchDB server)
monolog/monolog suggests installing ruflin/elastica (Allow sending log messages
to an Elastic Search server)
monolog/monolog suggests installing videlalvaro/php-amqplib (Allow sending log m
essages to an AMQP server using php-amqplib)
monolog/monolog suggests installing ext-amqp (Allow sending log messages to an A
MQP server (1.0+ required))
monolog/monolog suggests installing ext-mongo (Allow sending log messages to a M
ongoDB server)
monolog/monolog suggests installing aws/aws-sdk-php (Allow sending log messages
to AWS services like DynamoDB)
monolog/monolog suggests installing rollbar/rollbar (Allow sending log messages
to Rollbar)
monolog/monolog suggests installing php-console/php-console (Allow sending log m
essages to Google Chrome)
league/flysystem suggests installing ext-fileinfo (Required for MimeType)
league/flysystem suggests installing league/flysystem-eventable-filesystem (Allo
ws you to use EventableFilesystem)
league/flysystem suggests installing league/flysystem-rackspace (Allows you to u
se Rackspace Cloud Files)
league/flysystem suggests installing league/flysystem-copy (Allows you to use Co
py.com storage)
league/flysystem suggests installing league/flysystem-azure (Allows you to use W
indows Azure Blob storage)
league/flysystem suggests installing league/flysystem-webdav (Allows you to use
WebDAV storage)
league/flysystem suggests installing league/flysystem-aws-s3-v2 (Allows you to u
se S3 storage with AWS SDK v2)
league/flysystem suggests installing league/flysystem-aws-s3-v3 (Allows you to u
se S3 storage with AWS SDK v3)
league/flysystem suggests installing league/flysystem-dropbox (Allows you to use
Dropbox storage)
league/flysystem suggests installing league/flysystem-cached-adapter (Flysystem
adapter decorator for metadata caching)
league/flysystem suggests installing league/flysystem-sftp (Allows you to use SF
TP server storage via phpseclib)
league/flysystem suggests installing league/flysystem-ziparchive (Allows you to
use ZipArchive adapter)
laravel/framework suggests installing aws/aws-sdk-php (Required to use the SQS q
ueue driver and SES mail driver (~3.0).)
laravel/framework suggests installing doctrine/dbal (Required to rename columns
and drop SQLite columns (~2.4).)
laravel/framework suggests installing guzzlehttp/guzzle (Required to use the Mai
lgun and Mandrill mail drivers and the ping methods on schedules (~5.3|~6.0).)
laravel/framework suggests installing league/flysystem-aws-s3-v3 (Required to us
e the Flysystem S3 driver (~1.0).)
laravel/framework suggests installing league/flysystem-rackspace (Required to us
e the Flysystem Rackspace driver (~1.0).)
laravel/framework suggests installing pda/pheanstalk (Required to use the beanst
alk queue driver (~3.0).)
laravel/framework suggests installing predis/predis (Required to use the redis c
ache and queue drivers (~1.0).)
laravel/framework suggests installing pusher/pusher-php-server (Required to use
the Pusher broadcast driver (~2.0).)
fzaninotto/faker suggests installing ext-intl (*)
sebastian/global-state suggests installing ext-uopz (*)
phpdocumentor/reflection-docblock suggests installing dflydev/markdown (~1.0)
phpdocumentor/reflection-docblock suggests installing erusev/parsedown (~1.0)
phpunit/php-code-coverage suggests installing ext-xdebug (>=2.2.1)
phpunit/phpunit suggests installing phpunit/php-invoker (~1.1)
Writing lock file
Generating autoload files
> php artisan clear-compiled
> php artisan optimize
Generating optimized class loader
> php artisan key:generate
Application key [CZbM380YshFe0R8UK5zFMlYvL2Xa1WPG] set successfully.

6.跑完後,可以到下面網址看

http://localhost/laraveltest/public/

Laravel5上傳虛擬主機

一直找不到Laravel5上傳虛擬主機的方式,一方面也是自己對Laravel沒有像Codeigniter這麼清楚。
於是昨天先試著將Laravel5的執行目錄搬到根目錄下,然後再將它上傳到遠振虛擬主機。終於把這個簡潔、優雅為網頁藝術家創造的PHP 框架上傳上去了。(不過不能直接在虛擬主機執行composer安裝)
1455239163252

遠振虛擬主機租用 >> 遠振資訊官方網站
注意: php的版本要在5.5.9以上的版本(遠振虛擬主機可以選擇5.5、5.6跟最新的7.0)
1455239893267

XAMPP與Laravel5

1. PHP.ini中的extension=php_openssl.dll 前面的;要移除,重開apache
2..htaccess, index.php, favicon.ico從public移至上一層
3.index.php
require __DIR__.’/../bootstrap/autoload.php’;

require __DIR__.’/bootstrap/autoload.php’;

$app = require_once __DIR__.’/../bootstrap/app.php’;

$app = require_once __DIR__.’/bootstrap/app.php’;