DAFTAR PUSTAKA. Al Fatta, Hanif Analisis & Perancangan Sistem Informasi. Yogyakarta: Andi

DAFTAR PUSTAKA

Al Fatta, Hanif. 2007. Analisis & Perancangan Sistem Informasi. Yogyakarta: Andi. Gunawan, Wahyu. Kebut Sehari Jadi Master PHP. Genius. Yogyakarta. 2010. Hakim, Lukmanul. Bikin Website Super Keren dengan PHP dan JQuery. Lokomedia. Yogyakarta. 2010 Hakim, Lukmanul. Membongkar Trik Rahasia Para Master PHP. Lokomedia. Yogyakarta. 2010. Nugroho. 2002. Perancangan Sistem Informasi dengan Metodologi Berorientasi Objek. Bandung: Informatika. Ph. D., Roger S. Pressman, Rekayasa Perangkat Lunak Pendekatan Praktisi (BUKU SATU) : Yogyakarta, Andi Offset dan McGraw-Hill Book Co., 2002. Setiawan, Rony. Pengantar Basis Data. LP3I. Jakarta. 2006. Setiawan, Rony, Membangun E-Campus dengan PHP dan MySQL, LP3I. Jakarta. 2006 Suprianto, Dodit. 2008. Buku Pintar Pemrograman PHP. Bandung: Oase Media. http://lecturer.eepis-its.edu/~tessy/tutorial/java/5UML Class Diagram.pdf, Senin, 27 Maret 2011 http://data.tp.ac.id/dokumen/contoh+penulisan+landasan+teori+bab+2+sistem+informasi+akade mik+sekolah, Sabtu, 23 April 2011

76

L-1

LAMPIRAN Koneksi.php

"http://www.w3.org/TR/xhtml1/DTD/xhtml

1-transitional.dtd">

$cn=mysql_connect("localhost","root","root

") or die("koneksi database gagal");

xmlns="http://www.w3.org/1999/xhtml">

$db=mysql_select_db("sd",$cn)

or

die("database tidak ada");

<meta

?>

content="text/html; charset=iso-8859-1" />

http-equiv="Content-Type"

SDN Pasar Manggis 01 Pagi Fungsi.php

<style type="text/css">

VWXYZabcdefghijklmnopqrstuvwxyz1234

567890"; mt_srand((double) microtime()*1000000);

$string='';

for($i=0;$i<$pass;$i++)

align="center"

{

cellspacing="0">

$string

.=$allchar{mt_rand(0,

strlen($allchar))};

width="1015"

border="0" cellpadding="0"

}

height="189"

colspan="2"

return $string;

background="../../IMAGE/BANNER/Banne

}

r-new.jpg">

?>

Index.htm

colspan="2"

background="../../IMAGE/BANNER/side_a

XHTML

tas.jpg" bgcolor="#ECE9D8">

1.0

Transitional//EN"

L-2

width="770"

rowspan="6"

id="lofslidecontent45"

slidecontent"

style="width:750px;

valign="top"

height:300px">

background="../../IMAGE/BANNER/sidekir

i.jpg">

html

PUBLIC

"-

//W3C//DTD XHTML 1.0 Transitional//EN"

class="lof-main-wapper"

style="width:750px; height:300px">

"http://www.w3.org/TR/xhtml1/DTD/xhtml 1-transitional.dtd">

class="lof-

class="lof-main-

item">

xmlns="http://www.w3.org/1999/xhtml">

src="images/gbr1.jpg"

Mereka" height="300" width="750">

<meta

http-equiv="Content-Type"

content="text/html; charset=utf-8" />

title="Keceriaan

target="_parent"

LofCoolFlashNews 1.0 - Mootool<br /> <br /> title="Keceriaan<br /> <br /> 1.1

href="#">Keceriaan Mereka

rel="stylesheet"

type="text/css"

href="css/layout.css" />
rel="stylesheet"

Senangnya type="text/css"

href="css/style.css" /> <script

language="javascript"

Murid-murid kami ... !

language="javascript"

Acara<br />
<br />
type=
width="750">

src="js/lofcoolflashnews.mt11.js">

item-desc">

src="images/gbr2.jpg" Bersama"

title="Acara

height="300"

Bersama

riangnya

src="js/mootools.svn.js">

dan

type="text/javascript"

<script

Mereka"

target="_parent" href="#">Acara

L-3

Merayakan

Ulang

Tahun

sekolah di depan halaman SD Negeri Pasar

Manggis 01 Pagi

hasLofTip"

src="images/gbr3.jpg"

title="Keceriaan

Mereka::
title="Bergembira Bersama" height="300"

src="images/lofthumbs/gbr1.jpg"

width="750">

;

title=""

height="70"

target="_parent"

title="Bergembira

Bersama"

width="140">"> <span>1

href="#">Bergembira Bersama

;

height="70"

">

src="images/gbr4.jpg" Kelas

6

height="300" width="750">

href="#">Perpisahan

<span>2

2011"

class="lof-main-item-desc">

title="Perpisahan

title=""

target="_parent" Kelas

6 Kelas

2011" 6

2011

Acara perpisahan murid kelas

Bersama::
height="70" width="140">">

6 Tahun Ajaran 2010/2011

<span>3

title="Bergembira

title="Perpisahan

Kelas

6

L-4

2011::

src="images/lofthumbs/gbr4.jpg"

;

title=""

height="70"

width="140">">

<span>4

face="Verdana,

Arial,

Helvetica, sans-serif" size="+1">SDN Pasar

Manggis 01 Pagi berdiri sejak tahun 1969 di

bawah pimpinan (Kepala Sekolah) yakni

Bapak Gondo. Awalnya Sekolah ini hanya

<script type="text/javascript">

memiliki 1 (satu) lantai namun pad atahun

var

_lofmain

=

$('lofslidecontent45'); var

1992/1993, bangunan ini direhab total menjadi bangunan 2 (dua) lantai.

_lofscmain

=

_lofmain.getElement('.lof-main-wapper'); var

_lofnavigator

Visi => Terwujudnya peserta didik yang bertaqwa, berakhlak mulia, cerdas, berbudaya, mandiri sehat jasmani dan rohani, epnuh dengan

fxObject:{

inovasi dan bertanggung jawab.

transition:Fx.Transitions.Quad.easeInOut,

duration:400},interval:4000,

layoutStyle:'hrright' } )

.start(

true,

_lofmain.getElement('.preload') );

href="daftarsiswa.php"

decoration:none">
width="244">

src="../../IMAGE/BANNER/side_samping.j

pg" width="241" height="185" />

L-5

Helvetica,

style="float:right"

href="info.php"

decoration:none">

Berita

href="Hubungi.php"

style="text-

decoration:none">
width="244" height="86" />

|

href="guru.php"

style="text-

decoration:none">

src="../../IMAGE/BANNER/side4.jpg"

height="134"

colspan="2"

decoration:none">
background="../../IMAGE/BANNER/side6.j

src="../../IMAGE/BANNER/side1.jpg"

pg">

width="242" height="86" />

size=2

color="#FFFFFF">
decoration:none">
decoration:none">
color="#FFFFFF">Info

src="../../IMAGE/BANNER/side2.jpg"

href="berita.php"

width="242" height="86" />

href="siswa.php"

style="text-

Terkini

|

decoration:none">
src="../../IMAGE/BANNER/side3.jpg"

Kami

style="text-

color="#FFFFFF">Hubungi

width="244" height="86" />

DaftarSiswa.php

decoration:none">

src="../../IMAGE/BANNER/side5.jpg"

XHTML

width="244" height="86" />

"http://www.w3.org/TR/xhtml1/DTD/xhtml

1.0

1-transitional.dtd">

Transitional//EN"

xmlns="http://www.w3.org/1999/xhtml">

L-6

<meta

http-equiv="Content-Type"

colspan="2"

content="text/html; charset=iso-8859-1" />

background="../../IMAGE/BANNER/side_a

SDN Pasar Manggis 01 Pagi

tas.jpg" bgcolor="#ECE9D8">

<style type="text/css">

i.jpg">

include "koneksi.php";

style="font:Verdana, Arial, Helvetica, sans-

$bulan=array(1=>"Januari","Februari","Mar

serif" size="+2">FORM PENDAFTARAN

et","April","Mei","Juni","Juli","Agustus","S

SISWA BARU

eptember","Oktober","November","Desemb

er");

method="post" action="savemurid.php">

$sql="select * from kelas";

align="center">
id="form1"

width="497"

$hasil=mysql_query($sql) or die("Perintah

align="center"

SQL salah");

cellspacing="2">

$row=mysql_fetch_array($hasil);

name="form1"

border="0" cellpadding="0"

?>

$sql = mysql_query("select nis from murid

order by nis desc limit 1");

width="1015"

align="center"

border="0" cellpadding="0"

cellspacing="0">

if($d>0) {

$d=mysql_num_rows($sql);

$r=mysql_fetch_array($sql); height="189"

colspan="2"

$d=$r['nis'];

background="../../IMAGE/BANNER/Banne

$str=substr($d,0,5);

r-new.jpg">

$no_urut=(int)$str;

}

L-7

else

color="#000000"

{ $no_urut=0; }

face="Verdana, Arial, Helvetica, sans-serif"

$no_urut=$no_urut+1;

size="+1"> Tanggal Lahir

$nol="";

:

$nilai=5-strlen($no_urut);

for($i=1;$i<$nilai;$i++)

face="Verdana"

color="#FF0066">

{ $nol=$nol."0";}

<select size="1" name="d" style="font-

$nonis=$no_urut;

family: Verdana; font-size: 10pt">

?>

$i=0;

color="#000000"

face="Verdana, Arial, Helvetica, sans-serif"

for($i=1;$i<31;$i++) { ?>

size="+1">N I S

name="nis"

type="text"

id="nis" value="" />

color="#660066">

width="165">
color="#000000" Helvetica,

face="Verdana,

sans-serif"

Arial,

size="+1">

Nama

id="nama" />

family: Verdana; font-size: 10pt">
?>

name="nama"

<select size="1" name="b" style="font-

for($i=1;$i<12;$i++) {

:

size="2"

font-size:

10pt;

L-8

do {

?>

valign="top">
color="#000000" Helvetica,

face="Verdana,

sans-serif"

Arial,

size="+1">

Alamat

value="">
echo $row[1]?>

:

name="alamat"

id="alamat">

color="#000000"

face="Verdana, Arial, Helvetica, sans-serif"

size="+1"> Orang Tua

color="#000000"

face="Verdana, Arial, Helvetica, sans-serif"

size="+1"> Tahun Masuk :

type="text"

id="thn" size="5" />

face="Verdana, Arial, Helvetica, sans-serif"

:

face="Verdana, Arial, Helvetica, sans-serif" size="+1">Kelas : <select size="1" name="kelas">
color="#000000"

size="+1"> Bapak

name="bpk"

type="text"

id="bpk" />
color="#000000"

face="Verdana, Arial, Helvetica, sans-serif" size="+1"> Ibu

L-9

:

type="text"

id="ibu" />

color="#000000"

face="Verdana, Arial, Helvetica, sans-serif" size="+1">Password

:

name="pass"

type="text"

id="pass" />

*max.10 karakter

height="100"

colspan="3">

color="#000000"

face="Verdana, Arial, Helvetica, sans-serif"

name="DAFTAR"

size="+1">Untuk Login Siswa

type="submit"

id="DAFTAR"

value="DAFTAR" />

valign="top">
color="#000000"

face="Verdana,

Arial,

Helvetica, sans-serif" size="+1">Id Murid

:

name="idmurid"

type="text"

id="idmurid" />

width="244"

style="height:auto">
<em>(disarankan

NIS

href="daftarsiswa.php"

Siswa)

decoration:none">
style="text-

src="../../IMAGE/BANNER/side_samping.j pg" width="241" height="185" />

L-10

height="134"

background="../../IMAGE/BANNER/side6.j

decoration:none">
pg">

src="../../IMAGE/BANNER/side1.jpg"

Helvetica,

width="242" height="86" />

style="float:right"

size=2

color="#FFFFFF">

href="info.php"

decoration:none">

colspan="2"

style="text-

color="#FFFFFF">Info

|

decoration:none">
href="berita.php"

src="../../IMAGE/BANNER/side2.jpg"

decoration:none">

width="242" height="86" />

Berita

Terkini

href="Hubungi.php"

decoration:none">

href="siswa.htm"

style="text-

decoration:none">
|

style="text-

color="#FFFFFF">Hubungi Kami

src="../../IMAGE/BANNER/side3.jpg"

width="244" height="86" />

style="text-

href="guru.htm"

style="text-

decoration:none">

src="../../IMAGE/BANNER/side4.jpg"

width="244" height="86" />

Savemurid.php
decoration:none">
include "koneksi.php";

src="../../IMAGE/BANNER/side5.jpg"

//validasi data kode tidak boleh sama

width="244" height="86" />

$sql="select count(*) as jumlah from murid

where nis='$nis'";

L-11

$hasil=mysql_query($sql) or die("Perintah

}

SQL salah");

-->

$row=mysql_fetch_array($hasil);

if ($row[0]>0)

{

include "koneksi.php";

header

("location:pesan.php?psn=NIS

sudah terpakai oleh murid lain!");

$bulan=array(1=>"Januari","Februari","Mar

exit;}

et","April","Mei","Juni","Juli","Agustus","S

$tgl=$t."-".$b."-".$d; $sql="insert

eptember","Oktober","November","Desemb into

murid

er");

values('$nis','$kelas','$nama','$tgl','$alamat','

if($kelas=='')

$thn','$ibu','$bpk','$idmurid','$pass')";

{

$hasil=mysql_query($sql) or die("Perintah

$p="select * from jadwalekskul";

SQL salah");

}

header("location: daftarmurid.php");

else

?>

{ $p="select * from jadwalekskul where

Siswa.php

idkelas like '%$kelas%'";

};

XHTML

$has=mysql_query($p)

1.0

Transitional//EN"

or

die("Perintah

"http://www.w3.org/TR/xhtml1/DTD/xhtml

SQL salah");

1-transitional.dtd">

$row=mysql_fetch_array($has);

$sql="select * from kelas";

xmlns="http://www.w3.org/1999/xhtml">

$hasil=mysql_query($sql) or die ("Perintah

kelas SALAH");

<meta

http-equiv="Content-Type"

$rs=mysql_fetch_array($hasil);

content="text/html; charset=iso-8859-1" />

?>

SDN Pasar Manggis 01 Pagi

<style type="text/css">

r-new.jpg">

include "koneksi.php";

colspan="2"

$sql="select count(*) as jml from login

background="../../IMAGE/BANNER/side_a

where idmurid='$user' and pass='$pwd'";

tas.jpg" bgcolor="#ECE9D8">

L-16

ersion=ShockwaveFlash"

type="application/x-shockwave-flash"

width="770"

rowspan="6"

width="120" height="30" >

valign="top"

background="../../IMAGE/BANNER/sidekir

i.jpg">

classid="clsid:D27CDB6E-

AE6D-11cf-96B8-444553540000"

width="696"

align="center"

border="0" cellpadding="0"

cellspacing="0">

codebase="http://download.macromedia.co m/pub/shockwave/cabs/flash/swflash.cab#ve rsion=5,0,0,0" width="120" height="30">

<param

width="508"

height="391"

valign="top">

value="" /> <param

name="movie"

value="button2.swf" />

<param

name="quality"

value="high" />

href="profilsiswa.php?idmurid=">
name="BGCOLOR"

classid="clsid:D27CDB6E-

<embed

src="button2.swf"

quality="high"

AE6D-11cf-96B8-444553540000"

pluginspage="http://www.macromedia.com/

codebase="http://download.macromedia.co

shockwave/download/index.cgi?P1_Prod_V

m/pub/shockwave/cabs/flash/swflash.cab#ve

ersion=ShockwaveFlash"

rsion=5,0,0,0" width="120" height="30">

type="application/x-shockwave-flash"

<param

name="BGCOLOR"

value="" /> <param

name="movie"

value="button1.swf" /> <param

classid="clsid:D27CDB6E-

AE6D-11cf-96B8-444553540000" name="quality"

value="high" /> <embed

width="120" height="30" >

codebase="http://download.macromedia.co m/pub/shockwave/cabs/flash/swflash.cab#ve

src="button1.swf"

quality="high" pluginspage="http://www.macromedia.com/ shockwave/download/index.cgi?P1_Prod_V

rsion=5,0,0,0" width="120" height="30"> <param value="" />

name="BGCOLOR"

L-17

<param

name="movie"

value="button5.swf" />

<param

name="quality"

value="high" />

align="center">
style="font:Verdana, Arial, Helvetica, sans-

<embed

src="button5.swf"

quality="high"

serif"

size="+2">Selamat

Datang

pluginspage="http://www.macromedia.com/

shockwave/download/index.cgi?P1_Prod_V

width="533"

ersion=ShockwaveFlash"

align="center"

type="application/x-shockwave-flash"

cellspacing="2">

width="120" height="30" >

cellpadding="0"

color="#000000"

face="Verdana, Arial, Helvetica, sans-serif" size="+1">N I S

codebase="http://download.macromedia.co

m/pub/shockwave/cabs/flash/swflash.cab#ve

:

rsion=5,0,0,0" width="120" height="30"> <param

name="BGCOLOR"

value="" /> <param

name="movie"

width="303">
color="#000000"

Arial,

name="quality"

src="button3.swf"

width="208">
quality="high"

color="#000000"

pluginspage="http://www.macromedia.com/

Helvetica,

shockwave/download/index.cgi?P1_Prod_V

Nama :

type="application/x-shockwave-flash"

width="120" height="30" >

face="Verdana,

sans-serif"

ersion=ShockwaveFlash"

face="Verdana,

value="high" /> <embed

Helvetica, sans-serif" size="+1">

value="button3.swf" /> <param

border="0"

Arial,

size="+1">

color="#000000"

face="Verdana, Arial, Helvetica, sans-serif" size="+1">

L-18

color="#000000"

face="Verdana, Arial, Helvetica, sans-serif"

size="+1">Kelas

color="#000000"

:

face="Verdana, Arial, Helvetica, sans-serif"

size="+1"> Tanggal Lahir :

color="#000000"

face="Verdana, Arial, Helvetica, sans-serif" size="+1">

color="#000000"

face="Verdana, Arial, Helvetica, sans-serif"

size="+1">

color="#000000"

face="Verdana, Arial, Helvetica, sans-serif"

size="+1"> Orang Tua

valign="top">
color="#000000" Helvetica,

face="Verdana,

sans-serif"

Arial,

size="+1">

Alamat

face="Verdana, Arial, Helvetica, sans-serif" size="+1">

size="+1"> Bapak :

color="#000000"

size="+1">

size="+1"> Tahun Masuk

:

face="Verdana, Arial, Helvetica, sans-serif" size="+1">

color="#000000"

face="Verdana, Arial, Helvetica, sans-serif"

face="Verdana, Arial, Helvetica, sans-serif"

color="#000000"

face="Verdana, Arial, Helvetica, sans-serif"

:

color="#000000"

face="Verdana, Arial, Helvetica, sans-serif" size="+1"> Ibu :

L-19

color="#000000"

src="../../IMAGE/BANNER/side2.jpg"

face="Verdana, Arial, Helvetica, sans-serif"

width="242" height="86" />

size="+1">

href="siswa.php"

style="text-

decoration:none">

src="../../IMAGE/BANNER/side3.jpg"

width="244" height="86" />

style="text-

decoration:none">

src="../../IMAGE/BANNER/side4.jpg"

width="244" height="86" />

href="guru.php"

width="244"

style="height:auto">
decoration:none">
src="../../IMAGE/BANNER/side_samping.j

src="../../IMAGE/BANNER/side5.jpg"

pg" width="241" height="185" />

width="244" height="86" />

height="134"

colspan="2"

decoration:none">
background="../../IMAGE/BANNER/side6.j

src="../../IMAGE/BANNER/side1.jpg"

pg">

width="242" height="86" />

Helvetica,

href="info.php"

sans-serif"

size=2

color="#FFFFFF">
decoration:none">Info href="berita.php"

|

style="text-

L-20

decoration:none">

.style3

Berita

Helvetica, sans-serif; font-size: 14px; }

Terkini

|

href="Hubungi.php"

style="text-

{font-family:

Verdana,

Arial,

-->

decoration:none">

color="#FFFFFF">Hubungi

Kami

include "koneksi.php";

$bulan=array(1=>"Januari","Februari","Mar

et","April","Mei","Juni","Juli","Agustus","S

eptember","Oktober","November","Desemb

er");

if($kelas=='')

{

$p="select * from jadwalekskul"; }

Kegiatan.php

else

{

XHTML

$p="select * from jadwalekskul where

1.0

Transitional//EN"

"http://www.w3.org/TR/xhtml1/DTD/xhtml

idkelas like '%$kelas%'";

1-transitional.dtd">

};

$has=mysql_query($p)

xmlns="http://www.w3.org/1999/xhtml">

SQL salah");

$row=mysql_fetch_array($has);

<meta

http-equiv="Content-Type"

or

die("Perintah

$sql="select * from kelas";

content="text/html; charset=iso-8859-1" />

$hasil=mysql_query($sql) or die ("Perintah

SDN Pasar Manggis 01 Pagi

kelas SALAH");

<style type="text/css">

$rs=mysql_fetch_array($hasil);

color="#FFFFFF">Info href="berita.php"

|

style="text-

decoration:none">

include "koneksi.php";

Berita

$bulan=array(1=>"Januari","Februari","Mar

style="text-

et","April","Mei","Juni","Juli","Agustus","S

Terkini

|

href="Hubungi.php" decoration:none">
eptember","Oktober","November","Desemb

color="#FFFFFF">Hubungi

er");

Kami

$sql="select * from guru";

$hasil=mysql_query($sql) or die("Perintah SQL salah"); $row=mysql_fetch_array($hasil);

?>

L-24

width="1015"

align="center"

border="0"

cellpadding="0"

cellspacing="0">

width="45">
align="center"><strong>No

DAFTAR PUSTAKA. Al Fatta, Hanif Analisis & Perancangan Sistem Informasi. Yogyakarta: Andi

Recommend Documents

target="_parent" LofCoolFlashNews 1.0 - Mootool<br /> <br /> title="Keceriaan<br /> <br /> 1.1 href="#">Keceriaan Mereka

target="_parent" title="Bergembira Bersama" width="140">"> <span>1

href="#">Perpisahan <span>2 2011" class="lof-main-item-desc"> title="Perpisahan title="" target="_parent" Kelas 6 Kelas 2011" 6 2011

target="_parent"

LofCoolFlashNews 1.0 - Mootool<br /> <br /> title="Keceriaan<br /> <br /> 1.1

href="#">Keceriaan Mereka

target="_parent"

title="Bergembira

Bersama"

width="140">"> <span>1

href="#">Perpisahan

<span>2

2011"

class="lof-main-item-desc">

title="Perpisahan

title=""

target="_parent" Kelas

6 Kelas

2011" 6

2011