mssql rs php 记录,操作mssql的php代码_php

input {font-family: "Verdana";font-size: "11px";BACKGROUND-COLOR: "#FFFFFF";height: "18px";border: "1px solid #666666";}

//mssql.php

$host="localhost";

http://www.gaodaima.com/46769.html操作mssql的php代码_php

$user="sa";

$password="";

$db="kao";error_reporting(7);

if(!$sql) $sql="select @@VERSION";

echo "

";

echo "SQL Query: ";

echo "";

echo "

";

$conn = new COM("ADODB.Connection") or die("Cannot start ADO");

$conn->Open("Provider=SQLOLEDB; Data Source=$host;

Initial Catalog=$db; User ID=$user; Password=$password");$rs = $conn->Execute($sql);

$num_columns = $rs->Fields->Count();

echo $num_columns . "/n";

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";

}

echo "/n";

$rowcount++;

$rs->MoveNext();

}$rs->Close();

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

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

$conn = null;

?>

php与access数据库连接的代码

$dbc=new com("adodb.connection");

$dbc.open("driver=microsoft access driver (*.mdb);dbq=c:/member.mdb");

$rs=$dbc->execute("select * from tablename");

$i=0;

while (!$rs->eof){

$i+=1

$fld0=$rs->field(0);

$fld1=$rs->field(1);

....

echo "$fld0->value $fld1->value ....";

$rs->movenext();

}

$rs->close();

?>

欢迎大家阅读《操作mssql的php代码_php》,跪求各位点评,若觉得好的话请收藏本文，by 搞代码

原创文章，转载请注明： 转载自搞代码

微信 赏一包辣条吧~

支付宝 赏一听可乐吧~