PHP学习笔记：COM应用

adodb应用:

<?php
$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条记录<br>";
for ($i = 0;$i < $num_columns;$i++){
 $fld[$i] = $rs->fields($i);
}
$rowcount = 0;
while (!$rs->eof){
 for ($i=0;$i<$num_columns;$i++){
  echo $fld[$i]->value . "/t";  ///t为tab键
 }
 echo "<br><br>";
 $rowcount++;   //rowcount递增
 $rs->movenext();
}
$rs->close();
$conn->close();

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

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

调用word对象：

<?php
$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 ;
?>