Hello, I am getting a couple of sites designed and I am wondering whether I should get it done in PHP or ASP?

What is the difference? why is one better than the other?

One person told me that ASP is better because SQL server is better than MySQL for the database aspect

I can get either a linux or windows server so it does not matter

please reply with your opinions...thanks!

I'd recommend that you stick with PHP and MySQL. This will ensure that your sites can be ported easily to other platforms if need be. It may not matter now, but there is nothing wrong with keeping your server options open.

You can connect to variety of databases with PHP. PHP is not limited only to MySQL, there are lots of supported databases.

I'd go with php. Asp is getting old, imo...

Also php will run on windows and linux and as mentioned, use a variety of databases, including sql server.

will php work with sql server? on a windows server? i was under the impression that it only works with linux servers?

also, how is mysql compared to sql server? which is better?

thanks

PHP works on a windows server. There is a windows binary you can d/l from PHP.Net and it's easy to install and configure. Below is a link which will give you the skinny on PHP and SQL Server.

http://builder.com.com/5100-6371-5160904.html

Hope this information helps.

Originally posted by ensol
will php work with sql server? on a windows server? i was under the impression that it only works with linux servers?

also, how is mysql compared to sql server? which is better?

thanks

For a website, mysql is perfectly fine. If you really plan to use some of the advanced features of sql server (esp with 2005) i'd suggest .net on a windows server, but if you are like most people and just need some dynamic data, there is no reason mySQL won't work. PHP is fast, there is a lot of free code out there and lots of CMS, forums, etc.. so if this is all you are thinking of, then go ahead and stick with php/mysql ...

is there anything sql server can do that mysql cant

Originally posted by ensol
is there anything sql server can do that mysql cant

Lots. MySQL5 is about where sql server 2000 is. But not as powerful as sql server 2005. But what are you planning on using this for? Unless you plan on using stored procedures or xml databases within fields, I don't see why mysql won't work?

I moved from ASP to MySQL because of the database end. I had outgrown Access and we couldn't afford SQL Server. Since that time I prefer working in PHP, I have used PHP with postgres & mysql and I've never missed anything from ASP.

In the end I guess you could try to use either one if you have the funds. PHP is going to be more open, available on many more servers, and I just don't see what you'd be missing.

Then again, I've never used SQL server.

MySQl is very fast.

If you want to use some of the more advanced features like views, stored procedures and triggers that you find in sql servver etc then you would probably want to use mysql5.

Look at it this way -- do you really care what language the site is written if it does what it is supposed to do?

Unless you are the programmer; the language differences between PHP and ASP (or PHP and anything else) do not matter to you. As a person who is paying for the site, make sure your requirements are clearly defined ... very clearly defined and then see what kind of solution a company or person can provide for you.

Frankly speaking, the only thing you should be concerned about is defining the requirements of your project, a budget, and then talking to qualified providers. Leave this MyLanguage vs. YourLanguage to the people that have the time to argue over such things. You really will not get much in terms of unbiased advice here, as people are very loyal to their chosen platform.

As I said, do you really care about what language or database or server your site runs on, as long as it does what its supposed to do?

Originally posted by fyrestrtr
Look at it this way -- do you really care what language the site is written if it does what it is supposed to do?

Unless you are the programmer; the language differences between PHP and ASP (or PHP and anything else) do not matter to you. As a person who is paying for the site, make sure your requirements are clearly defined ... very clearly defined and then see what kind of solution a company or person can provide for you.

Frankly speaking, the only thing you should be concerned about is defining the requirements of your project, a budget, and then talking to qualified providers. Leave this MyLanguage vs. YourLanguage to the people that have the time to argue over such things. You really will not get much in terms of unbiased advice here, as people are very loyal to their chosen platform.

As I said, do you really care about what language or database or server your site runs on, as long as it does what its supposed to do?

I can't agree with this. I mean when you're talking about licensing fees, application portability, and availability of a work force to be able to assist in making changes/updates to a project I think you need to be very concerned in what db or language is used to build the application.

The first time you try to install your app on some other webhost and realize you have to spend more $$ per month in order to get a windows shared host it's going to matter. (as one example)

php and mysql is better coz they are free and easily portable to other platforms, and could also say high secure than asp in some cases.

if u use php the client can get support from others even if u r support is offline from other sites,

developing sites in php could be usefull for later with intergation with other application.

so better go with php and db which ever u want.

Here is my opinion only:

PHP vs ASP:
---------------

1- The fact is, ASP IS OUTDATED!
2- There is many times more existing PHP code out there then ASP Code. Don't believe me? Just take a look at hotscripts and compare.
3- PHP is FREE!
4- PHP is Cross Platform, while running ASP on Linux is a major headache (running ASP on any platform is a major headache, even on a windows server, but at least it was designed for windows servers :stickout: )
5- Personally, for me PHP seemed like the next logical step after doing CGI/Perl for a while, since they are close to eachother.

PHP is faster.
PHP is open source.
PHP is free.
PHP ain't Microsoft.

Regards,

G

Originally posted by Googled
1.PHP is faster.
2.PHP is open source.
3.PHP is free.
4.PHP ain't Microsoft.

Regards,

G

Do you have any proof for 1?

ASP is also free, negating 3.

2 and 4 have absolutely no relevance.

Please get your facts straight before you blindly bash something.

Hi,

thanks for being rude, it's really appreciated.

You may take a look here:

http://www.phpbuddy.com/sub_articles.php?other_articles=9

1, 2, 3 and 4 are explain for people who do not understand what it implies.

No relevance for you doesn't mean it isn't for others, you're not the center of the universe..

I agree with fyrestrtr.

If you're a programmer, it doesn't really matter which programming language to use. You should make a decision based on the project requirements / development time / performance.

null

One thing.... EVERYONE has just ASSUMED the orginal post MEANT ASP.... not ASP.NET..... for those of you who do not know, it is as different as night and day.... so which did the orginal poster mean?

-Chris

This will turn into ASP(.NET) vs PHP..
I also agree with fyrestrtr - it depends on the developer which language to use.
If you can do job A with PHP or ASP(.NET) and it takes you 2 days to do it with PHP and 1 day to do it with ASP(.NET) - the choice is obvious. The developer will choose ASP(.NET) since he's more familliar/works faster with it.

We are now talking about personal preferences in developing websites (we compare 2 languages) but I believe that poster doesn't need that info actually. Both languages do the same - empower websites. Also, bear in mind that PHP vs ASP.NET performance-wise depends also on HOW you code your site.
If you filter out data from database within scripting language instead within database itself - of course something will be slow, thus people blaming language for beeing slow. Common ignorance should also be taken in consideration when comparing 2 opposing languages.

So which language to use - PHP hosting is cheaper, ASP.NET is more expensive.
Both languages can work with variety of databases, both are fast in doing their job.
But I believe I'm not mistaken when I say that Apache/PHP/MySQL are more spread over the net than ASP.NET/IIS.
PHP development might be a tad bit slower than ASP.NET development since ASP.NET has a pretty solid framework behind it to ease the development cycle and reduce development time.

Just my 2 cents.

Even though I prefer PHP over ASP, I MUCH prefer ASP.NET to PHP.

Here are some reasons:

- You can develop complete DLL driven web APPLICATION, with ASP.NET.

- Much faster development time for applications in ASP.NET.

- Integrated security / user permission with ASP.NET.

- Much faster execution of code with ASP.NET (once it caches it the first time around).

- ASP.NET's Web.config and Global.asax files (not going to explain this one. Look it up).

The list goes on! PHP is great for Open Source Coding and SOME E-Commerce applications. But for serious web applications to sell to customers, I use ASP.NET 90% of the time.

Originally posted by deuce868
I moved from ASP to MySQL because of the database end. I had outgrown Access and we couldn't afford SQL Server. Since that time I prefer working in PHP, I have used PHP with postgres & mysql and I've never missed anything from ASP.

In the end I guess you could try to use either one if you have the funds. PHP is going to be more open, available on many more servers, and I just don't see what you'd be missing.

Then again, I've never used SQL server.

Like PHP support a variety of databases, ASP does the same too. You can easily switch your database from access/sql to mysql with minor changes to your sql queries.

PHP is much fast and reliable and you can find a lot open source projects in PHP. Since, ASP.NET is unleashed, you don't need to switch over to PHP. and yes, you can still use mysql with asp.net.

Use PHP if you come from C background. ASP/ASP.NET if your first language was Basic :)

I see a lot of ignorant and uneducated posts about asp in this thread.

Between the two:

ASP or ASP.NET + MS Sql: usually used for heavy ecommerce database usage or enterprise class sites like banks, more secure, a bit more expensive but not that much. ASP.NET is VB or C#

PHP + MySql: used by more people because it's a free, widely supported, more free scripts available.

Both are good scripting languages. The open source community will always say the free product is better even it it's not.

ASP.NET is VB or C#

Although this statement is correct, you can write ASP.NET code in any .NET-supported language (there are a few more (http://msdn.microsoft.com/netframework/technologyinfo/overview/) that are not shipped with MS Visual Studio). So if you are inclined, you can write your .NET application in Perl, Python or even Ruby.

Fyrestrtr is absolutely right. At the end of the day it doesn't matter if your salt comes from Poland, Thailand, Austria or the U.S. - if the soup tastes fine in the end you'll be happy.