HTML

HTML 

In this blog post I will explain some of the important HTML code used in our project. I will outline what it does and what we use it for.

Index page 

rsz_index

Index page is one of the most important pages in our website. The HTML code used for this page is to create a Register Form and a Log in Form which is the first thing that appears for the user when he enters the website. In previous post with discussed hot PHP script allows the page to do something so this HTML code is as well injected with PHP. If it was just HTML the log in and register forms would not work and the page would just submit to itself . There is also log in and register buttons created.

Submit Day Out page 

rsz_submit_day_out

This HTML code is also used to create a form fo day out submission. The codes consists of having 4 different text fields and one numeric field. The 4 text fields are used for name, description, location and the numeric field is used to give the day out a rating from 1 to 5.  There is also a submit button created.  As well as index page this page also has PHP so that it does not submit to it self and the data is authenticated and send to the database. This Page also contains code that create a box with the information every time a new day out is added. This looks more organized than having plain text on plain background.

Day Out Page 

rsz_day_out

 

Day out page HTML code is quite simple as it only consist of different <div> to sort out the day out’s we suggest to the user. The Page creates a top title with the type of the day and then 3 day out suggestion follows bellow it with all the information. Day out’s are stored in individual boxes to keep the information clear and easy to read. These boxes are created using CSS class=”day-box”.

 

 

Advertisements

PHP and MySQL

What is PHP ?

PHP (recursive acronym for PHP: Hypertext Preprocessor) is a widely-used open source general-purpose scripting language that is especially suited for web development and can be embedded into HTML.”

This one of the definition You can find on the web about what is PHP. This definition is from http://php.net/. So what are the features of PHP then? To understand that I have to outline that PHP is different from static html. This is because HTML run from your computer and PHP doesn’t get executed on your computer, but on the computer you requested the page from. Instead of writing a lot of commands using HTML , PHP allows you to embedded code which does “something”. The PHP code is read from top to bottom until the end of the process. If a user views the page source of a website that contains PHP he only sees the answers that PHP executes. This is enclosed in special start and processing instructions (<?php and ?>) which allows to jump in and out from PHP mode.

PHP Features 

  • Does not execute on your computer
  • It allows to enhance the HTML code
  • PHP is server side scripting
  • Allows you to create website application with registrations, log in pages, content upload ect.
  • PHP is free
  • PHP can be run on any operating system

These are one of the many features of PHP. For our website application we had to use PHP as well as it contains content upload, registration and log in. I will go into more details of PHP used in our website application in another blog post.

What is MySQL

“MySQL is a freely available open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL).”

MySQL is the most popular open source database management system. MySQL has been developed, distributed and supported by Oracle Corporation. Is use GNU (General Public Licence) which means that everyone can look at the MySQL script and update it to suit their needs. MySQL database is a rational database. This means that instead of storing a lot of data in one place the date is split in separate tables. in MySQL databases you can set up relationships between different data. The database is able to recognize the relationships so that you don’t have duplicate data, out of date data or missing data. The SQL which stand for Structured Query Language is used to follow the rule between the relationships. Therefore SQL is used to communicate with the database.

MySQL Features: 

  • Open source (general public can edit the script to suit their needs)
  • Free to use
  • Uses rational database management system
  • Allows to set rules and parameters for data
  • Make relationship between different data
  • Information is stored in different tables rather than in once place

References: 

http://www.homeandlearn.co.uk/php/php1p1.html

https://www.siteground.com/tutorials/php-mysql/mysql.htm

https://dev.mysql.com/doc/refman/4.1/en/what-is-mysql.html

http://www.sqlcourse.com/intro.html

http://php.net/manual/en/intro-whatis.php