Page 1 of 1

**SOLVED** - php and mysql or asp and sql server

Posted: Thu Jul 27, 2006 4:01 am
by mohson
Hi guys if you wanted to build a simple web application that would manage data and allows users to carryout out various tasks on data. what would you use to build this.

Seems a starnge questiong coming on to a php forum. BUT...

I used mysql and PHP........

I am told I could have used ASP.net and SQL server.

But why would you choose the php and mysql above the latter. I need to justify my choices or "technology decisions"

It would be useful to have your opinions and please any links to good articles relating to this subject.

Please feel free to air your views.

Posted: Thu Jul 27, 2006 8:48 am
by feyd
Whichever you:
  1. are most familiar with
  2. are most comfortable with
  3. find best fits the needs for you
  4. find best fits the needs for your client(s)
  5. find best fits the needs for your users
a and b are fairly common sense, while c through e can be difficult to figure out.

If you don't mind getting held into a server platform, ASP and SQL Server are certainly contenders. But if portability of the code to another server is more important, PHP and MySQL get an upper hand.

If you still can't decide from that, it's time to make a version and features list. This is a list of the features planned for each version of your application. Each feature gets some weight and a rough projected timeline. Then come the questions for each:
  1. What's the time required to build it?
  2. What's the benefit our users will get in return for that time investment?
  3. Is this feature possible with ASP?
  4. Is this feature possible with PHP?
  5. Are there any accessibility issues involved with this feature?
Then, finally, if the decision is still middle of the round, maybe you should do a preliminary build on both and see which one works better for your interests.

Posted: Thu Jul 27, 2006 9:22 am
by Chris Corbyn
PHP is both cheaper to run and works across platforms. ASP(.NET) requires a windows server to run which are not free. Some goes for MS SQL server.

I'm led to believe MySQL is faster too.

Posted: Thu Jul 27, 2006 9:34 am
by mohson
What about other view points like, amount of support available for the developer - php and mysql has more online support.

What about the fact that php mysql are free open source resources.

What about the rate at which php itself develops and introduces new functions

Would you consider these issues?

Actually looking at your post again I would say these are covered by points C and . Am I correct.

Servers isnt really an issue as the server platform is Unix and the system wont really be moved to another server.

Feaure list isnt an issue as all the basic features can be carried out in both.

Any more input feyd or anyone else?

Posted: Thu Jul 27, 2006 10:53 am
by mohson
Guys thanks for your tips. This is the sort of stuff im looking for

http://www.oracle.com/technology/pub/ar ... l_asp.html

and this

http://www.oreilly.com/pub/a/oreilly/as ... p_php.html