<style type= "Text/css" >
Input {font-family: "Verdana"; font-size: "11px"; Background-color: "#FFFFFF"; Height: "18px"; border: "1px solid #666666";}
</style>
<?php
mssql.php
$host = "localhost";
$user = "sa";
$password = "";
$db = "Kao"; error_reporting (7);
if (! $sql) $sql = "SELECT @ @VERSION";
echo "<form action=\" \ "method=\" post\ ">";
echo "SQL Query: <input type=\" text\ "value=\". $sql. " \ "Size=\" 120\ "name=\" sql\ ">";
echo "<input type=\" submit\ "name=\" next\ "value=\" submitted \ ">";
echo "</form>";
$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 connection to Access database code
?
$dbc =new com ("adodb.connection");
$dbc. Open ("Driver=microsoft Access Driver (*.mdb);d bq=c:\member.mdb");
$rs = $dbc->execute ("SELECT * FROM TableName");
$i = 0;
while (! $rs->eof) {
$i +=1
$FLD 0= $rs->field (0);
$FLD 1= $rs->field (1);
....
echo "$fld 0->value $fld 1->value ...";
$rs->movenext ();
}
$rs->close ();
?>