{"id":923,"date":"2021-04-21T09:47:35","date_gmt":"2021-04-21T01:47:35","guid":{"rendered":"https:\/\/wp.vicds.com\/?p=923"},"modified":"2021-05-08T12:26:20","modified_gmt":"2021-05-08T04:26:20","slug":"php-connect-msql","status":"publish","type":"post","link":"https:\/\/wp.vicds.com\/?p=923","title":{"rendered":"php connect m$sql@m$server"},"content":{"rendered":"\n

\u67d0\u500b\u60c5\u6cc1\u4e0b\u9700\u8981\u505a\u9019\u6a23\u7684\u9023\u7dda\u3002php\u7248\u672c\u662f7.3, m$sql\u662f2016\u653e\u5728win2012\u4e0a\u3002<\/p>\n\n\n\n

\u5148\u88dd\u5957\u4ef6<\/p>\n\n\n\n

apt install php-pear g++ make unixodbc-dev<\/p>\n\n\n\n

sudo pecl install sqlsrv
sudo pecl install pdo_sqlsrv
# \u5728\u9019\u88e1\u6211\u9047\u5230\u4e86\u4e0d\u80fd\u4e0b\u8f09\u7684\u554f\u984c\uff0c\u56e0\u6b64\u6211\u76f4\u63a5\u53bb\u5b98\u65b9\u6293
https:\/\/pecl.php.net\/package-search.php?pkg_name=sqlsrv<\/a>
sudo pecl install sqlsrv-5.9.0.tgz
pecl install pdo_sqlsrv-5.9.0.tgz

printf “; priority=20\\nextension=sqlsrv.so\\n” > \/etc\/php\/7.3\/mods-available\/sqlsrv.ini
printf “; priority=30\\nextension=pdo_sqlsrv.so\\n” > \/etc\/php\/7.3\/mods-available\/pdo_sqlsrv.ini
exit
sudo phpenmod -v 7.3 sqlsrv pdo_sqlsrv<\/p>\n\n\n\n

# \u53c3\u8003\u4e0b\u9762\u5b89\u88dddriver<\/p>\n\n\n\n

https:\/\/docs.microsoft.com\/en-us\/sql\/connect\/php\/system-requirements-for-the-php-sql-driver?redirectedfrom=MSDN&view=sql-server-ver15<\/a><\/p>\n\n\n\n

sudo su\ncurl https:\/\/packages.microsoft.com\/keys\/microsoft.asc | apt-key add -\n\n#Download appropriate package for the OS version\n#Choose only ONE of the following, corresponding to your OS version\n\n#Debian 8\ncurl https:\/\/packages.microsoft.com\/config\/debian\/8\/prod.list > \/etc\/apt\/sources.list.d\/mssql-release.list\n\n#Debian 9\ncurl https:\/\/packages.microsoft.com\/config\/debian\/9\/prod.list > \/etc\/apt\/sources.list.d\/mssql-release.list\n\n#Debian 10\ncurl https:\/\/packages.microsoft.com\/config\/debian\/10\/prod.list > \/etc\/apt\/sources.list.d\/mssql-release.list\n\nexit\nsudo apt-get update\nsudo ACCEPT_EULA=Y apt-get install -y msodbcsql17\n# optional: for bcp and sqlcmd\nsudo ACCEPT_EULA=Y apt-get install -y mssql-tools\necho 'export PATH="$PATH:\/opt\/mssql-tools\/bin"' >> ~\/.bashrc\nsource ~\/.bashrc\n# optional: for unixODBC development headers\nsudo apt-get install -y unixodbc-dev\n# optional: kerberos library for debian-slim distributions\nsudo apt-get install -y libgssapi-krb5-2<\/code><\/pre>\n\n\n\n
sudo vim \/var\/www\/html\/test_connect_m$sql.php<\/p>\n\n\n\n
<?php\n    $serverName = "192.168.0.250\\\\MSSQLSERVER, 1433";\n    $connectionOptions = array(\n\t\t"Database" => "database",\n\t\t"Uid" => "username",\n\t\t"PWD" => "password"\n\t);\n\t    \/\/Establishes the connection\n\t$conn = sqlsrv_connect($serverName, $connectionOptions);\n\tif($conn){\n\t\techo "Connected!";\n\t} else {\n\t\techo "iConnection failed";\n\t\tdie(print_r(sqlsrv_errors(), true));\n\t}\n\n\tsqlsrv_close($conn);\t\n?>\n<\/code><\/pre>\n\n\n\n
<\/p>\n\n\n\n
# \u9084\u662f\u9023\u4e0d\u4e0a\uff0c\u5f8c\u4f86\u67e5\u5230\u9019\u500b\uff0c\u6539\u5b8c\u5c31\u641e\u5b9a\u4e86<\/p>\n\n\n\n
https:\/\/owendavies.net\/articles\/docker-php-mssql-error\/<\/a>
<\/p>\n\n\n\n
Adding the following line to the d takes the SSL down to the 1024 bit RSA key<\/p>\n\n\n\n
sed -i -E 's\/(CipherString\\s*=\\s*DEFAULT@SECLEVEL=)2\/\\11\/' \/etc\/ssl\/openssl.cnf<\/code><\/pre>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
\u67d0\u500b\u60c5\u6cc1\u4e0b\u9700\u8981\u505a\u9019\u6a23\u7684\u9023\u7dda\u3002php\u7248\u672c\u662f7. […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-923","post","type-post","status-publish","format-standard","hentry","category-php"],"_links":{"self":[{"href":"https:\/\/wp.vicds.com\/index.php?rest_route=\/wp\/v2\/posts\/923","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wp.vicds.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wp.vicds.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wp.vicds.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wp.vicds.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=923"}],"version-history":[{"count":6,"href":"https:\/\/wp.vicds.com\/index.php?rest_route=\/wp\/v2\/posts\/923\/revisions"}],"predecessor-version":[{"id":930,"href":"https:\/\/wp.vicds.com\/index.php?rest_route=\/wp\/v2\/posts\/923\/revisions\/930"}],"wp:attachment":[{"href":"https:\/\/wp.vicds.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=923"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wp.vicds.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=923"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wp.vicds.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=923"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}