通过ODBC连接的SQL SERVER实例

通过ODBC连接的SQL SERVER实例,通过ODBC连接的SQL SERVER实例

通过ODBC连接的SQLSERVER实例一

<?

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

$query = "select * from tab_1 where no0" ;

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

print "<table width="100%" cellPadding="1" cellSpacing="0" align="top" bordercolorlight="#008000" bordercolordark="#008000"";

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

{

print "<trn";

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

print "<td width="6%"<input size="7" type="text" name=text$i value=$temp";

}

}

print "</table";

odbc_close($connection);

?