Introduction

Website Development is all around you, if you use the internet then you know that every website you have visited was developed by someone may it be [ Register or Signin to view external links. ] , [ Register or Signin to view external links. ] or even The Tech Game. Each and every one of these websites are famous and were not developed by someone with basic or intermediate skills. These were developed by experts who have spent endless hours advancing their skills. The internet is an endless stream of knowledge and it's there for you to learn all about website development and many many other topics!

The real question is how are these developed right? Well in this thread we are going to cover everything that you have seen in the index.

Basic Development

To begin developing a website you need to know the basics of what a website is made of and then learn them. The very basics a website are made of is HTML and CSS.
The HTML is for placing everything on the website and for inputting things like images, videos and even audio on the website.
The CSS side is for changing the style of the website, this includes the colors of links and background colors of the website.

We will go into this in more depth further down the page under Languages.

Advanced Development

Websites go way beyond just HTML and CSS, we introduce things like JavaScript, PHP, and SQL to make a website a lot more advanced than just an information website. You'll learn quickly that a website will improve on its visitors when people can sign up and even when there are more functions on the website such as a Password Generator.
When a visitor can get more out of the website they will feel more inclined to re-visit the website!

History

The internet was created by a man named [ Register or Signin to view external links. ] who worked for [ Register or Signin to view external links. ] in the 1990's where he developed what we know as the World Wide Web. He made the first release only two months after going into development in 1991, it then became available to the public on August 6th, 1991. You can consider this the beginning of website development since it was literally non-existent before this date.
You can view how the internet has evolved over the years including the introduction of new Website Browsers, Languages and much more by visiting [ Register or Signin to view external links. ] .

Companies

The goal of any website developer isn't to just make enough to live but to make enough to never have to work again. You can be a solo developer or be employed by a website development company. Many companies have come and gone over the years but what you will find is there are some companies out there who have been around since the beginning or not long after it!

Website Development and Design companies are probably one of the best-paid people online today because of their significance on the web. Let's face the facts if you want to make it big online then you'll need to have a website. Do you have a business? Then you will want to reach out to more clients by having a website because everyone uses the internet unless they are a technology dinosaur.

[ Register or Signin to view external links. ]
Big Drop is a company which was founded in 2011. They consist of a 15 personnel including designers, developers, UI/UX specialists and more. Their total team is anything from 50 to 250 employees. They are one of the most well know web development teams on the net today.

[ Register or Signin to view external links. ]
Lounge Lizard has been a company since 1998 making it one of the oldest website development companies. The company has an employee count anywhere between 10 and 50 paid staff. They specialize in Web and Mobile development and charge between $100 - $150 an hour.

[ Register or Signin to view external links. ]
Intechnic is also a very old company being founded in 1997. They charge an average of $150 - $200 an hour for their work. The team is believed to be between 10 and 50 employees. They have developed websites for Government of Victoria, Paramount, and Disney.

[ Register or Signin to view external links. ] .
Lead to Conversion is a younger company which was founded in 2006. They consist of around 35 - 50 developers and charge roughly $100 -$150 an hour. Some of their clients consist of Cleveland City Forge and Wyndham Hotels and Resorts.

Developers

Once you begin to build on your experience and get building websites based on your own designs and ideas you can pretty much consider yourself a website developer but that's just the beginning. The internet is always evolving and web developers along with it. Every day you will wake up to learn something new and that's just how it is. A lot of people consider themselves Website Developer Guru's but that can rage in a lot of things. It's easier to pick one topic and stick with that as your core development skill and then once you have mastered it learn another.

You will see a lot of website developers who run their own website with a portfolio who try to pick of jobs, this can be seen in The Tech Game too. These are the small guys looking to make their portfolio bigger. It's not all about the money but for guys like these getting jobs here will help them if they apply for a company as their portfolio has gotten bigger and bigger meaning they have more knowledge and have learned more.

Ethan Marcotte - [ Register or Signin to view external links. ] - [ Register or Signin to view external links. ]
Ethan Marcotte is a website developer, better known as the person who developed Responsive Websites.
His previous work includes People Magazine, New York Magazine, and the World Wide Web Consortium.

Karen McGrane - [ Register or Signin to view external links. ] - [ Register or Signin to view external links. ]
Karen McGrane is a UX expert with more than 15 years experience in her field of expertise.
Since becoming a website developer she has made many big and complicated websites.

Sarah Parmenter - [ Register or Signin to view external links. ] - [ Register or Signin to view external links. ]
Sarah Parmenter is a UI who specialises in Website Design. She was 19 when she started.
Her work includes National Breast Cancer Foundation of America, STV, and Blackberry.

The Basics

HTML
HTML is short for HyperText Markup Language basically HTML is the core behind a website, every website has it. HTML is the code that makes the website, the end user will see the visual or audible side being the final display after the server has called the files forward. HTML is one of the basis that any website is created from, you can make Tables, Links, Headings, Paragraphs and much more with the use of HTML. HTML is a text code, which is easy for anyone to understand with little to no knowledge about it. It was released in 1993 when the World Wide Web was just created making it one of the oldest languages to learn. As time has gone on HTML has changed and evolved with the internet, currently, we are on HTML5.

CSS
CSS is short for Cascading Style Sheets, like HTML this is one of the core parts of a website. CSS allows for the user to add internal CSS meaning it's limited to that page or external, where it is linked to all pages. Cascading Style Sheets go a long way to a website as they make the visual view more appealing. coloring links, adding a background color to the website and even decided what color headers and paragraphs are. It keeps them all on record and when the web page is called forward from the server the CSS is also called and it links into the website putting the rules into the display. Cascading Style Sheets were first introduced to websites in 1996 as a Style Sheet Language. CSS usually have the extension of .css.

Client Side Scripting

JavaScript
JavaScript is a programming language between HTML and the internet. It was first released in 1995, over 20 years ago. JavaScript crosses over a program and the web, like if you had to image creating a standard program, how the button looks is what it would look like on the web. Like in say Visual Basic (programming) you can have Arrays, Loop While, Booleans, and Loop For. JavaScript introduces them to your website allowing you to make your website more user-friendly and also allows the end client to interact with your website. JavaScript, however, does go beyond the web and just programming it's used in your computer. Such as your widgets on your desktop and PDF files.

ActionScript
ActionScript is one of the siblings of JavaScript both of them were developed based on HyperTalk. The difference is that ActionScript is an object-orientated programming language opposed to JavaScript which is a dynamic programming language. ActionScript is the controller of 2D vector animations which are generally made using Adobe Flash, it's been used with Flash since Flash Player 2 and all the way to Flash Player 11.8.
ActionScript was founded in 1998 only three years after it's sibling; JavaScript.

Server Side Scripting

PHP
PHP in it's early days stood for Personal Home Page but later was changed to PHP: Hypertext Preprocessor. This is one of the most common Server-side script languages as it is used on over 200,000,000 (200 million) websites to date and over 2,000,000 (2 million) website servers. Like many of the other big languages, PHP was developed and released in 1995, mover 20 years ago. PHP mixes in with HTML, you can have a web page with HTML and PHP on it. An example of this would be The Tech Game, it has the HTML for the text and PHP for displaying user titles.

Java
Java is an old one too, developed and released in 1995. This has become one of the most popular choices for both its server and client-side workings. Java is a general computer programming language that is mainly object-orientated. A little like ActionScript. In terms of website development, Java is coming up in the ranks as recent polls have shown that there is more than 9,000,000 (9 million) Java developers who use it on their website.

Python
Python is such widely used in websites today but not many people realize it's used on their own websites. Pyramid, Flask, and Django are the three that you will probably have on your website but don't actually know anything about. Python is a high-level programming language. Let's talk about Pyramid for a second, Pyramid is a server-side scripting that is linked to Databases, most commonly the MySQL database but it can be used on others such as Zope Object Database and CouchDB.

Ruby
Ruby was developed in 1995 by Yukihiro Matsumoto. He originally created Ruby to be for the programmer's productivity and fun but most importantly to show good user interface design for the websites. Ruby is a general level programming language and is object-orientated.

Brief

Business View
You always ask questions during the brief otherwise it's your own fault!
Lets look at this from a business point of view, before you can start work on the website you need to know what you're doing right? We refer to this as a Brief. A brief is when you get the job offer and the client will tell you what they want in their website, how many pages, images, videos and they can even tell you what style they want. Clients will usually provide the text for the website and any images they want on it if it's for personal use but sometimes you will have to go and research other websites related to their needs and come up with a design similar, but not the same, and type up information for their website.


Click to View Content
[ Register or Signin to view external links. ]

Example - image [ Register or Signin to view external links. ]

Personal View
You have the idea for your website now before you go ahead and try to develop it you may wish to get a brief between you and your partners of what you want the website to look like, it contents and much more. It's not as simple as thinking the idea and diving into development, great things take time to complete. You should always brief your team or partners in on the idea and then from there work out how it's going to be completed.
Know what you want before planning it out!

Planning

You have the information you needed to begin the planning stages if you got a brief of the project at hand. This is the stage where you will begin the planning of the website with the use of basic designs of what the website can potentially look like. Remember that you need to stick to your brief when making the website, if your client was a specific color flow then you have you get that for them. You can't just make it how you please and show them. It has to be done the way they want if you want them to tell their friends about your services. Here is a quick one I made in Microsoft Word.


Click to View Content
[ Register or Signin to view external links. ]


The purpose of this is so that you can always look back and see how your progress to your original layout was looking but keep in mind you might have an idea but when it comes to the coding you realise it doesn't work that easy and have to make some compromises on your original thoughts and designs you made. You'll want to spend some time coming up with a few different ideas for the layout and have them ready in case the client asks how the website will be set out. This also allows them the chance to see what their website will look like.

Mock-ups

You have your brief and you have your plans, it's now time to come up with the design examples. These probably won't be used for the website but this is just a mock-up of what the website will potentially look like. You always want to have a few mock-ups before beginning work on the actual design and they should all be different to some extent. This here is one I made really quickly based on the planning example I showed above. This took no more than 5 minutes to put together but it's just an example like I said.


Click to View Content
[ Register or Signin to view external links. ]


You have all your mocks ready in the event the client asks again to see the progress you can show them these basic, boring website templates and then show them the real preview. In reality, the preview will make them surprised because the mock will make them think the website is going to be ugly and then they get amazed at the progress of the real design.

Domains

By this point you've got the idea of the website, the planning and should have some possible final examples of how you want the website to look. You now know it's purpose and what content the website will now hold. The next motion is to acquire about the domain you wish to have for the website. When searching for a domain you want to keep it related to the topic of the website, short and easy to remember. Picking a domain for your website is hard and can take hours if not days to finally purchase the one you like. I'd suggest trying to get one similar to other domains relating to the same type of website you have but remember, be original with it. You can purchase a domain from the many hosts out there and some will offer deals and even give you the option to purchase high-end domains like .science and .website. You want to get the right one since if you decide to change the domain you'll probably have to change a lot of your content as well.
Here is a few places you should look at when purchasing a domain for your website.
[ Register or Signin to view external links. ] , [ Register or Signin to view external links. ] , [ Register or Signin to view external links. ] , [ Register or Signin to view external links. ] , [ Register or Signin to view external links. ] , [ Register or Signin to view external links. ] , [ Register or Signin to view external links. ] , [ Register or Signin to view external links. ] .

Creating the website
[list]You now have the domain, this was a key part before you created your final website that will be put on the web for a number of reasons including but not limited to, placing it in the footer and for links you want the entire domain in. You now want to move on and get the real website made as you have the mock-ups and planning and you know exactly what you want to do with the website. It's all a matter of just putting it together. If you are a beginner to website development I would suggest making the website using [ Register or Signin to view external links. ] , it's simple and easy to follow. There is no real coding behind it for you and you can view live previews of the website as you make it.

You will also want to get your hands on professional graphics for the website, including the logo. You can either find a service and purchase it or you can create your own. If you want to make your own I suggest using [ Register or Signin to view external links. ] . It's the best on the market and it's also easy to use like Dreamweaver with loads of tutorials online to making the perfect website logo to suit your needs. If you want to purchase graphics for your website I would suggest having a look at The Tech Game very own Graphics Forum as there are many amazing graphic designers.

Hosting

You have everything ready to go and now it's time to get a web host, the reason we have left this to last is so that you get the full time you paid for with a live website. Say you pay monthly and you buy hosting before you start work on the site and it takes two weeks to make. Are you only getting two weeks hosting right? So why not wait until you are ready to put your website online before buying and get the full month. Many hosts will offer many packages, if your website does not have a database linked to it then you probably won't need expensive hosting to start off with. You should be fine with the hosts smallest/mid-package until you can see the statistics that you're using more resources than usual, that is when you will have to upgrade. A small website shouldn't be any more than $5/$10 a month for hosting until such times your website is becoming much bigger.
Here is a few places you should look at when purchasing hosting for your website.
[ Register or Signin to view external links. ] , [ Register or Signin to view external links. ] , [ Register or Signin to view external links. ] , [ Register or Signin to view external links. ] , [ Register or Signin to view external links. ] , [ Register or Signin to view external links. ] , [ Register or Signin to view external links. ] , [ Register or Signin to view external links. ] , [ Register or Signin to view external links. ] .

Upload website

Almost there! You now have the domain, web hosting, and the design ready to go. It's not the time to put that website live on the web for all to see. You'll need to configure the domain to the web hosting and then go to the hosting panel and follow the instructions to upload your website. It may or may not appear instantly once you upload it if that's the case then try clearing your browser which should solve the problem of not seeing anything. Remember that you can now carry on with more protection for your websites like DDoS protection and Copyright protection. You will be able to find out more information about these below in this same thread.

Testing

Congratulations you now have your website on the web. It's now time to do the testing to make sure that everything works as it should be working. This includes checking all images are in place and aren't broken. Links lead to the correct location and also check how the website looks on different browsers such as Internet Explorer and Google Chrome. It is also worth checking out what the website will look like on different devices such as a Desktop, Mobile, and Tablet. If there are any issues then you know what they are and can work to fix them in due time. Testing should be carried out three times, to make sure that you haven't missed anything. Make sure that you also check the grammar of any information posted on the website.

Third-Party Testing

If you work with a team of developers it's a good idea to ask them to have a look over the website and see if they can see any errors or have any suggestions to help you with the testing of the website as you may or may not have missed something when doing the testing yourself. If you are a solo developer then ask some friends on Skype or Facebook to take 10-15 minutes and check over the website for you as it's always good to have a second set of eyes look at your website just in case you missed something. These people may consider themselves to be beta testers as they can check the website before the initial release to the public.

What is SEO

Search Engine Optimization also referred to as SEO is when you get traffic from people just searching for the likes of Google and Bing. The top-ranked pages are the ones that are seen to have the most relevance to what the user has searched for. The purpose of SEO is to get your website on page one on Google meaning you'll get huge amounts of traffic when people search for keywords relating to your website. Websites which have a better reputation for their work will probably be at the top of page one on Google.

How to use SEO

If you want your website to get a good ranking you will have to put the time and effort into making quality information and presenting it on your website. Search Engines usually look for key factors such as Titles, Links, Words, Reputation and Linking Words. These are all factors which will affect your state for ranking. I looked around to get a good example to explain this to anyone who wants to learn SEO and here is what I got the best result.


Click to View Content
[video=youtube]https://www.youtube.com/watch?v=hF515-0Tduk&feature=youtu.be[/video]

Submitting to Search Engines

Submitting to Search Engines will be a massive boost in popularity that your website will need if you want it to become a success. You will want to submit your website to Google, Bing, and Yahoo. These three companies are the biggest on the web and with millions upon millions of users will get you the best ranking and also get you traffic flowing in. Alternatively you can just submit your website to the likes of [ Register or Signin to view external links. ] where they do all the work for you but it can take anything up to 4 weeks for them to index your website and sometimes your website doesn't even get indexed meaning you will have to resubmit it. Take the manual route and submit to Google, Bing, and Yahoo through their Search Engine website.

What is advertising

Advertising is a method of promotion. Do you ever see an advert on TV for a new pair of shoes or console? Well, that's what advertising is but it's a little different for websites since you don't often see websites being advertised unless it's for insurance or something. Advertising is promotion, it's getting the word out there all about your website. Keeping it short and hitting the people with facts as to why they should be visiting your website. It's all about getting traffic to your website and should only contain relevant information.

Where to advertise

There are millions of places to advertise your website. Social Media is a big hit today, putting up a page on Facebook about your website and inviting all your friends to like it can help you out. Get them to share it as well. You can advertise on websites that allow you to. Advertising can be exchanged as well, one site owner advertises your website and you advertise theirs. No money is exchanged and both websites will get hits from each other. Look on the web for Free Advertising, there are websites dedicated to just people sharing their websites.

Why advertise

As previously stated, advertising is about getting traffic to your website. The goal of advertising is to in the end bring people to your website to see your work or see your products. Should you be advertising as you don't want all the time you spent on your website going to waste as nobody views it do you? obviously not! Take your time and present a good website and solid reason as to why people should visit your site and you never know you might get a few sales or even have some people wanting to purchase that advertisement space you have free.

What are these

Ready Made Scripts are websites that have already been created, and most have a database to make them work. You can find a script for nearly anything from a YouTube Coin System to URL Shorten scripts. These scripts basically build the entire website for you and carry out all the development stages. All you will have to do is edit the settings to make the website display as your own i.e. changing the title, logo and maybe even the design layout. In the end, this basically allows for you to create a completely functional website in a matter of a few hours work.
[ Register or Signin to view external links. ]

Why use them

Why would you want to use these? Well, it allows for the end user to interact with the website, these usually allow them to sign up and use the website for its purpose. Let's go back to the Youtube Coin System, this system allows members to like, comment and subscribe to channels earning them points which they can then add to their videos and others do the same. This will allow the user to benefit from the website gathering better search results and even getting the owner and the website a good reputation for being the place to be on YouTube. Generally, these make your websites have a better standing and allow for the user to get good use of them.

Advantages

The advantage of using these scripts is that the developer doesn't need to have the greatest development skills all they need to know is some basics to apply changes to the website. These also save a qualified developer a lot of time from developing the website as they can get the script and edit the script to be the way the client or themselves want the website to look. The script will function correctly as well which saves the developer from having to troubleshoot when they make a mistake in the code.

Disadvantages

There are a few disadvantages to using these as well, if the person who created the script doesn't release a new version then the developer will either have to use the same version at all time or they will have to attempt to upgrade the script themselves. Another disadvantage is that the code might have an error in it meaning that the website may have a vulnerability that the creator didn't realize when they first released the script which puts the website at risk of being hacked. Finally, the biggest disadvantage is that the owner of the website didn't actually develop it to an extent, meaning they haven't put their full knowledge into effect on the website.

Advertisements

When you own a website you want to make money back from it right? So say you sell products, there is a chance your website will be known depending on your advertising skills. However, you want to give people the same chance you have been given by advertising right? You can make advertisement space on your website and sell it. You will always find someone looking to bring in some more traffic to their website and would be willing to pay that small fee to have their website advertised on your website. You should look at your traffic, to begin with, and then come up with a reasonable price to sell your Ad Space for. On average for moderate websites, it's usually $10-$20 for a month ad space.

Sales

A lot of websites nowadays offer products or services, say it's a forum, for example, you would sell upgrades to the members and that would make you some small money. If it's enough to cover the monthly hosting bill then you've ultimately saved money and anything gained after that is profit for that month. Selling products on your website may it be eBooks, Graphics, Clothes, basically anything will bring you an income. This will help you in many ways including covering website bills and helping to promote your site as well as paying your team if you have one. Remember only to sell what you can provide and have the rights to sell otherwise you might get a bad reputation or legal issues.

Other

There are many ways to make money from owning a website. You might have Social Media linked to your website that has a big and active fan base if that is the case you can sell shout outs/posts on the likes of Twitter and Facebook to promote other peoples websites and services. That is only the beginning though as there are thousands upon thousands of ways to make money from your website may it be a Blog, Store or Forum. You will be able to find methods and tutorials online to help benefit your well being. Use keywords related to your website when looking for these methods to get the full effect from them.

HTML

HTML will allow you to display things like images, videos, and sound on your website. Every website has HTML on it and basically what it does is allows for the website to have some form of text. Below are some examples of different purposes of code including Paragraphs, Images, and Headings.

Headings
[ Register or Signin to view external links. ]
Heading 1

[ Register or Signin to view external links. ]
Heading

There are 6 heading types, h1 being the biggest and h6 being the smallest Heading 1 (h1) as the most important heading and Heading 6 (h6) as the least important.

Paragraphs[/align]
[ Register or Signin to view external links. ]

The p function defines a paragraph where it will put each paragraph on a separate line but leaving a line between each paragraph.

Images
[ Register or Signin to view external links. ]

This will add an image to the website, from what I added the image will be some form of the banner for The Tech Game but if the image is broken/non-existent then the text 'The Tech Game' will show in its place at a length of 304 pixels and height of 228 pixels.

CSS

CSS allows users to add styles to their website, may it be the Font of the text, the colors of the text and links. Ever noticed how when you click a link on most websites it gets a highlighted color indicating you've clicked it? Well, that's CSS for you. Say the default link color is white and once clicked it becomes blue. This is all done with the use of either internal or external CSS.

Links
[ Register or Signin to view external links. ]

When you visit the website for the first time you'll see links which are normal, their standard color.
This is an a:link.

When you click on a link it may or may not change color but if it does then you've been on that page.
This is an a:visited.

Finally, if you hover over a link and it changes color this means that it's the link you're about to click.
This is an a:hover.

Fonts
[ Register or Signin to view external links. ]

This implies that the text will be normal as displayed when typing a message on the likes of The Tech Game.
p.normal

This will put the font in italics and will tilt it to the side when the user is reading it.
p.italic

This is similar to the italics as it bends the text to the side but isn't as commonly supported.
p.oblique

Borders
[ Register or Signin to view external links. ]

This will give the border a solid look, making it noticeable and also the border will be colored red.
p.one

This will also make the border think and noticeable, but this time the border will be a green color.
p.two

PHP

PHP is used a lot of websites even on The Tech Games you'll be able to see in the search bar at the top of your browser. PHP has many uses such as Contact Forms, Arrays, Loops and much more. It's a massive part of web design due to its impact on making websites interactive for the end user.

Arrays
[ Register or Signin to view external links. ]

This will display all the cars in order automatically.

[ Register or Signin to view external links. ]

The result would show "I like Volvo, BMW and Toyota" stating all the cars.

If, Else, ElseIf

The If statement.

[ Register or Signin to view external links. ]

This shows that if the current hour is below 20 then send "Have a good day" to display.

The If... Else statement.

[ Register or Signin to view external links. ]

This shows to display "Have a good day" if the time is below 20 and if otherwise (over 20) display "Have a good night."

The If... Elseif... Else statement.

[ Register or Signin to view external links. ]
This one shows that if the time is below 10 then "Have a good morning" will be sent to display. If the time is between 10 and 20 then "Have a good day" will be sent to display. Anything else will show "Have a good night".

Forms
[ Register or Signin to view external links. ]

This will allow the user to fill out their name and email address and click a submit button.
This is only the beginning for the making of a Contact Form.


Click to View Content
[ Register or Signin to view external links. ]

JavaScript

JavaScript is where we cross over our Programming skills and introduce them to the website we are making. This will make the website look a lot better for the end user and can be the beginning of a new era. Basically, this allows for you to program the behavior of your website.

Errors
[ Register or Signin to view external links. ]

The error testing of the demo will consist of the Try and Catch method.
First off the code will be tried for and errors - try.
After Try if an error is there it can be changed - Catch.

Arrays
[ Register or Signin to view external links. ]
The first line gathers the car types and names the array cars.
The second line will go through the array and display cars[0] being Saab.

Object
[ Register or Signin to view external links. ]

This example is a objectname:text
Objectname: The name like First Name
text: the name like James, Hayley


Click to View Content
[ Register or Signin to view external links. ]

jQuery

jQuery is the more simple version of JavaScript and is easier for a new learner to get to grips with than spending endless hours learning JavaScript a lot of people often just accept jQuery and learn it.

Animate
[ Register or Signin to view external links. ]

This function allows for the Animation to move place, basically, the graphic was in a solid state if you will and then became a liquid (moving) and finally returning to a solid state.


Click to View Content
[ Register or Signin to view external links. ]


Callback
[ Register or Signin to view external links. ]

This code works similar to the Spoiler on The Tech Game. It displays a button saying hide but once the button is clicked the visible text is hidden and a browser alert is sent.


Click to View Content
[ Register or Signin to view external links. ]


Stop
[ Register or Signin to view external links. ]

This code will kill the current Animation that is already in progress. It will stop it regardless of how much is complete.


Click to View Content
[ Register or Signin to view external links. ]

SQL

Have you ever used something like Microsoft Access for making a database at school, college, university or even in your place of work? Then you'll not be surprised to know that SQL is simply a database with many of the same features and the wording is the same (titles).

Where

SELECT * FROM Customers
WHERE Country='Mexico';


This code will access the Customers table and pull forward the information regarding the country of Mexico.

[ Register or Signin to view external links. ]

From

SELECT * FROM Customers;


This will select all the Customers from the Customers table.

[ Register or Signin to view external links. ]

And

SELECT * FROM Customers
WHERE Country='Germany'
AND City='Berlin';


This will select all the Customers from the Germany who stay in Berlin.

[ Register or Signin to view external links. ]

DDoS Protection

We all know of the dreaded [ Register or Signin to view external links. ] (DDoS) attack but this might not seem too bad until you own a website and you begin to lose potential customers because someone thought it would be funny to hit your website offline. You will have seen the DDoS warning before accessing a website before, we see it in The Tech Game every now and then but it's what helps keep the forums online. There are many companies out there to chose from, it's just a case of getting the one that's right for you. I've left some companies below for you to have a look into and then decide who is best for you. Some are free and some are paid.
[ Register or Signin to view external links. ] , [ Register or Signin to view external links. ] , [ Register or Signin to view external links. ] , [ Register or Signin to view external links. ] , [ Register or Signin to view external links. ]

Copyright Protection

The web is a big place and there is a 99.99% chance that something you publish will be posted by someone else claiming ownership of that content. Let's look at MyBB for a second, a lot of people buy a custom theme and there are people who like to 'RIP' the themes and release them for free. This is a copyright issue if you own the theme and/or created it. A lot of people tend to copyright their work online with the use of Digital Millennium Copyright Act (DMCA) and such. The Tech Game also has a DMCA policy, check it out [ Register or Signin to view external links. ] . Copyright Protection will allow for you to have your work removed from another website if they have stolen your work, posted it without permission or anything alike, here are a few websites you should have a look at when you want to protect your content.
[ Register or Signin to view external links. ] , [ Register or Signin to view external links. ] , [ Register or Signin to view external links. ]

Legal Issues

All website owners will have legal issues at some point, but they may not arise! You need to be careful as to what you publish on the web and especially your own website. Make sure you read over your web hosts terms of services as well before publishing content to your website. The biggest issue to date is copyright as it's so easy to steal ones work from the internet. If I'm honest this topic is far too big to cover in just one section so here are some useful websites to look at when choosing a domain and much more!
[ Register or Signin to view external links. ] , [ Register or Signin to view external links. ] , [ Register or Signin to view external links. ]

Blogs

[ Register or Signin to view external links. ]
WordPress is web software you can use to create a beautiful website or blog. We like to say that WordPress is both free and priceless at the same time. The core software is built by hundreds of community volunteers, and when you're ready for more there are thousands of plugins and themes available to transform your site into almost anything you can imagine. Over 60 million people have chosen WordPress to power the place on the web they call "home" we'd love you to join the family.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
Open Blog is a free and open source blogging platform built using the CodeIgniter PHP framework.
It provides users with a very powerful yet easy to use interface which makes blogging simple and enjoyable.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
Dotclear is an open-source web publishing software created in 2002 by Olivier Meunier. A one man's project at first, Dotclear soon gathered a team comprising different personalities with various backgrounds.
The project's purpose is to provide a user-friendly tool allowing anyone to publish on the web, regardless of their technical skills.
Taken from [ Register or Signin to view external links. ] .

Portals/CMS

[ Register or Signin to view external links. ]
Drupal is an open-source platform and content management system for building dynamic web sites offering a broad range of features and services including user administration, publishing workflow, discussion capabilities, news aggregation, metadata functionalities using controlled vocabularies and XML publishing for content sharing purposes.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
Joomla is an award-winning content management system (CMS), which enables you to build Web sites and powerful online applications. Many aspects, including its ease-of-use and extensibility, have made Joomla the most popular Web site software available.
Best of all, Joomla is an open source solution that is freely available to everyone.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
Concrete5 makes running a website easy. Go to any page on your site, and an editing toolbar gives you all the controls you need to update your website.
No intimidating manuals, no complicated administration interfaces - just point and click.
Taken from [ Register or Signin to view external links. ] .

Forums

[ Register or Signin to view external links. ]
MyBB is the free and open source, intuitive, extensible, and incredibly powerful forum software you've been looking for. With everything from forums to threads, posts to private messages, search for profiles, and reputation to warnings, MyBB features everything you need to run an efficient and captivating community. Through plugins and themes, you can extend MyBB's functionality to build your community exactly as you'd like it.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
vBulletin is the world leader in forum and community publishing software. Customers have created vibrant communities for over 10 years on vBulletin's stable and mature platform. Developed with security, powerful administration features and speed in mind, it serves over 40,000 online communities. We provide world-renowned technical support, with the average support ticket answered within 3 hours, at any time of the day or night, 7 days a week. To learn more about our products, please visit the features page.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
XenForo is a commercial Internet forum software package written in the PHP programming language using the Zend Framework. The software is developed by former vBulletin lead developers Kier Darby and Mike Sullivan. The first public beta release of XenForo was released in October 2010. XenForo 1.0.0 Stable was released on March 8, 2011. XenForo has several SEO features built in. Its popularity is growing, according to feedback from various community forums and weblogs.
Taken from [ Register or Signin to view external links. ] .

Image Galleries

[ Register or Signin to view external links. ]
The gallery is an open source web based photo album organizer. Gallery gives you an intuitive way to blend photo management seamlessly into your own website whether you're running a small personal site or a large community site. Serving millions worldwide, the Gallery project is the most widely used system of its kind.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
Coppermine is a multi-purpose fully-featured and integrated web picture gallery script written in PHP using GD or ImageMagick as image library with a MySQL backend.
CPG has so fully featured it's not enough to fully list them.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
4imagesis as a web based PHP and MySQL for displaying images on the Internet. 4images can be configured through an administration area. 4images supports apart from the typical image formats like JPG, GIF and PNG, other data formats. Furthermore, 4images includes a template system to modify the design of the gallery. An external language file allows for easy translation into other languages.
Taken from [ Register or Signin to view external links. ] .

Wikis

[ Register or Signin to view external links. ]
MediaWiki is a free software wiki package written in PHP, originally for use on Wikipedia. It is now used by several other projects of the non-profit Wikimedia Foundation and by many other wikis. MediaWiki is designed to be run on a large server farm for a website that gets millions of hits per day. MediaWiki is an extremely powerful, scalable software and a feature-rich wiki implementation that uses PHP to process and display data stored in a database, such as MySQL.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
DokuWiki is standards compliant, simple to use Wiki, mainly aimed at creating documentation of any kind. It is targeted at developer teams, workgroups and small companies. It has a simple but powerful syntax which makes sure the datafiles remain readable outside the Wiki and eases the creation of structured texts. All data is stored in plain text files, no database is required.
Taken from [ Register or Signin to view external links. ] .

Social Networking

[ Register or Signin to view external links. ]
Dolphin is the world's most advanced community software. Open-source, independent, downloadable, scalable, customizable, full-featured, free software for building social networks, dating sites, and web-communities. Loaded with video chat, recorder, video player, forums, groups, events, video messenger, mailbox, desktop app, video sharing, photo sharing, iPhone app and much more. Build your own business or advance your hobby with Dolphin!
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
Jcow is a flexible Social Networking software written in PHP. It can help you to * Build a social network for your interests and passions. * Build a member community for your existing website. * Build a social networking site like facebook/myspace/twitter.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
Oxwall is unbelievably flexible and easy to use PHP/MySQL community software platform.
Oxwall is used for a wide range of projects starting from family sites and custom social networks to collaboration tools and enterprise community solutions.
Taken from [ Register or Signin to view external links. ] .

Ad Manager

[ Register or Signin to view external links. ]
OSClass is all you need to easily create your own classifieds website. It's a free and open script to create your advertisement or listings site.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
Noah's Classifieds Free Version is a great Classifieds App that can be used for any niche.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
Revive Adserver is the open source ad server formerly known as OpenX Source. Revive Adserver enables publishers, ad networks, and advertisers to Serve ads on websites, in apps, and in video players, and collect detailed statistics about impressions, clicks and conversions.
Taken from [ Register or Signin to view external links. ] .

Gaming

[ Register or Signin to view external links. ]
BlackNova Traders is a web-based, multi-player space exploration game inspired by the popular BBS game of TradeWars. It is coded using PHP, SQL, and Javascript.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
Shadows Rising is a browser based RPG written in PHP, Javascript, and XHTML. MySQL/PostgreSQL supported. The core engine will allow users create unique RPGs by adding new items, classes, terrain maps to Game Modules.
Taken from [ Register or Signin to view external links. ] .

Mails

[ Register or Signin to view external links. ]
Roundcube - Free webmail for the masses. Roundcube webmail is a browser-based multilingual IMAP client with an application-like user interface. It provides full functionality you expect from an e-mail client, including MIME support, address book, folder manipulation, message searching and spell checking.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
SquirrelMail is a standards-based webmail package written in PHP. It includes built-in pure PHP support for the IMAP and SMTP protocols, and all pages render in pure HTML 4.0 for maximum compatibility across browsers. SquirrelMail has all the functionality like an email client, including strong MIME support, address books, and folder manipulation.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
WEBinsta email list manager is built to provide a centralized mailing list/newsletter system for the small to medium website. It's simple yet quite powerful. It supports the standard subscribe and un-subscribe, remote verification, unsubscribe links, attachments, and host of other such features. The best of all the total integration is less than 3 lines of code.
Taken from [ Register or Signin to view external links. ] .

Polls and Surveys

[ Register or Signin to view external links. ]
LimeSurvey (formerly PHPSurveyor) is an open source online survey application written in PHP based on a MySQL, PostgreSQL or MSSQL database. It enables users without coding knowledge to develop, publish and collect responses to surveys. Surveys can include branching, custom preferred layout and design (using a web template system), and can provide basic statistical analysis of survey results.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
Piwik is an open source web analytics software program. It provides you with detailed real time reports on your website visitors: the search engines and keywords they used, the language they speak, your popular pages and so much more. Piwik aims to be an open source alternative to Google Analytics.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
Simple things can be amazing. Asking questions to your visitors shouldn't be rocket science. No databases, no fuss. The Amazing Little Poll is a very simple PHP polling script. It does what it should do, and it is specially optimized to make it very easy to set-up.
Taken from [ Register or Signin to view external links. ] .

Project Management

[ Register or Signin to view external links. ]
qdPM is a free web-based project management tool suitable for a small team working on multiple projects. It is fully configurable. You can easy manage Projects, Tasks and People. Customers interact using a Ticket System that is integrated into Task management.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
eyeOS is a disruptive desktop entirely usable from a web browser. It includes an office suite and some collaboration applications, as well as a full framework to develop new web apps as if they were desktop apps. Free and Open Source so you can host your own system, keeping all your data under your control.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
ProjectPier is a Free, Open-Source, self-hosted PHP application for managing tasks, projects, and teams through an intuitive web interface. ProjectPier will help your organization communicate, collaborate and get things done Its function is similar to commercial groupware/project management products but allows the freedom and scalability of self-hosting.
Taken from [ Register or Signin to view external links. ] .

e-Commerce

[ Register or Signin to view external links. ]
OpenCart is an open source PHP-based online shopping cart system. A robust e-commerce solution for Internet merchants with the ability to create their own online business and participate in e-commerce at a minimal cost. OpenCart is designed feature rich, easy to use, search engine friendly and with a visually appealing interface.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
Abante Cart is a free PHP based eCommerce solution for merchants to provide ability creating an online business and sell products online quick and efficient. AbanteCart application is built and supported by experienced enthusiasts that are passionate about their work and contribution to rapidly evolving eCommerce industry. AbanteCart is more than just a shopping cart, it is rapidly growing eCommerce platform with many benefits.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
osCommerce is an online shop e-commerce solution that offers a wide range of out-of-the-box features that allows online stores to be setup fairly quickly with ease and is available for free as an Open Source based solution.
Taken from [ Register or Signin to view external links. ] .

ERP

[ Register or Signin to view external links. ]
Vtiger CRM is a full-featured CRM software ideal for small and medium businesses, with low-cost product support available to production users that need reliable support. Vtiger CRM helps you bring the full potential to life in marketing, sales, and overall customer service.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
Dolibarr is a software built by modules addition, to manage small or medium companies, freelancers or foundations. Dolibarr is an OpenSource project base on a WAMP, MAMP or LAMP server.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
Sugar CRM is the world's leading provider of commercial open source customer relationship management (CRM) software. Founded as an open source project in 2004, SugarCRM applications have been downloaded over five million times and currently serve over 500,000 users in 75 languages.
Taken from [ Register or Signin to view external links. ] .

Guest Books

[ Register or Signin to view external links. ]
Lazarus is a free guestbook script written in PHP that uses your MySQL database for storage and is based upon the excellent Advanced Guestbook script from Proxy2. Lazarus has more features and several layers of anti spam protection to make one of the most feature rich and spam resistant guestbook scripts available for free.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
BellaBook is a small and simple PHP guestbook. It works using "flat files" - that means no need to fiddle with complex MySQL databases! BellaBook has been crafted to provide a feature packed user feedback system with an easy-to-edit coding structure; using CSS to control it all.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
phpBook is a PHP/MySQL guestbook program. Features: Nice interface; Fast and stable code; Language templates (english, german, italian, potuguese, french, dutch, swedish, chinese, japanese, danish, etc); Location templates (world, europe, belgium, etc); IP logging and banning; Browser logging; Pagebreak's; Smilie's database and help (over 90 included), etc.
Taken from [ Register or Signin to view external links. ] .

Customer Support

[ Register or Signin to view external links. ]
osTicket is a widely-used open source support ticket system. It seamlessly integrates inquiries created via email and web-based forms into a simple easy to use multi-user web interface. Easily manage, organize and archive all your support requests and responses in one place while providing your clients with accountability and responsiveness they deserve.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
Hesk is Free PHP Help Desk Software that runs with a MySQL database. It allows you to set up a web-based ticket support system (helpdesk) for your website. Once the Help Desk Software is installed your customers will be able to submit support tickets and staff will have an easy-to-use web interface to manage customer support requests.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]

Click to View Content
[ Register or Signin to view external links. ]

Trellis Desk is a powerful and robust help desk solution for your business. Improve your company's service by allowing your customers to quickly and easily submit support tickets to your team. Trellis Desk sports a range of advanced features that enable your business to handle customer support more efficiently.
Taken from [ Register or Signin to view external links. ] .

Frameworks

[ Register or Signin to view external links. ]
CodeIgniter is a powerful PHP framework with a very small footprint, built for PHP coders who need a simple and elegant toolkit to create full-featured web applications. If you're a developer who lives in the real world of shared hosting accounts and clients with deadlines, and if you're tired of ponderously large and thoroughly undocumented frameworks.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
Zend Framework is based on simplicity, object-oriented best practices, corporate friendly licensing, and a rigorously tested agile codebase. Zend Framework is focused on building more secure, reliable, and modern Web 2.0 applications and web services, and consuming widely available APIs from leading vendors like Google, Amazon, Yahoo!, Flickr, as well as API providers and cataloguers like StrikeIron and ProgrammableWeb.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
CakePHP makes building web applications simpler, faster and requires less code. CakePHP is a rapid development framework for PHP which uses commonly known design patterns like Active Record, Association Data Mapping, Front Controller and MVC. Our primary goal is to provide a structured framework that enables PHP users at all levels to rapidly develop robust web applications, without any loss to flexibility.
Taken from [ Register or Signin to view external links. ] .

Educational

[ Register or Signin to view external links. ]
Moodle is a Course Management System (CMS), also known as a Learning Management System (LMS) or a Virtual Learning Environment (VLE). It is a Free web application that educators can use to create effective online learning sites.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
Claroline is an Open Source eLearning and eWorking platform allowing teachers to build effective online courses and to manage learning and collaborative activities on the web. Translated into 35 languages, Claroline has a large worldwide users and developers community.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
DoceboLMS is a SCORM compliant Open Source e-Learning platform used in corporate, government and education markets. DoceboLMS makes it extremely easy to construct the didactic content of lessons and teachers are free to reuse files that they already have (Powerpoint, Word, PDF, film clips, etc). Users can also be managed by groups or categories and it is also possible to personalize the graphics environment for subgroups of users.
Taken from [ Register or Signin to view external links. ] .

Database Tools

[ Register or Signin to view external links. ]
phpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
MyWebSQL is the ultimate desktop replacement for managing your MySQL databases over the web. With an interface that works just like your favorite desktop applications, you don't need to keep switching over web pages to get simple things done. Just log in to your database and manage your database as if you are working on your desktop!
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
Adminer is a full-featured database management tool written in PHP. Conversely to phpMyAdmin, Adminer consist of a single file ready to deploy to the target server. Adminer is available for MySQL, PostgreSQL, SQLite, MS SQL and Oracle.
Taken from [ Register or Signin to view external links. ] .

Music

[ Register or Signin to view external links. ]
kPlaylist is a free PHP system that makes your music collection available via the Internet. kPlaylist is a music database that you manage via the web. With kPlaylist you can stream your music (ogg, mp3, wav, wma, etc.), you can upload, make playlists, share, search, download and a lot more.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
Podcast Generator is a free web based podcast publishing script written in PHP: upload media files (audio-video) via a web form along with episode information and automatically create podcast w3c-compliant feed including iTunes specific tags. It also features a comprehensive web administration.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
AmpJuke will act as your streaming server. Besides music streaming AmpJuke can fetch album covers/images/lyrics automatically using various web services from last.fm, Bing! and other sources. Scan+import tags from as many tracks you like, use the favorites as well as a bunch of other personal settings to customize the way AmpJuke operates.
Taken from [ Register or Signin to view external links. ] .

Video

[ Register or Signin to view external links. ]
ClipBucket is an opensource and free script that will let you start your own Video Sharing(Youtube Clone) website in matter of minutes, ClipBucket is fastest growing script with most video sharing websites and social networking freatures.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
VidiScript packed with features you can only find on major media sharing communities such as YouTube, Meta Cafe and Break, VidiScript is the most powerful FREE open source video sharing community script available online today!
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
videoDB is a web application to manage a personal video collection. Multiple video types are supported, ranging from VHS tapes and DVDs to Blu-ray discs and DivX files on hard-disc. Even video games are supported. VideoDB allows you to effortlessly maintain and manage your collection by features fetching of movie data and covers from various information sourced, including Internet Movie Database (IMDB), Amazon, Allocine, DVDInside, DVDPlace, Google, OFDB, DVDB, and tv.com. External data like cover images or actor thumbnails is locally cached in videoDB and readily available in your database.
Taken from [ Register or Signin to view external links. ] .

RSS

[ Register or Signin to view external links. ]
Gregarius is a web-based RSS/RDF/ATOM feed aggregator, designed to run on your web server, allowing you to access your news sources from wherever you want.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
Feed On Feeds is a server side, multi-user RSS and Atom aggregator! A news aggregator allows you to subscribe to news sources and have new items collected together on a single page. The newest items appear at the top, and you can mark old news items read.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
selfoss is a new multipurpose rss reader, live stream, mashup, aggregation web application. selfoss supports all modern browsers, including Mozilla Firefox, Safari, Google Chrome, Opera and Internet Explorer. You can easily add your own data sources. Spouts (aka plugins) fetch the content from the different sources.
Taken from [ Register or Signin to view external links. ] .

File Manager

[ Register or Signin to view external links. ]
ownCloud gives you freedom and control over your own data. A personal cloud which runs on your own server. ownCloud allows you to access your data wherever you are, when you need it.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
Pydio was formerly known as AjaXplorer. Pydio: Put Your Data In Orbit! allows you to instantly turn any server into a powerful file sharing platform: install once and access your files from anywhere. Organize, preview and share them, easily and securely.
Taken from [ Register or Signin to view external links. ] .

[ Register or Signin to view external links. ]
LetoDMSis an open-source document-management-system based on PHP and MySQL. LetoDMS allows you to store any kind of binary data - just like a usual file-system. But there are some features that extend the normal capabilities of a file-system. LetoDMS makes it possible to access your documents not only via intranet in your office but worldwide via the internet.
Taken from [ Register or Signin to view external links. ] .