Senin, 21 November 2011

CONTOH PROGRAM SEDERHANA

Bahasa pemrograman adalah teknik komando/instruksi standar untuk memerintah komputer. Bahasa pemrograman ini merupakan suatu set aturan sintaks dan semantik yang dipakai untuk mendefinisikan program komputer. Bahasa ini memungkinkan seorang programmer dapat menentukan secara persis data mana yang akan diolah oleh komputer, bagaimana data ini akan disimpan/diteruskan, dan jenis langkah apa secara persis yang akan diambil dalam berbagai situasi.


DESIGN MENU UTAMA


CODE LISTING
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>MID</title>
</head>
<body>
<center>
<table width="623" border="1">
  <tr>
    <td colspan="4"><div align="center">RECEIPSIONIST HOTEL TIDUR NYEYAK JALAN   BERASAN SELALU </div></td>
  </tr>
  <tr>
    <td width="124"><a href="entry.php">ENTRY DATA</a> </td>
    <td width="173">&nbsp;</td>
    <td width="174">&nbsp;</td>
    <td width="124">&nbsp;</td>
  </tr>
  <tr>
    <td height="23"><a href="form_edit.php">EDIT DATA</a> </td>
    <td colspan="2" rowspan="2">Soal MID : Buatlah proses entry data dan pilih salah satu proses disamping !!!! </td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>CARI DATA </td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><a href="hapus.php">HAPUS DATA</a> </td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td colspan="4">&nbsp;</td>
    </tr>
</table>
</center>
</body>
</html>

DESIGN ENTRY DATA
 
 
CODE LISTING

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>MID</title>
</head>
<body>
<center>
<table width="745" border="1">
  <tr>
    <td colspan="2"><div align="center">RECEIPSIONIST HOTEL TIDUR NYEYAK JALAN BERASAN SELALU </div></td>
  </tr>
  <tr>
    <td width="177" height="46">ENTRY DATA </td>
    <td width="527" rowspan="4"><form method="post" action="insert.php">
      <table width="551" border="1">
        <tr>
          <td colspan="3"><div align="center">ENTRY DATA </div></td>
          </tr>
        <tr>
          <td width="168">ID TAMU </td>
          <td width="21"><div align="center">:</div></td>
          <td width="340"><label>
            <input type="text" name="ID" id="ID" />
          </label></td>
        </tr>
        <tr>
          <td>NAMA</td>
          <td><div align="center">:</div></td>
          <td><label>
            <input name="NAMA" type="text" id="NAMA" size="49" />
          </label></td>
        </tr>
        <tr>
          <td>JENIS KAMAR </td>
          <td><div align="center">:</div></td>
          <td><label>
            <input name="JENIS_KAMAR" type="text" id="JENIS_KAMAR" size="49" />
          </label></td>
        </tr>
        <tr>
          <td>TGL MASUK </td>
          <td><div align="center">:</div></td>
          <td><label>
            <input type="text" name="tanggal" id="tanggal" size="5"/>
            <input type="text" name="bulan" id="bulan" size="5"/>
            <input type="text" name="tahun" id="tahun" size="5"/>
          </label></td>
        </tr>
        <tr>
          <td colspan="2"><label>
            <center><a href="index.php"><input name="utama" type="button" id="utama" value="Menu Utama" />
            </a></center>
          </label></td>
          <td><label>
            <input name="SIMPAN" type="submit" id="SIMPAN" value="Simpan" />
          </label></td>
        </tr>
      </table>
    </form>    </td>
    </tr>
  <tr>
    <td height="43">EDIT DATA </td>
    </tr>
  <tr>
    <td height="43">CARI DATA </td>
    </tr>
  <tr>
    <td height="40">HAPUS DATA </td>
    </tr>
</table>
</center>
</body>
</html>


LISTING PHP

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>MID</title>
</head>
<body>
</body>
 <?php
                 $ID = $_POST['ID'];
     $NAMA = $_POST['NAMA']; 
     $JENIS_KAMAR = $_POST['JENIS_KAMAR']; 
     $TGL_MASUK = $_POST['tahun'].'-'.$_POST['bulan'].'-'.$_POST['tanggal'];
     //koneksi database 
     $conn = mysql_connect("localhost","root",""); 
     mysql_select_db("HOTEL"); 
      
     $query = "insert into TAMU set ID='$ID',NAMA='$NAMA',JENIS_KAMAR='$JENIS_KAMAR',TGL_MASUK='$TGL_MASUK'"; 
     $hasil = mysql_query($query); 
     if($hasil){ 
      echo "Data Tamu telah disimpan"; 
     }else{ 
      echo "Error! gagal menyimpan data Tamu:".mysql_error(); 
     } 
     ?>  <br>
<a href="index.php">Back</a>
</html>
 
DESIGN EDIT DATA








LISTING PHP
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>MID</title>
</head>
<body>
</body>
<?php
//koneksi ke mysql

mysql_connect("localhost", "root", "");
mysql_select_db("HOTEL");

$op = $_GET['op'];

// bagian untuk proses edit

if ($op == "edit")
{
  
$ID = $_GET['ID'];

$query = "SELECT * FROM TAMU WHERE ID = '$ID'";
$hasil = mysql_query($query);
$data  = mysql_fetch_array($hasil);
 
echo "<form method=\"post\" action=\"".$_SERVER['PHP_SELF'].
"?op=update\">";
echo "<table border=\"1\">";

echo "<tr>
<td>ID</td>
<td><input type=\"text\" name=\"ID\"
value=\"".$data['ID']."\"></td>
</tr>";

echo "<tr>
<td>Nama</td>
<td>
<input type=\"text\" name=\"NAMA\" size=\"35\"
value=\"".$data['NAMA']."\">
</td>
</tr>";

echo "<tr>
<td>Jenis Kamar</td>
<td>
<input type=\"text\" name=\"JENIS_KAMAR\" size=\"35\"
value=\"".$data['JENIS_KAMAR']."\" >
</td>
</tr>";

echo "<tr>
<td>Tanggal Masuk</td>
<td>
<input type=\"text\" name=\"TGL_MASUK\"
value=\"".$data['TGL_MASUK']."\">
</td>
</tr>";

echo "<input type=\"hidden\" name=\"IDLama\"
value=\"".$data['ID']."\">";
echo "</table>";

echo "<input type=\"submit\" name=\"submit\"
value=\"Simpan Perubahan\">";
echo "</form>";
}

else if ($op == "update")
{

$ID = $_POST['ID'];

$NAMA = $_POST['NAMA'];

$IDLama = $_POST['IDLama'];

$JENIS_KAMAR = $_POST['JENIS_KAMAR'];

$TGL_MASUK = $_POST['TGL_MASUK'];

$query = "UPDATE TAMU
SET ID = '$ID', NAMA = '$NAMA',
JENIS_KAMAR = '$JENIS_KAMAR',
TGL_MASUK = '$TGL_MASUK'
WHERE ID = '$IDLama'";
$hasil = mysql_query($query);
if ($hasil) echo "<p>Proses Update Sukses</p>";
else echo "<p>Proses Update Gagal</p>";
}

?>

<center>
<table border="1">
<tr>
<th>No</th>
<th>ID</th>
<th>Nama</th>
<th>Jenis Kamar</th>
<th>Tanggal Masuk</th>
<th>Action</th>
</tr>
</center>
<?php

$no = 1;
$query = "SELECT * FROM tamu";
$hasil = mysql_query($query);
while ($data = mysql_fetch_array($hasil))
{
echo "<tr>";
echo "<td>".$no."</td>";
echo "<td>".$data['ID']."</td>";
echo "<td>".$data['NAMA']."</td>";
echo "<td>".$data['JENIS_KAMAR']."</td>";
echo "<td>".$data['TGL_MASUK']."</td>";
echo "<td>
<a href=\"".$_SERVER['PHP_SELF'].
"?op=edit&ID=".$data['ID']."\">
Edit
</a>
</td>";
echo "</tr>";
$no++;
}

?>
</table>
<a href="index.php">Back</a>
</html>

Diposting oleh di
Label:

5 komentar:

Langganan: Posting Komentar (Atom)