Assignment: HTML, PHP and SQL

Running head: HTML, PHP AND SQL
HTML, PHP and SQL
Name of the Student
Name of the University
Author’s note

1HTML, PHP AND SQL
Table of Contents
1. Part 1............................................................................................................................................2
1.1 Primary Characteristics of Web 1.0.......................................................................................2
1.2 Limitations of Web 1.0..........................................................................................................2
1.3 Functions of a URL Request..................................................................................................2
2. Part 2............................................................................................................................................3
3. Part 3............................................................................................................................................4
3.1 Principles of Web Design and Analysis................................................................................4
3.2 Steps to Design a Website.....................................................................................................4
4. References....................................................................................................................................6

2HTML, PHP AND SQL
1. Part 1
1.1 Primary Characteristics of Web 1.0
 Storing of Website Content in Files.
 The webpage would not offer interactive features that would change based on the
behaviour of the website.
 The comments of the visitors of the website were primarily added to a page of Guestbook
rather than being attached within content pages.
 The Web 1.0 based browsers offered support based on proprietary tags (Choudhury
2014).
1.2 Limitations of Web 1.0
 The Web 1.0 based browsers produced static webpages where users were just able to
view posts but were not able to provide reviews or feedbacks.
 The website are not interactive.
1.3 Functions of a URL Request
Whenever an URL is entered in a browser, it would actually send an HTTP command to
the Web server. This would direct the server for fetching and transmitting the requested page.
HTTP is regarded as the underlying protocol that wold provide definition for messages
being transmitted and formatted. They would also be able to define the different actions that Web
browsers and Web servers should take for the purpose of response according to different
commands (Prati et al. 2013). The use of Web browser is used for the purpose of searching
different websites provided by a URL.

3HTML, PHP AND SQL
HTTP is called a stateless protocol as each commands would be executed in an
independent manner without prior knowledge of commands that would have occurred before.
Hence it would become difficult for implementing of websites that would react as per user input
(Zeng et al. 2015). One of the main standard that would control the World Wide Web is HTML.
They provide definitions based on the ways in which the webpages would be formatted and
displayed.
2. Part 2
Some of the relevant technologies that would enable a URL request for a PHP document
to display data from a database are Fetch API and XMLHttpRequest.
PHP is a kind of scripting language based on server side scripting. The PHP interpreter
would execute a command based on PHP script based on a request from the Web server. The
main result of the execution of the request is that the Web server would sent back the result to
the Web client, which would be issued firstly.
The PHP control structures could be defined as the main core of the programming logic.
They would permit a script for the purpose of reacting on the user input and hanging of repetitive
tasks. There would be two kinds of control structures such as Control loops and Conditional
statements.
The interaction of a PHP with the database could be performed by following the certain
steps:
 Creation of Connection – The creation of connection with the SQL server could be
performed by using the mysql_connect() function.

4HTML, PHP AND SQL
 Selection of Database – The database should be selected that would be created and
saving of data. This could be achieved with the help of mysql_select_db() function.
 Performing of Database Query – The data would be selected from the database and
brought into the web page. This could be performed by using mysql_query() function.
 Use of Return Data – The display of result on webpage could be performed by using
while() loop function in addition with mysql_fetch_array() function.
 Closing of Connection – The closing of the connection could be performed by using
mysql_close() function. This would be meant for closing the MySQL connection.
Session management could be defined as a web session sequence based on network
HTTP request and transactions of response that would be associated to a particular user. The
complex and modern web applications requires the retainment of information or the status about
each of the users for the particular duration of multiple requests (Shin et al. 2013).
3. Part 3
3.1 Principles of Web Design and Analysis
The primary purposes of web design are:
 Hierarchy of visual attractiveness
 High form of intuitive structure
 Simple accessibility of website
 Easy communication and attractive content of website (Wasson 2015)

5HTML, PHP AND SQL
3.2 Steps to Design a Website
 Requirement Analysis – This is the primary step within the SDLC. This would help in
finding the precise requirements of a website. This step would be help for determination
of target audiences, detailed features, goals of website and various similar information.
 Design – Based on the gathered information, there would be a design process of the
website. The design of the website would incorporate the design of product portfolio of
company and layouts.
 Implementation – Based on the design of the website by the designers of the team, the
different programmers would get involved for the design of the website.
 Testing – After the website is designed the testing team would be responsible for
detection of bugs and errors within the website and thus would report them back (Cebi
2013).
 Evolution – The final step involves the addition of fin details within the website. This
includes optimizing of functionality and performance based on SEO.

6HTML, PHP AND SQL
4. References
Cebi, S., 2013. Determining importance degrees of website design parameters based on
interactions and types of websites. Decision Support Systems, 54(2), pp.1030-1043.
Choudhury, N., 2014. World Wide Web and its journey from web 1.0 to web 4.0. International
Journal of Computer Science and Information Technologies, 5(6), pp.8096-8100.
Prati, A., Vezzani, R., Fornaciari, M. and Cucchiara, R., 2013. Intelligent video surveillance as a
service. In Intelligent multimedia surveillance (pp. 1-16). Springer, Berlin, Heidelberg.
Shin, S., Yegneswaran, V., Porras, P. and Gu, G., 2013, November. Avant-guard: Scalable and
vigilant switch flow management in software-defined networks. In Proceedings of the 2013
ACM SIGSAC conference on Computer & communications security (pp. 413-424). ACM.
Wasson, C.S., 2015. System engineering analysis, design, and development: Concepts,
principles, and practices. John Wiley & Sons.
Zeng, P., Tan, Q., Cao, W. and Huang, T., 2015, April. High efficient multi-pattern URL
matching algorithm based on HTTP protocol. In Communication Systems and Network
Technologies (CSNT), 2015 Fifth International Conference on(pp. 1039-1043). IEEE.