Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

MySQL backend - what should be front end?

Posted on 2016-10-04
8
Medium Priority
?
97 Views
Last Modified: 2016-10-05
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
Comment
Question by:Keyboard Cowboy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
  • +2
8 Comments
 
LVL 5

Expert Comment

by:SoLost
ID: 41828725
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
 
LVL 44

Expert Comment

by:zephyr_hex (Megan)
ID: 41828746
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
 
LVL 84

Expert Comment

by:Dave Baldwin
ID: 41828758
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
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
LVL 1

Author Comment

by:Keyboard Cowboy
ID: 41830347
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
 
LVL 84

Accepted Solution

by:
Dave Baldwin earned 1000 total points
ID: 41830383
There are several IDEs for PHP, PHPStorm is the most recommended.  I use a code editor called HTML-Kit myself.
0
 
LVL 44

Assisted Solution

by:zephyr_hex (Megan)
zephyr_hex (Megan) earned 1000 total points
ID: 41830425
I've also heard recommendations for PHPStorm.  I use NetBeans because it supports more than PHP.
0
 
LVL 9

Expert Comment

by:Brian Tao
ID: 41830445
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
 
LVL 1

Author Comment

by:Keyboard Cowboy
ID: 41830458
I'll check it out - thanks!
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

604 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question