Solved

MySQL backend - what should be front end?

Posted on 2016-10-04
8
63 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
  • 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 42

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 83

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
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 

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 83

Accepted Solution

by:
Dave Baldwin earned 250 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 42

Assisted Solution

by:zephyr_hex (Megan)
zephyr_hex (Megan) earned 250 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
 

Author Comment

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

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Suggested Solutions

More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

831 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