php连接access
$conn=new COM("ADODB.Connection");
$dsn="DRIVER={Microsoft Access Driver (*.mdb)};DBQ=".realpath("data.mdb").";Uid=Admin; Pwd=BDC2002Data;";
$conn->open($dsn);
$sql="select * from dict";
$rs=$conn->Execute($sql);
$row="0";
while(!$rs->EOF)
{
for ($i=0;$i<$rs->Fields->count;$i++)
{
if ($i==0)
{
$string.=$rs->Fields($i)->Value;
continue;
}
$string.='|'.$rs->Fields($i)->Value;
}
$string.="\n";
if ($row==300)
{
//break;
}
$row++;
$rs->MoveNext();
echo $string;
}
或者
//ODBC连接数据库
$cnx=odbc_connect("program","","");
if(!$cnx){
error_handler("ODBC_connect连接有错误",$cnx);
}
$cur=odbc_exec($cnx,"select * from diary");
if (!$cur){
error_hander("Odbc_exec运行有错,没有指针传回",$cur);
}
//取出成功的数据
$cur=odbc_exec($cnx,"select * from diary order by id desc");
while(odbc_fetch_row($cur))
{
$title=odbc_result($cur,2);
$id=odbc_result($cur
test.php -------------------------------------------------------------------------------------
echo $_SERVER['DOCUMENT_ROOT'].""; //获得服务器文档根
echo $_SERVER['PHP_SELF'].""; //获得执行该代码的文件服务器绝对路径
/*
php手册上的解释： “PHP_SELF” 当前正在执行脚本的文件名，与 docum ......
一个简单的例子读取CSV文件：
<?php
$handle=fopen("test.csv","r");
echo "<table border=2>";
//配合while循环读取文件
while($data=fgetcsv($handle,1024))
{
list($user,$pwd,$partment,$title)=$data;
echo "<tr>
<td>$user</td>
<td>$pwd< ......
