$dbc = new COM("ADODB.Connection");
$dbc->Provider = "MSDASQL";
$dbc->Open("icqdb");
//$rs = $dbc->Execute("select * from icqusers_tb where uin <=1200 ORDER BY
uin"); //是查询
$rs = $dbc->Execute("UPDATE icqusers_tb SET name=nickname where uin
<=1200");
$rs = $dbc->Execute("UPDATE icqusers_tb SET email=uin where uin <=1200");
$rs = $dbc->Execute("UPDATE icqusers_tb SET email=email+'@cqgs.mail' where
uin <=1200"); url:http://www.hrbs.net/php/brightsunbbs/showthread.php?
threadid=996我没实际用过,希望上面的代码对你有用
$dbc->Provider = "MSDASQL";
$dbc->Open("icqdb");
//$rs = $dbc->Execute("select * from icqusers_tb where uin <=1200 ORDER BY
uin"); //是查询
$rs = $dbc->Execute("UPDATE icqusers_tb SET name=nickname where uin
<=1200");
$rs = $dbc->Execute("UPDATE icqusers_tb SET email=uin where uin <=1200");
$rs = $dbc->Execute("UPDATE icqusers_tb SET email=email+'@cqgs.mail' where
uin <=1200"); url:http://www.hrbs.net/php/brightsunbbs/showthread.php?
threadid=996我没实际用过,希望上面的代码对你有用
现在控制面板里面建好odbc数据源
然后用
$db=odbc_connect("数据源名","","");
就好了
<?php
$conn = odbc_connect("WebDB", "", "");
$query = "select user, idno ";
$query .= "from userinfo";
$result_id = odbc_do($conn, $query);
while(odbc_fatch_row($result_id)) {
$user = odbc_result($result_id, 1);
$idno = odbc_result($result_id, 2);
echo $user."的身份证字号为".$idno."<br>\n";
}
odbc_close($conn);
?>
//這段代碼可以用:
$dbc = new COM("ADODB.Connection");
$dbc->Provider = "MSDASQL";
$dbc->Open("dbTEST");
$rs = $dbc->Execute("select * from TABLE1");
$i = 0;
while (!$rs->EOF) {
$i += 1;
$fld0 = $rs->Fields(0);
$fld1 = $rs->Fields(1);
$fld2 = $rs->Fields(2);
print "$fld0->value $fld1->value $fld2->value<BR>";
$rs->MoveNext();
}
$rs->Close();
?>
<?php
$conn = odbc_connect("WebDB", "", "");
$query = "select user, idno ";
$query .= "from userinfo";
$result_id = odbc_do($conn, $query);
while(odbc_fatch_row($result_id)) {
$user = odbc_result($result_id, 1);
$idno = odbc_result($result_id, 2);
echo $user."的身份证字号为".$idno."<br>\n";
}
odbc_close($conn);
?>
推荐使用:ADOdb
关键是给出了统一的访问方式,而且支持数据缓冲.
http://php.weblogs.com
include('tohtml.inc.php'); // load code common to ADODB
include('adodb.inc.php'); // load code common to ADODB
$conn = &ADONewConnection('ado_access'); // create a connection
//ms access ("access" or "ado_access")
$conn->PConnect('ggsaddon');// connect to dsn name
$sql = 'select EmployeeName, EmployeeCode from Employee';
$rs = $conn->Execute($sql);
rs2html($rs,'border=2 cellpadding=3',array('Employee Name','Employee ID'));
$rs->Close(); // optional
$conn->Close(); // optional
?>