HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Suggest HOWTO (http://www.howtoforge.com/forums/forumdisplay.php?f=9)
-   -   Suggestion for Front End Gui for Database Entry (http://www.howtoforge.com/forums/showthread.php?t=58790)

PRO_wannabe 20th September 2012 21:07

Suggestion for Front End Gui for Database Entry
 
I was hoping someone could suggest a front end gui that would allow customer service reps to enter in to a database that would have already been created with mysql or some other open source database. I haven't actually created a database yet and was hoping for a suggestion on an easy to create and maintain program. The gui should also allow querying the database. Currently, we just enter data in to an excel spreadsheet which becomes long and tedious after a while.

appreciate any help,
thanks
Keith

falko 21st September 2012 17:45

Something like phpMyAdmin?

PRO_wannabe 21st September 2012 18:16

I appreciate the quick reply. I was afraid someone would come back with phpMyAdmin as a suggestion. I admit that I have perused this as a possibility for creating the database as admin. On first look it doesn't seem to lend itself for easily creating something to present to an end user unless I am greatly overlooking its abilities. Remember end users are usually not computer savvy and need something simple for data entry/querying a db. I will go back and look at phpMyAdmin but again I was hoping for something simple for my customer reps not for an admin.

thanks,
Keith

falko 22nd September 2012 10:35

I guess you will have to program a suitable front-end yourself that fits your needs.

MaddinXx 7th October 2012 00:33

I'm still not sure what you want, but I guess SQLBuddy could be for you:

http://sqlbuddy.com/

It's a very simple MySQL frontend like phpMyAdmin with limited functionality and only a single file.

Therefor, styling etc. can be done easily with HTML/CSS e.g. to hide irrelevant information.

Note that this project is no longer alive, but that doesn't mean it's bad...

TiTex 7th October 2012 09:26

if it doesn't need to be web based there are a lot of free tools out there that can query,update,export databases/tables some of them are very easy to use

falko 7th October 2012 11:35

Instead of phpMyAdmin you could also try Chive: http://www.howtoforge.com/installing...in-alternative

PRO_wannabe 8th October 2012 15:30

Thanks for each of your replies. I continue to evaluate your suggestions.
cheers,
Keith

Damieen 10th October 2012 08:39

Well , if you don't mind, may I know which programming language are you using for the back end ??

PRO_wannabe 10th October 2012 17:35

Currently, I don't have a backend (strictly computer speaking :-)) at current. This was just a project I was wanting to try so I haven't nailed anything down. I was just thinking it would be nice to have some gui frontend to be able to let a customer rep to be able to input/edit/view data in a database that is currently residing in long excel spreadsheets, even though the ability to quickly see all the information in the spreadsheet form is nice. I don't know if that kind of view is possible from a LAMP scenerio. I really don't have a good handle on programming at this time though I can definitely learn. I use to program many years ago back in the old days ie fortran, basic, rpg, prehistoric languages ;-)

Keith


All times are GMT +2. The time now is 13:24.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.