1. Halo Guest, pastikan Anda selalu menaati peraturan forum sebelum mengirimkan post atau thread baru.

Program Web PHP Raport Siswa

Discussion in 'Pemrograman Web' started by sakawetan, Jan 7, 2012.

Page 1 of 3
  1. sakawetan

    sakawetan Newbie

    Joined:
    Dec 31, 2011
    Messages:
    5
    Likes Received:
    4
    Location:
    Lasem
    *MySQL Command Prompt
    Code:
    //membuat database
CREATE DATABASE raport;

//memilih database
USE raport;

//membuat tabel nilai siswa dalam database raport
CREATE TABLE  `nilai_siswa` (
 `nis` INT( 5 ) NOT NULL AUTO_INCREMENT ,
  nama VARCHAR( 50 ) NOT NULL default '',
 `uas` INT( 5 ) NOT NULL ,
 `uts` INT( 5 ) NOT NULL ,
 `nil_akhir` INT( 5 ) NOT NULL ,
PRIMARY KEY ( `nis` )
);
    Keterangan:
    perintah SQL diatas dijalankan dengan MySQL command prompt melalui cmd.. Mysql dapat dikelola secara visual dengan phpMyAdmin

    *input.php
    Code:
    <html>
<head>
<title>::Nilai Siswa::</title>
</head>
<body>
<table width=800 align=center>
<tr>
<td>
<form method=post action=simpan.php>
<table width=300 align=center>
<tr>
<td colspan=3 align=center><h3>INPUT NILAI SISWA</h3><hr></td>
</tr>  
<tr>
<td width=100>NIS</td>
<td width=10>:</td>
<td width=190><input name=nis type=text id=nis/></td>
</tr>
<tr>
<td width=100>Nama</td>
<td width=10>:</td>
<td width=190><input name=nama type=text id=nama/></td>
</tr>
<tr>
<td width=100>Nilai UTS</td>
<td width=10>:</td>
<td width=190><input name=uts type=text id=uts/></td>
</tr>
<tr>
<td width=100>Nilai UAS</td>
<td width=10>:</td>
<td width=190><input name=uas type=text id=uas/></td>
</tr>
<tr>
<td colspan=3><input type=submit name=submit value=Simpan><input type=reset name=reset value=Reset></td>
</tr>
</table>
</form>
<hr>
</td>
</tr>
</table>
</body>
</html>
    *simpan.php
    PHP:
    <?php
    require"input.php";
    ?>

    <?php
    $conn    =mysql_connect("localhost","root","root");
    mysql_select_db("raport");
    $nis=$_REQUEST['nis'];
    $nama=$_REQUEST['nama'];
    $uas=$_REQUEST['uas'];
    $uts=$_REQUEST['uts'];
    $total= 5;
    $nil_akhir=$uas+$uts/$total;
    $sql="insert into nilai_siswa (nis,nama,uas,uts,nil_akhir) values('$nis','$nama','$uas','$uts','$nil_akhir')";
    mysql_query($sql);
    ?>

    <?php
    require"tampil.php";
    ?>
    Keterangan:
    $conn=mysql_connect("localhost","username","password");
    Melakukan koneksi di server. admin menamai server name 'localhost', username 'root', password 'root' bawaan standar sie. Teman-teman jangan lupa merubah setingan ini bila tidak sesuai dengan konfigurasi yang ada
    mysql_select_db("raport");
    Untuk memilih database di server. disitu nama database nya 'raport'
    $nis=$_REQUEST['nis'];
    string nis digunakan untuk memperoleh nilai variable dari 'nis'. Variable nis merupakan nilai variable yang dimasukkan pada input
    $total= 5;
    Pernyataan diatas mengisikan string '2' ke variable $kota $nil_akhir=$uas+$uts/$total;
    string nil_akhir didapat dari nilai variable srting uas ditambah dengan nilai variable uts dan dibagi dengan nilai variable string total
    $sql="insert into nilai_siswa (nis,nama,uas,uts,nil_akhir) values('$nis','$nama','$uas','$uts','$nil_akhir')";
    perintah sql untuk memasukkan data ke dalam tabel nilai_siswa. nilai variable yang terdiri dari string nis,nama,uas,uts akan dimasukkan ke field tabel nilai_siswa
    $sql=mysql_query("select * from nilai_siswa");
    perintah query untuk menampilkan data table nilai_siswa

    *tampil.php
    Code:
    <html>
<head>
<title>:Tampil::</title>
</head>
<body>
<table width=800 border="1" align=center>
 <tr>
  <td colspan=5 align=center><b>DAFTAR NILAI SISWA</b></td>
 </tr>
 <tr align=center>
  <td><b>NIS</b></td>
  <td><b>NAMA</b></td>
  <td><b>Nilai UTS</b></td>
  <td><b>Nilai UAS</b></td>
  <td><b>Nilai Akhir</b></td>
 </tr>
<?php
$conn=mysql_connect("localhost","root","root");
mysql_select_db("raport");
$sql=mysql_query("select * from nilai_siswa");
while($tampil=mysql_fetch_array($sql))
{
?>
 <tr>
  <td><?=$tampil["nis"];?></td>
  <td><?=$tampil["nama"];?></td>
  <td><?=$tampil["uts"];?></td>
  <td><?=$tampil["uas"];?></td>
  <td><?=$tampil["nil_akhir"];?></td>
 </tr>
<?
}
?>
</table>
</body>
</html>
     
    sakawetan, Jan 7, 2012
    #1
  2. GentZu AoZora

    GentZu AoZora Forbidden

    Joined:
    Nov 28, 2010
    Messages:
    2,932
    Likes Received:
    275
    Location:
    Bandung City
    dapet dari pelajaran kuliah ya?
     
    GentZu AoZora, Jan 7, 2012
    #2
  3. sicoy.0001

    sicoy.0001 Ads.id Pro

    Joined:
    Feb 19, 2011
    Messages:
    287
    Likes Received:
    10
    Location:
    Cikarang
    ya,, lmyan juga buat selingan cz selama ini kan cuma wp ma blogcepot terus,,,,
    sekali2 back to PWL ......... :gembira:
     
    sicoy.0001, Jan 7, 2012
    #3
  4. sakawetan

    sakawetan Newbie

    Joined:
    Dec 31, 2011
    Messages:
    5
    Likes Received:
    4
    Location:
    Lasem
    loop file :
    hxxp://www.filesonic.com/file/GjLQ3fh/raport.zip O:-)

    iya :D
     
    Last edited by a moderator: Jan 12, 2012
    sakawetan, Jan 8, 2012
    #4
    nvidia738 likes this.
  5. sakawetan

    sakawetan Newbie

    Joined:
    Dec 31, 2011
    Messages:
    5
    Likes Received:
    4
    Location:
    Lasem
    ibarat seperti pohon yang baru ditanam maka perlu waktu untuk bisa tumbuh apalagi berbuah.. yarp- dari kalimat sebelum ini saya menyadari.. saya hadir dipadepokan ini berlabel pendatang baru newbi belum bisa apa-apa belum tau apa-apa & tentunya masih orintasi belajar 8-|
    untuk itu para mastah-mastah yang terhormat perkenankan saya berbagi seri lanjutan Thread: Program Web PHP Raport Siswa

    cek 1
    halaman login siswa
    user : wildan
    pass : wildan

    [​IMG]


    cek 2
    tampilan profil siswa

    [​IMG]

    cek 3
    tampilan raport siswa

    [​IMG]

    cek 4
    tampilan detail raport siswa

    [​IMG]

    bila ada yg berkenan.. silahkan unduh filenya|>hxxp://www.ziddu.com/download/18166071/raport.zip.html<| semoga bermanfaat :D .. maaf bila ada salah ing pangucap
     
    Last edited: Jan 20, 2012
    sakawetan, Jan 10, 2012
    #5
    newspirit, pandaris03 and nvidia738 like this.
  6. irw4nz3r0

    irw4nz3r0 Ads.id Fan

    Joined:
    Dec 6, 2011
    Messages:
    204
    Likes Received:
    0
    Location:
    Palembang
    saya sedot gan,, mulai mau mempelajari, agan punya contoh codingan untuk sistem akademik gak,,,kalu ada tolong dishare gan
     
    irw4nz3r0, Jan 11, 2012
    #6
  7. kohkono

    kohkono Super Hero

    Joined:
    Sep 13, 2010
    Messages:
    1,249
    Likes Received:
    432
    Location:
    Carving Rock City
    Bookmark dulu agh..sapa tahu ntar ada tugas dikampus kaya ginian..thank's
     
    kohkono, Jan 11, 2012
    #7
  8. irw4nz3r0

    irw4nz3r0 Ads.id Fan

    Joined:
    Dec 6, 2011
    Messages:
    204
    Likes Received:
    0
    Location:
    Palembang
    sama gan saya malhan mau mikirin skripsi nih gan,, ada yg bisa bantu gak buat script coodingan sistem informasi akademik universitas
     
    irw4nz3r0, Jan 11, 2012
    #8
  9. ayead

    ayead Super Hero

    Joined:
    Mar 21, 2010
    Messages:
    1,368
    Likes Received:
    57
    Location:
    Banjarmasin, Kalimantan Selatan
    WAhhhh,,, kereen bgt, kbtulan ane lagi belajar buat portal akademik SMA,, bisa dimasukan neh,,,

    Makasih banyaakkk,, ditunggu share selanjutnya
     
    ayead, Jan 11, 2012
    #9
  10. masrimanas

    masrimanas Super Hero

    Joined:
    Oct 18, 2010
    Messages:
    1,612
    Likes Received:
    106
    Location:
    Kampar, Riau
    keren sharenya,gan
    btw, ente ada livelink nya tuh:senyum:
     
    masrimanas, Jan 11, 2012
    #10
  11. irw4nz3r0

    irw4nz3r0 Ads.id Fan

    Joined:
    Dec 6, 2011
    Messages:
    204
    Likes Received:
    0
    Location:
    Palembang
    waah lagi yg nunggu yg punya thread koment punya saya
     
    irw4nz3r0, Jan 11, 2012
    #11
  12. kohkono

    kohkono Super Hero

    Joined:
    Sep 13, 2010
    Messages:
    1,249
    Likes Received:
    432
    Location:
    Carving Rock City
    Ampun...angkat tangan deh..soalnya bukan satu jurusan sama Fakultasku mas...sorry..
     
    kohkono, Jan 11, 2012
    #12
  13. irw4nz3r0

    irw4nz3r0 Ads.id Fan

    Joined:
    Dec 6, 2011
    Messages:
    204
    Likes Received:
    0
    Location:
    Palembang
    nngnya agan kokohono falkultas apaa???
     
    irw4nz3r0, Jan 13, 2012
    #13
  14. dite_caem

    dite_caem Newbie

    Joined:
    Jul 24, 2012
    Messages:
    1
    Likes Received:
    0
    .gan kalo kita sebagai admin, gima programya?
    .tugasnya admin nginputin nile rapotnya jg. isa bantuin gan?
     
    dite_caem, Jul 24, 2012
    #14
  15. master hendy

    master hendy Newbie

    Joined:
    Jul 24, 2012
    Messages:
    11
    Likes Received:
    0
    Location:
    Majalengka
    izin bookmark ya sob
     
    master hendy, Jul 24, 2012
    #15
  16. ariedan

    ariedan Ads.id Pro

    Joined:
    Aug 29, 2010
    Messages:
    453
    Likes Received:
    47
    Location:
    Depan Layar Monitor
    mantap mas bro... ane download dulu buat belajar. kebetulan saya kemarin juga ada tugas buat ginian tapi cuma sederhana.
     
    ariedan, Jul 24, 2012
    #16
  17. zuliantoe

    zuliantoe Ads.id Fan

    Joined:
    May 9, 2012
    Messages:
    103
    Likes Received:
    5
    Location:
    Solo - Denpasar
    buat control panel khusus admin gan......


    udah punya konsep programnya pa belum ?
     
    zuliantoe, Jul 24, 2012
    #17
  18. isnuN3

    isnuN3 Super Hero

    Joined:
    Mar 2, 2012
    Messages:
    1,012
    Likes Received:
    13
    download dlu mastah mayan buat koleksi sapa tau butuh.
     
    isnuN3, Jul 24, 2012
    #18
  19. jawsplanet

    jawsplanet Super Hero

    Joined:
    Apr 12, 2011
    Messages:
    1,776
    Likes Received:
    104
    Location:
    Tangerang
    hmmmmm
    mantep jg sih bro,web php buat bikin raport siswa
     
    jawsplanet, Jul 24, 2012
    #19
  20. mp3online

    mp3online Super Hero

    Joined:
    Jul 19, 2011
    Messages:
    2,228
    Likes Received:
    294
    Location:
    jakarta
    lah kok ujung2nya nyari recehan ziddu :D
     
    mp3online, Jul 25, 2012
    #20
Page 1 of 3

Share This Page