try
{
$com = new COM("Adodb.Connection");
$com->open("Driver={SQL Server};server=(local);uid=sa;pwd=*****;database=*****;");
}
catch(com_exception $e)
{
die($e->getMessage());
}
try
{
$rs = new COM("Adodb.RecordSet");
$rs->open("select * from user_list",$com,1,1);
}
catch(com_exception $e)
{
die($e->getMessage());
}
$AllCount = $rs->RecordCount;
for($i=1;$i<$AllCount;$i++)
{
echo($rs["u_id"]->value."
");
$rs->MoveNext();
}
$rs->Close();
$rs = null;
$com->Close();
$com = null;
?>
呵呵,随便写了点代码,测试了一下,速度还行
{
$com = new COM("Adodb.Connection");
$com->open("Driver={SQL Server};server=(local);uid=sa;pwd=*****;database=*****;");
}
catch(com_exception $e)
{
die($e->getMessage());
}
try
{
$rs = new COM("Adodb.RecordSet");
$rs->open("select * from user_list",$com,1,1);
}
catch(com_exception $e)
{
die($e->getMessage());
}
$AllCount = $rs->RecordCount;
for($i=1;$i<$AllCount;$i++)
{
echo($rs["u_id"]->value."
");
$rs->MoveNext();
}
$rs->Close();
$rs = null;
$com->Close();
$com = null;
?>
呵呵,随便写了点代码,测试了一下,速度还行