laravel5? freetds(??)? ?? sqlserver? ??? ??????
Jul 31, 2018 pm 04:22 PM
? ???? freetds? ?? laravel5? sqlserver? ???? ??? ?????, ????? ??? ??? ??? ??? ????? ??? ???? ?????.
?? ??
???? ubuntu 16.04, ??? PHP ??? 7.0.30, sqlserver 2012, freetds? 0.92 Laravel5.5 ? 5.4 ?? ????
php ???? ??
sudo?apt-get?install?php7.0-odbc? sudo?apt?install?php7.0-sybase
??tds ??
sudo?apt-get?install?freetds-bin?freetds-common?tdsodbc?odbcinst?unixodbc?unixodbc-dev?? sudo?mv?/etc/odbcinst.ini?/etc/odbcinst.ini.bak?? sudo?cp?/usr/share/tdsodbc/odbcinst.ini?/etc/
freetds ??
?sudo?vim?/etc/freetds/freetds.conf
?? ??
[global]
????tds?version?=?8.0?#?TDS?version,?ref?<a href="http://www.freetds.org/userguide/choosingtdsprotocol.htm" target="_blank">this</a>.
????client?charset?=?UTF-8
????text?size?=?20971520
[Server2012]?#自定義名稱，后面需要使用
????host?=?{yourdomain}.database.windows.net?//?ip地址或域名
????port?=?1433
????tds?version?=?8.0?#8.0為2012其他自行測(cè)試
SQLSER ??? VER# ????#?TDSVER=8.0?tsql?-H?my_server_host?-p?1433?-U?my_user?-P?my_password?-D?my_database
Laravel5 ??
???? config/database.php ?? ??? ?? ??>, ????? sqlsrv? ?????
???'mssql'?=>?[
????????'driver'?=>?'sqlsrv',
????????'host'?=>?'Server2012',?//?這個(gè)對(duì)應(yīng)freetds.conf的配置名稱
????????'port'?=>?'1433',
????????'database'?=>?env('DB_DATABASE',?'數(shù)據(jù)庫'),
????????'username'?=>?env('DB_USERNAME',?'用戶'),
????????'password'?=>?env('DB_PASSWORD',?'密碼'),
????????'charset'?=>?'utf8',
????????'collation'?=>?'utf8_unicode_ci',
????????'prefix'?=>?'',
????????'strict'?=>?false,
????????'engine'?=>?null,
????],
config/database.php在connections中添加配置，驅(qū)動(dòng)使用sqlsrvrrreee多數(shù)據(jù)庫
如果你用了mysql又想用sqlserver的部份信息，個(gè)人項(xiàng)目原因，但一般的做法是sqlserver的系統(tǒng)寫API讓Mysql系統(tǒng)的調(diào)用，但這次偷偷懶，就兩個(gè)一起用了
在Model中 加入protected $connection = 'mssql';并使用protected $table = 'EMPLOYEE';
mysql? ???? sqlserver? ?? ??? ????? ?? , ?? ???? ??? sqlserver ???? API? ???? Mysql ???? ???? ?? ???? ?? ???? ???? ??? ??? ?? ?? ?????? protected $connection = 'mssql' ?? ;??? protected $table = 'EMPLOYEE';? ???? ??? ???? ????? ?? ????? ??? ??? ??? ????. #???? #?? ?? ??: #?? ??#
? ??? laravel5? freetds(??)? ?? sqlserver? ??? ??????? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!
? AI ??
Undress AI Tool
??? ???? ??
Undresser.AI Undress
???? ?? ??? ??? ?? AI ?? ?
AI Clothes Remover
???? ?? ???? ??? AI ?????.
Clothoff.io
AI ? ???
Video Face Swap
??? ??? AI ?? ?? ??? ???? ?? ???? ??? ?? ????!
?? ??
??? ??
???++7.3.1
???? ?? ?? ?? ???
SublimeText3 ??? ??
??? ??, ???? ?? ????.
???? 13.0.1 ???
??? PHP ?? ?? ??
???? CS6
??? ? ?? ??
SublimeText3 Mac ??
? ??? ?? ?? ?????(SublimeText3)
??? ??
8637
17
1783
16
1727
56
1577
28
1442
31
Laravel? ??? ???? ??? ??????
Jun 21, 2025 am 12:21 AM
Inlaravel, PoliciesorganizeauthorizationLogicFormodELACTIONS.1. POLICIESARECLASSESSWITHMEDSLIKEVIEW, ??, ???? ? ???? ? DELETETHETTRUEORFALSEBASEDONUSERMISSIONS.2. TOREGISTERAPOLICY, MAPTHETEMODELTOITSPOLIDEINTHEATHOUSPOFOFAOFAOFOFAOFOFOFOFOFOFOFOFOFOFOFORRAY.
Laravel? ?? ?? ? ??? ??? ??????
Jun 13, 2025 am 11:17 AM
Artisan? ?? ???? ??????? Laravel? ?? ? ?????. ?? ???? ??? ?????. 1. ????, ?? ?? ?? ?? ??? ???? MAIE? ?? ??? ???? ?????. ???? ? ?? ??; 2. ?????? ?????? ? ???? ???? ??????? ???? ??????? ???? DB : ???? ??? ??; 3. Make : Command Creation Command ???? ?? ??? ?? ??? ???? ???? ?? ???? ?????. 4. ?? ?? ??? ? ?? ?? ??? ?????. ? : ?? ???? ?? ??? ???? ??????. ??? ???? ??? ?? ?? ???? ?? ???? ? ????.
Laravel? ????? ???? ??? ??? ??????
Jun 20, 2025 am 12:31 AM
Laravel?? ????? ?? ??? HTTP ??? ???? ??? ???? ??? ???? ?? ?? ? ? ??????? ????. ?? ?? ??? ???? ??????? ????? ??? ??? ????? ??, ?? ? ?? ??? ??? ???? USERCONTroller? ??? ???? ??? ??? ? ???? ????. Artisan Command Phpartisanmake : ControllerUserController? ?? ????? ??? ? ???, ?? ????? -Resource ??? ???? ???? ?? CRUD ??? ?????. ?? ?? Route :: get ( '/user/{id
Laravel? ??? ?? ???? ???? ?? ???? ????? ???????
Jun 22, 2025 pm 04:09 PM
LaravelProvidesRobustOlsForValidatingFormData.1.BasicValidationCanbedOneUsingTheValidate () MethodIngTrollers, intringfieldsMeetCriterialIKERequired, maxlength, oruniqueValues.2
?? ?? | ? ?? ?? ???
Jun 27, 2025 pm 05:41 PM
CachingInlaravelsificiforlyMepplicationPerformanceBERDUCINGDATABASEQUERIES ? REDUNDANTPROCESSING.TOUSECACHINGEFFECTICE, FOCCUSTHESSTEPS : 1.USEROUTECACHINGFORSTATICROUTESWITHPHPARTISANROUTE : CACHE, CACHE, ADVERPUBLICPAGES/ANBORBUTNO
Laravel? .env ??? ???? ??? ??????
Jun 22, 2025 am 01:03 AM
.env ??? Laravel ?????? ?? ??? ???? ? ???? ?? ?????. ??? ??? ???? ???? ?? ?? ??? ?????. ?? ???? ??? ?????. 1. ?????? ??, API ? ? ?? ?? ???? ?? ??; 2. ENV () ?? config () ??? ?? ??? ?????. 3. ?? ? ??? ???? ?? ?? ???????. 4. ??? ???? ?? ?? ??? ????? ????. 5. ??.env ??? ?? ??? ?? ?? ? ????. ??? ??? ?? ?? ??? ??? ?? ?? ?? ??? ??? ?? ?? ??? ?? ???????.
? ??? ???? ORM? ??????
Jun 22, 2025 am 09:37 AM
eloquentormislaravel'sbuilt-inobject-RelationalMapperThathitsimplifiesDatabaseInteractionSusingphpclassEndobjects.1.itmapsDatabasetableStomodels, enablingexpressivesyntaxforqueries.2.modelscorrespondtotablesbyplyingthemodelname, butcustomtablename, butcustomtablenname
Laravel ????? Assert ???? ??? ??????
Jun 14, 2025 am 12:38 AM
Laravel ????? Assert ??? ?? ????? ???? ?? ??? ???? ? ?????. ???? Assert ????? AssertTrue (), AssertFalse (), AsserTequals () ? AsserTnull ()? ????, ??? ?? ???? ????? ???? ? ?????. http ??? ?? assertstatus (), assertredirect (), assertsee () ? assertjson ()? ???? ?? ?? ? ??? ??? ? ????. ?????? ??? AssertDatabaseHas () ? AssertDatabasemissing? ?? ??? ? ????
