Sql Database
- Thread starter Mark
- Start date
- Staff
- #2
- 518
Mark, my guess is you're talking about MySQL databases.
All Apache/Linux based websites used MySQL databases to store information, therefore the well known LAMP (Linux Apache MySQL PHP) environment.
SQL is for Windows based servers, and although MySQL can be used there, it cannot be optimized to work as best as under the Apache servers.
Val.
All Apache/Linux based websites used MySQL databases to store information, therefore the well known LAMP (Linux Apache MySQL PHP) environment.
SQL is for Windows based servers, and although MySQL can be used there, it cannot be optimized to work as best as under the Apache servers.
Val.
G
Guest
Guest
Integrating a MySQL database into a website is either very easy or very complex... depending on what you want to do.
The mechanics of it is done through your web host most often via a user control panel of some type... you make the request and back comes the name of the database, user-names and passwords, and host-name (usually "localhost.")
Once you have the database, you need software or to write code to "talk" to it to either store data in it or get data out of it.
Many websites (like this one) and WordPress are database-driven, as are content managers like phpNuke, Drupal, Joom, etc.
The question you should answer here is "What do you want to do on your website?" Manage content? Shopping cart? Blog? Photo gallery?
Al
The mechanics of it is done through your web host most often via a user control panel of some type... you make the request and back comes the name of the database, user-names and passwords, and host-name (usually "localhost.")
Once you have the database, you need software or to write code to "talk" to it to either store data in it or get data out of it.
Many websites (like this one) and WordPress are database-driven, as are content managers like phpNuke, Drupal, Joom, etc.
The question you should answer here is "What do you want to do on your website?" Manage content? Shopping cart? Blog? Photo gallery?
Al
- 2,024
All you need is 2 forms, one to enter one to search, its a very simple function you're talking about.
The website part would need to be in php, tied to the mysql db on your server, using queries and updates.
It isn't particularly hard to make a mysql db do anything if you understand programming logic.
I think a better question might be, exactly what is the purpose of what you're wanting to do? If we knew the intent, it would be MUCH easier to suggest the solution.
The website part would need to be in php, tied to the mysql db on your server, using queries and updates.
It isn't particularly hard to make a mysql db do anything if you understand programming logic.
I think a better question might be, exactly what is the purpose of what you're wanting to do? If we knew the intent, it would be MUCH easier to suggest the solution.
LJohnson89
Expert
A number of individuals have proposed PHP and MySql. However, there are FREE Microsoft options also.
You can use FREE SQL Server Express and FREE Visual Studio Express to create a database driven website. To create a database-driven website isn't rocket science, but you do need some programming aptitupde to understand what's going on.
BTW, I do database driven websites for a living, but I use ASP.Net/SQL Server and not PHP/MySql. Is one better than the other? Probably,not. However, MS Techonologies are used by the companies that employ me to improve their business processes.
L A Johnson
You can use FREE SQL Server Express and FREE Visual Studio Express to create a database driven website. To create a database-driven website isn't rocket science, but you do need some programming aptitupde to understand what's going on.
BTW, I do database driven websites for a living, but I use ASP.Net/SQL Server and not PHP/MySql. Is one better than the other? Probably,not. However, MS Techonologies are used by the companies that employ me to improve their business processes.
L A Johnson
- 2,024
Yeah there is nothing wrong with the Microsoft variants or whatever, and usually thats what college people are using.
It's the oddest thing, but big corporations require their people to use the Microsoft stuff even though functionally it isn't really any better, its just different.
However, if you're gonna pick one to learn, I'd suggest linux just because you can find a lot more free code laying around. The people that do stuff in linux tend to be fast and loose with code, putting it up everywhere, while the Microsoft guys tend to not share quite as much.
It's the oddest thing, but big corporations require their people to use the Microsoft stuff even though functionally it isn't really any better, its just different.
However, if you're gonna pick one to learn, I'd suggest linux just because you can find a lot more free code laying around. The people that do stuff in linux tend to be fast and loose with code, putting it up everywhere, while the Microsoft guys tend to not share quite as much.
G
Guest
Guest
Wars have been fought over lesser issues than Microsoft platform vs. non-M$.
I'll spare you the sound and fury as well as a long, drawn out explanation. Just listen to me and then check it out:
1. The M$ free stuff is limited in both scale and function. Think about it. It has to be . They don't want to cannibalize their "good stuff."
2. The IIS server that ASP.NET runs on is not nearly as secure, not nearly as fast (on most hardware) and not nearly as stable as Apache (free.)
3. The vast majority of data-driven web sites are done in what is called LAMP: Linux (operating system), Apache (web server) MySQL (database), PHP (scripting language.)
4. ASP.NET (a language and a platform) is basically a huge javascript generator and unless all your folks use IE (as in a corporate INTRAnet,) you are courting trouble with those who use FireFox, Safari, Chrome, Opera, etc.
Unless you have the resources of a large corporation, stick with the tried and true LAMP platform. You can't go wrong with it.
(That WAS the short version. Let me know if you want the LONG one!!!)
Al
I'll spare you the sound and fury as well as a long, drawn out explanation. Just listen to me and then check it out:
1. The M$ free stuff is limited in both scale and function. Think about it. It has to be . They don't want to cannibalize their "good stuff."
2. The IIS server that ASP.NET runs on is not nearly as secure, not nearly as fast (on most hardware) and not nearly as stable as Apache (free.)
3. The vast majority of data-driven web sites are done in what is called LAMP: Linux (operating system), Apache (web server) MySQL (database), PHP (scripting language.)
4. ASP.NET (a language and a platform) is basically a huge javascript generator and unless all your folks use IE (as in a corporate INTRAnet,) you are courting trouble with those who use FireFox, Safari, Chrome, Opera, etc.
Unless you have the resources of a large corporation, stick with the tried and true LAMP platform. You can't go wrong with it.
(That WAS the short version. Let me know if you want the LONG one!!!)
Al
- Thread starter
- #8
LJohnson89
Expert
I have to disagree with a few of the things that you wrote here.
1) ASP.Net is geared towards IE. I'm a .Net Developer and I rarely use IE except to make sure my web design layout displays correctly.
2) It is built for the Intranet. A number of banks and airlines utilize ASP.Net for their websites (e.g. Chase, AirTran, SpiritAir). I'm pretty sure they handle quite a few transactions.
3) You need the resources of a large corporation. I'm a corporation, but not a large corporation and I have no trouble supporting or troubleshooting any issues that arise.
I could nitpick further, but what it really comes down to is personal preference similar to choosing Chevy or Ford.
I am not a M$ shill.
If you go with ASP.Net/SQL I can assist you or guide you in the right direction. If you choose PHP/MySQL, I can't help you there as that isn't the technologies I use.
Another thing, it's more than storing data in a database. You have to understand and have good database design principles.
1) ASP.Net is geared towards IE. I'm a .Net Developer and I rarely use IE except to make sure my web design layout displays correctly.
2) It is built for the Intranet. A number of banks and airlines utilize ASP.Net for their websites (e.g. Chase, AirTran, SpiritAir). I'm pretty sure they handle quite a few transactions.
3) You need the resources of a large corporation. I'm a corporation, but not a large corporation and I have no trouble supporting or troubleshooting any issues that arise.
I could nitpick further, but what it really comes down to is personal preference similar to choosing Chevy or Ford.
I am not a M$ shill.
- - - - - - - - - - - - - - - - - -
If you go with ASP.Net/SQL I can assist you or guide you in the right direction. If you choose PHP/MySQL, I can't help you there as that isn't the technologies I use.
Another thing, it's more than storing data in a database. You have to understand and have good database design principles.
Last edited:
G
Guest
Guest
I spent a number of years writing in ASP 3.0 and then on dot Net.
People say it is easier to write maintainable code in ASP.NET. I think that is a good point... but...
There are tons of code-foundations for PHP. I like CodeIgniter
but Zend has one, Smarty is out there (more of a template) and there are others such as Cake.
Indeed, there are more ways to write good, solid, structured code in PHP than there is in ASP.NET. Plus there are tons and tons of code libraries that you can get do do lots of chores... from database abstraction (like ADODB) to the security stuff at this site.
ASP.NET has some very good classes (objects) and is well documented, but to put up a really robust site you have to buy into M$ Visual Studio and SQL-Server... and you are looking at several thousand dollars.
Everything you can do with the above can be done with a LAMP platform, but perhaps not quite a easily and quickly.
There is an alternative... you could try the Mono Project which is an open source "duplication" of ASP.Net and runs on several platforms. I've never used it but I'm told it is pretty good.
The only reason I know of to write a web-based application in ASP.NET is because some large corporate IT dept. who feels safe with M$ is paying you big bucks to do it. And for large corporate INTRAnets, it's a good solution. But if you want to open up IIS to the world... given its record on security... well you are a braver man than I.
Besides, ASP.NET objects don't always render so well on Firefox, Chrome, Opera, or Safari... and that's probably close to over half the users out there.
YMMV
Al
Find me here
People say it is easier to write maintainable code in ASP.NET. I think that is a good point... but...
There are tons of code-foundations for PHP. I like CodeIgniter
but Zend has one, Smarty is out there (more of a template) and there are others such as Cake.
Indeed, there are more ways to write good, solid, structured code in PHP than there is in ASP.NET. Plus there are tons and tons of code libraries that you can get do do lots of chores... from database abstraction (like ADODB) to the security stuff at this site.
ASP.NET has some very good classes (objects) and is well documented, but to put up a really robust site you have to buy into M$ Visual Studio and SQL-Server... and you are looking at several thousand dollars.
Everything you can do with the above can be done with a LAMP platform, but perhaps not quite a easily and quickly.
There is an alternative... you could try the Mono Project which is an open source "duplication" of ASP.Net and runs on several platforms. I've never used it but I'm told it is pretty good.
The only reason I know of to write a web-based application in ASP.NET is because some large corporate IT dept. who feels safe with M$ is paying you big bucks to do it. And for large corporate INTRAnets, it's a good solution. But if you want to open up IIS to the world... given its record on security... well you are a braver man than I.
Besides, ASP.NET objects don't always render so well on Firefox, Chrome, Opera, or Safari... and that's probably close to over half the users out there.
YMMV
Al
Find me here
Similar threads
