Dynamic Website with PHP Exercise

Create Dynamic Website
-Define Local Information & Testing Server in DW
Website Name: Contactroot
folder: contact

Create record set & display informationIn dynamic website:
1. Create "country_all.php"
2. Create a dabase connection to the "newland_tours" database on MySQL database server
3. Create record set "rsCountries" to retrieve all fields and records from tbl_country(sory by countryName ascending)
4. Make a table with two row-first row: header-second row: record
(Assume "dynamic"

Sort descending
1. Choose "dynamic" website and open "country_all.php"
2. Add a new column "population" in the table
3. Change the record to dsiplay by population descending (desc in SQL) in advanced mode

Setting up dynamic website development enviroment

Here is the listing of some tools useful:
1. XAMPP (Apache + PHP + MySQL, with phpmyadmin)
2. MySQL ODBC Connector

Enviroment
Web Server + Application Server + Database Server
1. Open Source: Apache + PHP + MySQL
2. Microft IIS (web server + ASP/ASP.NET) + Open Source MySQL (Need MySQL ODBC Connector)

Security Tools

• PortQry
• Virus sample