Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Suggest HOWTO

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 20th September 2012, 21:07
PRO_wannabe PRO_wannabe is offline
Junior Member
 
Join Date: Sep 2012
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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

Last edited by PRO_wannabe; 20th September 2012 at 21:15.
Reply With Quote
Sponsored Links
  #2  
Old 21st September 2012, 17:45
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,721 Times in 2,562 Posts
Default

Something like phpMyAdmin?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 21st September 2012, 18:16
PRO_wannabe PRO_wannabe is offline
Junior Member
 
Join Date: Sep 2012
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #4  
Old 22nd September 2012, 10:35
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,721 Times in 2,562 Posts
Default

I guess you will have to program a suitable front-end yourself that fits your needs.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 7th October 2012, 00:33
MaddinXx MaddinXx is offline
Senior Member
 
Join Date: Jul 2011
Location: Switzerland
Posts: 197
Thanks: 25
Thanked 60 Times in 44 Posts
Default

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...
__________________
Rackster Internet Services's presences:
Official | Open Source | Github | Facebook | Twitter
Reply With Quote
  #6  
Old 7th October 2012, 09:26
TiTex TiTex is offline
Senior Member
 
Join Date: Aug 2011
Location: Cluj-Napoca,Romania
Posts: 125
Thanks: 0
Thanked 17 Times in 17 Posts
Send a message via Skype™ to TiTex
Default

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
Reply With Quote
  #7  
Old 7th October 2012, 11:35
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,721 Times in 2,562 Posts
Default

Instead of phpMyAdmin you could also try Chive: http://www.howtoforge.com/installing...in-alternative
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #8  
Old 8th October 2012, 15:30
PRO_wannabe PRO_wannabe is offline
Junior Member
 
Join Date: Sep 2012
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for each of your replies. I continue to evaluate your suggestions.
cheers,
Keith
Reply With Quote
  #9  
Old 10th October 2012, 08:39
Damieen Damieen is offline
Junior Member
 
Join Date: Sep 2012
Location: new york
Posts: 10
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Well , if you don't mind, may I know which programming language are you using for the back end ??
__________________
.
Reply With Quote
  #10  
Old 10th October 2012, 17:35
PRO_wannabe PRO_wannabe is offline
Junior Member
 
Join Date: Sep 2012
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

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
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail hold in Q fisherofer Installation/Configuration 1 5th February 2012 13:29
PDC_Samba_LDAP misterm Installation/Configuration 0 16th April 2010 13:45
LDAP tree population error ehpmail Installation/Configuration 0 5th February 2009 22:40
Mod_Perl Configuration Issue szise Installation/Configuration 4 28th November 2008 12:41
OpenLDAP + Samba Domain Controller On Ubuntu 7.10 bootzcat HOWTO-Related Questions 7 21st March 2008 15:31


All times are GMT +2. The time now is 12:16.


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