IRMARAMLI: October 2019

Monday, October 28, 2019

WEEK 7: WEB APPLICATION DEVELOPMENT (Database & SQL, Database integration, Redirecting Page)

Server side script (MySQL)

1. SQL Data Manipulation Language (DML)

SELECT
UPDATE
DELETE
INSERT INTO

2. SQL Data Definition Language( DDL)

CREATE TABLE
ALTER TABLE
DROP TABLE
CREATE INDEX
DROP INDEX

Basic select query

SELECT * FROM tablename

SELECT AuthorID, lastName FROM Authors;

DATABASE INTEGRATION

Advantage of using database to store web data

faster access
better concurrent access
easier change to data script
increased security

LAB 6 ASSIGNMENT

Based on topic 8 & 9 create sample exercise

we do all the exercise in this chapter.

WEEK 6: SERVER SIDE SCRIPT (PHP)

PHP is popular and its use in increasing rapidly because several advantage:

Easy to use
Secure and easy to learn
easy to learn
open source
language support for database
must using php extension

The way to write code using php

<html> Server Side Script: PHP

<?php

echo “<h1> Hello, World!>/h1>”;

</html>

Operators

1. Arithmetic Operators

2. Comparison operators

SERVER SIDE SCRIPT(PHP) & FORM

PHP is really good at handling data submitted to the server in HTML forms.

simple form:

<form METHOD= “GET”

ACTION= “process.php”>

Two main attributes

Method: Get and post

Action: specify the target which where is data be transmitted.

LAB 5 ASSIGNMENT

Creating table

Using LabPhpAdmin document that sir provided we can create the table.
What we do ?

Create database
insert the field name, data type and value
insert the value

WEEK 5: Concept of web server

During week 5 we learn Concept of web server.

Web servers

Specialized software that respond to client request by providing resources.
When users enter URL into web browsers, they request specific document from server
Communicate with client using HTTP
The top servers is Apache

Introduce 3 Web servers

Internet Information System
Personal web server (PWS)
Apache Web Server

HTTP Request types

Request method

Retrieve and send client form data to web server

Get
Post
Cache

LAB 4 ASSIGNMENT

The task is to create HTML Documents by using creative example or exercises given and design the interface such as buttons, menus etc.

This is what i did:

How i code?

<html>
<head>

<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
<br></br>
<h1>LEARN JAVASCRIPT</h1>
<img src="javascriptpicture.gif" width="600" height="200">
<style>

body {
font-family: Arial, Helvetica, sans-serif;
margin: 0;
}

.navbar {
overflow: hidden;
background-color: #333;
}

.navbar a {
float: left;
font-size: 16px;
color: white;
text-align: center;
padding: 14px 16px;
text-decoration: none;
}

.subnav {
float: left;
overflow: hidden;
}

.subnav .subnavbtn {
font-size: 16px;
border: none;
outline: none;
color: white;
padding: 14px 16px;
background-color: inherit;
font-family: inherit;
margin: 0;
}

.navbar a:hover, .subnav:hover .subnavbtn {
background-color: red;
}

.subnav-content {
display: none;
position: absolute;
left: 0;
background-color: orange;
width: 100%;
z-index: 1;
}

.subnav-content a {
float: left;
color: blue;
text-decoration: none;
}

.subnav-content a:hover {
background-color: #eee;
color: black;
}

.subnav:hover .subnav-content {
display: block;
}
</style>
</head>

<body>

<div class="navbar">
<a href="#home">Home</a>

<div class="subnav">
<button class="subnavbtn">JavaScript Basic <i class="fa fa-caret-down"></i></button>
<div class="subnav-content">
<a href="syntax.html">Syntax</a>
<a href="Operators.html">Operators</a>
<a href="JavaScriptBasic.html">Placement</a>
<a href="ifElse.html">If- Else</a>
</div>
</div>

<div class="subnav">
<button class="subnavbtn">JavaScript Object <i class="fa fa-caret-down"></i></button>
<div class="subnav-content">
<a href="objectt.html">Object</a>
<a href="Numbers.html">Numbers</a>
<a href="Boolean.html">Boolean</a>
<a href="String.html">String</a>
</div>
</div>
<div class="subnav">
<button class="subnavbtn">JavaScript Advance <i class="fa fa-caret-down"></i></button>
<div class="subnav-content">
<a href="formvalidation.html"> Form Validation</a>
<a href="animation.html">Animation</a>
<a href="Multimedia.html">Multimedia</a>
<a href="browsers.html">Browsers</a>
</div>
</div>
<a href="#contact">Help</a>
</div>

<div style="padding:0 16px">
<h3>What is JavaScript?</h3>
<p>Hover over the "Javascript is a dynamic computer programming language. It is lightweight and
most commonly used as a part of web pages, whose implementations allow
client-side script to interact with the user and make dynamic pages. It is an
interpreted programming language with object-oriented capabilities.
JavaScript was first known as LiveScript, but Netscape changed its name to
JavaScript, possibly because of the excitement being generated by Java.
JavaScript made its first appearance in Netscape 2.0 in 1995 with the
name LiveScript. The general-purpose core of the language has been
embedded in Netscape, Internet Explorer, and other web browsers.
</p>
</div>

</body>
</html>

Friday, October 25, 2019

WEEK 4: Concept of client server, Cascading style sheet (CSS), and Java Script.

During week 4 we learn 3 chapter which is concept of client server, Cascading style sheet (CSS), and Java Script.

1.0 concept of client server

Clients and server corporate to deliver network service.
clients : initiates communication
server : send information back to clients

Client-Server Relationships

Fundamental paradigm that determines the characteristics of computer languages on the web.

The difference

1. How the language are invoked

Server side

invoked by submit button and typing in a URL.

Client side

HTML code.

2. What resources and information they can access

Server side

Operate as normal user program unless web administrators imposed restriction.

Client side

They have full access to the structures and operation of the browsers.

3. What structures can be manipulated

Server side

can manipulate any resources on the server that are accessible to any user program.

Client side

cannot manipulate anything on the server

4. How they interact with user and system.

Server side

Cannot manipulate any information on the client browser, cannot modify the existing.

Client side

interact easily with user

5. The speed and predictability of their interactions

Server side

modern traffic

Client side

swift, immediate and predictable

How client side and server side script works

Client Side Script

Interpreted or executed by the browser/client
Run on the user's workstation
Example: JavaScript, JScript, VBScript

Server Side Script

Interpreted or executed by the web server
Provide interaction web sites that interface to database or data stores
example: php, asp, netbean

2.0 Cascading Style Sheet (CSS)

Cascading style sheet is a clients side

WHY CSS?

Allows much richer document appearances that HTML
Reduce workload by centralizing commands .
Use same style on multiple page
Reduce page download size
can use HTML for content but use CSS for presentation

3.0 JavaScript

Client side scripts

Common uses of javascripts include: alerts message, popup windows, dropdown menu, form validation and displaying date and time

What do i need to create javascript

Can create using the same equipment as HTML

Computer
text editor: notepad etc
web browser: Internet explorer etc

LAB ASSIGNMENT 3

For lab assignment 3 we are required to design an interface for our own airlines web-based system. this is the example given:

And this is what i did:

To do this lab assignment i applied what sir teach during theory class and i refer notes to recall back how to create all the form and elements.

Hi, i will continue explain about html and form. Form used to collect information from people viewing your site. there are two form method which is post and get. both of this method is different.

Input Elements, there are 4 input elements that can be use which is text box, password box, radio button and check box. This is the example to code the input.
a) text

<INPUT type="text" name=“myname" size=30 maxlength=40 >

b)password

c)radio button

<INPUT type="radio" name="os“ value="mac"> Macintosh <br\>

d) check box

SELECT, we can create a pop up list which anyone can be selected . the advantage is little screen space for the list option

<OPTION>No response

<OPTION>Compuserve

WEEK 3: INTRODUCTION TO HTML

Hi, in week 3 for teory class we learn about introduction to HTML.After sir explain about this topic i can relate with lab assignment 2, we learn about html tag, table form and frame.

So first i will explain what is HTML actually ? HTML is the main language of the WWW. Web server is used to communicate the page structure to the browser. an html must have html or htm file extension and can be created using notepad. below is the basic html tag that you can memorizes.

this is how to code html:

HTML document structure have two parts which is head and body. head contains documents title and body contain the information.

Thursday, October 24, 2019

LAB ASSIGNMENT 2

Hello, for the 2nd lab assignment sir give us task which is we need to do the exercise based on the HTML.pdf notes. during this lab session i learn how to use html coding so here is my first experience using HTML.

First i learn the document structure, in html we need to put <html> at first and the last is </html>. after that head and title <head><title>Titlegoeshere</title></head> after that we can put the body.

HTML Headings, the tag to make heading is <h1>Ali fell over </h1>. we can increase the number of heading like h2, h3, h4 and the size of will decrease.

Horizontol rule is a Lines are used to separate different areas of a web page. The tag for a horizontal ruled line is <hr>. below is the example of horizontol rule

The horizontal ruled line DOES NOT have a closing tag
HTML paragraphs, The opening tag for a paragraph <p> and the closing is </p>.

HTML Text Formatting Properties, we can change the text format like italic, bold,strong and else. for example, <strong>, <i> for italic, <small>. The close tag just add /.

HTML Links, use the <a href= "location'> opening tag and </a> for closing. Whatever appears between these two tags will become underlined and colored, and if you click on the underlined text it will send the browser to the location within the quotes.for example.

there are many more topic that i learn so stay tune

WEEK 2

Hi, what i learn in first week of semester is introduction to network & web application. in this chapter Tuan zalizam explain about the type of programming languages, for example machine language which is consist of the numeric code. Secondly assembly language which is designed to be easily translated into machine language