Untuk Tugas: Laporan Modul 6

Langkah Praktikum

Percobaan 1

Memodifikasi script percobaan 1 modul 4 dengan menambahkan script CSS dibagian bawah tag body.
Membuka notepad dan ketikkan script berikut.

<!DOCTYPE HTML>
<head>
<title>Data Mahasiswa</title>
</head><body>
<link rel="stylesheet" href="style.css">
<?php 
//koneksi ke database
$koneksi=mysql_connect ('localhost','root','');
$db=mysql_select_db('mahasiswa');
?>

th{
 background-color: #2B95EC;
 color: #ffffff;
}
tr:hover{
background-olor: #00ccff;
}
</style>

<table width="600" cellpadding="3" cellspasing="3" align="center" border="1">
<tr>
<th colspan="2">Input Data Mahasiswa</th></tr>
<form action="form.php" method="POST" enctype"multipart/form-data">
<tr>
<td width="500">NIM</td>
<td width="600"><input type="number" name="txtnim" required="required" size="25" ></td>
</tr>
<tr>
<td width="500"> Nama</td>
<td width="600"><input type="text" name="txtnama" required="required" size="45"></td>
</tr>
<tr><td width="500"> Jenis Kelamin</td>
<td width="600"><input type="radio" name="radiokelamin" value="Laki-laki" required="required">Laki-laki
<input type="radio" name="radiokelamin" value="Perempuan" required="required">Perempuan</td>
</tr>
<tr>
<td width="500"> Alamat</td>
<td width="600"><textarea name="txtalamat" rows="5" required="required" cols="45"></textarea.ini></td>
</tr>
<tr>
<td width="500"> jurusan</td>
<td width="600"><input type="text" name="txtjurusan" required="required" size="45"></td>
</tr>
<tr>
<td width="500"></td>
<td width="600"><input id="submit" type="submit" name="submit" value="simpan">
<input id="submit" type="reset" value="Batal"></td>
</tr>
</form>
</table>
<?php

if (isset ($_POST ['submit'])){
$nama   = $_POST['txtnama'];
$nim   = $_POST['txtnim'];
$jeniskelamin = $_POST['radiokelamin'];
$alamat   = $_POST['txtalamat'];
$jurusan  = $_POST['txtjurusan'];

$input="insert into mhs (nim, nama, jenis_kelamin, alamat, jurusan) values ('$nama', '$nim', '$jeniskelamin','$alamat','$jurusan')";

if($nim==''){
echo "<br>";

}else{

mysql_query($input);
echo'<br>Data berhasil dimasukan';
}
}
?>
<hr>
<h2 align="center">
 Data mahasiswa</h2>
<?php
$warna1 = "#FFFFFF";
$warna2 = "#CCFFFF";
$warna  = $warna1;

$sql = mysql_query("SELECT * FROM mhs ORDER BY nim");
  if(!$sql)
  die ("Query salah");
  
  echo"<table cellpadding=4 border=1 align=center>
<tr>
  
  <th>No</th>
  <th>Nim</th>
  <th>Nama</th>
  <th>Jenis Kelamin</th>
  <th>Alamat</th>
  <th>Jurusan</th>
  <th>Pilihan</th></tr>
";
  
$no=+1;
while ($baris=mysql_fetch_row($sql)) {
  $nim   = $baris[0];
  $nama   = $baris[1];
  $jeniskelamin = $baris[2];
  $alamat   = $baris[3];
  $jurusan  = $baris[4];
  
 if($warna == $warna1) {
 $warna = $warna2;
 }
 else {
 $warna = $warna1;
 }
  echo"
<tr>
   <td align=center>$no</td>
   <td align=center>$nim</td>
   <td align=center>$nama</td>
   <td align=center>$jeniskelamin</td>
   <td align=center>$alamat</td>
   <td align=center>$jurusan</td>
   <td align=center><a href='hapus.php?nim=$nim'>Hapus</a> |<a href='update.php?nama=$nama&nim=$nim&jeniskelamin=$jeniskelamin&alamat=$alamat&jurusan=$jurusan'> ubah</a></td></tr>
";
   
$no++;
}
echo"</table>
";
?>

</body>
</html>

Menyimpan file dengan nama form.php pada folder yang sudah dibuat sebelumnya.
Membuka file dengan menggunakan browser.
Hasil.

Tugas 1

Memodifikasi hasil tugas modul 4 dengan menambahkan script css yang berbeda dari modul 1 percobaan 6.
Membuka notepad dan ketikkan script berikut.

<html>
<head>
 <title>Data Mahasiswa</title>
</head>
<body>
 <link rel='stylesheet' type='text/css' href='css.css'>

<?php
  //koneksi ke database
  $koneksi=mysql_connect('localhost', 'root', ''); //host,user,password
  $db=mysql_select_db('modul6'); //nama database
 ?>

<div class="form-style-8">
  <br/><h2 align="center">
Input Data Mahasiswa</h2>
<form action="m6.php" method="POST" enctype="multipart/form-data">
    <input type="text" name="txtnim" placeholder="NIM" />
    <input type="text" name="txtnama" placeholder="Nama" />
 <input name="kelamin" type="radio" value="Laki-laki" />Laki-Laki
 <input name="kelamin" type="radio" value="Perempuan" />Perempuan<hr>
 <textarea name="txtalamat" placeholder="Alamat" cols="45" rows="5"></textarea.ini>
    <input type="text" name="txtjurusan" placeholder="Jurusan" />
 <input name="simpan" id="submit" type="submit" value="Simpan" onclick="popup()"/>
 <input id="submit" type="reset" value="Batal" />
 </form>
</div>
<?php
  //simpan data ke database
  if (isset($_POST['simpan'])){
   $nim    = $_POST['txtnim'];
   $nama    = $_POST['txtnama'];
   $jeniskelamin  = $_POST['kelamin'];
   $alamat   = $_POST['txtalamat'];
   $jurusan   = $_POST['txtjurusan'];
  
   //query input
   $input="insert into m6(nim, nama, jenis_kelamin, alamat, jurusan) values ('$nim', '$nama', '$jeniskelamin', '$alamat', '$jurusan')";
  
   //kondisi inputan
   if($nim==''){
    echo "</br>NIM tidak boleh kosong, diisi dulu";
   }else if($nama==''){
    echo "</br>Nama tidak boleh kosong, diisi dulu";
   }else if($jeniskelamin==''){
    echo "</br>Jenis Kelamin tidak boleh kosong, diisi dulu";
   }else if($alamat==''){
    echo "</br>Alamat tidak boleh kosong, diisi dului";
   }else if($jurusan=''){
    echo "</br>Jurusan tidak boleh kosong, diisi dulu";
   }else{
    mysql_query($input);
    echo'</br>Data berhasil dimasukkan';
   }
  }
 ?>
 <hr>
 <h2 align="center">
Data Mahasiswa</h2>
<?php
  //menampilkan data
  $sql=mysql_query("select * from m6 order by nim");
  if(!$sql)
  die("Query salah");
  echo "<table cellpadding=4 border=1 align=center>
<tr>
     <th>No</th>
     <th>NIM</th>
     <th>Nama</th>
     <th>Jenis Kelamin</th>
     <th>Alamat</th>
     <th>Jurusan</th>
     <th>Pilihan</th>
    </tr>
";
    $posisi=0;
    $no=$posisi+1;
    while ($baris=mysql_fetch_row($sql)){
     $nim=$baris[0];
     $nama=$baris[1];
     $jeniskelamin=$baris[2];
     $alamat=$baris[3];
     $jurusan=$baris[4];
     
     echo "
<tr>
       <td align=center>$no</td>
       <td align=center>$nim</td>
       <td align=center>$nama</td>
       <td align=center>$jeniskelamin</td>
       <td align=center>$alamat</td>
       <td align=center>$jurusan</td>
       <td align=center><a href='delete.php?nim=$nim'>Hapus</a> 
       |<a href='update.php?nim=$nim&nama=$nama&jeniskelamin=$jeniskelamin&alamat=$alamat&jurusan=$jurusan'> Ubah</a></td></tr>
;
      </tr>
";
     $no++;
    }
  echo "</table>
";
 ?>
</body>
</html>

Simpan dengan nama m6.php pada folder yang telah anda buat.
Membuka notepad dan ketikkan script berikut.

}
.form-style-8 h2{
    background: #4D4D4D;
    text-transform: uppercase;
    font-family: 'Open Sans Condensed', sans-serif;
    color: #B4BCBC;
    font-size: 18px;
    font-weight: 100;
    padding: 20px;
    margin: -30px -30px 30px -30px;
}
.form-style-8 input[type="text"],
.form-style-8 input[type="date"],
.form-style-8 input[type="datetime"],
.form-style-8 input[type="email"],
.form-style-8 input[type="number"],
.form-style-8 input[type="search"],
.form-style-8 input[type="time"],
.form-style-8 input[type="url"],
.form-style-8 input[type="password"],
.form-style-8 textarea,
.form-style-8 select 
{
    box-sizing: border-box;
    -webkit-box-sizing: border-box;
    -moz-box-sizing: border-box;
    outline: none;
    display: block;
    width: 100%;
    padding: 7px;
    border: none;
    border-bottom: 1px solid #ddd;
    background: transparent;
    margin-bottom: 10px;
    font: 16px Arial, Helvetica, sans-serif;
    height: 45px;
}
.form-style-8 textarea{
    resize:none;
    overflow: hidden;
}
.form-style-8 input[type="button"],.form-style-8 input[type="reset"], 
.form-style-8 input[type="submit"]{
    -moz-box-shadow: inset 0px 1px 0px 0px #45D6D6;
    -webkit-box-shadow: inset 0px 1px 0px 0px #45D6D6;
    box-shadow: inset 0px 1px 0px 0px #45D6D6;
    background-color: #4D4D4D;
    border: 1px solid #27A0A0;
    display: inline-block;
    cursor: pointer;
    color: #FFFFFF;
    font-family: 'Open Sans Condensed', sans-serif;
    font-size: 14px;
    padding: 8px 18px;
    text-decoration: none;
    text-transform: uppercase;
}
.form-style-8 input[type="button"]:hover, 
.form-style-8 input[type="submit"]:hover {
    background:linear-gradient(to bottom, #34CACA 5%, #30C9C9 100%);
    background-color:#34CACA;
}
</style>

Simpan dengan nama css.css pada folder yang sama dengan file m6.php
Membuka file m6.php dengan browser.
Hasil.

Tugas 2

Membuat script baru untuk memodifikasi tabel input data percobaan 1 modul 6.
Membuka notepad dan ketikkan script berikut.

<style>

.form-style-8 h2{
    background: #4D4D4D;
    text-transform: uppercase;
    font-family: 'Open Sans Condensed', sans-serif;
    color: #B4BCBC;
    font-size: 18px;
    font-weight: 100;
    padding: 20px;
    margin: -30px -30px 30px -30px;
</style>

<div class="form-style-8">
  <br/><h2 align="center">
Input Data Mahasiswa</h2>
</div>
<table width="600" cellpadding="3" cellspasing="3" align="center" border="1">
<tr>
<form action="form.php" method="POST" enctype"multipart/form-data">
<tr>
<td width="500">NIM</td>
<td width="600"><input type="number" name="txtnim" required="required" size="25" ></td>
</tr>
<tr>
<td width="500"> Nama</td>
<td width="600"><input type="text" name="txtnama" required="required" size="45"></td>
</tr>
<tr><td width="500"> Jenis Kelamin</td>
<td width="600"><input type="radio" name="radiokelamin" value="Laki-laki" required="required">Laki-laki
<input type="radio" name="radiokelamin" value="Perempuan" required="required">Perempuan</td>
</tr>
<tr>
<td width="500"> Alamat</td>
<td width="600"><textarea name="txtalamat" rows="5" required="required" cols="45"></textarea.ini></td>
</tr>
<tr>
<td width="500"> jurusan</td>
<td width="600"><input type="text" name="txtjurusan" required="required" size="45"></td>
</tr>
<tr>
<td width="500"></td>
<td width="600"><input id="submit" type="submit" name="submit" value="Simpan">
<input id="submit" type="reset" value="Batal"></td>
</tr>
</form>
</table>
<?php

if (isset ($_POST ['submit'])){
$nama   = $_POST['txtnama'];
$nim   = $_POST['txtnim'];
$jeniskelamin = $_POST['radiokelamin'];
$alamat   = $_POST['txtalamat'];
$jurusan  = $_POST['txtjurusan'];

$input="insert into mhs (nim, nama, jenis_kelamin, alamat, jurusan) values ('$nama', '$nim', '$jeniskelamin','$alamat','$jurusan')";

if($nim==''){
echo "<br>";

}else{

mysql_query($input);
echo'<br>Data berhasil dimasukan';
}
}
?>
<hr>
<h2 align="center">
 Data mahasiswa</h2>
<?php
$warna1 = "#FFFFFF";
$warna2 = "#CCFFFF";
$warna  = $warna1;

</body>
</html>

Hasil.

Untuk Tugas

Jumat, 21 November 2014

Laporan Modul 6

Tidak ada komentar:

Posting Komentar