답변 2개
채택된 답변
+20 포인트
9년 전
http://php.net/manual/kr/function.mssql-query.php">http://php.net/manual/kr/function.mssql-query.php
</p><p><code><span style="color: #000000"><span style="color: #FF8000">// Connect to MSSQL
</span><span style="color: #0000BB">$link </span><span style="color: #007700">= </span><span style="color: #0000BB">mssql_connect</span><span style="color: #007700">(</span><span style="color: #DD0000">'KALLESPC\SQLEXPRESS'</span><span style="color: #007700">, </span><span style="color: #DD0000">'sa'</span><span style="color: #007700">, </span><span style="color: #DD0000">'phpfi'</span><span style="color: #007700">);
if (!</span><span style="color: #0000BB">$link </span><span style="color: #007700">|| !</span><span style="color: #0000BB">mssql_select_db</span><span style="color: #007700">(</span><span style="color: #DD0000">'php'</span><span style="color: #007700">, </span><span style="color: #0000BB">$link</span><span style="color: #007700">)) {
die(</span><span style="color: #DD0000">'Unable to connect or select database!'</span><span style="color: #007700">);
}
</span><span style="color: #FF8000">// Do a simple query, select the version of
// MSSQL and print it.
</span><span style="color: #0000BB">$version </span><span style="color: #007700">= </span><span style="color: #0000BB">mssql_query</span><span style="color: #007700">(</span><span style="color: #DD0000">'SELECT @@VERSION'</span><span style="color: #007700">);
</span><span style="color: #0000BB">$row </span><span style="color: #007700">= </span><span style="color: #0000BB">mssql_fetch_array</span><span style="color: #007700">(</span><span style="color: #0000BB">$version</span><span style="color: #007700">);
echo </span><span style="color: #0000BB">$row</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">];
</span><span style="color: #FF8000">// Clean up
</span><span style="color: #0000BB">mssql_free_result</span><span style="color: #007700">(</span><span style="color: #0000BB">$version</span><span style="color: #007700">);</span></span></code></p><p>
로그인 후 평가할 수 있습니다
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인