Accessing an MSAccess database using php

  • Resolved mikej999

    (@mikej999)


    3 years, 1 month ago

    I would like to upload an MSAccess database (.accdb) to my Bluehost website and access the data using php in order to display it in the web pages. Read only, not write. Can I connect directly to the file from php, or do I have to convert the data first?

    I have ploughed through documentation and tried things without success. The documentation seems to say that I have to convert the data into an ODBC database, but no matter which set of instructions I try to follow I get nowhere. It would be much easier to just upload the MSAccess file and access it directly, if that is possible.

Viewing 7 replies - 1 through 7 (of 7 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    3 years, 1 month ago

    Please explain how this ties to WordPress. Thanks.

    For what it’s worth, if you’re doing this with WP, figure out how to export your data from access in a way you can import in into MySQL. Then, you can use the database tools built into WP to access the table(s) you create via access.

    Thread Starter mikej999

    (@mikej999)

    3 years, 1 month ago

    Bluehost operates via WordPress, ie, a Bluehost website is a WordPress website (I get emails from WordPress notifying me of software updates). The WordPress blurb for these forums says they are for self-hosted and “Self-hosted WordPress requires purchasing hosting with another provider, such as Bluehost, …”. So I think I am in the right place.

    I have tried exporting from MSAccess into things like MySQL, but there seems to be endless software to download, and no matter what I try I never get there. Some of the answers on these forums on related topics seem to suggest that direct connection to MSAccess is possible, and that would (should!) be so much easier.

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    3 years, 1 month ago

    I think your question has a lot more to do with PHP than with WordPress. It would probably be better to post in more PHP-centric place like StackExchange.

    Thread Starter mikej999

    (@mikej999)

    3 years, 1 month ago

    Thanks, I’ll try there.

    You refer to “the database tools built into WP”. Are there any that I should be aware of, other than php itself?

    Moderator Yui

    (@fierevere)

    永子

    3 years, 1 month ago

    “alien” databases can be accessed with ODBC driver (its a PHP extension)

    Some documentation can be found using search terms
    PHP ODBC UnixODBC MSAccess

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    3 years, 1 month ago

    see https://developer.ww.wp.xz.cn/reference/classes/wpdb/

    Thread Starter mikej999

    (@mikej999)

    3 years, 1 month ago

    Many thanks for the replies. Hopefully I’ll get there, but it will take time so I’ll close this topic as ‘resolved’.

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘Accessing an MSAccess database using php’ is closed to new replies.