Ch5(ms access with php)

How to connect to MS Access. PHP
and ODBC

// Microsoft Access
• $connection = odbc_connect("Driver={Microsoft Access Driver (*.mdb)};Dbq=FileN
ame“[, $user, $password]);

EX: INSERT DATA
<?php
$db = realpath("./db1.mdb");
$conn = new COM('ADODB.Connection');
$conn->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=$db");
$insert = "insert into tbProduct(ProductID, ProName, Quantity, UnitPrice) values(1, 'cc', 2,4)";
$res = $conn->Execute($insert);?>
EX: DELETE
<?php
$delete = "DELETE FROM tbProduct WHERE ProductID=4";
$res = $conn->Execute($delete);
?>
EX: UPDATE
<?php
$update = "UPDATE tbProduct SET ProName='dddd', Quantity=34, UnitPrice=5 WHERE
ProductID=1";
$res = $conn->Execute($update);
?>

EX:
<?php
$db_conn = new COM("ADODB.Connection");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("./db1.mdb").";";
$db_conn->open($connstr);
$rS = $db_conn->execute("SELECT * FROM tbProduct");
$f1 = $rS->Fields(0);
$f2 = $rS->Fields(1); //$rs->Fields['ProName']->Value
$f3= $rS->Fields(2);
$f4= $rS->Fields(3);
$st="<table
border=1><tr><th>ProID</th><th>ProName</th><th>Quantity</th><th>UnitPrice</th><th>Tot
al</th></tr>";
while (!$rS->EOF) {
$st.="<tr><td>" . $f1->value . "</td><td>" . $f2->value . "</td><td>" . $f3->value .
"</td><td>" . $f4->value . "$</td><td>" . ($f4->value)*($f3->value) . "$</td></tr>";
$rS->MoveNext();
}
$st.="</table>";
print $st;
$rS->Close();
$db_conn->Close();
?>

• It is easy if you run Web Server on Widows PC.
• Windows 2000, XP, Vista ODBC located inside Administrative Tools folder. Double
click ODBC Data Sources. ODBC Data Source Administrator window displays.

EX:
<?php
$conn=odbc_connect("dbProduct","" ,"");
print('<body>');
print('<table align="center" width="90%" border=1>');
print('<tr><th>ProductID</th><th>ProductName</th><th>Quantity</th><th>UnitPrice</th><th
>Total</th></tr>');
if($conn)
{
$sql="select * from tbProduct";
$row=odbc_exec($conn, $sql);
while(odbc_fetch_row($row)){
$proID=odbc_result($row,1);
$proName=odbc_result($row,2);
$quantity=odbc_result($row,3);
$unitPrice=odbc_result($row,4);
print('<tr><td>'.$proID.'</td><td>'. $proName.'</td><td>'.$quantity.'</td><td>' . $unitPrice .
'$</td><td>' . $unitPrice*$quantity . '$</td></tr>');}}
print('</table>');
print('</body>');
print('</html>');
?>

Ch5(ms access with php)

More Related Content

What's hot

Viewers also liked

Similar to Ch5(ms access with php)

More from Chhom Karath

Recently uploaded

Ch5(ms access with php)

Editor's Notes