|
|
Posted by rcnews on 08/09/06 15:01
Thanks for all the responses.
It sounds like Microsoft Access is not a favorite among programmers
here. But I'm afraid I'm stuck with it (for now at least), since our
company has been using it for about 4 years and we don't have the
resources/time right now to switch over to another system (though I
like Dikkie Dik's advice of a progressive transfer).
That being said, I'm actually wondering if PHP is the best language to
use for connecting our Access database to the website based on your
comments? What I know is that we're currently using PHP (written by
another technician) to have our website forms filter data into email
accounts, so that the data can be manually entered later on in Access.
You say it's possible, Kasper, to combine Access and PHP, but not that
common. So maybe the best thing is to switch to another database
system. At the same time, I don't fully understand some of your
suggestions. For example, are softwares like SQLite or MySQL a
replacement for your Microsoft Access database, or are they associate
programs to help connect your existing databases to your website? The
idea of transferring our existing data into another software seems
rather daunting.
I hope you understand what I'm getting at.
your student,
Ross
Kasper Johansen wrote:
> Miguel Cruz skrev:
> > You can do it with ODBC. Are you confident that Access can handle the
> > load, though?
>
> Access can be pretty tough... But any I agree with Miguel. You should
> try some of the alternatives like SQLite or something. SQLite will work
> on many other platforms than just Windows (even though you can get
> Access working on Linux, it isnt something that it is fun, and most
> users wont even bother going through the trouble for something like Access).
>
> You wont find many guides on how to work with Access and PHP, though it
> is totally possible.
>
>
> If you decide to work with Access anyway, here is what you will have to
> do in Windows.
>
> 1. Go to the control panel @ Windows.
> 2. Go to administration.
> 3. Go to Data Sources (ODBC) (I think that is what it is called).
> 4. Click on "System-DSN".
> 5. Click "Add".
> 6. Choose "Microsoft Access Driver (*.mdb)"
> 7. Choose a name-id for the connection (something simple like "myaccess").
> 8. Click "Choose" and choose the access database, that the connection
> should work with.
>
>
> Now you make a testing PHP-document to test the actual connection.
>
> Write something like:
> <?
> $conn = odbc_connect("myacces");
>
> $f_test = odbc_exec($conn, "SELECT * FROM testtable") or
> die(odbc_errormsg($conn));
> while($d_test = odbc_fetch_array($f_test){
> print_r($d_test);
> }
> ?>
>
>
> Be aware, that you should create "testtable" and fill it with somedata,
> so that PHP will print something :)
>
> I havent testet any of the code.
>
> --
> Best regards and good luck
> Kasper Johansen aka knj
Navigation:
[Reply to this message]
|