Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 phpMyAdmin connection to spreadsheet

Author  Topic 

jasonlive
Starting Member

1 Post

Posted - 2013-09-25 : 01:48:05
hi folks,

i have written a nice little php page that submits employee timesheets to a phpMyAdmin database. Currently the DB is stored on my Mac using MAMP with address localhost:8889. the username is root.
its all running great from php.

the long term goal is to have the database hosted online and i will need to connect to it from mac and windows machines.

for now my issue is i want to connect to the localhost db from libreoffice ( and excel from a windows machine) and be able to query to the spreadsheet.
i have no idea how to begin to do this. im getting asked all sorts of things like "datasource url" and "driver class". i have no idea how to fill in these fields. i have only a blank spreadsheet at the moment. is there a tutorial on this or any guidance somewhere!
   

- Advertisement -