HANDOUT WEB DINAMIS A. HALAMAN PENGUNJUNG

HANDOUT WEB DINAMIS NAMA SISTEM : WEB PROFIL SEKOLAH SMK EL RAHMA TOOLS : APACHE, PHP, HTML, MYSQL PENYIMPANAN : simpan file gambar di folder IMAGES , file untuk halaman pengunjung disimpan di root dokument website anda, file untuk admnistrator disimpan di folder ADMINIST, foto pengajar disimpan di folder PENGAJAR, foto alumni disimpan di folder ALUMNI.

A. HALAMAN PENGUNJUNG 1. FILE : TEMPLATE.PHP

LISTING PROGRAM <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> :: SMK El Rahma Yogyakarta: your excelent choice :: <style type="text/css">

Final project mata kuliah web dinamis Composed by : asih winantu,s.kom

1

Beranda

Profil Sekolah

Fasilitas

Prestasi

Staf Pengajar

Denah

Berita

Buku Tamu

Alumni

© 2009, SMK El Rahma Yogyakarta
Powered By : Raissa Enterprise

2. FILE : INDEX.PHP
2

$CONTENTMODULES[] = "profil.php"; $menu ="Profile SMK EL RAHMA"; } elseif ($page=="fasilitas") { $CONTENTMODULES[] = "fasilitas.php"; $menu ="Fasilitas Sekolah"; } elseif ($page=="prestasi") { $CONTENTMODULES[] = "prestasi.php"; $menu ="Prestasi Yang Sudah Diraih"; } elseif ($page=="pengajar") { $CONTENTMODULES[] = "pengajar.php"; $menu ="Staff Pengajar"; } elseif ($page=="denah") { $CONTENTMODULES[] = "denah.php"; $menu ="Denah Kampus SMK ERA"; } elseif ($page=="berita") { $CONTENTMODULES[] = "berita.php"; $menu ="Berita"; } elseif ($page=="bukutamu") { $CONTENTMODULES[] = "bukutamu.php"; $menu ="Buku tamu"; } elseif ($page=="alumni") { $CONTENTMODULES[] = "alumni.php"; $menu ="Data Alumni"; } include("template.php"); ?> 3. FILE : GLOBALS.PHP


3

4. FILE : SAMBUTAN .PHP

Untitled Document <style type="text/css"> " ; print "" ; } ?>

$data[nama]
$data[jabatan]

$data[isi]

5. FILE: PROFIL.PHP Untitled Document <style type="text/css"> Final project mata kuliah web dinamis Composed by : asih winantu,s.kom

4

Profil : $data[profil] Sejarah : $data[sejarah] Visi-misi : $data[visi_misi]
"; } print "Jurusan
"; $query=mysql_query("select * from jurusan") ; while($data2=mysql_fetch_array($query)) { print "";} print"
Jurusan Kompetensi
$data2[jurusan] $data2[kompetensi]
"; ?> 6. FILE: PRESTASI.PHP Untitled Document <style type="text/css">

5

$oke=mysql_query("select nm_prestasi,gambar,keterangan, DATE_FORMAT(tgl_raih,'%d-%m-%Y') as tgl_raih from prestasi") ; while($data=mysql_fetch_array($oke)) { print " "; } ?>

$data[nm_prestasi]

Diraih tanggal : $data[tgl_raih]
$data[keterangan]
7. FILE: PENGAJAR.PHP Untitled Document <style type="text/css"> ";} ?>

NO Nama NIP

$no $data[nama] $data[nip] Detail
8. FILE: PENGAJAR_DETAIL.PHP Untitled Document <style type="text/css">
Detail Data Pengajar

6

print ""; } ?>

Nip
Nama
Pendidikan
Email
Web
Pelajaran :
:
:
:
:
: $data[nip]
$data[nama]
$data[pendidikan]
$data[email]
$data[web]
$data[mt_pelajaran]

9. FILE: DENAH.PHP
Gambar Kampus SMK El Rahma :

Denah/rute ke kampus :

10. FILE: BERITA.PHP Untitled Document <style type="text/css"> "; } ?>

No Judul Berita Penulis Tanggal Berita

$no $data[judul] $data[author] $data[tanggal] Detail
11. FILE: BERITA_DETAIL.PHP Untitled Document
Detail Berita

$data[judul]
"; print "
$data[isi]
"; print "
Written by : $data[author] at $data[tanggal]
"; } ?>
7

12. FILE: BUKUTAMU.PHP

Nama :

Email :

Kota : <select name="kota" size="1" id="kota">

Komentar :

8

$email=$_POST['email']; $komentar=$_POST['komentar']; $lokasi=$_POST['lokasi']; $oke=mysql_query("INSERT INTO bukutamu VALUES (0,'$nama','$email','$lokasi','$komentar','')") or die (mysql_error()); if ($oke) { print "Terimakasih sudah mengisi buku tamu ya, !!"; }else print "gagal"; } ?> 13. FILE: ALUMNI.PHP

Untitled Document "; } ?>

No Tahun lulus Nama Jurusan

$no $data[thn_lulus] $data[nama] $data[jurusan] Detail
14. FILE: ALUMNI_DETAIL.PHP

Untitled Document <style type="text/css">
9

.style5 {color: #660066} -->
Detail Data Alumni

"; } ?>

NIS
Nama
Jurusan
Email
Kegiatan Sekarang
Pesan-Kesan :
:
:
:
:
: $data[nis]
$data[nama]
$data[jurusan]
$data[email]
$data[kegiatan]
$data[komentar]


10

B.HALAMAN ADMINISTRATOR Buat folder untuk menyimpan seluruh file-file yang hanya bisa diakses oleh administrator situs. Nama folder adalah ADMINISTRATOR atau ADMINIST 1.

2.

FILE : KONEKSI.PHP FILE : LOGIN.PHP

LISTING PROGRAM : ::--LOGIN--

LOGIN ADMINISTRATOR

Username :

Password :

11

$hasil = mysql_query($query); $data = mysql_fetch_array($hasil); $USERNAME = $data['username']; $PASSWORD = $data['password']; $username=$_POST['username']; $password=$_POST['password']; if ($username == $USERNAME AND $PASSWORD == $password) { session_register("SES_USERNAME"); session_register("SES_PASSWORD"); $_SESSION["SES_USERNAME"] = $USERNAME; $_SESSION["SES_PASSWORD"] = $PASSWORD; ?>
Selamat datang di halaman Administrator. Silakan masuk ke MENU Administrator.
Password Anda salah. Silakan LOGIN kembali!
3.

FILE : LOGOUT.PHP

4.

FILE :AUHENTICATION.PHP

12

else { return FALSE; } } ?> 5.

FILE : MENUADMIN.PHP

LISTING PROGRAM: Silakan Anda LOGINSebagai Administrator."; } else { ?> ::-- LOGIN --::
::-- MENU ADMINISTRATOR --::


13

6.

FILE : LISTMENUADMIN.PHP

LISTING PROGRAM : Untitled Document <style type="text/css">

<span class="style1">Menu Administrator

[ LOGOUT ]

ADMINISTRATOR

Ubah Password

14

PROFIL SEKOLAH

Input Profil

Lihat Profil

JURUSAN

Input Jurusan

Lihat Jurusan

FASILITAS

Input Fasilitas

Lihat Fasilitas

BUKU TAMU

Lihat Data Buku Tamu

DATA PENGAJAR

Tambah Data Pengajar

Lihat Data Pengajar

PROFIL ALUMNI

Input Alumni

Lihat Alumni

<strong>PRESTASI

Tambah Data Prestasi

Lihat Data Prestasi

BERITA

Tambah Berita

Lihat Berita

7.

FILE : CHANGE_PASSWORD.PHP


15

UBAH PASSWORD ADMINISTRATOR

Anda tidak berhak mengakses halaman ini.
Silakan Anda LOGINsebagai Administrator.
UBAH PASSWORD ADMINISTRATOR

Masukkan Password baru :

Masukkan kembali Password baru :

$password2) { print "Kedua password harus sama!. Tekan tombol BACK pada browser Anda."; } else { $query = "UPDATE user SET password='$password1' WHERE username='admin'"; mysql_query($query); print "Password Anda sudah diganti, silakan LOGIN kembali. "; }}} ?>


16

8.

FILE : INPUT_PROFIL.PHP

Silakan Anda LOGIN sebagai Administrator.
INPUT PROFIL

Profil :

Sejarah :

Visi-misi :


17

9.

FILE : LIHAT_PROFIL.PHP

INPUT PROFIL

Data Profil sudah masuk ke dalam database. Silakan kembali ke MENU Administrator.

DATA PROFIL SEKOLAH



18

DATA PROFIL SEKOLAH

Profil :

$data[profil]

Sejarah :

$data[sejarah]

Visi-misi :

$data[visi_misi]

Edit
"; } } ?>

10. FILE HAPUS PROFI.PHP

DATA PROFIL SEKOLAH


?>

11. FILE : EDIT_PROFIL.PHP
19

{ ?>

EDIT PROFIL

Profil :

Sejarah :

Visi-misi :

"; } } else { $query = "UPDATE profil SET profil='$profil',sejarah='$sejarah',visi_misi='$vimi' where id='$id'"; mysql_query($query); ?> Final project mata kuliah web dinamis Composed by : asih winantu,s.kom

20

Untuk menu admin selanjutnya, silhkan modifikasi file-file yang sudah ada..


21

C. DATABASE YANG DIGUNAKAN : mysql> use smkera; Database changed mysql> show tables; +------------------+ | Tables_in_smkera | +------------------+ | alumni | | berita | | bukutamu | | fasilitas | | jurusan | | pengajar | | prestasi | | profil | | sambutan | | user | +------------------+ 10 rows in set (0.00 sec) mysql> desc alumni; +-----------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+--------------+------+-----+---------+-------+ | nis | varchar(10) | NO | PRI | | | | nama | varchar(30) | NO | | | | | jurusan | varchar(30) | NO | | | | | thn_lulus | varchar(4) | NO | | | | | foto | varchar(30) | NO | | | | | kegiatan | varchar(100) | NO | | | | | email | varchar(30) | NO | | | | | komentar | text | NO | | | | +-----------+--------------+------+-----+---------+-------+ 8 rows in set (0.00 sec) mysql> desc berita; +---------+-------------+------+-----+-------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------+-------------+------+-----+-------------------+----------------+ | id | int(10) | NO | PRI | NULL | auto_increment | | judul | varchar(50) | NO | | | | | isi | text | NO | | | | | tanggal | timestamp | NO | | CURRENT_TIMESTAMP | | | author | varchar(50) | NO | | | | | gambar | varchar(50) | YES | | NULL | | +---------+-------------+------+-----+-------------------+----------------+ 6 rows in set (0.00 sec) mysql> desc bukutamu; +----------+-------------+------+-----+-------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+-------------------+----------------+ | id | int(10) | NO | PRI | NULL | auto_increment | | nama | varchar(30) | NO | | | | | email | varchar(30) | NO | | | | | lokasi | varchar(50) | NO | | | | | komentar | text | NO | | | | | tanggal | timestamp | NO | | CURRENT_TIMESTAMP | | +----------+-------------+------+-----+-------------------+----------------+ 6 rows in set (0.00 sec) mysql> desc fasilitas; +----------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+---------+----------------+ | id_fasilitas | int(10) | NO | PRI | NULL | auto_increment | | nama_fasilitas | varchar(50) | NO | | | | | keterangan | text | NO | | | | | gambar | varchar(50) | NO | | | | +----------------+-------------+------+-----+---------+----------------+ 4 rows in set (0.00 sec) Final project mata kuliah web dinamis Composed by : asih winantu,s.kom

22

mysql> desc jurusan; +------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+---------+----------------+ | id | int(2) | NO | PRI | NULL | auto_increment | | jurusan | varchar(30) | NO | | | | | kompetensi | text | NO | | | | +------------+-------------+------+-----+---------+----------------+ 3 rows in set (0.00 sec) mysql> desc pengajar; +--------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+---------+-------+ | nip | varchar(10) | NO | PRI | | | | nama | varchar(30) | NO | | | | | pendidikan | text | NO | | | | | mt_pelajaran | varchar(50) | NO | | | | | email | varchar(30) | YES | | NULL | | | web | varchar(30) | YES | | NULL | | | foto | varchar(30) | YES | | NULL | | +--------------+-------------+------+-----+---------+-------+ 7 rows in set (0.00 sec) mysql> desc prestasi; +-------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+----------------+ | id_prestasi | int(10) | NO | PRI | NULL | auto_increment | | nm_prestasi | varchar(50) | YES | | NULL | | | tgl_raih | datetime | YES | | NULL | | | keterangan | text | YES | | NULL | | | gambar | varchar(50) | YES | | NULL | | +-------------+-------------+------+-----+---------+----------------+ 5 rows in set (0.00 sec) mysql> desc profil; +-----------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | profil | varchar(250) | NO | | | | | sejarah | text | NO | | | | | visi_misi | text | NO | | | | +-----------+--------------+------+-----+---------+----------------+ 4 rows in set (0.00 sec) mysql> desc sambutan; +---------+-------------+------+-----+-------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------+-------------+------+-----+-------------------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | nama | varchar(50) | NO | | | | | jabatan | varchar(50) | NO | | | | | isi | text | NO | | | | | tanggal | timestamp | NO | | CURRENT_TIMESTAMP | | | foto | varchar(50) | NO | | | | +---------+-------------+------+-----+-------------------+----------------+ 6 rows in set (0.00 sec) mysql> desc user; +----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+-------+ | username | varchar(15) | NO | | | | | password | varchar(15) | NO | | | | +----------+-------------+------+-----+---------+-------+ 2 rows in set (0.00 sec)


23

D. PETUNJUK Petunjuk pengerjaan final project: 1. 2. 3. 4. 5. •

script-script diatas akan lebih optimal dijalankan menggunakan integrated web server WAMP versi 1.7, dan vertrigo. silahkan kerjakan web anda sampai selesai dan semua link atau menunya bisa digunakan. lengkapi dengan gambar/gambar atau feature-feature yang lainnya. desain boleh diubah tanpa mengubah substansi sistem yang sudah saya tentukan. lengkapi sistem anda dengan script-script yang anda ketahui seperti : - script php/javascript untuk validasi data - script untuk menampilkan data tabel dalam bentuk paging nomer 4-5 : optional

Petunjuk pengumpulan tugas akhir : Tugas akhir dikumpulkan dalam bentuk CD + cover (judul web, nama, nim) : Hasil yang dikumpulkan adalah : • Web, • gambar-gambar yang digunakan, • basisdata (in sql form) serta • file pdf/rtf yang berisi : 1. penjelasan tentang system. (capture tampilan tiap halaman + script) 2. kritik, saran,pesan+kesan anda selama mempelajari pemrograman web di STMIK El Rahma.

Selamat mengerjakan semoga sukses

Best regards, Asih Winantu,S.Kom NIDN : 0513068001


Contact details : Email : [email protected] Ym : vegie_2506 Blog : http://www.keluargamustafa.co.cc HP : 08156811419

24

Report "HANDOUT WEB DINAMIS A. HALAMAN PENGUNJUNG"

Your name

Email

Reason

Description

Copyright © 2024 ADOC.PUB. All rights reserved.
About Us | Privacy Policy | Terms of Service | Copyright | Contact Us | Cookie Policy

Sign In

Email

Password

Remember me Forgot password?

Our partners will collect data and use cookies for ad personalization and measurement. Learn how we and our ad partner Google, collect and use data. Agree & close
INPUT PROFIL

Data Profil sudah masuk ke dalam database. Silakan kembali ke MENU Administrator.

$data[nm_prestasi]
	Diraih tanggal : $data[tgl_raih] $data[keterangan]

No	Judul Berita	Penulis	Tanggal Berita
$no	$data[judul]	$data[author]	$data[tanggal]	Detail

Nama	:
Email	:
Kota	:	<select name="kota" size="1" id="kota">
Komentar	:

No	Tahun lulus	Nama	Jurusan
$no	$data[thn_lulus]	$data[nama]	$data[jurusan]	Detail

HANDOUT WEB DINAMIS A. HALAMAN PENGUNJUNG

Recommend Documents

Detail Data Pengajar

Detail Berita

$data[judul]

Detail Data Alumni

<span class="style1">Menu Administrator

DATA PROFIL SEKOLAH

DATA PROFIL SEKOLAH

DATA PROFIL SEKOLAH