Jump to content

MySQL Frontend Software


sentinel

Recommended Posts

I've been teaching myself PHP/MySQL, and this weekend I wrote a conference registration system for this organization I work for. (ok maybe calling it a 'system' is too much, it's just a webform which writes the input to a table in a MySQL DB and emails it to someone)

Anyways, the only way I have to access the DB is through a phpMyAdmin. That's fine for me, but it's not as useful the office workers who will actually be using the system.

Anyways, I was wondering if anyone could suggest some free, user friendly software to connect to a MySQL DB to make the data more accessable and usable?

Alternatively, has anyone had experience linking Excel to MySQL with an ODBC driver or something? This would probably be ideal.

Thanks

Link to comment
Share on other sites

There's always MySQL Administrator...

http://www.mysql.com/products/tools/administrator/

It's not really built for this sort of thing though.

What exactly do the office workers need to do with database?

You've coded a form that inserts data into the database, so why not code a page that takes information out of the database for the office workers to use?

It wouldn't be too much harder than making the form and the code to insert data, and it could be tailored to your exact needs :)

As for transfering the data to Excell, I think one of the easiest ways to do it would be to write some code that takes data from the database, and outputs it to a CSV file that can then be imported into excell.

Link to comment
Share on other sites

some good tips

I thought about doing the csv thing or just having them copy/paste it in excel, but then if there's a new entry, the file wouldn't be current unless they manually update it. It seems to me that it could be much more automated than this.

Thinking about it more, I think I would be happy to have something where they could choose from a selection of pre-made queries to run on the data. Like if they wanted to print out the list, change a feild on an individual entry, print mailing labels, see basic calculations and statistics, etc.

I suppose I could build this on a web page, but I don't have a login system set up and I don't want to leave this open. I'd prefer to have something either under the authentication that phpMyAdmin has, or even have the db login information stored on their workstations.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...