Technology Overview

TechnologyOverview

Symantec’s teams around the world are developing technologies and building solutions to help customers secure and manage their information. The company has a robust portfolio and a long history of technology leadership. The technology selected for implementing Online Funding for People is PHP/MYSQL. WAMP is used as the HTTP server.

Symantec’s Security Technology and Response (STAR) division, which includes Security Response, is a global team of security engineers, virus hunters, threat analysts, and researchers that provides the underlying security technology, content, and support for all Symantec corporate and consumer security products. The group is Symantec’s eyes and ears when it comes to surveying and keeping a finger on the pulse of the Internet security threat landscape.

Software and Services to Enable Confidence in a Connected World Symantec’s portfolio of software and services protects completely, in ways that can be managed easily and with controls that can be enforced automatically enabling confidence wherever information is used or stored. Our market-leading solutions help customers ensure that their information from digital photos to intellectual property is secure and well managed.

Technologies

Technology can be most broadly defined as the entities, both material and immaterial, created by the application of mental and physical effort in order to achieve some value. In this usage, technology refers to tools and machines that may be used to solve real-world problems.

4.1 PHP

PHP is a general-purpose scripting language that is especially suited to server side web development where PHP generally runs on a web server. PHP code is embedded into the HTML source document. Any PHP code in a requested file is executed by the PHP runtime, usually to create dynamic web page content. It can also be used for command-line scripting and client-side GUI applications. PHP can be deployed on many web servers and operating systems, and can be used with many relational database management systems (RDBMS). It is available free of charge, and the PHP Group provides the complete source code for users to build, customize and extend for their own use.

4.2 MySQL

MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. MySQL is a popular choice of database for use in web applications and is an open source product. The process of setting up a MySQL database varies from host to host, however we will end up with a database name, a user name and a password. Before using our database, we must create a table. A table is a section of the database for storing related information. In a table we will set up the different fields which will be used in that table. Creating a table in PhpMyAdmin is simple; we just type the name, select the number of fields and click the ‘go’ button. We will then be taken to a setup screen where you must create the fields for the database. Another way of creating databases and tables in PhpMyAdmin is by executing simple SQL statements. We have used this method in order to create our database and tables.

4.3 Apache

The Apache HTTP Server is web server software notable for playing a key role in the initial growth of the World Wide Web. In 2009 it became the first web server software to surpass the 100 million web site milestone. WAMP is developed and maintained by an open community of developers under the auspices of the Apache Software Foundation. Since April 1996 Apache has been the most popular HTTP server software in use. As of November 2010 Apache served over 59.36% of all websites and over 66.56% of the first one million busiest websites.

4.4 WAMP

WAMP is a small and light Apache distribution containing the most common web development technologies in a single package. Its contents, small size, and portability make it the ideal tool for students developing and testing applications in PHP and MySQL. WAMP is available as a free download in two specific packages: full and lite. While the full package download provides a wide array of development tools, WAMP Lite contains the necessary technologies that meet the Ontario Skills Competition standards. The light version is a small package containing Apache HTTP Server, PHP, MySQL, PhpMyAdmin, Openssl, and SQLite.

Obtaining and Installing WAMP

As previously mentioned, WAMP is a free package available for download and use for various web development tasks. All WAMP packages and add-ons are distributed through the Apache Friends website at the address: http://www.apachefriends.org/. Once on the website, navigate and find the Windows version of WAMP and download the self-extracting ZIP archive. After downloading the archive, run and extract its contents into the root path of a hard disk or USB drive. For example, the extract path for a local Windows installation would simply be C:\.If extracted properly we will notice a new WAMP directory in the root of your installation disk. In order to test that everything has been installed correctly, first start the Apache HTTP Server by navigating to the WAMP directory and clicking on the apache_start.bat batch file. Next we will test if the server is running correctly by opening an internet browser and typing http://localhost/ into the address bar. If configured correctly, we will be presented with a screen similar to that of the one below.

In order to stop all Apache processes we do not close the running terminal application, but instead run another batch file in the WAMP Lite directory called apache_stop.bat.

4.5 Creating a Database and Inserting Data

Now that we have run and tested Apache and PHP, the next step is running MySQL and creating a database and table which will hold information to be used by our website. In order to start MySQL, navigate to the WAMP directory and run the mysqli_start.bat batch file. The WAMP package contains an application called PhpMyAdmin which allows developers to administer and maintain MySQL databases. We will be using PhpMyAdmin to create a database and table, and enter test data. Before testing PhpMyAdmin, make sure that both Apache and MySQL are running by opening their respective batch files: apache_start.bat and mysqli_start.bat. Along with

Apache and MySQL running in the background, we type http://localhost/phpMyAdmin/ into our web browser. If successful we will be presented with a PhpMyAdmin start page similar to the one shown below.

The first step with PhpMyAdmin running is creating a new database. We create a new database by directly executing SQL statements as shown below. The successful execution of the sql query creates a database ‘mydb’ with fifteen tables in it. The tables are admin, Bankchalan, cards, card_types, catfund, cities, companies, companymembers, countries, data, donations, login, provinces, status, and users. We also inserted values in the all tables by admin panel. The screenshot below shows the successful execution of the query thus creation of a database named mydb.

 Creation of database in MySQL using PhpMyAdmin

Thus we have learned to create a database in MYSQL by executing sql statements. After creating the database and tables we are now ready to use them in our website “Student Management System”.