Learning about SQL, PHP, etc
AlphaTrinity
North Wales, PA
Hey guys,
A good friend of mine and I are going to attempt to make a website that is going to be pretty complicated for us (me being mostly a hardware/networking guy, and him claiming to be "an old school text programmer) to get started.
He's doing most of the research, while I volunteered to find tutorials and examples about whatever he thinks would be good for programming this site.
At first he mentioned using PHP, but now he has moved more towards using SQL to make this site. I saw that Keebler and some others posted a lot of tutorial sites and books, and I'm going to check them out as soon as I'm done posting this thread.
My question is: what software do I need in order to write SQL or PHP scripts? I saw that Microsoft has something called SQL Server 2005 that uses T-SQL. Would that be a good software for us to start with? We would definitely prefer freeware, but if it comes down to it I suppose we could buy software that we might need. He will be running Vista while I'm still running XP. I also have a linux box that I could use if there are better options on that (Fedora 6 I believe).
Thanks so much for the help
A good friend of mine and I are going to attempt to make a website that is going to be pretty complicated for us (me being mostly a hardware/networking guy, and him claiming to be "an old school text programmer) to get started.
He's doing most of the research, while I volunteered to find tutorials and examples about whatever he thinks would be good for programming this site.
At first he mentioned using PHP, but now he has moved more towards using SQL to make this site. I saw that Keebler and some others posted a lot of tutorial sites and books, and I'm going to check them out as soon as I'm done posting this thread.
My question is: what software do I need in order to write SQL or PHP scripts? I saw that Microsoft has something called SQL Server 2005 that uses T-SQL. Would that be a good software for us to start with? We would definitely prefer freeware, but if it comes down to it I suppose we could buy software that we might need. He will be running Vista while I'm still running XP. I also have a linux box that I could use if there are better options on that (Fedora 6 I believe).
Thanks so much for the help
0
Comments
Either way, you're in for a very mammoth undertaking to learn the language. You'll be learning not only how to write it, but how to write it <i>well</i> which is just as important. In the interim, you'll also be learning the finer points of HTML and how to design an efficient SQL database.
Are you sure you wouldn't want a pre-fabricated content management system (CMS)? Radeon_Man is right. Most people who want to undertake this don't quite understand the scope of the task.
Sure we'll give CMS a try if you both recommend it. But since I have no idea what exactly CMS is (software?) maybe you guys could recommend something.
And about being a mammoth undertaking..we both have plenty of time to dedicate to this (me having probably more than twice the amount of time as my partner), so we're prepared to tackle it I think.
Which I would recommend spending on content, not technical issues
http://en.wikipedia.org/wiki/List_of_content_management_systems for a bunch of CMS systems. I played around with e107 a few years ago, but I have limited CMS experience. I will let others chime in recommendations.
Subdreamer
Wordpress
e107
Mambo
Joomla
Of those, wordpress is by far the easiest to set up and have a workable site up and running in a short amount of time.
look into Ruby on Rails
I find that learning about different web technologies is half the fun.
http://www.rubyonrails.org/
check out some of the screencasts to see what you can do. You can build your own ideas, ground up, and it *may* be a little less complex than php.
Good luck
I've been busy the last couple of days, but today I have some free time and I'm going to start working on tutorials.