windows+xampp+yii+sqlserver 配置教程
首先下载xampp官网地址：https://www.apachefriends.org/zh_cn/index.htmlhttps://set1.mail.qq.com/cgi-bin/viewfile?f=71BD4AC129C94B1FBCED14094FAEC37E932D33B78077CDF9CA86893782CE0C1A0F17B8BD20B0647A8FBBD89696B66AAFED959FCEFE038B5AB86B10655C803C24111D0DCAB8964204AC7EFC07639103FE77BD8628997CA67414D853D512741E72&mailid=ZL4121-5hyDe4mKh_6XTFIFjxRQb66&sid=xT9ySLpysMmxemQz&net=1402177802
这是其他版本的xampp 主要是对应PHP的版本 https://www.apachefriends.org/download.html
https://set1.mail.qq.com/cgi-bin/viewfile?f=71BD4AC129C94B1FBCED14094FAEC37E932D33B78077CDF9CA86893782CE0C1A0F17B8BD20B0647A8FBBD89696B66AAFED959FCEFE038B5ADA2BE07ABAFE088BE31AAAAF545EAF8689747917B9989FECEB9FCD73C0D904E4C14AB1B88CB19236&mailid=ZL4121-5hyDe4mKh_6XTFIFjxRQb66&sid=xT9ySLpysMmxemQz&net=1402177802
https://set1.mail.qq.com/cgi-bin/viewfile?f=71BD4AC129C94B1FBCED14094FAEC37E932D33B78077CDF9CA86893782CE0C1A0F17B8BD20B0647A8FBBD89696B66AAFED959FCEFE038B5A93C26D9D0E7FC687E2CBE4432DF95C55EB6724480F74A9A3E9D3A32174784BED331E6E65F12B42CD&mailid=ZL4121-5hyDe4mKh_6XTFIFjxRQb66&sid=xT9ySLpysMmxemQz&net=1402177802
https://set1.mail.qq.com/cgi-bin/viewfile?f=71BD4AC129C94B1FBCED14094FAEC37E932D33B78077CDF9CA86893782CE0C1A0F17B8BD20B0647A8FBBD89696B66AAFED959FCEFE038B5ACB5072F09925E574D2E6879DEDE2CB11E3412048563A4F0B4C17E0050E244778EFD8A32D17B0C79E&mailid=ZL4121-5hyDe4mKh_6XTFIFjxRQb66&sid=xT9ySLpysMmxemQz&net=1402177802
一直下一步，中间有访问权限提示一直点允许知道安装结束
运行
https://set1.mail.qq.com/cgi-bin/viewfile?f=71BD4AC129C94B1FBCED14094FAEC37E932D33B78077CDF9CA86893782CE0C1A0F17B8BD20B0647A8FBBD89696B66AAFED959FCEFE038B5AC219D93E23115B83A63D858FA5E3DB0EE15F2CB9B5D565563F6115D0892F7D4F89E3F1F0D4F7DA70&mailid=ZL4121-5hyDe4mKh_6XTFIFjxRQb66&sid=xT9ySLpysMmxemQz&net=1402177802
https://set1.mail.qq.com/cgi-bin/viewfile?f=71BD4AC129C94B1FBCED14094FAEC37E932D33B78077CDF9CA86893782CE0C1A0F17B8BD20B0647A8FBBD89696B66AAFED959FCEFE038B5AAE5B8D2A867A2C6B609EAADBC6498C32DD21F9678CF19ED1EE590515AED2B780509584CAD0E022F5&mailid=ZL4121-5hyDe4mKh_6XTFIFjxRQb66&sid=xT9ySLpysMmxemQz&net=1402177802
按照完成之后就可以了，，此时需要把botappserver也就是我们的代码放到根目录下 C:\xampp\htdocs
这里基本上算完成一大半了
记住运行cmdcd到 C:\xampp\htdocs\botappServer
之后运行init
https://set1.mail.qq.com/cgi-bin/viewfile?f=71BD4AC129C94B1FBCED14094FAEC37E932D33B78077CDF9CA86893782CE0C1A0F17B8BD20B0647A8FBBD89696B66AAFED959FCEFE038B5AE017045F240D8FBEC15CE2F0C6B0E7F94B98B965C8C11A31E2C77A279E12EF1149CD78475BD469F8&mailid=ZL4121-5hyDe4mKh_6XTFIFjxRQb66&sid=xT9ySLpysMmxemQz&net=1402177802
https://set1.mail.qq.com/cgi-bin/viewfile?f=71BD4AC129C94B1FBCED14094FAEC37E932D33B78077CDF9CA86893782CE0C1A0F17B8BD20B0647A8FBBD89696B66AAFED959FCEFE038B5AF4ED2C7DF0B2A11B8D10459EEA38CAE8DBB2B0A30932F6C771A8A2A6B659152F489788895299506F&mailid=ZL4121-5hyDe4mKh_6XTFIFjxRQb66&sid=xT9ySLpysMmxemQz&net=1402177802
打开文件C:\xampp\php\php.ini 在此处添加C:\xampp\php\ext 支持sql server 的动态库文件 xampp 其实很坑的地方在这
https://set1.mail.qq.com/cgi-bin/viewfile?f=71BD4AC129C94B1FBCED14094FAEC37E932D33B78077CDF9CA86893782CE0C1A0F17B8BD20B0647A8FBBD89696B66AAFED959FCEFE038B5AEDA90EFB2722F361FA3016AFDA53574150A8781E7BC0FA22618C5D9AF761FEBCF21D488ADF6B057E&mailid=ZL4121-5hyDe4mKh_6XTFIFjxRQb66&sid=xT9ySLpysMmxemQz&net=1402177802
extension=php_sqlsrv_56_ts.dll
extension=php_pdo_sqlsrv_56_ts.dll
此处是为了设置我们的服务接口为直接访问地址比如http://localhost会直接跳转到 服务器接口不需要像 http://localhost/botappserver/api/web
打开目录C:\xampp\apache\conf找到httpd.conf 打开编辑
https://set1.mail.qq.com/cgi-bin/viewfile?f=71BD4AC129C94B1FBCED14094FAEC37E932D33B78077CDF9CA86893782CE0C1A0F17B8BD20B0647A8FBBD89696B66AAFED959FCEFE038B5AC2D357E6EB89F3173636E2A4D5C341FBCC80B52047D721C163A33052C921D185C6D746D333E05DFB&mailid=ZL4121-5hyDe4mKh_6XTFIFjxRQb66&sid=xT9ySLpysMmxemQz&net=1402177802
https://set1.mail.qq.com/cgi-bin/viewfile?f=71BD4AC129C94B1FBCED14094FAEC37E932D33B78077CDF9CA86893782CE0C1A0F17B8BD20B0647A8FBBD89696B66AAFED959FCEFE038B5ADF5B14D04AA56CD827C5FEDEEB6A97691967106B1703F5254625F0DB4B2FB3AECFA31E3C59D59DFF&mailid=ZL4121-5hyDe4mKh_6XTFIFjxRQb66&sid=xT9ySLpysMmxemQz&net=1402177802
编辑C:/xampp/htdocs/botappServer/api/web
<Directory " C:/xampp/htdocs/botappServer/api/web">zhuyi </Directory> 中间要添加
# 开启 mod_rewrite 用于美化 URL 功能的支持（译注：对应 pretty URL 选项）
RewriteEngine on
# 如果请求的是真实存在的文件或目录，直接访问
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
# 如果请求的不是真实文件或目录，分发请求至 index.php
RewriteRule . index.php
# ...其它设置...
此处算设置完成 重起服务 start
找到botappserver目录下 botappServer\common\config main-local.php
打开
https://set1.mail.qq.com/cgi-bin/viewfile?f=71BD4AC129C94B1FBCED14094FAEC37E932D33B78077CDF9CA86893782CE0C1A0F17B8BD20B0647A8FBBD89696B66AAFED959FCEFE038B5AE71165584B6535EEA2A195DB69939454AE38865F4D49FEC1AFC54D7A863A136E89BAD294E9FCBC2D&mailid=ZL4121-5hyDe4mKh_6XTFIFjxRQb66&sid=xT9ySLpysMmxemQz&net=1402177802
把不需要的都注释了，这个是可以连接多种数据库的方式供参考
return [ // ... 'components' => [ // ... 'db' => [ 'class' => 'yii\db\Connection', 'dsn' => 'mysql:host=localhost;dbname=mydatabase', // MySQL, MariaDB //'dsn' => 'sqlite:/path/to/database/file', // SQLite //'dsn' => 'pgsql:host=localhost;port=5432;dbname=mydatabase', // PostgreSQL //'dsn' => 'cubrid:dbname=demodb;host=localhost;port=33000', // CUBRID //'dsn' => 'sqlsrv:Server=localhost;Database=mydatabase', // MS SQL Server, sqlsrv driver //'dsn' => 'dblib:host=localhost;dbname=mydatabase', // MS SQL Server, dblib driver //'dsn' => 'mssql:host=localhost;dbname=mydatabase', // MS SQL Server, mssql driver //'dsn' => 'oci:dbname=//localhost:1521/mydatabase', // Oracle 'username' => 'root', //数据库用户名 'password' => '', //数据库密码 'charset' => 'utf8', ], ], // ... ];
页:
[1]