Solved

MySQL backend - what should be front end?

Posted on 2016-10-04
8
69 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 43

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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

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 43

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Foreword This article was written many years ago, in the days when PHP supported the MySQL extension (http://php.net/manual/en/function.mysql-connect.php).  Today (http://php.net/manual/en/migration70.removed-exts-sapis.php) you would not use MySQL…
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…

829 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