// API callback
av({"version":"1.0","encoding":"UTF-8","entry":{"xmlns":"http://www.w3.org/2005/Atom","xmlns$blogger":"http://schemas.google.com/blogger/2008","xmlns$georss":"http://www.georss.org/georss","xmlns$gd":"http://schemas.google.com/g/2005","xmlns$thr":"http://purl.org/syndication/thread/1.0","id":{"$t":"tag:blogger.com,1999:blog-875899154744260851.post-4726989809513802698"},"published":{"$t":"2018-07-08T19:54:00.000-07:00"},"updated":{"$t":"2020-09-01T21:09:12.916-07:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"Linux"},{"scheme":"http://www.blogger.com/atom/ns#","term":"teknologi"}],"title":{"type":"text","$t":"Cara Menyambungkan  PHP MSSQL di Centos 7"},"content":{"type":"html","$t":"\u003Cbr \/\u003E\n\u003Cdiv class=\"separator\" style=\"clear: both; text-align: center;\"\u003E\n\u003Ca href=\"https:\/\/4.bp.blogspot.com\/-p-nlE3PsQak\/W0LOMhFkmpI\/AAAAAAAAAvE\/5FYGHX25X90T0Ck2oizdlKYMwwWtPjeZgCLcBGAs\/s1600\/maxresdefault%2B%25281%2529.jpg\" imageanchor=\"1\" style=\"margin-left: 1em; margin-right: 1em;\"\u003E\u003Cimg border=\"0\" data-original-height=\"768\" data-original-width=\"1024\" height=\"480\" src=\"https:\/\/4.bp.blogspot.com\/-p-nlE3PsQak\/W0LOMhFkmpI\/AAAAAAAAAvE\/5FYGHX25X90T0Ck2oizdlKYMwwWtPjeZgCLcBGAs\/s640\/maxresdefault%2B%25281%2529.jpg\" width=\"640\" \/\u003E\u003C\/a\u003E\u003C\/div\u003E\n\u003Cbr \/\u003E\n\u003Cdiv class=\"separator\" style=\"clear: both; text-align: center;\"\u003E\n\u003C\/div\u003E\n\u003Cbr \/\u003E\n\u003Cbr \/\u003E\n\u003Cdiv style=\"text-align: justify;\"\u003E\nUntuk menyambungkan PHP MSSQL dengan Webserver sebenarnya tidak rumit hanya saja ketika menginstall modul php di centos kadang terlewat dan belum teristall semuanya, berikut tahapan tahapan nya.\u003C\/div\u003E\n\u003Cbr \/\u003E\n1. Pastikan terlebih dahulu SQL Server di Windows sudah bisa di remote dengan port yang telah ditentukan.\u003Cbr \/\u003E\n2. Install Freetds di centos sebagai driver penyambung antara php di centos dengan sql server di windows dan unix ODBC untuk kerluaan lainya.\u003Cbr \/\u003E\n\u003Cbr \/\u003E\nyum install unixODBC\u003Cbr \/\u003E\nyum install freetds\u003Cbr \/\u003E\n\u003Cbr \/\u003E\n3. edit atau buat odbc.ini di\u0026nbsp; \/etc\u0026nbsp; \u0026nbsp;sesuaikan script dibawah dengan IP server dan DB yang ada.\u003Cbr \/\u003E\n\u003Cbr \/\u003E\n[MSSQL]\u003Cbr \/\u003E\nDriver=FreeTDS\u003Cbr \/\u003E\nDescription=MS SQL Test\u003Cbr \/\u003E\nTrace=No\u003Cbr \/\u003E\nServer= 121.0.0.1\u003Cbr \/\u003E\nDatabase= myDB\u003Cbr \/\u003E\nPort=1433\u003Cbr \/\u003E\nTDS_Version = 8.0\u003Cbr \/\u003E\n\u003Cbr \/\u003E\n4. Edit file odbcinst.ini kemudian copy kan script berikut, cek lokasi driver harus sesuai dengan kondisi di server.\u003Cbr \/\u003E\n\u003Cbr \/\u003E\n[FreeTDS]\u003Cbr \/\u003E\nDescription = FreeTDS driver\u003Cbr \/\u003E\nDriver = \/usr\/lib64\/libtdsodbc.so.0\u003Cbr \/\u003E\nSetup = \/usr\/lib64\/libtdsS.so.2\u003Cbr \/\u003E\nTrace = Yes\u003Cbr \/\u003E\nTraceFile = \/tmp\/freetds.log\u003Cbr \/\u003E\nFileUsage = 1\u003Cbr \/\u003E\nUsageCount =1\u003Cbr \/\u003E\n\u003Cbr \/\u003E\n[ODBC]\u003Cbr \/\u003E\nDEBUG=1\u003Cbr \/\u003E\nTraceFile=\/root\/sqltrace.log\u003Cbr \/\u003E\nTrace=Yes\u003Cbr \/\u003E\n\u003Cbr \/\u003E\n5. Buka\u0026nbsp; freetds.conf kemudian buat seperti script dibawah, sesuaikan IP dan Port di server\u003Cbr \/\u003E\n\u003Cbr \/\u003E\n\u003Cbr \/\u003E\n[MSSQL]\u003Cbr \/\u003E\n\u0026nbsp;host = 127.0.0.1\u003Cbr \/\u003E\nport = 1433\u003Cbr \/\u003E\ntds version = 8.0\u003Cbr \/\u003E\n\u003Cbr \/\u003E\n6. jika semua langkah sudah benar, coba kita tes koneksi di centos dengan odbc jika berhasil akan seperti di bawah ini ;\u003Cbr \/\u003E\n\u003Cbr \/\u003E\n[root@localhost]# isql -v MSSQL sa password\u003Cbr \/\u003E\n+---------------------------------------+\u003Cbr \/\u003E\n| Connected!\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp;|\u003Cbr \/\u003E\n|\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp;|\u003Cbr \/\u003E\n| sql-statement\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; |\u003Cbr \/\u003E\n| help [tablename]\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; |\u003Cbr \/\u003E\n| quit\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp;|\u003Cbr \/\u003E\n|\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; |\u003Cbr \/\u003E\n+---------------------------------------+\u003Cbr \/\u003E\n\u003Cbr \/\u003E\n7. agar odbc atau mssql server bisa digunakan, setelah install php dan web service di centos maka modul php-mssql dan pdo-pdo-sqlsrv\u0026nbsp;harus di instalkan juga\u003Cbr \/\u003E\n\u003Cbr \/\u003E\nyum install php-mssql\u003Cbr \/\u003E\nyum install pdo-sqlsrv\u003Cbr \/\u003E\n\u003Cbr \/\u003E\nkemudian masukan extensi nya di php.ini\u0026nbsp; dan save\u003Cbr \/\u003E\n\u003Cbr \/\u003E\nextension=pdo_sqlsrv.so\u003Cbr \/\u003E\nextension=sqlsrv.so\u003Cbr \/\u003E\n\u003Cbr \/\u003E\n8. buat file phpinfo dan cek modul yang terintall di php server kita\u003Cbr \/\u003E\n\u003Cbr \/\u003E\n\u003Cbr \/\u003E\n\u003Cdiv class=\"separator\" style=\"clear: both; text-align: center;\"\u003E\n\u003Ca href=\"https:\/\/4.bp.blogspot.com\/-duR2YnQY6UQ\/W0LHyLwY3ZI\/AAAAAAAAAug\/3vyjskuxQ0Ey7D_tlpBYN54zE4kBpnVMgCLcBGAs\/s1600\/phpinfofreetds.png\" imageanchor=\"1\" style=\"margin-left: 1em; margin-right: 1em;\"\u003E\u003Cimg border=\"0\" data-original-height=\"730\" data-original-width=\"989\" height=\"472\" src=\"https:\/\/4.bp.blogspot.com\/-duR2YnQY6UQ\/W0LHyLwY3ZI\/AAAAAAAAAug\/3vyjskuxQ0Ey7D_tlpBYN54zE4kBpnVMgCLcBGAs\/s640\/phpinfofreetds.png\" width=\"640\" \/\u003E\u003C\/a\u003E\u003C\/div\u003E\n\u003Cbr \/\u003E\n9. jika sudah dipastikan modul terinstall selanjutnya kita coba test koneksi dengan menggunakan file php berikut 2 contoh dengan mssql dan pdo\u003Cbr \/\u003E\n\u003Cbr \/\u003E\ncontoh 1 koneksi php-mssql :\u003Cbr \/\u003E\n\u003Cbr \/\u003E\n\u003Cpre class=\"qoate-code\" style=\"background: none 0px 0px repeat scroll rgb(240, 240, 240) !important; border: 1px solid rgb(218, 218, 218) !important; font-family: Consolas, Monaco, \u0026quot;Courier New\u0026quot;, Courier, monospace !important; font-size: 12px !important; font-stretch: normal; font-variant-east-asian: normal; font-variant-numeric: normal; line-height: 1.3em !important; margin-bottom: 22px !important; outline: 0px; overflow-x: auto !important; overflow-y: auto; padding: 11px !important; vertical-align: baseline; white-space: pre-wrap !important; word-wrap: break-word !important;\"\u003E\u0026lt;?php\n$conn = mssql_connect(\"servername\", \"\u0026lt;user\u0026gt;\", \"\u0026lt;password\u0026gt;\");\nmssql_select_db( \"Database1\", $conn );\n$query_result = mssql_query( \"SELECT field1 FROM Table1\", $conn );\necho \"The field number one is: \";\necho mssql_result ($query_result, 0, 0);\nmssql_close($conn); \/\/ close connection\n?\u0026gt;\u003C\/pre\u003E\ncontoh 2 koneksi dengan pdo-sqlsrv\u003Cbr \/\u003E\n\u003Cbr \/\u003E\n\u003Cpre class=\"qoate-code\" style=\"background: none 0px 0px repeat scroll rgb(240, 240, 240) !important; border: 1px solid rgb(218, 218, 218) !important; font-family: Consolas, Monaco, \u0026quot;Courier New\u0026quot;, Courier, monospace !important; font-size: 12px !important; font-stretch: normal; font-variant-east-asian: normal; font-variant-numeric: normal; line-height: 1.3em !important; margin-bottom: 22px !important; outline: 0px; overflow-x: auto !important; overflow-y: auto; padding: 11px !important; vertical-align: baseline; white-space: pre-wrap !important; word-wrap: break-word !important;\"\u003E\u0026lt;?php\n\n\/\/ connect to DSN MSSQL with a user and password\n$connect = odbc_connect(\"MSSQL\", \"sa\", \"password\") or die\n(\"couldn't connect\");\n\n$result = odbc_exec($connect, \"SELECT field1, Name FROM tabel1\");\nwhile(odbc_fetch_row($result)){\n  print(odbc_result($result, \"id\") .\n  ' ' . odbc_result($result, \"Name\") . \"\u0026lt;br\u0026gt;\\n\");\n}\nodbc_free_result($result);\nodbc_close($connect);\n\n?\u0026gt;\u003C\/pre\u003E\n\u003Cbr \/\u003E\n\u003Cbr \/\u003E"},"link":[{"rel":"replies","type":"application/atom+xml","href":"https:\/\/www.mozunote.com\/feeds\/4726989809513802698\/comments\/default","title":"Post Comments"},{"rel":"replies","type":"text/html","href":"https:\/\/www.mozunote.com\/2018\/07\/cara-menyambungkan-php-mssql-di-centos-7.html#comment-form","title":"0 Comments"},{"rel":"edit","type":"application/atom+xml","href":"https:\/\/www.blogger.com\/feeds\/875899154744260851\/posts\/default\/4726989809513802698"},{"rel":"self","type":"application/atom+xml","href":"https:\/\/www.blogger.com\/feeds\/875899154744260851\/posts\/default\/4726989809513802698"},{"rel":"alternate","type":"text/html","href":"https:\/\/www.mozunote.com\/2018\/07\/cara-menyambungkan-php-mssql-di-centos-7.html","title":"Cara Menyambungkan  PHP MSSQL di Centos 7"}],"author":[{"name":{"$t":"Mozu"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/15656279653354976812"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"16","height":"16","src":"https:\/\/img1.blogblog.com\/img\/b16-rounded.gif"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"https:\/\/4.bp.blogspot.com\/-p-nlE3PsQak\/W0LOMhFkmpI\/AAAAAAAAAvE\/5FYGHX25X90T0Ck2oizdlKYMwwWtPjeZgCLcBGAs\/s72-c\/maxresdefault%2B%25281%2529.jpg","height":"72","width":"72"},"thr$total":{"$t":"0"}}});