jils corner website documentation

8/2/2019 Jils Corner Website Documentation

1/21

Jels Corner Website

A Project

Presented to the Faculty of the

College of Information and Computing Studies

Colegio de Dagupan

Joyce F. Quilla-Reyes

(Instructor)

In Partial Fulfillment

Of the Requirements for the Course

(Subj Code) WEB DEVELOPMENT

Denis Aquino Oril

Jaudrey Cayabyab Sta. Cruz

March 12, 2012


2/21

TABLE OF CONTENTS

PAGE

TITLE PAGE . . . . . . . . . .

TABLE OF CONTENTS . . . . . . . . . 1

LIST OF TABLES . . . . . . . . . 2

LIST OF FIGURES . . . . . . . . . 3

CHAPTER

1 SITE SPECIFICATION

Proposed Domain . . . . . . . 4

Purpose of the Site . . . . . . . 4

2 SITE STORY BOARD

Wire Frame . . . . . . . . 6

Site Map . . . . . . . . . 5

3 SITE COMPONENTS . . . . . . . . 7

4 SOURCE CODE . . . . . . . . . 8-20

REFERENCES. . . . . . . . .

1


3/21

LIST OF TABLES

Table No. Table Title Page

1.1 (Database for Jels Musician Reservation). .1

. . .

2


4/21

LIST OF TABLES

Figure No. FIGURE TABLE PAGE

1.1 (Database for Jels Musician Reservation) 7

1.2 (Database Structure of Jels Musician) 7


5/21

3

Chapter 1

SITE SPECIFICATION

Proposed Domain Name of the WebsiteJels Musician Website

Purpose of the siteThe developed design project, the Jels Musician Website is

to improve the current process of managing the current

business that their company have.

Audience or user considerationsThe website is not developed for any other services aside

from ordering transactions and viewing products. It will

not be used in any other company but with the chosen

company which is Jels Musician. Online payment is not

included in the developed website as requested by the

company because of their business policy.

MaintenanceThe developed website is a web-based application which will

help the both company and their customers in the process

ordering transaction. Since Jels Musician offers band

rehearsal, selling customize guitars,drums and other music

gadgets. The developed website design system will focus on

ordering transaction such as registration of the customer

for future use viewing newest products. The design website

must be done and maintain is using the PHP scriptinglanguage and Xampp.

Client-Side Scripting LanguageWe use the PHP scripting language and Xampp in all the part

of the system design to the purposed of ordering

transaction and for the registration of their customers.


6/21

4

Server-Side Scripting LanguageWe use the PHP scripting language and Xampp in making the

server of the website to have a record of registration ofthe customer.

Chapter II

a.Site Map Jels Musician Website

Home Reservation Submit


7/21

5

b.Wire FrameJels Musician Website

Home page (jels.php)

Purpose of the Page

The purpose of this web page is to save the effort of the

customer. Instead going to the shop they can just visit the site and

view some products. It will help them to save a great deal of money,

time and will make their shopping experience much safer than before.


8/21

6

CHAPTER III

SITE COMPONENTS

Table 1.1 (Database for Jels Musician Reservation)

Name Address Contact_num Time_reseDenis,Oril,A Pangasinan 2147483647 09:00pmJaudreySta.CruzC Capaoay 2147483647 01:00pm

The purpose of this database is to have the records of the

customers for the reservation the product.

Table 1.2 (Database Structure of Jels Musician)

name char(20)address char(50)contact_num int(15)Time_reservation carchar(10)


9/21

7

CHAPTER IV

SOURCE CODE

Jells.php

Home


10/21

8

Reserve.php

Home


11/21

9

Name

Address

Contact No.

Time Reservation

admin.php


12/21

10

Admin

handle2.php


13/21

11

$time = $_POST['txttime'];

$conn = mysql_connect("localhost","root","") ;

mysql_select_db("dbjels", $conn) ;

$sql = "select * from tbljels1";

$mysql=mysql_query($sql, $conn);

while($fetch=mysql_fetch_array($mysql))

{

echo "$fetch[name]$fetch[address]

$fetch[contact_num]$fetch[time_reservation]";

}

}

?>

handle.php


14/21

12

$_POST['txtname'].','.$_POST['txtlastname'].''.$_POST['txtMI'];

$address = $_POST['txtser'];

$contact = $_POST['txtcontact'];

$time = $_POST['txttime'];



$sql = "SELECT * from tbljels1";;


while($fetch=mysql_fetch_array($mysql))

if($time==$fetch[time_reservation])

{



$sql = "INSERT into tbljels1;";


echo "Already Reserve";

}

else

{

echo "


15/21

13

src='11.gif' >

Thanks for choosing

JEL'S MUSICIAN
THANK YOU :)

";

}

}

?>

guitar.php

Home


16/21

14

width="100%">

Ibanez
Php 9,800

Globe
Php 4,500

Yamaha
Php 18,000

Fender
Php 14,500

Epiphone
Php 22,000


17/21

15

gadget.php

Home

AllSet Magnum
Php 30,000


18/21

16

Zoom G2
Php 8,000

Zoom G1N
Php 9,000

Digitech
Php 4,000

MXRz
Php 3,000

Iron Lung(Nano)
Php4,000

drums.php

Home


19/21

17

Gammon
Php 20,800

Longxing
Php 15,000

Mapex
Php 18,000

Gretsch
Php 25,000

TKO
Php 30,000


20/21

18

bass.php

Home


21/21

19

Ibanez
Php 8,000

Fender(with free amp)
Php 12,000

Yamaha
Php 16,500

Fender USA
Php 20,000

Washburn(with free amp)
Php 25,000

20

jils corner website documentation

Documents