IRMARAMLI

Thursday, November 28, 2019

LAB ASSIGNMENT 09 & 10

Hello :)
So today i will tell about what we do during lab assignment 9 and 10

Basically, what we need to do is continue our lab assignment 7. we just need to add column picture in lab 09 and for lab 10 we need to add column video. For these two lab assignment i feel excited because i a great job hehehhehe. Below is result of what i have done for lab 9 and 10 :)

LAB ASSIGNMENT 8

In lab 08 we did the interface and connect it with php admin. the interface consist of username and password. after user enter the right answer the desktop will display the information of the user.

LAB ASSIGNMENT 07

In this lab we need to create our own database and create an interface for the system. What i did is Samsung system, the content is home, list of product, register new product and view product that just added in register. Actually for lab 07 we only need to create the interface for our website. below is the interface that i created,

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