Mencari Ilmu: phpmyadmin...coneksi jaringan

Nama : Dewi Nursanti B. Kumuru

Kelas : xi trpl

Sourcecode conn.php

<?php

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

if(!$con)

{

die('tidak bisa terkoneksi:'.mysql_error());

}

if(mysql_query("create database dbdatasiswa",$con))

{

echo"database sukses dibuat";

}

else

{

echo"error membuat database:".mysql_error();

}

mysql_close($con);

jika database sukses akan muncul “database sukses dibuat”

jika database eror akan muncul “error membuat database”

Sourcecode nilai.php

<?php

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

$database="dbdatasiswa";

mysql_select_db($database,$con) or die ("database tidak ketemu");

$sql="create table nilai

(

nis varchar(15),

nama varchar(15),

kelas varchar(15),

jurusan varchar(5),

n_adaptif int,

n_normatif int,

n_produktif int,

jumlah int,

rata int,

grade char(4),

primary key(nis)

)";

if(mysql_query($sql,$con))

{

echo "tabel sukses dibuat";

}

else

{

echo "error membuat tabel:".mysql_error();

}

//eksekusi query

mysql_query($sql,$con);

mysql_close($con);

jika tabel nilai sukses akan muncul “tabel sukses dibuat”

jika tabel nilai eror akan muncul “error membuat tabel”

Sourcecode input.php

<?php

echo"<img src='kompi.GIF' >Data Siswa SMK N 3 Palu";

echo"<body background =hijau.GIF>";

echo"<pre>";

echo"<form method=POST action=input.php><br><br>";

echo"nis <input type=text name=nis><br><br>";

echo"nama <input type=text name=nama><br><br>";

echo "kelas <input type = radio name = kelas value= x>x<input type = radio

name = kelas value= xi>xi<input type = radio name = kelas value=

xii>xii<br><br>";

echo"jurusan <select name=jurusan><option value =

rpl>rpl</option><option value = rpl>tgb</option><option value =

rpl>tmo</option><option value = tkj>tkj</option></select><br><br>";

echo"n_adaptif <input type=text name=n_adaptif><br><br>";

echo"n_normatif <input type=text name=n_normatif><br><br>";

echo"n_produktif <input type=text name=n_produktif><br><br>";

echo"<input type=submit name=ok value=OK></pre></form>";

$nis=$_POST['nis'];

$nama=$_POST['nama'];

$kelas=$_POST['kelas'];

$jurusan=$_POST['jurusan'];

$n_adaptif=$_POST['n_adaptif'];

$n_normatif=$_POST['n_normatif'];

$n_produktif=$_POST['n_produktif'];

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

if(!$con)

{

die('tidak bisa terkoneksi:'.mysql_error());

}

$database="dbdatasiswa";

mysql_select_db($database,$con) or die ("database tidak ketemu");

$jumlah=$n_adaptif+$n_normatif+$n_produktif;

$rata=$jumlah/3;

if ($rata <= 50){

$g = "E";

}else

if ($rata <= 60){

$g = "D";

}else

if ($rata <= 70){

$g = "C";

}else

if ($rata <= 80){

$g = "B";

}else

if ($rata <= 100){

$g = "A";

}

$grade=$g;

if($_POST['ok']=="OK"){

if($nis=="" || $nama=="" || $kelas=="" || $jurusan=="" || $n_adaptif=="" ||

$n_normatif=="" || $n_produktif==""){

echo "Gagal di inputkan!!";}else{

$query="insert into nilai values ('$nis','$nama','$kelas','$jurusan', '$n_adaptif',

'$n_normatif', '$n_produktif', '$jumlah', '$rata', '$grade')";

}

if(mysql_query($query,$con))

{

echo"berhasil diinputkan!!";

}

mysql_close($con);

echo"<form method=POST action=output.php>";

echo"<input type=submit value=Lihat>";

echo"</form>";

Tampilannya input.php

Jika diklik OK, akan muncul “berhasil diinputkan!!”maka akan tersimpan di array

Jika diklik Lihat, maka akan muncul form output.php

Sourcecode Output.php

<?php

echo"<center><img src='kompi.GIF' >Data siswa";

echo"<br><br><body background =animated_41.gif>";

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

if(!$con)

{

die('tidak bisa terkoneksi:'.mysql_error());

}

$database="dbdatasiswa";

mysql_select_db($database,$con) or die ("database tidak ketemu");

$i=1;

$u=1;

$v=1;

$result = mysql_query("SELECT * FROM nilai order by nama");

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

$hpp[$i][1]=$row['nis'];

$hpp[$i][2]=$row['nama'];

$hpp[$i][3]=$row['kelas'];

$hpp[$i][4]=$row['jurusan'];

$hpp[$i][5]=$row['n_adaptif'];

$hpp[$i][6]=$row['n_normatif'];

$hpp[$i][7]=$row['n_produktif'];

$hpp[$i][8]=$row['jumlah'];

$hpp[$i][9]=$row['rata'];

$hpp[$i][10]=$row['grade'];

$aa=$hpp[$i][1];

$bb=$hpp[$i][2];

$cc=$hpp[$i][3];

$dd=$hpp[$i][4];

$ee=$hpp[$i][5];

$ff=$hpp[$i][6];

$gg=$hpp[$i][7];

$ni=$_POST['ni'];

$nm=$_POST['nm'];

$kl=$_POST['kl'];

$jr=$_POST['jr'];

$ad=$_POST['ad'];

$no=$_POST['no'];

$pr=$_POST['pr'];

if ($_POST[$v]=="Update"){

if($ni=="" || $nm=="" || $kl=="" || $jr=="" || $ad=="" || $no=="" ||

$pr==""){$bilang=" Gagal mengupdate $bb!!";}else{

$jm=$ad+$no+$pr;

$ra=$jm/3;

if ($ra <= 50){

$g = "E";

}else

if ($ra <= 60){

$g = "D";

}else

if ($ra <= 70){

$g = "C";

}else

if ($ra <= 80){

$g = "B";

}else

if ($ra <= 100){

$g = "A";

}

$gr=$g;

if (mysql_query("UPDATE nilai SET nis='$ni', nama='$nm', kelas='$kl', jurusan='$jr',

n_adaptif='$ad', n_normatif='$no', n_produktif='$pr', jumlah='$jm', rata='$ra',

grade='$gr' WHERE nis = '$aa'")){

$bilang=" Berhasil mengupdate $bb!! ";

}

if ($_POST[$i]=="Hapus"){

if (mysql_query("DELETE FROM nilai WHERE nis = '$aa'")){

$bilang=" Berhasil menghapus $bb!!";

}

if ($_POST[$u]=="Edit"){

$up="<tr bgcolor = white><td><form method = POST action = output.php><input size

= 6 type = text name = ni value = '$aa'></td><td><input size = 6 type = text name = nm

value = '$bb'></td><td><input size = 6 type = text name = kl value =

'$cc'></td><td><input size = 6 type = text name = jr value = '$dd'></td><td><input

size = 6 type = text name = ad value = '$ee'></td><td><input size = 6 type = text name =

no value = '$ff'></td><td><input size = 6 type = text name = pr value = '$gg'></td><td

width = 60 align = center>$font".$row['jumlah']."</td><td width = 60 align =

center>$font".$row['rata']."</td><td width = 60 align =

center>$font".$row['grade']."</td><td width = 100 align = center>$font<form method =

POST action = output.php><input type = submit name =$v

value=Update></td></form></tr>";

}

$i++;

$u++;

$v++;

}

$i=1;

$u=1;

$v=1;

$result = mysql_query("SELECT * FROM nilai order by nama");

mysql_query("SELECT * FROM nilai order by nama");

echo "<table border=2><tr bgcolor = white><td width = 60 align = center>$font

Nis</td><td width = 60 align = center>$font Nama</td><td width = 60 align =

center>$font Kelas</td><td width = 60 align = center>$font Jurusan</td><td width =

60 align = center>$font N_Adaptif</td><td width = 60 align = center>$font

N_Normatif</td><td width = 60 align = center>$font N_Produktif</td><td width = 60

align = center>$font Jumlah</td><td width = 60 align = center>$font Rata</td><td

width = 60 align = center>$font Grade</td><td width = 100 align = center>$font

Ket</td></tr>";

while($row = mysql_fetch_array($result))

{

$hps[$i]=$row['nis'];

if ($_POST[$u]=="Edit"){

echo"$up";

$i++;

$u++;

$v++;

}else{

echo "<tr bgcolor = white><td width = 60 align = center>$font".$row['nis']."</td><td

width = 60 align = center>$font".$row['nama']."</td><td width = 60 align =

center>$font".$row['kelas']."</td><td width = 60 align =

center>$font".$row['jurusan']."</td><td width = 60 align =

center>$font".$row['n_adaptif']."</td><td width = 60 align =

center>$font".$row['n_normatif']."</td><td width = 60 align =

center>$font".$row['n_produktif']."</td><td width = 60 align =

center>$font".$row['jumlah']."</td><td width = 60 align =

center>$font".$row['rata']."</td><td width = 60 align =

center>$font".$row['grade']."</td><td width = 100 align = center>$font<form method =

POST action = output.php><input type = submit name =$i value=Hapus><input type =

submit name =$u value=Edit></td></form></tr>";

$i++;

$u++;

$v++;}

}

echo "</table>";

echo "$bilang";

mysql_close($con);

echo"</center>";

echo"<br><br><a href=input.php>Kembali</a>"

Tampilan output.php

Jika diklik hapus, maka data yang dihapus tadi akan terhapus….

Jika diklik edit, maka akan muncul form yang siap untuk diedit

Apabila telah selesai diedit, maka klik update untuk mengapdate datanya

Jika diklik kembali, maka akan kembali ke form input.php

Mencari Ilmu

Senin, 16 April 2012

phpmyadmin...coneksi jaringan

Tidak ada komentar:

Posting Komentar