通过ODBC连接的SQL SERVER实例一

<?

$connection = odbc_connect("mydata","userid","passwd");

$query = "select * from tab_1 whereno>0" ;

$result = odbc_do($connection,$query) ;

print "<table border='1' width='100%' id='tab1' cellPadding='1' cellSpacing='0'align='top' bordercolorlight='#008000' bordercolordark='#008000'>";

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

{

print "<tr>n";

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

print "<td width='6%'><inputsize='7' type='text'name=text$i value=$temp>";

}

}

print "</table>";

odbc_close($connection);

?>