RE: [PHP] My boss wants to know...
| From: | John W. Holmes | Date: | Wed, 09 Oct 2002 22:51:31 +0000 |
| Subject: | RE: [PHP] My boss wants to know... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-119469@lists.php.net to get a copy of this message | ||
> Hi guys, got a tricky question here and I know I will probably get
> flamed for asking it here but here goes!
>
> My boss wants me to put a large Access database onto the net so that
> people can query it both from the company and from the outside and he
> wants to be able to have the database up to date and also easy to
> change.
>
> As far as I can see that leaves me with only Active Server Pages in
> which to access this database or am I wrong?
You can use PHP, of course. ODBC or COM.
Here is an example some program automatically created that shows how to
connect to and query an Access database:
$conn = new COM("ADODB.Connection") or die("Cannot start ADO");
$conn->Open("Driver={Microsoft Access Driver (*.mdb)};Dbq="
.realpath("datab/test.mdb"). ";Password=;");
$SQL="SELECT COUNT(*) AS Count FROM test";
$countx = 0;
$rs = $conn->Execute("$SQL");
while (!$rs->EOF) {
$countx = $rs->Fields("Count");
---John Holmes...