Solved

Develop webapp with MS SQL or MySQL with clean interface

Posted on 2014-09-08
10
257 Views
Last Modified: 2014-09-13
Hello,

I currently develop using ASP (classic) and MS SQL as backend. For as much as I want the site to look clean it has certain limits it seems to me.
As compared to how other applications I have seen around like:

https://www.mindbodyonline.com/
http://www.zendesk.com/

The interface is gorgeous and clean, almost like a wordpress website. Only has a database backend ...

I am thinking of learning either ASP.net or PHP, but I am not sure if PHP will allow me to develop an application that will have that look and feel or if there is some other tool that would allow me to do so ?  

What do people use to develop wordpress sites and apps ?   I am sorry if I sound like a beginner but outside the classic ASP/SQL environment I am not too saavy.  
I use Dreamweaver CC which allows to develop using PHP but not sure if by using DW as my tool I can do web apps like the ones I mentioned.

Any help is greatly appreciated.
0
Comment
Question by:amucinobluedot
[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
  • 4
  • 4
  • 2
10 Comments
 
LVL 70

Assisted Solution

by:Jason C. Levine
Jason C. Levine earned 167 total points
ID: 40310031
PHP is a server-side script.  Look and feel are front-end things handled by HTML, CSS, and JavaScript.  To the extent PHP or .Net is involved, it's to store user preferences or previous choices and output the desired text or page accordingly.

WordPress is built with PHP but also makes heavy use of JavaScript, including JQuery.  Themes can call even more JavaScript depending on needs and design philosophy. Dreamweaver is simply an IDE and can be used to edit your files but it's not going to make you a better designer.
0
 

Author Comment

by:amucinobluedot
ID: 40310053
What is used to develop applications with that look and feel ?
0
 
LVL 70

Assisted Solution

by:Jason C. Levine
Jason C. Levine earned 167 total points
ID: 40310067
HTML, CSS, and JavaScript in the hands of skilled professionals.

If you want to see which common libraries or frameworks are referenced, you can always use Built With.

http://builtwith.com/
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 110

Accepted Solution

by:
Ray Paseur earned 333 total points
ID: 40310311
Might be worth mentioning that Facebook is a PHP machine, too.  If you want some getting-started resources for PHP, this article can help.
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/A_11769-And-by-the-way-I-am-new-to-PHP.html

And if you want to get started on the right foot, avoid the antipatterns and antipractices noted here.
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/A_12293-AntiPHPatterns-and-AntiPHPractices.html
0
 

Author Comment

by:amucinobluedot
ID: 40310618
Those are great resources thank you.  Say I learn how to use PHP. Which seems the way to go at this point. Is there a way to use PHP with MS SQL Database ?  I can only find a way to connect to MySQL which is not as robust.
And I don't think DWCC supports a design like the ones I sent. What do designers use for creating Wordpress sites ?  I know those are also PHP with MySQL backends.
0
 
LVL 110

Assisted Solution

by:Ray Paseur
Ray Paseur earned 333 total points
ID: 40310757
Yes, PHP supports MSSQL.  
http://www.php.net/manual/en/book.mssql.php

But I would choose MySQL over MSSQL if you're going to use PHP.
http://www.php.net/manual/en/book.mysqli.php

And before you mistake MySQL for something less than robust, consider that Facebook is a PHP + MySQL machine.  MySQL gets 70,000 downloads a day and is embedded in over 12,000,000 installations, including every WordPress site on earth.  If MySQL were not "robust" it would never have enjoyed that kind of popularity.
0
 

Author Comment

by:amucinobluedot
ID: 40310817
True ... I just downloaded a good DB Manager for MySQL ... so ... Ill start playing with it.
I am still to find a good designer for making my site look and feel like the links above.
Would DW CC have that sort of templates ?  to make them look and feel like wordpress sites ?
0
 
LVL 110

Assisted Solution

by:Ray Paseur
Ray Paseur earned 333 total points
ID: 40310923
DW might have templates you would like, but why not just use WordPress?  It has a database back end.  WordPress "look and feel" is developed through the use of Themes.  There are lots of Themes available - both free and paid - and you can build your own, too.
0
 

Author Comment

by:amucinobluedot
ID: 40310968
Yes, but How can I modify a theme to use it for my web application ?
It can be customized through their interface. Which tool can be used to create Wordpress templates so that they can be modified ?
0
 
LVL 110

Assisted Solution

by:Ray Paseur
Ray Paseur earned 333 total points
ID: 40311042
You're at the threshold of a substantial learning curve, no matter what path you pursue.  There are several good books about WordPress on Amazon.com and the community has reviewed them so you can see which books are the best respected.  A Google search for "Learn WordPress" will turn up links like these.  
http://learn.wordpress.com/
http://codex.wordpress.org/New_To_WordPress_-_Where_to_Start
https://managewp.com/learning-wordpress

Please understand that the questions you're asking will require weeks if not months of study before you will be able to understand the answers.  In respect of your time, you might want to think about hiring a professional developer.  You will get good results much faster that way.
0

Featured Post

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

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

Creating and Managing Databases with phpMyAdmin in cPanel.
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…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.

738 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