{"id":1385,"date":"2018-12-12T02:01:16","date_gmt":"2018-12-12T00:01:16","guid":{"rendered":"http:\/\/www.shukko.com\/x3\/?p=1385"},"modified":"2018-12-12T02:02:45","modified_gmt":"2018-12-12T00:02:45","slug":"php-ile-mssql-sunucuya-baglanalim","status":"publish","type":"post","link":"https:\/\/www.shukko.com\/x3\/2018\/12\/12\/php-ile-mssql-sunucuya-baglanalim\/","title":{"rendered":"php ile mssql sunucuya baglanalim"},"content":{"rendered":"\n<p>php ile mssql sunucuya baglanalim. Centos 7 uzerinde Directadmin icin yazdim.<\/p>\n\n\n\n<p>1- php 5.6 ile FREETDS kullaniyoruz<\/p>\n\n\n\n<p>freetds yi cek<\/p>\n\n\n\n<p>wget wget ftp:\/\/ftp.freetds.org\/pub\/freetds\/stable\/freetds-patched.tar.gz<\/p>\n\n\n\n<p>freetds yi uygun sekilde kur:<\/p>\n\n\n\n<p>tar zxvf freetds-patched.tar.gz<br>\ncd freetds-1.00.109\/<br>\n.\/configure &#8211;prefix=\/usr\/local\/freetds<br>\nmake<br>\nmake install<\/p>\n\n\n\n<p>php configure dosyasini duzenle<\/p>\n\n\n\n<p>nano \/usr\/local\/directadmin\/custombuild\/configure\/ap2\/configure.php56<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>    --with-mssql=\/usr\/local\/freetds \\<\/code><\/pre>\n\n\n\n<p>ekle&nbsp;<\/p>\n\n\n\n<p>sonrasi bu:<\/p>\n\n\n\n<p>cd \/usr\/local\/directadmin\/custombuild<br>.\/build php n<\/p>\n\n\n\n<p class=\"has-background has-vivid-red-background-color\">2- Php 7.2 icin &#8211; Php 7 ile beraber freetds kullanamiyoruz. php destegini kesti.<\/p>\n\n\n\n<p>microsoft kendisi cikardi pdo lib sqlsrv vs vs<\/p>\n\n\n\n<p>php 7.2 icin kurulum su sekildedir. (PECL ile yapicaz)<\/p>\n\n\n\n<p>curl https:\/\/packages.microsoft.com\/config\/rhel\/7\/prod.repo &gt; \/etc\/yum.repos.d\/mssql-release.repo<br>yum update<br> ACCEPT_EULA=Y yum install -y msodbcsql mssql-tools unixODBC-devel<br>pecl install sqlsrv<br>pecl install pdo_sqlsrv<br>nano \/usr\/local\/lib\/php.ini<\/p>\n\n\n\n<p>ekle:<\/p>\n\n\n\n<p>extension=sqlsrv<br>extension=pdo_sqlsrv<\/p>\n\n\n\n<p>kaydet.<\/p>\n\n\n\n<p>service httpd restart<\/p>\n\n\n\n<p>Gule Gule Kullan&#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>php ile mssql sunucuya baglanalim. Centos 7 uzerinde Directadmin icin yazdim. 1- php 5.6 ile FREETDS kullaniyoruz freetds yi cek wget wget ftp:\/\/ftp.freetds.org\/pub\/freetds\/stable\/freetds-patched.tar.gz freetds yi uygun sekilde kur: tar zxvf freetds-patched.tar.gz cd freetds-1.00.109\/ .\/configure &#8211;prefix=\/usr\/local\/freetds make make install php configure dosyasini duzenle nano \/usr\/local\/directadmin\/custombuild\/configure\/ap2\/configure.php56 ekle&nbsp; sonrasi bu: cd \/usr\/local\/directadmin\/custombuild.\/build php n 2- Php 7.2 icin [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1385","post","type-post","status-publish","format-standard","hentry","category-kategerisiz"],"_links":{"self":[{"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/posts\/1385","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/comments?post=1385"}],"version-history":[{"count":3,"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/posts\/1385\/revisions"}],"predecessor-version":[{"id":1388,"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/posts\/1385\/revisions\/1388"}],"wp:attachment":[{"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/media?parent=1385"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/categories?post=1385"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/tags?post=1385"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}