Web Design company – Goweb99 blogGet your website designed for as low as $99.

I just viewed my Website and I wanted to tell you that it looks great! I also wanted to say what a pleasure it was to work with you and your entire team at Go Web 99. I truly feel I got a professional website without paying the expensive professional fees. As a small business I can’t Thank you enough.
Sincerely,
Cheryl Lund
Bella Blinds & Window Designs – http://bellablindsandwindows.com

---

[Translate]

I wanted to thank you for all of your help. You were very patient when I was unable to give the matter all of my attention. I would definitely recommend your services to anyone interested in creating a web site.
Marina – http://floridatreasurecoastrental.com

---

[Translate]

Thank you for designing the website for the restuarant.
The site is user friendly and we would certainly recommend you to other businesses who would want a website for their works.
Thank you once again,
it was a job well done
Balraj Awasthy (Timothy Tikka House) – http://timothyindiancuisine.com

---

[Translate]

The Goweb99 team has built a beautiful website for us. They have responded to our many requested changes and ideas with patience and persistence. Our new website will be a great new tool in our marketing efforts.

Sincerely,
Larry Hairston – http://breckenridgemountaincondos.com

---

[Translate]

I wanted to personally thank-you and the Goweb99 Team for creating my personalized vacation website.  The website you created was exceptional and will greatly help to market my vacation rental villas.   Your creativity, timely development and patience with my many many changes was greatly appreciated!  Thank-you so much!

 Sincerely,
Elizabeth Bender
Beach Villas
Jeb Holdings LLC – www.luxurybeachvillassite.com

---

[Translate]

I am writing to thank you for working with me to put together a new web site. I am very pleased with the outcome. The website has already brought us rentals, and it has been up for only a short time.

I was pleased to see that I was able to change the way the website was set up to meet my needs. Tony worked with me to make any changes I suggested.
We worked together to make a website that is exactly what I wanted.

My husband and I were especially pleased with the price of the website.
The price was what made us decide to go ahead with the webpage, and, quite frankly, I was not expecting the quality we experienced from GOWeb99. I would recommend this service for anyone who has been thinking about designing a website for their business.

Sincerely,
Alice and Tom Eldred – http://greatestpoconorentals.com

---

[Translate]

We use this service for the first time and were not sure what to expect. We are happy to report that they are very professional in every aspect of web design. We had a gentleman by the name of Tony Walker who did our design, he was in contact with us often, and made changes for us to our satisfaction. Very pleased with the work, and staff from Go Web 99. A special thanks to Tony Walker.
Edward Sayfie – http://lakemichigancottagerental.com

---

[Translate]

Go Web 99 values customer satisfaction and they are very true to their word. The technicians are honest and very hard working. Tony Walker, our support technician was very responsible and prompt with any changes I had wanted to make to our website. They consulted us with every little detail, and made sure that it was exactly what we wanted. I would recommend GoWeb99 to anyone who wants an organized and professional website that is wallet friendly. We were so pleased with them that we are currently working on our second website with them. Thank-you Go Web 99 for the hard work you have put in to our website, and keep up the good work!
Mr. M R Malik – http://awesomepizza.ca

---

[Translate]

The ORDER BY is a keyword which is used to arrange or sort the data in a recordset.

If  you will not specify in which order to arrange the result, ORDER BY will arrange them in ascending order by default.

If you want to sort the records in a descending order, you can use the DESC keyword.

Syntax

SELECT column_name(s)
FROM table_name
ORDER BY column_name(s) ASC|DESC

For eg:

<?php
$conn = mysql_connect(”localhost”,”tutor”,”tutor123″);
if (!$conn)
{
die(’Could not connect: ‘ . mysql_error());
}
mysql_select_db(”my_db”, $conn);
$result = mysql_query(”SELECT * FROM Country ORDER BY Country”);
while($row = mysql_fetch_array($result))
{
echo $row['Country'];
echo ” ” . $row['Capital'];
echo “<br />”;
}
mysql_close($conn);
?>

Output:

Poland Warsaw
Zimbabwe Harare

Order by Two Columns

It is also possible to order by more than one column. When ordering by more than one column, the second column is only used if the values in the first column are same:

SELECT column_name(s)
FROM table_name
ORDER BY column1, column2

---

[Translate]

WHERE clause is used to filter records, on the basis of some conditions.

Syntax

SELECT column_name(s)
FROM table_name
WHERE column_name operator value

The following example selects all rows from the “Country” table where Country=’Poland’.

For eg:

<?php
$conn = mysql_connect(”localhost”,”tutor”,”tutor123″);
if (!$conn)
{
die(’Could not connect: ‘ . mysql_error());
}
mysql_select_db(”my_db”, $conn);
$result = mysql_query(”SELECT * FROM Country
WHERE Country=’Poland’”);
while($row = mysql_fetch_array($result))
{
echo $row['Country'] . ” ” . $row['Capital'];
echo “<br />”;
}
?>

Output:

Poland Warsaw

---

[Translate]

The SELECT statement is used to select data from a database, based on some conditions or all of the data.

Syntax

SELECT column_name(s)
FROM table_name

The following example selects all the data stored in the “Country” table.A * character selects all the data in the table.

For eg:

<?php
$conn = mysql_connect(”localhost”,”tutor”,”tutor123″);
if (!$conn)
{
die(’Could not connect: ‘ . mysql_error());
}
mysql_select_db(”my_db”, $conn);
$result = mysql_query(”SELECT * FROM Persons”);
while($row = mysql_fetch_array($result))
{
echo $row['Country'] . ” ” . $row['Capital'];
echo “<br />”;
}
mysql_close($conn);
?>

The example above stores the data returned by the mysql_query() function in the $result variable.

Next, we use the mysql_fetch_array() function to return the first row from the recordset as an array. Each call to mysql_fetch_array() returns the next row in the recordset. The while loop loops through all the records in the recordset. To print the value of each row, we use the PHP $row variable.

Output:

Zimbabwe Harare
Poland Warsaw

Display the Result in an HTML Table

The following example selects the same data as the example above, but will display the data in an HTML table:

<?php
$conn= mysql_connect(”localhost”,”tutor”,”tutor123″);
if (!$con)
{
die(’Could not connect: ‘ . mysql_error());
}
mysql_select_db(”my_db”, $conn);
$result = mysql_query(”SELECT * FROM Country”);
echo “<table border=’1′>
<tr>
<th>Country</th>
<th>Capital</th>
</tr>”;
while($row = mysql_fetch_array($result))
{
echo “<tr>”;
echo “<td>” . $row['Country'] . “</td>”;
echo “<td>” . $row['Capital'] . “</td>”;
echo “</tr>”;
}
echo “</table>”;
mysql_close($con);
?>

Output:

Firstname	Lastname
Zimbabwe	Harare
Poland	Warsaw

---

[Translate]

The most interesting part of a web application is that you can use dayabase to fill the form data and vice versa. This is the most useful part also, as it increases the user interactivity and helps is realizing many functions like filling up a form online.

For eg:

<html>
<body>
<form action=”insert.php” method=”post”>
Country: <input type=”text” name=”country” />
Capital: <input type=”text” name=”capital” />
<input type=”submit” />
</form>
</body>
</html>

When a user clicks the submit button in the HTML form in the example above, the form data is sent to “AddValues.php”.

The “AddValues.php” file connects to a database, and retrieves the values from the form with the PHP $_POST variables.Then, the mysql_query() function executes the INSERT INTO statement, and a new record will be added to the “Country” table.

AddValues.php:

<?php
$con = mysql_connect(”localhost”,”tutor”,”tutor123″);
if (!$conn)
{
die(’Could not connect: ‘ . mysql_error());
}
mysql_select_db(”my_db”, $conn);
$sql=”INSERT INTO Country (Country, Capital)
VALUES(’$_POST[country]‘,’$_POST[capital]‘)”;
if (!mysql_query($sql,$con))
{
die(’Error: ‘ . mysql_error());
}
echo “Record added successfully”;
mysql_close($conn)
?>

---

[Translate]

After creating a table you will need to insert records. You can use the INSERT INTO statement to add records to a database table.

There are two different forms to write this statement. The first form doesn’t specify the column names where the data will be inserted, only their values:

INSERT INTO table_name VALUES (value1, value2, value3,…)

The second form specifies both the column names and the values to be inserted:

INSERT INTO table_name (column1, column2, column3,…)
VALUES (value1, value2, value3,…)

For eg:

<?php
$conn = mysql_connect(”localhost”,”tutor”,”tutor123″);
if (!$conn)
{
die(’Could not connect: ‘ . mysql_error());
}
mysql_select_db(”my_db”, $conn);
mysql_query(”INSERT INTO Persons (Country, Capital)
VALUES (’India’, ‘New Delhi’)”);
mysql_query(”INSERT INTO Persons (Country, Capital)
VALUES (’United States of America’, ‘Washington D.C.’)”);
mysql_query(”INSERT INTO Persons (Country, Capital)
VALUES (’Zimbabwe’, ‘Harare’)”);
mysql_query(”INSERT INTO Country (Country, Capital)
VALUES (’Poland’, ‘Warsaw’)”);
mysql_close($conn);
?>

---

[Translate]

A primary key uniquely identifies the rows in a table. Each primary key value is unique within the table. It cannot be null because the database engine requires a value to locate the record.

The primary key of a relational table uniquely identifies each record in the table. A primary key can be any of the following:

It can either be a normal attribute that is guaranteed to be unique such as Social Security Number in a table with no more than one record per person

It can be generated by the DBMS. Primary keys may consist of a single attribute or multiple attributes in combination.

Autoincrement

We can get a unique auto generated number from MySQL by creating an auto incremented field. MySQL will generate a unique number by incrementing the last number of the table and will automatically add to the auto incremented field. We need not have to specify any thing in our query while adding the auto incremented field data. After successfully adding the record we can get this unique number by using mysql_insert_id().

For eg:

$sqlQuerry = “CREATE TABLE Persons
(
countryID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(countryID),
Country varchar(15),
Capital varchar(15)
)”;
mysql_query($sqlQuerry,$conn);

---

[Translate]

The CREATE TABLE statement is used to create a table in a database of MySQL.

Syntax

CREATE TABLE table_name
(
column_name1 data_type,
column_name2 data_type,
column_name3 data_type,
….
)

We must add the CREATE TABLE statement to the mysql_query() function to execute the command.

For eg:

<?php
$conn = mysql_connect(”localhost”,”tutor”,”tutor123″);
if (!$conn)
{
die(’Could not connect: ‘ . mysql_error());
}
// Create database
if (mysql_query(”CREATE DATABASE my_db”,$conn))
{
echo “Database Creation:Successful”;
}
else
{
echo “Database Creation:Unsuccessful: ” . mysql_error();
}
// Create table
mysql_select_db(”my_db”, $conn); //Select database in which table is to be created
$sqlQuerry = “CREATE TABLE Country
(
Country varchar(15),
Capital varchar(15),
)”;
// Execute query
mysql_query($sqlQuerry,$conn);
mysql_close($con);
?>

Before creating a table you must select some database. The database is selected with the mysql_select_db() function.

Varchar() is a function which defines the data type for the variables containing alpha-numeric characters. You need to specify the maximum length of the field in varchar() e.g. varchar(15).

---

[Translate]

The first step is to create a database and then we can create tables in that database which we can use in our application.

To create a database in MySQL the CREATE DATABASE statement is used.

Syntax

CREATE DATABASE database_name

The above statement runs in a querry analyzer. A querry analyzer is an interface to run database commands.  But you can run this stament directly from PHP by using the mysql_query() function. This function is used to send a query or command to a MySQL connection.

The following example creates a database called “my_db”:

For eg:

<?php
$conn = mysql_connect(”localhost”,”tutor”,”tutor123″);
if (!$conn)
{
die(’Could not connect: ‘ . mysql_error());
}
if (mysql_query(”CREATE DATABASE my_db”,$conn))
{
echo “Database creation:Successful”;
}
else
{
echo “Database creation:Unsuccessful: ” . mysql_error();
}
mysql_close($conn);
?>

---

[Translate]

For using a database, first you need to install a database, then there must be a database with the desired tables you wish to use. Finally there should be data in the tables which you will be using in your application.

The second major step then is to access the data through the database in your application.
For accessing data in a database, you must create a connection to the database. A connection is the gateway through which your request will go to the database and the result will be provided to you from the database.

In PHP, this is done with the mysql_connect() function.

Syntax

mysql_connect(servername,username,password);

Parameter
servername	Optional. Specifies the server to connect to. Default value is “localhost:3306″
username	Optional. Specifies the username to log in with. Default value is the name of the user that owns the server process
password	Optional. Specifies the password to log in with. Default is “”

In the following example we store the connection in a variable ($con) for later use in the script. The “die” part will be executed if the connection fails:

For eg:

<?php
$con = mysql_connect(”localhost”,”peter”,”abc123″);
if (!$con)
{
die(’Could not connect to database: ‘ . mysql_error());
}
// some code
?>

Closing a Connection

The connection that is created and opened to access data in a database will be closed automatically when the script ends. But you can close it as soon as the database related work is done. To close the connection through your code you can use the mysql_close() function:

<?php
$conn = mysql_connect(”localhost”,”tutor”,”tutor123″);
if (!$conn)
{
die(’Could not connect to database: ‘ . mysql_error());
}
// some code
mysql_close($conn);
?>

---

[Translate]

As you already know that PHP is a scripting language which is used to create dynamic contents on a website. The dynamic content may be some static information like a single image with effects or a single line as a banner. But there could be a serious need to store and retrieve some information at times. All of the content management systems, blogs or only a simple form processor use database.

The best and the most often used database with PHP is MySQL. MySQL is the most popular open-source database system. It is simple to use, and easy to interface with.

A database in general is a repository of information, where data is stored in a format which can easily operated upon.

The most common and widely used type of database is relation where the data is stored in tables. Tables are database objects which consists of columns and rows. A table contain similar kind of data associated to each other by some defined relation. Some tables may also be related to each other. Each table has a set of primary keys which are used to refer to the data uniquely. Primary key is a set of some information which is unique for each row.

Databases are useful when storing information categorically.

Database Tables

A database most often contains one or more tables. Each table is identified by a name. Each table contains records with data.

Below is an example of a table called “Country”:

Country	Capital
India	Delhi
United States of America	Washington D.C.
Zimbabwe	Harare
Poland	Warsaw

The table above contains four records, one for each country and two columns, Country and capital.

---

[Translate]