• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 104
  • Last Modified:

MySQL backend - what should be front end?

I have to create a new application to manage a mysql-based database which is browser-based.
I have no idea where to start.  I don't whether to investigate Java, javascript, PHP, Ruby on Rails, what.  
I need to it be completely browser-based without special need for users to load any software (otherwise, I'd just use an access front end).
This is new terrority for me - any general ideas?
0
Keyboard Cowboy
Asked:
Keyboard Cowboy
  • 2
  • 2
  • 2
  • +2
2 Solutions
 
SoLostCommented:
Using MySQL's vast range of connectors MySQL can be used by just about any language that you want.

First you need to ask yourself a few questions.

Do you already have any experience developing web sites/pages?  If so, I'd try to stick to what you already know.

Do you already have a web server that this web interface will run on?  If you do this may also limit which language to use.

Most people that I know developing web sites these days are usually in ASP.NET or php.
0
 
zephyr_hex (Megan)DeveloperCommented:
You will need a server side language.  JavaScript / HTML are client side, and can be used in conjunction with a server side language.

I would recommend that you go with something that's well documented.  PHP is one of the most popular server side languages, so you'll easily be able to find tutorials, etc.  But you should also consider what your requirements are for a web server because the server side language you choose may depend on what your web server requirements are.
0
 
Dave BaldwinFixer of ProblemsCommented:
I recommend PHP also.  It's what I use and there are a lot of code examples available and some are even good examples.  

Reference page: http://php.net/manual/en/book.mysqli.php

Book: PHP & MySQL: Novice to Ninja http://shop.oreilly.com/product/9780994346988.do
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Keyboard CowboyAuthor Commented:
Thanks everyone - What would I author the screens in - is there a particular editor or does PHP drive the screens through some of mechanism.

just looking up tutorials on PHP now.
0
 
Dave BaldwinFixer of ProblemsCommented:
There are several IDEs for PHP, PHPStorm is the most recommended.  I use a code editor called HTML-Kit myself.
0
 
zephyr_hex (Megan)DeveloperCommented:
I've also heard recommendations for PHPStorm.  I use NetBeans because it supports more than PHP.
0
 
Brian TaoSenior Business Solutions ConsultantCommented:
Although this question is closed, here's one more comment for you.
By looking at your question description, it seems that you're asked to provide a web-based MySQL user interface in your company or to your customer.
Do you have to literally "build" (or write) it? Or it's just a requirement to have such user interface?
If the former, the comments above from other experts are the way to go; but if the latter, try phpMyAdmin (It is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. official website: https://www.phpmyadmin.net/).  It probably has everything you need.
0
 
Keyboard CowboyAuthor Commented:
I'll check it out - thanks!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now