tambah data alumni - eprints.umpo.ac.ideprints.umpo.ac.id/1504/8/lampiran.pdftambah data alumni

30
Tambah Data Alumni <div class="container"> <form action="./index.php?p=alumni-create" method="post" class="form- horizontal"> <h1>Tambah Data Alumni</h1> <hr/> <fieldset> <legend>Data Alumni</legend> <div class="form-group"> <label for="nim" class="col-lg-2 control-label">NIM</label> <div class="col-lg-4"> <input required="true" type="text" name="nim" class="form-control" id="nim" placeholder="NIM"> </div> </div> <div class="form-group"> <label for="nama" class="col-lg-2 control-label">Nama</label> <div class="col-lg-10"> <input required="true" type="text" name="nama" class="form-control" id="nama" placeholder="Nama"> </div> </div> <div class="form-group"> <label for="jenis_kelamin" class="col-lg-2 control-label">Jenis Kelamin</label> <div class="col-lg-10"> <select id="jenis_kelamin" name="jenis_kelamin" class="form- control"> <option value="Laki-laki">Laki-laki</option> <option value="Perempuan">Perempuan</option> </select> </div> </div> <div class="form-group"> <label for="tempat_lahir" class="col-lg-2 control-label">Tempat Lahir</label> <div class="col-lg-4">

Upload: leduong

Post on 04-May-2019

300 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Tambah Data Alumni - eprints.umpo.ac.ideprints.umpo.ac.id/1504/8/LAMPIRAN.pdfTambah Data Alumni

Tambah Data Alumni

<div class="container">

<form action="./index.php?p=alumni-create" method="post" class="form-

horizontal">

<h1>Tambah Data Alumni</h1>

<hr/>

<fieldset>

<legend>Data Alumni</legend>

<div class="form-group">

<label for="nim" class="col-lg-2 control-label">NIM</label>

<div class="col-lg-4">

<input required="true" type="text" name="nim" class="form-control" id="nim"

placeholder="NIM">

</div>

</div>

<div class="form-group">

<label for="nama" class="col-lg-2 control-label">Nama</label>

<div class="col-lg-10">

<input required="true" type="text" name="nama" class="form-control" id="nama"

placeholder="Nama">

</div>

</div>

<div class="form-group">

<label for="jenis_kelamin" class="col-lg-2 control-label">Jenis

Kelamin</label>

<div class="col-lg-10">

<select id="jenis_kelamin" name="jenis_kelamin" class="form- control">

<option value="Laki-laki">Laki-laki</option>

<option value="Perempuan">Perempuan</option>

</select>

</div>

</div>

<div class="form-group">

<label for="tempat_lahir" class="col-lg-2 control-label">Tempat

Lahir</label>

<div class="col-lg-4">

Page 2: Tambah Data Alumni - eprints.umpo.ac.ideprints.umpo.ac.id/1504/8/LAMPIRAN.pdfTambah Data Alumni

<input type="text" id="tempat_lahir" name="tempat_lahir" class="form- control"

placeholder="Tempat Lahir"/>

</div>

<label for="tanggal_lahir" class="col-lg-2 control-label">Tanggal

Lahir</label>

<div class="col-lg-4">

<input type="text" id="tanggal_lahir" name="tanggal_lahir"

class="form-control" placeholder="Tempat Lahir"/>

</div>

</div>

<div class="form-group">

<label for="jurusan_id" class="col-lg-2 control-label">Jurusan</label>

<div class="col-lg-10">

<select class="form-control" name="jurusan_id" id="jurusan_id">

<?php

$queryJurusan = mysql_query("SELECT * FROM jurusan");

while ($rowJurusan = mysql_fetch_array($queryJurusan)) {

?>

<option value="<?php echo $rowJurusan['id']; ?>"><?php echo

$rowJurusan['nama']; ?></option>

<?php

}

mysql_free_result($queryJurusan);

?>

</select>

</div>

</div>

<div class="form-group">

<label for="ipk" class="col-lg-2 control-label">IPK</label>

<div class="col-lg-4">

<input type="number" step="any" min="0" name="ipk" class="form- control"

id="ipk" placeholder="IPK">

</div>

</div>

<div class="form-group">

<label for="alamat" class="col-lg-2 control-label">Alamat</label>

<div class="col-lg-10">

Page 3: Tambah Data Alumni - eprints.umpo.ac.ideprints.umpo.ac.id/1504/8/LAMPIRAN.pdfTambah Data Alumni

<textarea class="form-control" name="alamat" id="alamat" rows="3"

id="textArea"></textarea>

</div>

</div>

<div class="form-group">

<label for="tahun_masuk" class="col-lg-2 control-label">Tahun

Masuk</label>

<div class="col-lg-4">

<input type="number" name="tahun_masuk" class="form-control"

id="tahun_masuk" placeholder="Tahun Masuk">

</div>

</div>

<div class="form-group">

<label for="tanggal_lulus" class="col-lg-2 control-label">Tanggal

Lulus</label>

<div class="col-lg-4">

<input type="text" name="tanggal_lulus" class="form-control"

id="tanggal_lulus" placeholder="Tanggal Lulus">

</div>

<label for="tahun_lulus" class="col-lg-2 control-label">Tahun

Lulus</label>

<div class="col-lg-4">

<input type="number" name="tahun_lulus" class="form-control"

id="tahun_lulus" placeholder="Tahun Lulus">

</div>

</div>

<div class="form-group">

<label for="judul_skripsi" class="col-lg-2 control-label">Judul

Skripsi</label>

<div class="col-lg-10">

<input type="text" name="judul_skripsi" class="form-control"

id="judul_skripsi" placeholder="Judul Skripsi">

</div>

</div>

</fieldset>

<hr/>

<fieldset>

<legend>User Account</legend>

<div class="form-group">

Page 4: Tambah Data Alumni - eprints.umpo.ac.ideprints.umpo.ac.id/1504/8/LAMPIRAN.pdfTambah Data Alumni

<label for="username" class="col-lg-2 control-label">Username</label>

<div class="col-lg-4">

<input required="true" type="text" name="username" class="form- control"

id="username" placeholder="Username">

</div>

</div>

<div class="form-group">

<label for="password" class="col-lg-2 control-label">Password</label>

<div class="col-lg-4">

<input type="password" name="password" class="form-control"

id="password" placeholder="Password">

</div>

</div>

</fieldset>

<hr/>

<fieldset>

<div class="form-group">

<div class="col-lg-10 col-lg-offset-2">

<div class="btn-group">

<a href="./index.php?p=alumni" class="btn btn-default">Kembali</a>

<button type="submit" class="btn btn-primary"

name="simpan">Simpan</button>

<button type="reset" class="btn btn-danger">Batal</button>

</div>

</div>

</div>

</fieldset>

</form>

</div>

Page 5: Tambah Data Alumni - eprints.umpo.ac.ideprints.umpo.ac.id/1504/8/LAMPIRAN.pdfTambah Data Alumni

Edit Data Alumni

<form action="./index.php?p=alumni-edit" method="post" class="form-horizontal">

<h1><small>Edit Data Alumni,</small> <?php echo $row['nama']; ?></h1>

<hr/>

<fieldset>

<legend>Data Alumni</legend>

<div class="form-group">

<label for="nim" class="col-lg-2 control-label">NIM</label>

<div class="col-lg-4">

<input required="true" value="<?php echo $row['nim']; ?>" type="text" name="nim"

class="form-control" id="nim" placeholder="NIM"> </div>

</div>

<div class="form-group">

<label for="nama" class="col-lg-2 control-label">Nama</label>

<div class="col-lg-10">

<input required="true" value="<?php echo $row['nama']; ?>" type="text"

name="nama" class="form-control" id="nama" placeholder="Nama"> </div>

</div>

<div class="form-group">

<label for="jenis_kelamin" class="col-lg-2 control-label">Jenis

Kelamin</label>

<div class="col-lg-10">

<select id="jenis_kelamin" name="jenis_kelamin" class="form- control">

<option value="Laki-laki" <?php echo ($row['jenis_kelamin'] == 'Laki-laki' ?

'selected=selected' : ''); ?>>Laki-laki</option>

<option value="Perempuan"<?php echo ($row['jenis_kelamin'] == 'Perempuan' ?

'selected=selected' : ''); ?>>Perempuan</option>

</select>

</div>

</div>

<div class="form-group">

<label for="tempat_lahir" class="col-lg-2 control-label">Tempat

Lahir</label>

Page 6: Tambah Data Alumni - eprints.umpo.ac.ideprints.umpo.ac.id/1504/8/LAMPIRAN.pdfTambah Data Alumni

<div class="col-lg-4">

<input value="<?php echo $row['tempat_lahir']; ?>" type="text" id="tempat_lahir"

name="tempat_lahir" class="form-control" placeholder="Tempat Lahir"/>

</div>

<label for="tanggal_lahir" class="col-lg-2 control-label">Tanggal

Lahir</label>

<div class="col-lg-4">

<input value="<?php echo $row['tanggal_lahir']; ?>" type="text" id="tanggal_lahir"

name="tanggal_lahir" class="form-control" placeholder="Tempat Lahir"/>

</div>

</div>

<div class="form-group">

<label for="jurusan_id" class="col-lg-2 control-label">Jurusan</label>

<div class="col-lg-10">

<select class="form-control" name="jurusan_id" id="jurusan_id">

<?php

$queryJurusan = mysql_query("SELECT * FROM jurusan");

while ($rowJurusan = mysql_fetch_array($queryJurusan)) {

?>

<option value="<?php echo $rowJurusan['id']; ?>" <?php echo ($rowJurusan['id']

== $row['jurusan_id'] ? 'selected=selected' : '') ?>><?php echo

$rowJurusan['nama']; ?></option>

<?php

}

mysql_free_result($queryJurusan);

?>

</select>

</div>

</div>

<div class="form-group">

<label for="ipk" class="col-lg-2 control-label">IPK</label>

<div class="col-lg-4">

<input value="<?php echo $row['ipk']; ?>" type="number" step="any" min="0"

name="ipk" class="form-control" id="ipk" placeholder="IPK"> </div>

Page 7: Tambah Data Alumni - eprints.umpo.ac.ideprints.umpo.ac.id/1504/8/LAMPIRAN.pdfTambah Data Alumni

</div> <div

class="form-group">

<label for="alamat" class="col-lg-2 control-label">Alamat</label>

<div class="col-lg-10">

<textarea class="form-control" name="alamat" id="alamat" rows="3"

id="textArea"><?php echo $row['alamat']; ?></textarea>

</div>

</div>

<div class="form-group">

<label for="tahun_masuk" class="col-lg-2 control-label">Tahun

Masuk</label>

<div class="col-lg-4">

<input value="<?php echo $row['tahun_masuk']; ?>" type="number"

name="tahun_masuk" class="form-control" id="tahun_masuk" placeholder="Tahun

Masuk">

</div>

</div>

<div class="form-group">

<label for="tanggal_lulus" class="col-lg-2 control-label">Tanggal

Lulus</label>

<div class="col-lg-4">

<input value="<?php echo $row['tanggal_lulus']; ?>" type="text"

name="tanggal_lulus" class="form-control" id="tanggal_lulus"

placeholder="Tanggal Lulus">

</div>

<label for="tahun_lulus" class="col-lg-2 control-label">Tahun

Lulus</label>

<div class="col-lg-4">

<input value="<?php echo $row['tahun_lulus']; ?>" type="number"

name="tahun_lulus" class="form-control" id="tahun_lulus" placeholder="Tahun

Lulus">

</div>

</div>

<div class="form-group">

<label for="judul_skripsi" class="col-lg-2 control-label">Judul

Skripsi</label>

<div class="col-lg-10">

Page 8: Tambah Data Alumni - eprints.umpo.ac.ideprints.umpo.ac.id/1504/8/LAMPIRAN.pdfTambah Data Alumni

<input value="<?php echo $row['judul_skripsi']; ?>" type="text"

name="judul_skripsi" class="form-control" id="judul_skripsi" placeholder="Judul

Skripsi">

</div>

</div>

</fieldset>

<hr/>

<fieldset>

<div class="form-group">

<div class="col-lg-10 col-lg-offset-2">

<div class="btn-group">

<a href="./index.php?p=alumni" class="btn btn-default">Kembali</a>

<button type="submit" class="btn btn-primary"

name="simpan">Simpan</button>

<button type="reset" class="btn btn-danger">Batal</button>

</div>

</div>

</div>

<input type="hidden" value="1" name="pengguna_id" id="pengguna_id"/>

<input type="hidden" value="<?php echo $id; ?>" name="id" id="id"/>

</fieldset>

</form>

Page 9: Tambah Data Alumni - eprints.umpo.ac.ideprints.umpo.ac.id/1504/8/LAMPIRAN.pdfTambah Data Alumni

Tambah Berita Baru

<h1>Tambah Berita Baru</h1>

<hr/>

<form class="form-horizontal" action="./index.php?p=berita-create"

method="post" enctype="multipart/form-data">

<div class="form-group">

<div class="col-lg-12">

<input id="judul" name="judul" class="form-control" value=""

placeholder="Judul Berita" required="true"/>

</div>

</div>

<div class="form-group">

<div class="col-lg-12">

<textarea id="isi" name="isi"></textarea>

</div>

</div>

<div class="form-group">

<div class="col-lg-12">

<input type="file" name="gambar" id="gambar" class="form-control"/>

</div>

</div>

<hr/>

<div class="form-group">

<div class="col-lg-12">

<div class="btn-group">

<a href="./index.php?p=berita" class="btn btn-default">Kembali</a> <button

type="submit" id="simpan" name="simpan" class="btn btn-

primary">Simpan</button>

<button type="reset" id="reset" name="reset" class="btn btn-

danger">Reset</button>

</div>

</div>

</div>

Page 10: Tambah Data Alumni - eprints.umpo.ac.ideprints.umpo.ac.id/1504/8/LAMPIRAN.pdfTambah Data Alumni

<input type="hidden" id="pengguna_id" name="pengguna_id" value="10"/>

Page 11: Tambah Data Alumni - eprints.umpo.ac.ideprints.umpo.ac.id/1504/8/LAMPIRAN.pdfTambah Data Alumni

Edit Berita

<h1><small>Edit Berita</small> <?php echo $row['judul']; ?></h1>

<hr/>

<form class="form-horizontal" action="./index.php?p=berita-edit" method="post"

enctype="multipart/form-data">

<div class="form-group">

<div class="col-lg-12">

<input required="true" id="judul" name="judul" class="form-control"

value="<?php echo $row['judul']; ?>" placeholder="Judul Berita"/> </div>

</div>

<div class="form-group">

<div class="col-lg-12">

<textarea id="isi" name="isi"><?php echo $row['isi']; ?></textarea>

</div>

</div>

<div class="form-group">

<div class="col-lg-12">

<input type="file" name="gambar" id="gambar" class="form-control"/>

</div>

</div>

<hr/>

<div class="form-group">

<div class="col-lg-12">

<div class="btn-group">

<a href="./index.php?p=berita" class="btn btn-default">Kembali</a> <button

type="submit" id="simpan" name="simpan" class="btn btn-

primary">Simpan</button>

<button type="reset" id="reset" name="reset" class="btn btn-

danger">Reset</button>

</div>

</div>

</div>

Page 12: Tambah Data Alumni - eprints.umpo.ac.ideprints.umpo.ac.id/1504/8/LAMPIRAN.pdfTambah Data Alumni

<input type="hidden" value="<?php echo $row['gambar']; ?>"

name="gambar_old"/>

<input type="hidden" id="pengguna_id" name="pengguna_id" value="10"/>

<input type="hidden" id="id" name="id" value="<?php echo $id; ?>"/> </form>

Page 13: Tambah Data Alumni - eprints.umpo.ac.ideprints.umpo.ac.id/1504/8/LAMPIRAN.pdfTambah Data Alumni

Ganti Password

<h1>Ganti Password</h1>

<hr/>

<?php

if (isset($msg)) {

?>

<div class="alert alert-warning"><?php echo $msg; ?></div>

<?php

}

?>

<form class="form-horizontal" action="index.php?p=password-edit"

method="post">

<fieldset>

<div class="form-group">

<label for="passwordLama" class="control-label col-lg-2">Password

Lama</label>

<div class="col-lg-10">

<input type="password" id="passwordLama" name="password_lama"

placeholder="Password lama" class="form-control"/>

</div>

</div>

<div class="form-group">

<label for="passwordBaru" class="control-label col-lg-2">Password

Baru</label>

<div class="col-lg-10">

<input type="password" id="passwordBaru" name="password_baru"

placeholder="Password baru" class="form-control"/>

</div>

</div>

<div class="form-group">

<label for="password" class="control-label col-lg-2">Ulangi

Password</label>

<div class="col-lg-10">

<input type="password" id="password" name="password"

placeholder="Password " class="form-control"/>

</div>

Page 14: Tambah Data Alumni - eprints.umpo.ac.ideprints.umpo.ac.id/1504/8/LAMPIRAN.pdfTambah Data Alumni

</div> <div

class="form-group">

<label for="s" class="control-label col-lg-2"></label>

<div class="col-lg-10">

<input id="s" type="submit" value="Ganti Password" name="ganti" class="btn

btn-primary"/>

</div>

</div>

</fieldset>

</form>

Page 15: Tambah Data Alumni - eprints.umpo.ac.ideprints.umpo.ac.id/1504/8/LAMPIRAN.pdfTambah Data Alumni

Tambah Data Pengguna

<h1>Ganti Password</h1>

<hr/>

<?php

if (isset($msg)) {

?>

<div class="alert alert-warning"><?php echo $msg; ?></div>

<?php

}

?>

<form class="form-horizontal" action="index.php?p=password-edit"

method="post">

<fieldset>

<div class="form-group">

<label for="passwordLama" class="control-label col-lg-2">Password

Lama</label>

<div class="col-lg-10">

<input type="password" id="passwordLama" name="password_lama"

placeholder="Password lama" class="form-control"/>

</div>

</div>

<div class="form-group">

<label for="passwordBaru" class="control-label col-lg-2">Password

Baru</label>

<div class="col-lg-10">

<input type="password" id="passwordBaru" name="password_baru"

placeholder="Password baru" class="form-control"/>

</div>

</div>

<div class="form-group">

<label for="password" class="control-label col-lg-2">Ulangi

Password</label>

<div class="col-lg-10">

<input type="password" id="password" name="password"

placeholder="Password " class="form-control"/>

</div>

Page 16: Tambah Data Alumni - eprints.umpo.ac.ideprints.umpo.ac.id/1504/8/LAMPIRAN.pdfTambah Data Alumni

</div> <div

class="form-group">

<label for="s" class="control-label col-lg-2"></label>

<div class="col-lg-10">

<input id="s" type="submit" value="Ganti Password" name="ganti" class="btn

btn-primary"/>

</div>

</div>

</fieldset>

</form>

Page 17: Tambah Data Alumni - eprints.umpo.ac.ideprints.umpo.ac.id/1504/8/LAMPIRAN.pdfTambah Data Alumni

Alumni Detail

<div class="container">

<h1>Detail <small><?php echo $row['nama']; ?></small></h1>

<hr/>

<table class="table table-striped">

<thead>

<tr>

<th style="width: 200px;"></th>

<th></th>

</tr>

</thead>

<tbody>

<tr>

<td>NIM</td>

<td><?php echo $row['nim']; ?></td>

</tr>

<tr>

<td>Nama</td>

<td><?php echo $row['nama']; ?></td>

</tr>

<tr>

<td>Jenis Kelamin</td>

<td><?php echo $row['jenis_kelamin']; ?></td>

</tr>

<tr>

<td>Tempat / Tanggal Lahir</td>

<td><?php echo $row['tempat_lahir']; ?>, <?php echo

$row['tanggal_lahir']; ?></td>

</tr>

<tr>

<td>Jurusan</td>

<td><?php echo $row['jurusan']; ?></td>

</tr>

<tr>

<td>IPK</td>

Page 18: Tambah Data Alumni - eprints.umpo.ac.ideprints.umpo.ac.id/1504/8/LAMPIRAN.pdfTambah Data Alumni

<td><?php echo $row['ipk']; ?></td>

</tr>

<tr>

<td>Alamat</td>

<td><?php echo $row['alamat']; ?></td>

</tr>

<tr>

<td>Tahun Masuk</td>

<td><?php echo $row['tahun_masuk']; ?></td>

</tr>

<tr>

<td>Tanggal Lulus</td>

<td><?php echo $row['tanggal_lulus']; ?></td>

</tr>

<tr>

<td>Tahun Lulus</td>

<td><?php echo $row['tahun_lulus']; ?></td>

</tr>

<tr>

<td>Judul Skripsi</td>

<td><?php echo $row['judul_skripsi']; ?></td>

</tr>

</tbody>

</table>

<hr/>

<div class="btn-group">

<a href="./index.php?p=alumni&j=<?php echo $row['jid']; ?>" class="btn btn-

default">Kembali</a>

</div>

</div>

<?php

mysql_free_result($query);

Page 19: Tambah Data Alumni - eprints.umpo.ac.ideprints.umpo.ac.id/1504/8/LAMPIRAN.pdfTambah Data Alumni

HOME

<div class="carousel-inner">

<div class="item active">

<img src="./images/slideshow/01.jpg" alt="First slide">

<div class="container">

<div class="carousel-caption">

<h1>Selamat Datang</h1>

<h3>Alumni Fakultas Teknik Universitas Muhammadiyah

Ponorogo</h3>

<p>Situs ini merupakan resmi alumni, sebagai pusat informasi alumni Fakultas

Teknik Universitas Muhammadiyah Ponorogo</p>

<p><a class="btn btn-lg btn-info" href="./index.php#login"

role="button">Sign in</a></p>

</div>

</div>

</div>

<div class="item">

<img src="./images/slideshow/04.jpg" alt="Second slide">

<div class="container">

<div class="carousel-caption">

<h1>Berbagai Informasi Terbaru</h1>

<p>yang berkaitan dengan alumni Fakultas Teknik Universitas

Muhammadiyah Ponorogo</p>

<p><a class="btn btn-lg btn-info" href="./index.php?p=berita"

role="button">Lihat selengkapnya &raquo;</a></p>

</div>

</div>

</div>

<div class="item">

<img src="./images/slideshow/03.jpg" alt="Third slide">

<div class="container">

<div class="carousel-caption">

<h1>Lihat Teman Seangkatan Anda</h1>

<p>Dalam fasilitas data alumni, anda dapat mencari identitas terbaru dari teman-teman

anda...</p>

Page 20: Tambah Data Alumni - eprints.umpo.ac.ideprints.umpo.ac.id/1504/8/LAMPIRAN.pdfTambah Data Alumni

<p><a class="btn btn-lg btn-info" href="./index.php?p=alumni"

role="button">Lihat selengkapnya &raquo;</a></p>

</div>

</div>

</div>

</div>

<a class="left carousel-control" href="#myCarousel" role="button" data-

slide="prev"><span class="glyphicon glyphicon-chevron-left"></span></a>

<a class="right carousel-control" href="#myCarousel" role="button" data-

slide="next"><span class="glyphicon glyphicon-chevron-right"></span></a>

</div>

<div class="container">

<!-- Example row of columns -->

<div class="row">

<div class="col-sm-4">

<div class="row">

<div class="col-lg-12">

<blockquote>

<p>Barang siapa bersungguh-sungguh maka akan mendapatlah ia...</p>

<small>Enjoy aja, <cite title="Source Title">oke...</cite></small>

</blockquote>

</div>

<div class="col-lg-12">

<fieldset>

<a name="login"></a>

<h1 style="padding-top: 60px;">Login</h1>

<p>Silakan masukkan username dan password anda. Jika belum terdaftar silakan

hubungi adminitrator, email <a

href="mailto:[email protected]">[email protected]</a></p>

<?php

if (isset($_GET['loginmsg']) && $_GET['loginmsg'] == '100') {

?>

<p class="alert alert-warning">Login masih belum benar, silakan ulangi

kembali</p>

<?php

}

?>

Page 21: Tambah Data Alumni - eprints.umpo.ac.ideprints.umpo.ac.id/1504/8/LAMPIRAN.pdfTambah Data Alumni

<form class="form-horizontal" action="./login.php" method="post">

<div class="form-group">

<div class="col-lg-12">

<input type="text" id="username" name="username" class="form-control"

placeholder="Username"/> </div>

</div>

<div class="form-group">

<div class="col-lg-12">

<input type="password" id="password" name="password" class="form-control"

placeholder="Password"/> </div>

</div>

<div class="form-group">

<div class="col-lg-12">

<input type="submit" name="loginButton" id="loginButton" value="Login"

class="btn btn-primary"/>

</div>

</div>

</form>

</fieldset>

</div>

</div>

</div>

<div class="col-sm-8">

<?php

$query = mysql_query("SELECT a.*, b.nama AS pengguna FROM berita a,

pengguna b WHERE b.id = a.pengguna_id ORDER BY a.id DESC LIMIT 0, 3");

while ($row = mysql_fetch_array($query)) {

?>

<div class="row">

<div class="col-md-4">

<?php

if (file_exists('./images/' . $row['gambar'])) {

?>

<img src="./images/<?php echo $row['gambar']; ?>"

class="gambar-berita-thumb img-responsive"/>

<?php

}

Page 22: Tambah Data Alumni - eprints.umpo.ac.ideprints.umpo.ac.id/1504/8/LAMPIRAN.pdfTambah Data Alumni

?>

</div>

<div class="col-md-8">

<h3 class="berita-judul-home"><a href="./index.php?p=berita-

detail&id=<?php echo $row['id']; ?>"><?php echo $row['judul']; ?></a></h3>

<p><?php echo substr(strip_tags($row['isi']), 0, 300); ?>...</p>

<p class="info-berita">Oleh <?php echo $row['pengguna']; ?> | Dikirim <?php echo

date('d/m/Y H:i', strtotime($row['waktu_kirim'])); ?> | Diubah <?php echo

date('d/m/Y H:i', strtotime($row['waktu_kirim'])); ?></p>

</div>

</div>

<hr/>

<?php

}

mysql_free_result($query);

?>

</div>

</div>

</div>

Page 23: Tambah Data Alumni - eprints.umpo.ac.ideprints.umpo.ac.id/1504/8/LAMPIRAN.pdfTambah Data Alumni

Edit Data Alumni

<form action="./index.php?p=profile-edit" method="post" class="form-horizontal">

<h1><small>Edit Data Alumni,</small> <?php echo $row['nama']; ?></h1>

<hr/>

<fieldset>

<legend>Data Alumni</legend>

<div class="form-group">

<label for="nim" class="col-lg-2 control-label">NIM</label>

<div class="col-lg-4">

<input required="true" value="<?php echo $row['nim']; ?>" type="text" name="nim"

class="form-control" id="nim" placeholder="NIM"> </div>

</div>

<div class="form-group">

<label for="nama" class="col-lg-2 control-label">Nama</label>

<div class="col-lg-10">

<input required="true" value="<?php echo $row['nama']; ?>" type="text"

name="nama" class="form-control" id="nama" placeholder="Nama"> </div>

</div>

<div class="form-group">

<label for="jenis_kelamin" class="col-lg-2 control-label">Jenis

Kelamin</label>

<div class="col-lg-10">

<select id="jenis_kelamin" name="jenis_kelamin" class="form- control">

<option value="Laki-laki" <?php echo ($row['jenis_kelamin'] == 'Laki-laki' ?

'selected=selected' : ''); ?>>Laki-laki</option>

<option value="Perempuan"<?php echo ($row['jenis_kelamin'] == 'Perempuan' ?

'selected=selected' : ''); ?>>Perempuan</option>

</select>

</div>

</div>

<div class="form-group">

Page 24: Tambah Data Alumni - eprints.umpo.ac.ideprints.umpo.ac.id/1504/8/LAMPIRAN.pdfTambah Data Alumni

<label for="tempat_lahir" class="col-lg-2 control-label">Tempat

Lahir</label>

<div class="col-lg-4">

<input value="<?php echo $row['tempat_lahir']; ?>" type="text" id="tempat_lahir"

name="tempat_lahir" class="form-control" placeholder="Tempat Lahir"/>

</div>

<label for="tanggal_lahir" class="col-lg-2 control-label">Tanggal

Lahir</label>

<div class="col-lg-4">

<input value="<?php echo $row['tanggal_lahir']; ?>" type="text" id="tanggal_lahir"

name="tanggal_lahir" class="form-control" placeholder="Tempat Lahir"/>

</div>

</div>

<div class="form-group">

<label for="jurusan_id" class="col-lg-2 control-label">Jurusan</label>

<div class="col-lg-10">

<select class="form-control" name="jurusan_id" id="jurusan_id">

<?php

$queryJurusan = mysql_query("SELECT * FROM jurusan");

while ($rowJurusan = mysql_fetch_array($queryJurusan)) {

?>

<option value="<?php echo $rowJurusan['id']; ?>" <?php echo ($rowJurusan['id']

== $row['jurusan_id'] ? 'selected=selected' : '') ?>><?php echo

$rowJurusan['nama']; ?></option>

<?php

}

mysql_free_result($queryJurusan);

?>

</select>

</div>

</div>

<div class="form-group">

<label for="ipk" class="col-lg-2 control-label">IPK</label>

<div class="col-lg-4">

Page 25: Tambah Data Alumni - eprints.umpo.ac.ideprints.umpo.ac.id/1504/8/LAMPIRAN.pdfTambah Data Alumni

<input value="<?php echo $row['ipk']; ?>" type="number" step="any" min="0"

name="ipk" class="form-control" id="ipk" placeholder="IPK"> </div>

</div>

<div class="form-group">

<label for="alamat" class="col-lg-2 control-label">Alamat</label>

<div class="col-lg-10">

<textarea class="form-control" name="alamat" id="alamat" rows="3"

id="textArea"><?php echo $row['alamat']; ?></textarea>

</div>

</div>

<div class="form-group">

<label for="tahun_masuk" class="col-lg-2 control-label">Tahun

Masuk</label>

<div class="col-lg-4">

<input value="<?php echo $row['tahun_masuk']; ?>" type="number"

name="tahun_masuk" class="form-control" id="tahun_masuk" placeholder="Tahun

Masuk">

</div>

</div>

<div class="form-group">

<label for="tanggal_lulus" class="col-lg-2 control-label">Tanggal

Lulus</label>

<div class="col-lg-4">

<input value="<?php echo $row['tanggal_lulus']; ?>" type="text"

name="tanggal_lulus" class="form-control" id="tanggal_lulus"

placeholder="Tanggal Lulus">

</div>

<label for="tahun_lulus" class="col-lg-2 control-label">Tahun

Lulus</label>

<div class="col-lg-4">

<input value="<?php echo $row['tahun_lulus']; ?>" type="number"

name="tahun_lulus" class="form-control" id="tahun_lulus" placeholder="Tahun

Lulus">

</div>

</div>

<div class="form-group">

<label for="judul_skripsi" class="col-lg-2 control-label">Judul

Skripsi</label>

Page 26: Tambah Data Alumni - eprints.umpo.ac.ideprints.umpo.ac.id/1504/8/LAMPIRAN.pdfTambah Data Alumni

<div class="col-lg-10">

<input value="<?php echo $row['judul_skripsi']; ?>" type="text"

name="judul_skripsi" class="form-control" id="judul_skripsi" placeholder="Judul

Skripsi">

</div>

</div>

</fieldset>

<hr/>

<fieldset>

<div class="form-group">

<div class="col-lg-10 col-lg-offset-2">

<div class="btn-group">

<a href="./index.php?p=alumni" class="btn btn-default">Kembali</a>

<button type="submit" class="btn btn-primary"

name="simpan">Simpan</button>

<button type="reset" class="btn btn-danger">Batal</button>

</div>

</div>

</div>

<input type="hidden" value="<?php echo $rowAlumni['id']; ?>" name="id"

id="id"/>

</fieldset>

</form>

Page 27: Tambah Data Alumni - eprints.umpo.ac.ideprints.umpo.ac.id/1504/8/LAMPIRAN.pdfTambah Data Alumni

Pencarian Data Alumni

<div class="container">

<h1>Data Alumni <small>Semua Jurusan</small></h1>

<hr/>

<table class="table table-striped">

<thead>

<tr>

<th style="width: 80px;">NIM</th>

<th style="width: 200px;">Nama</th>

<th style="width: 160px;">Jurusan</th>

<th>Alamat</th>

<th style="width: 60px;">Masuk</th>

<th style="width: 60px;">Lulus</th>

<th style="width: 80px; text-align: center;">Detail</th>

</tr>

</thead>

<tbody>

<?php

$query = mysql_query("SELECT a.*, b.nama AS jurusan FROM alumni a, jurusan b

WHERE b.id = a.jurusan_id AND (a.nim LIKE '%".$keywords."%' OR a.nama LIKE

'%".$keywords."%') ORDER BY b.id ASC, a.nim ASC");

while ($row = mysql_fetch_array($query)) {

?>

<tr>

<td><?php echo $row['nim']; ?></td>

<td><?php echo $row['nama']; ?></td>

<td><?php echo $row['jurusan']; ?></td>

<td><?php echo $row['alamat']; ?></td>

<td><?php echo $row['tahun_masuk']; ?></td>

<td><?php echo $row['tahun_lulus']; ?></td>

<td align="center">

<span class="btn-group">

<a href="./index.php?p=alumni-detail&id=<?php echo $row['id']; ?>" class="btn

btn-primary btn-xs">Detail</a>

</span>

</td>

Page 28: Tambah Data Alumni - eprints.umpo.ac.ideprints.umpo.ac.id/1504/8/LAMPIRAN.pdfTambah Data Alumni

</tr>

<?php

}

?>

</tbody>

<tfoot>

<tr>

<th></th>

<th></th>

<th></th>

<th></th>

<th></th>

<th></th>

<th></th>

</tr>

</tfoot>

</table>

</div>

<?php

mysql_free_result($query);

else {

$queryJurusan = mysql_query("SELECT * FROM jurusan WHERE id =

'$jurusan_id'");

$rowJurusan = mysql_fetch_array($queryJurusan);

?>

<div class="container">

<h1>Data Alumni <small><?php echo $rowJurusan['nama']; ?></small></h1>

<hr/>

<table class="table table-striped">

<thead>

<tr>

<th style="width: 80px;">NIM</th>

<th style="width: 200px;">Nama</th>

<th>Alamat</th>

<th style="width: 60px;">Masuk</th>

<th style="width: 60px;">Lulus</th>

<th style="width: 80px; text-align: center;">Detail</th>

</tr>

</thead>

Page 29: Tambah Data Alumni - eprints.umpo.ac.ideprints.umpo.ac.id/1504/8/LAMPIRAN.pdfTambah Data Alumni

<tbody>

<?php

$query = mysql_query("SELECT * FROM alumni WHERE jurusan_id =

'$jurusan_id' AND (nim LIKE '%".$keywords."%' OR nama LIKE

'%".$keywords."%') ORDER BY nim ASC");

while ($row = mysql_fetch_array($query)) {

?>

<tr>

<td><?php echo $row['nim']; ?></td>

<td><?php echo $row['nama']; ?></td>

<td><?php echo $row['alamat']; ?></td>

<td><?php echo $row['tahun_masuk']; ?></td>

<td><?php echo $row['tahun_lulus']; ?></td>

<td align="center">

<span class="btn-group">

<a href="./index.php?p=alumni-detail&id=<?php echo $row['id']; ?>" class="btn

btn-primary btn-xs">Detail</a>

</span>

</td>

</tr>

<?php

}

?>

</tbody>

<tfoot>

<tr>

<th></th>

<th></th>

<th></th>

<th></th>

<th></th>

<th></th>

</tr>

</tfoot>

</table>

</div>

<?php

mysql_free_result($query);

mysql_free_result($queryJurusan);

Page 30: Tambah Data Alumni - eprints.umpo.ac.ideprints.umpo.ac.id/1504/8/LAMPIRAN.pdfTambah Data Alumni

}