|
|
Posted by Michael Vilain on 08/09/06 17:24
Currently, you're restricted to only running your web server, php, and
Access through ODBC and the COM object on a Windows box because Access
only runs on Windows.
You could "add a translation layer" where the web site's data is input
into a suitable database (MySQL, SQLite, or Postgres), then run a
periodic "extract" to transfer the data to Access. This way if someone
does any sort of database injection exploit, you'll have a layer between
the actual business data in Access and the web. You currently do this
now with the manual data entry; it will just be easier.
In article <1155135709.072707.187900@75g2000cwc.googlegroups.com>,
rcnews@gmail.com wrote:
> 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
--
DeeDee, don't press that button! DeeDee! NO! Dee...
Navigation:
[Reply to this message]
|