PHP学习笔记：COM应用

笔记

ADODB应用:

$conn = new COM("ADODB.Connection");
$conn->Open("Provider = Microsoft.JET.OLEDB.4.0;Data source=D:\usr\www\html\data.mdb");  //ACCESS
//$conn->Open("Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=database;User ID=user;Password=password:)";  //SQL
$rs = $conn->Execute("select * from Spzs");

$num_columns = $rs->Fields->Count();
echo $num_columns . "\n条记录
";
for ($i = 0;$i  $fld[$i] = $rs->Fields($i);
}
$rowcount = 0;
while (!$rs->EOF){
 for ($i=0;$i  echo $fld[$i]->value . "\t";  //\t为TAB键
 }
 echo "

";
 $rowcount++;   //rowcount递增
 $rs->MoveNext();
}
$rs->Close();
$conn->Close();

$rs->Release();
$conn->Release();

$rs = null;
$conn = null;
?>

调用WORD对象：

$word = new COM("word.application") or die ("Canot start Microsoft Word");
print "Loaded Word version ($word->Version)\n";
$word->visible = 1;  //将其置前
$word->Documents->Add(); //打开一个新文档

//随便做些事情
$word->Selection->Typetext("This is a test");
$word->Documents[1]->SaveAs("Useless test.doc");
$word->Quit(); //关闭WORD
//释放对象
$word->Release();
$word = null ;
?>