|
 |
| |
หาตัฃวอย่างการใช้งาน PHP adodb ได้จากที่ไหนบ้างครับ |
| |
 |
|
|
 |
 |
|
List Record
========================================================
<html>
<head>
<title>ThaiCreate.Com PHP & COM (ADO)</title>
</head>
<body>
<?php
$strConn = new COM("ADODB.Connection") or die("Cannot start ADO");
$strConn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("mydatabase.mdb"));
$strSQL = "SELECT * FROM customer";
$objRec = $strConn->Execute($strSQL);
?>
<table width="600" border="1">
<tr>
<th width="91"> <div align="center">CustomerID </div></th>
<th width="98"> <div align="center">Name </div></th>
<th width="198"> <div align="center">Email </div></th>
<th width="97"> <div align="center">CountryCode </div></th>
<th width="59"> <div align="center">Budget </div></th>
<th width="71"> <div align="center">Used </div></th>
</tr>
<?
While (!$objRec->EOF)
{
?>
<tr>
<td><div align="center"><?=$objRec->Fields["CustomerID"]->Value;?></div></td>
<td><?=$objRec->Fields["Name"]->Value;?></td>
<td><?=$objRec->Fields["Email"]->Value;?></td>
<td><div align="center"><?=$objRec->Fields["CountryCode"]->Value;?></div></td>
<td align="right"><?=$objRec->Fields["Budget"]->Value;?></td>
<td align="right"><?=$objRec->Fields["Used"]->Value;?></td>
</tr>
<?
$objRec->MoveNext();
}
?>
</table>
<?
$objRec->Close();
$strConn->Close();
$strConn = null;
?>
</body>
</html>
Add Record
========================================================
<html>
<head>
<title>ThaiCreate.Com PHP & COM (ADO)</title>
</head>
<body>
<?
$strConn = new COM("ADODB.Connection") or die("Cannot start ADO");
$strConn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("mydatabase.mdb"));
$strSQL = "SELECT * FROM customer WHERE CustomerID = '".$_POST["txtCustomerID"]."' ";
$objRec = $strConn->Execute($strSQL);
if(!$objRec->EOF)
{
echo("CustomerID already exist.");
}
else
{
$strSQL = "";
$strSQL .= "INSERT INTO customer ";
$strSQL .= "(CustomerID,Name,Email,CountryCode,Budget,Used) ";
$strSQL .= "VALUES ";
$strSQL .= "('".$_POST["txtCustomerID"]."','".$_POST["txtName"]."','".$_POST["txtEmail"]."' ";
$strSQL .= ",'".$_POST["txtCountryCode"]."','".$_POST["txtBudget"]."','".$_POST["txtUsed"]."') ";
$flgSave = $strConn->Execute($strSQL);
If($flgSave)
{
echo("Save Done.");
}
else
{
echo("Error Save");
}
}
$objRec->Close();
$strConn->Close();
$strConn = null;
?>
</body>
</html>
Delete Record
========================================================
<html>
<head>
<title>ThaiCreate.Com PHP & COM (ADO)</title>
</head>
<body>
<?
$strConn = new COM("ADODB.Connection") or die("Cannot start ADO");
$strConn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("mydatabase.mdb"));
$strSQL = "";
$strSQL .="DELETE FROM customer ";
$strSQL .="WHERE CustomerID = '".$_GET["CusID"]."' ";
$flgDelete = $strConn->Execute($strSQL);
If($flgDelete)
{
echo("Record Deleted.");
}
else
{
echo("Error Delete [".$strSQL."]");
}
$strConn->Close();
$strConn = null;
?>
</body>
</html>
|
 |
 |
 |
 |
| Date :
21 ต.ค. 2551 13:09:26 |
By :
@W_IN |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
PHP AdoDB
|
| |
|
|
| |
| Date :
2009-04-25 19:09:41 |
By :
webmaster |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
 Load balance : Server 02
|
