<?php
$ListArr = array();
$conn = odbc_connect('dbserver', 'ID', 'PASSWORD');
if($conn){
$sql = "select top 10".PHP_EOL.
"m_code,m_id,convert(char(10),m_regdate,120) as m_regdate".PHP_EOL.
"from tbl_member".PHP_EOL.
"order by m_code desc".PHP_EOL;
$rs = odbc_exec($conn, $sql);
while (odbc_fetch_row($rs)){
array_push($ListArr,
array(
odbc_result($rs,"m_code"),
iconv('euc-kr','utf-8',odbc_result($rs,"m_id")),
odbc_result($rs,"m_regdate")
)
);
}
odbc_close($conn);
}
?>
<table border="1">
<thead><tr><th>CODE</th><th>ID</th><th>DATE</th></tr></thead>
<tbody>
<?php
if(count($ListArr)>0){
foreach($ListArr as $arr1){
echo "<tr><td>".$arr1[0]."</td><td>".$arr1[1]."</td><td>".$arr1[2]."</td></tr>";
}
}else{
echo "<tr><td colspan=\"3\" align=\"center\">No Exist</td></tr>";
}
?>
</tbody>
</table>
16. 10. 24.
PHP에서 ODBC 이용 MS-SQL 연동
피드 구독하기:
댓글 (Atom)
댓글 없음:
댓글 쓰기