win7+php7+laravel5.3+nginx+oracle12c支持 全教程
首先win7 環(huán)境是必須的，這里就不說如何安裝OS了，請(qǐng)自行百度
1. 安裝 phpStudy，這是我第一次聽說這個(gè)軟件，看起來真的不錯(cuò)，可以自行選擇版本將運(yùn)行環(huán)境進(jìn)行打包處理，這里直接選擇php 7.0.12-nts+nginx即可
2. 開始安裝composer ?，下載地址是 ?https://getcomposer.org/Composer-Setup.exe，一路確定即可
3.因?yàn)閏omposer源的問題可以直接換源，執(zhí)行以下命令
??composer?config?-g?repo.packagist?composer?https://packagist.phpcomposer.com
4. 下載laravel5.3 版本，下載地址是：https://github.com/laravel/laravel ? 并將其加壓縮到你需要的位置上即可，我是 D:\runninglaravel
5. 進(jìn)行composer安裝 ，使用cmd 進(jìn)入到?D:\runninglaravel 目錄下，執(zhí)行命令：
?composer?install
6. ?復(fù)制.env.example 為.env文件，執(zhí)行命令
copy?.env.example?.env
7. ?執(zhí)行命令：
?php?artisan?key:generate
8. ?接下來是進(jìn)行php study的修改，將站點(diǎn)目錄修改為?D:\runninglarave\public
9. 修改nginx.conf 其目的是將所有的請(qǐng)求定位到publicindex.php文件上進(jìn)行統(tǒng)一處理
??location?/?{
??????????????root?"D:/running/laravel/public";
????????????index??index.php;
????????????if?(!-e?$request_filename)?{?
????????????rewrite?^(.*)$?/index.php?s=$1?last;?
????????????break;?
????????????}
????????}
這是我的處理文件，很糙，但是目前可用
10. 到這里為止，再檢查一下php的擴(kuò)展 ?需要打開的是open_ssl （這個(gè)我遇到過問題，即使打開了也會(huì)報(bào)錯(cuò) encry**函數(shù)未定義，我的處理方式是重啟電腦）
11. laravel已經(jīng)安裝好，現(xiàn)在需要做的是進(jìn)行l(wèi)aravel的oracle支持，laravel默認(rèn)是不支持oracle的，現(xiàn)在添加第三方的組件
? ??? ?composer require yajra/laravel-oci8
12. 如果要用php連接oracle不光需要php擴(kuò)展，還需要oracle的客戶端程序，
? 下載文件：http://download.oracle.com/otn/nt/instantclient/121020/instantclient-basic-nt-12.1.0.2.0.zip?AuthParam=1488258321_c18d9fdc85acf4d32185f80bcd7e3b5a
? ? 同時(shí)還需要將文件解壓縮后，并將解壓縮位置添加在環(huán)境變量上
13. 開啟php ?擴(kuò)展， 打開php_oci ?php_oci_11g ? php_pdo_oci,需要注意的還有就是打開 ?
oci8.privileged_connect?=?On
? ? ?允許oci_connect連接，這樣就同時(shí)支持了兩種方式一個(gè)是pdo方式，第二個(gè)是開啟oci_connnect連接方式
14. 雖然框架中已經(jīng)有了對(duì)oracle的支持，但是在接入點(diǎn)還需要進(jìn)行修改
? ??在 ?IlluminateDatabaseConnectorsConnectionFactory.php ; 添加兩個(gè)類的聲明
use?YajraOci8ConnectorsOracleConnector; use?YajraOci8Oci8Connection;
? ? 還是這個(gè)文件還需要重寫兩個(gè)函數(shù)
????protected?function?createConnection($driver,?$connection,?$database,?$prefix?=?'',?array?$config?=?[])
????{
????????if?($resolver?=?Connection::getResolver($driver))?{
????????????return?$resolver($connection,?$database,?$prefix,?$config);
????????}
????????switch?($driver)?{
????????????case?'mysql':
????????????????return?new?MySqlConnection($connection,?$database,?$prefix,?$config);
????????????case?'pgsql':
????????????????return?new?PostgresConnection($connection,?$database,?$prefix,?$config);
????????????case?'sqlite':
????????????????return?new?SQLiteConnection($connection,?$database,?$prefix,?$config);
????????????case?'sqlsrv':
????????????????return?new?SqlServerConnection($connection,?$database,?$prefix,?$config);
????????????case?'oracle':
????????????????return?new?Oci8Connection($connection,?$database,?$prefix,?$config);;
????????}
????????throw?new?InvalidArgumentException("Unsupported?driver?[$driver]");
????}
}
public?function?createConnector(array?$config)
????{
????????if?(!?isset($config['driver']))?{
????????????throw?new?InvalidArgumentException('A?driver?must?be?specified.');
????????}
????????if?($this->container->bound($key?=?"db.connector.{$config['driver']}"))?{
????????????return?$this->container->make($key);
????????}
????????switch?($config['driver'])?{
????????????case?'mysql':
????????????????return?new?MySqlConnector;
????????????case?'pgsql':
????????????????return?new?PostgresConnector;
????????????case?'sqlite':
????????????????return?new?SQLiteConnector;
????????????case?'sqlsrv':
????????????????return?new?SqlServerConnector;
????????????case?'oracle':
???????????????return?new?OracleConnector;
????????}
????????throw?new?InvalidArgumentException("Unsupported?driver?[{$config['driver']}]");
????}
最后就是修改config中database.php文件中的配置了， ? ?
??'oracle'?=>?[
????????????'driver'????????=>?'oracle',
????????????'tns'???????????=>?env('DB_TNS',?''),
????????????'host'??????????=>?'192.168.11.111',
????????????'port'??????????=>?1521,
????????????'database'??????=>?'ORCL',
????????????'username'??????=>?"c##test1",
????????????'password'??????=>?'111111',
????????????'charset'???????=>?env('DB_CHARSET',?'AL32UTF8'),
????????????'prefix'????????=>?env('DB_PREFIX',?''),
????????????'prefix_schema'?=>?env('DB_SCHEMA_PREFIX',?''),
????????],同時(shí)修改default ?
????'default'?=>?'oracle',
至于用戶名是C##開始的，請(qǐng)自行百度，關(guān)于CDB和PDB的區(qū)別
測(cè)試代碼：
Route::get('test',?function?()?{
$m?=?DB::table("users_data")->get();
var_dump($m->all());
});PS: ? 現(xiàn)在附上PDO方式的連接測(cè)試代碼
$tns?=?"??
(DESCRIPTION?=
????(ADDRESS_LIST?=
??????(ADDRESS?=?(PROTOCOL?=?TCP)(HOST?=?192.168.11.111)(PORT?=?1521))
????)
????(CONNECT_DATA?=
??????(Service_Name?=?orcl)
????)?
??)?";
$db_username?=?"C##test1";???#這里不能使用?sys角色的用戶
$db_password?=?"111111";
try?{
????$conn?=?new?PDO("oci:dbname="?.?$tns,?$db_username,?$db_password);
}?catch?(PDOException?$e)?{
????echo($e->getMessage());
}
$sql?=?"select?*?from?users_data";
$rs?=?$conn->query($sql);
$m?=?$rs->fetchAll();
oci_connect連接的測(cè)試代碼
$conn?=?oci_connect('C##test1',?'111111',?'192.168.11.111/orcl');
if?(!$conn)?{
????$e?=?oci_error();
????print?htmlentities($e['message']);
????exit;
}else?{
????echo?"連接oracle成功！";
}
最后關(guān)于 laravel框架連接oracle的方式是使用oci_connect的方式進(jìn)行連接
?public?function?createConnection($tns,?array?$config,?array?$options)
????{
????????//?add?fallback?in?case?driver?is?not?set,?will?use?pdo?instead
????????if?(!?in_array($config['driver'],?['oci8',?'pdo-via-oci8',?'oracle']))?{
????????????return?parent::createConnection($tns,?$config,?$options);
????????}
????????$config?????????????=?$this->setCharset($config);
????????$options['charset']?=?$config['charset'];
????????return?new?Oci8($tns,?$config['username'],?$config['password'],?$options);
????}
如果當(dāng)初并未設(shè)定oracle或者oci8 ?或者pdo-via-oci8的話，則使用PDO方式，否則使用oci8的oci_connect方式進(jìn)行連接
OK: ? ?我的整個(gè)搭建過程到此為止，如有問題敬請(qǐng)留言！
下載文檔
