New complex website

Please know where I am starting;  I am a windows sys admin.  I have run and maintained several websites that are simple, html.  I have minor experience with perl, asp and php.  I have separate experience with DB's as well, but very little with mysql.
   I now want to make a more complicated website, but I am not sure what questions I should be researching, process, or tools that might help.
   The website will be a pay to register or subscription based.  The website will maintain a DB of information on each user, and run queries to match information.  Now that I think about it, kind a like a dating website.  Two users login, enter a bunch of info, and then a search will find matches.

So where do I start????
I have never done a login website.  I am not sure how to right a website that will use functions to query a DB or even populate it.  I need to know if there are any good tools I can use, and what I should be researching.  So simple links would be awesome.

Thank you all!
LVL 11
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

For me the most natural choice is a LAMP stack (Linux, apache, mysql, php) which also is the most populate configuration on the internet which makes getting support easy.  

I don'r know if you have used object oriented programming, PHP supports both older procedural programming and OOP, and the two can be used together.  mysql uses a syntax the is pretty much standard SQL that is quite intuitive, and php and mysql merge very well in scripts for db operations, with common formats, structures and objects.

Mysql can also be managed using myphpadmin, so you don't need to do everything with scripts. as a windows admin you may favor using asp, or .net and certainly those are options, but the support os narrower, because they are not open source and have a much smaller installed base.

One of the things you can do to learn the server side is download and install wampserver which will let you set up a fully functional server environment using apache, php, and mysql along with phpmy admin.  That will make learning a lot easier and quicker.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jason C. LevineDon't talk to me.Commented:
Are you certain you want to write this from the ground up?
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development

From novice to tech pro — start learning today.