windows+xampp+yii+sqlserver 配置教程

wuliws

　　首先下载xampp  官网地址：https://www.apachefriends.org/zh_cn/index.html

https://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
　　这里基本上算完成一大半了
　　记住运行cmd  cd到   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', ], ], // ... ];