通过ODBC连接的SQL SERVER实例

通过odbc连接的sql rver实例一

<?

$connection = odbc_connect(“mydata”,”urid”,”passwd”);

$query = “lect * from tab_1 whereno>0” ;

$re教师节祝福贺卡sult = odbc_do($connection,$query) ;

print “<table border=’1′ width=’100%’ id=’tab1′ cellpadding=̵人事任命书模板7;1′ cellspacing=’0′align=’top’ 最有效减肥药排行榜bordercolorlight=’#008000′ bordercolordar资治通鉴原文k=’#008000′>”;

while(odbc_fetch_into($result,&$fields))

{

print “<tr>\nR苏州理工大学21;;

for ($i = 21; $i <= 31 ; $i ++){

print “<td width=’6%’><input style=’background-color: #ffffff; border-bottom: #000000 1px solid; border-left: #ffffff 1px solid; border-right: #ffffff 1px solid; border-top: #ffffff1px solid; border-bottom: #ffffff 1px solid; color: #000000; font-size: 9pt’size=’7′ type=’text’name=text$i value=$temp>”;

}

}

print “</table>”;

odbc_clo($connection);

?>