Computer Applications

Tuesday, March 16, 2010

Categories Of Web Hostings

Free web hosting service
Shared web hosting service
Reseller web hosting
Virtual Dedicated Server
Dedicated hosting service
Managed hosting service
Colocation web hosting service

Cloud Hosting: is a new type of hosting platform that allows customers powerful, scalable and reliable hosting based on clustered load-balanced servers and utility billing.

Grid hosting: this form of distributed hosting is when a server cluster acts like a grid and is composed of multiple nodes.

Domain

1.Domain Name System (DNS), an hierarchical naming system for computers or any resource connected to the Internet.
2.Domain model, a conceptual model of a system that describes the various entities involved and their relationships
3.Domain name registrar, an organization that manages the reservation of Internet domain names in one or more domains.

Web Site

A web site is a collection of related web pages, images, videos or other digital assets that are addressed relative to a common Uniform Resource locator (URL), often consisting of only the domain name, or the IP address, and the root path ('/') in an Internet Protocol-based network.

A web page is a document, typically written in plain text interspersed with formatting instructions of Hypertext Markup Language (HTML,XHTML).

Saturday, January 23, 2010

What is MySQL?

1.MySQL is a database.
2.The data in MySQL is stored in database objects called tables.
3.A table is a collections of related data entries and it consists of columns and rows.

Queries:

A query is a question or a request.

With MySQL, we can query a database for specific information and have a recordset returned.

Create a Connection to a MySQL Database

Code:

$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
?>

Closing a Connection in PHP & MySQL.

Code:

$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_close($con);
?>

Create Database and Tables in MySQL

Code:

$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
if (mysql_query("CREATE DATABASE my_db",$con))
{
echo "Database created";
}
else
{
echo "Error creating database: " . mysql_error();
}
mysql_close($con);
?>