HTML :
<HTML>
<HEAD>
<TITLE>LATIHAN</TITLE>
</HEAD>
<BODY BGCOLOR="PINK"><H1 ALIGN = "LEFT">INPUT DATA PEMBELIAN</H1>
<HR ALIGN= "CENTER" WIDTH=1000 SIZE=3>
<FORM ACTION="lat_chec3.PHP" METHOD="GET"><PRE>
NO. TRANSAKSI = <INPUT TYPE="TEXT" NAME="NO" SIZE=10><BR>
NAMA PENUMPANG = <INPUT TYPE="TEXT" NAME="NM" SIZE=25><BR>
KODE TUJUAN = <select name="TUJUAN">
<option value="JAKARTA">JKT-01</option>
<option value="BANDUNG">BDG-02</option>
<option value="JOGJAKARTA">JGJ-03</option></SELECT><BR>
JUMLAH BELI = <INPUT TYPE="TEXT" NAME="JML" SIZE=5><BR>
KODE KELAS = <Input type = 'Radio' Name ='KLS' value= 'VIP'>VP<Input type = 'Radio' Name ='KLS' value= 'EXECUTIVE'>EX<Input type = 'Radio' Name ='KLS' value= 'EKONOMI'>EK<BR>
BIAYA TAMBAHAN = <input type="checkbox" name="MS" value=7500 >MAKAN SIANG <BR>
<input type="checkbox" name="SN" value=5000 >SNACK <BR>
<input type="checkbox" name="AM" value=3000 >AIR MINERAL <BR>
<INPUT TYPE="SUBMIT" VALUE="PROSES">
<HR ALIGN= "CENTER" WIDTH=1000 SIZE=3></FORM>
</BODY>
</HTML>
Pembuatan PHP :
<HTML>
<HEAD><TITLE>LATIHAN</TITLE></HEAD>
<BODY BGCOLOR="PINK">
<H1 ALIGN = "LEFT">TAMPIL DATA PEMBELIAN</H1>
<HR ALIGN= "CENTER" WIDTH=1000 SIZE=3>
<?PHP
$xNO = $_GET['NO'];
$xNM = $_GET['NM'];
$xTUJUAN = $_GET['TUJUAN'];
$xJML = $_GET['JML'];
$xKLS = $_GET['KLS'];
$xMS = $_GET['MS'];
$xAM = $_GET['AM'];
$xSN = $_GET['SN'];
ECHO "<PRE>NO. TRANSAKSI = $xNO<BR><BR>";
ECHO "NAMA PENUMPANG = $xNM<BR><BR>";
ECHO "TUJUAN = $xTUJUAN<BR><BR>";
IF ($xTUJUAN == "JAKARTA")
$HRG = 500000;
ELSE
IF ($xTUJUAN == "BANDUNG")
$HRG = 700000;
ELSE
IF ($xTUJUAN == "JOGJAKARTA")
$HRG = 1000000;
ECHO "HARGA = $HRG<BR><BR>";
ECHO "JUMLAH BELI = $xJML<BR><BR>";
$TOT = $HRG * $xJML;
ECHO "TOTAL BELI = $TOT<BR><BR>";
ECHO "KELAS = $xKLS<BR><BR>";
IF ($xKLS == "VIP"){
IF ($TOT >= 2000000){
$DISK = $TOT * 10/100;}
ELSE
{
$DISK = 0;}}
ELSE
IF ($xKLS == "EXECUTIVE"){
IF ($TOT >= 1500000){
$DISK = $TOT * 10/100;}
ELSE
{
$DISK = 0;}}
ELSE
IF ($xKLS == "EKONOMI"){
IF ($TOT >= 1000000){
$DISK = $TOT * 10/100;}
ELSE
{
$DISK = 0;}}
ECHO "DISKON = $DISK<BR><BR>";
$BIAYA=$xMS + $xSN + $xAM;
ECHO "BIAYA TAMBAHAN = $BIAYA<BR><BR>";
$TTL = $TOT-$DISK+$BIAYA;
ECHO "TOTAL BAYAR = $TTL<BR><BR>";
?>
<HR ALIGN= "CENTER" WIDTH=1000 SIZE=3>
</BODY>
</HTML>
Nh-aziz'blogs
RSS Subscribe
At a Glance
Mari Bergabung
Minggu, 24 Oktober 2010
Selasa, 12 Oktober 2010
CONTOH MEMBUAT DATABASE DENGAN MYSQL
Cara Masuk Ke Dos(cmd):
C:\Documents and Settings\Badar>cd\apache\mysql\bin
C:\apache\mysql\bin>mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 3.23.47-max-debug
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
Cara Melihat Database yang mungkin sudah ada:
mysql> show databases;
+----------+
| Database |
+----------+
| badar |
| mysql |
| test |
+----------+
3 rows in set (0.06 sec)
mysql>
Membuat Dtabase Baru, dan Melakukan Printah Pada database tersebut:
mysql> create database contoh;
Query OK, 1 row affected (0.01 sec)
mysql> use contoh;
Database changed
mysql>
Membuat Tabel:
Di sini saya mengisikan beberapa table sbb:
mysql> create table mahasiswa
-> (mhs_no int(11)primary key auto_increment,
-> mhs_nama varchar(30),
-> mhs_alamat varchar(225));
Query OK, 0 rows affected (0.20 sec)
mysql> create table progstudy
-> (ps_kode varchar(2),
-> ps_desc varchar(50));
Query OK, 0 rows affected (0.06 sec)
mysql> create table dosen
-> (dosen_nama varchar(30),
-> dosen_alamat varchar(225),
-> dosen_telp varchar(20));
Query OK, 0 rows affected (0.01 sec)
mysql> create table gaji
-> (gaji_no int(11),
-> dosen_no int(11),
-> gaji_pokok int(20));
Query OK, 0 rows affected (0.01 sec)
mysql> create table kelas
-> (kelas_desc varchar(11),
-> dosen_no int(11),
-> mk_no int(11));
Query OK, 0 rows affected (0.00 sec)
mysql>
Melihat Setruktur table yang baru anda buat Sbb:
mysql> desc kelas;
+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| kelas_desc | varchar(11) | YES | | NULL | |
| dosen_no | int(11) | YES | | NULL | |
| mk_no | int(11) | YES | | NULL | |
+------------+-------------+------+-----+---------+-------+
3 rows in set (0.08 sec)
mysql>
Melihat seluruh table dalam database:
mysql> show tables;
+------------------+
| Tables_in_contoh |
+------------------+
| dosen |
| gaji |
| kelas |
| mahasiswa |
| progstudy |
+------------------+
5 rows in set (0.00 sec)
mysql>
Cara menghapus table:
Mysql>drop table dosen;
Menambahkan Kolom
mysql>alter table mahasiswa
>add mhs_telp int(20);
Jika mau menambahkan sebelum or sesudah: first, after.
Menghapus Type Colum
Kita akan mengganti colom mhs_telp menjadi varchar.
Mengubah Nama dan type colum
mysql>alter table mahasiswa
>change mhs_sex mhs_jnskelamin enum('L','P');
Menghapus Colom
mysql>alter table mahasiswa
>drop mhs_notelp;
Mengisi record:
mysql>insert into mahasiswa
>(mhs_nama,
>mhs_alamat,
>mhs_telp,
>mhs_tplahir,
>mhs_tgllahir,
>mhs_jnskelamin)
>values
>('arif budiman',
>'teluk betung',
>'(082839)768686',
>'teluk betung',
>'1976-03-14',
>'L');
Menambahkan Kolom
mysql>alter table mahasiswa
>add mhs_telp int(20);
Jika mau menambahkan sebelum or sesudah: first, after.
Menghapus Type Colum
Kita akan mengganti colom mhs_telp menjadi varchar.
Mengubah Nama dan type colum
mysql>alter table mahasiswa
>change mhs_sex mhs_jnskelamin enum('L','P');
Menghapus Colom
mysql>alter table mahasiswa
>drop mhs_notelp;
Mengisi record:
mysql>insert into mahasiswa
>(mhs_nama,
>mhs_alamat,
>mhs_telp,
>mhs_tplahir,
>mhs_tgllahir,
>mhs_jnskelamin)
>values
>('arif budiman',
>'teluk betung',
>'(082839)768686',
>'teluk betung',
>'1976-03-14',
>'L');
Minggu, 10 Oktober 2010
Senin, 04 Oktober 2010
Minggu, 03 Oktober 2010
Contoh Logika dengan menggunakan html
Logika1.html
<html>
<head><title>Logika2</title></head>
<body>
<form action="Logika2.php"method="get">
<pre>
Nama Karyawan = <input type="text" name="nm" size=20><br><br>
Kode Jabatan = <input type="text" name="kd" size=5><br><br>
Kasbon = <input type="text" name="kb" size=5><br><br>
</pre>
<input type="submit"value="Total">
</body>
</html>
Logika2.php
<html>
<head><title>Logika2</title></head>
<body>
<?php
$xnm=$_GET['nm'];
$xkd=$_GET['kd'];
$xkb=$_GET['kb'];
echo "Nama Karyawan = $xnm<br>";
if($xkd=="DR"){
$jab=" Direktur";
$gp=4000000;}
else if($xkd=="SR"){
$jab=" Sekretaris";
$gp=1500000;}
else if($xkd=="ST"){
$jab=" Staff";
$gp=1000000;}
echo"Jabatan = $jab<br>";
echo"Gaji Pokok = $gp<br>";
echo"Kasbon = $kb<br>";
$gb=$gp-$xkb;
echo"Gaji Bersih = $gb<br>";
echo "</pre>";
?>
</body>
<html>
Yang berikutnya saya beri nama penyimpanan dengan nama Logika3.html, beserta php nya.
Logika3.html
<html>
<head><title>logika3</title></head>
<body><pre>
<form action="logika3.php" method="get">
Nama Pembeli = <input type="text" name="np" size=25><br><br>
Kode Barang = <input type="text" name="kb" size=3><br><br>
Jumlah Barang = <input type="text" name="jb" size=5><br><br>
<input type="submit" value="TOTAL">
</pre>
</body>
</html>
Logika3.php
<html>
<head><title>logika3</title></head>
<body><pre>
<?php
$xnp=$_GET['np'];
$xkb=$_GET['kb'];
$xjb=$_GET['jb'];
if ($xkb=="KM"){
$nb="Komputer";
$hrg=3000000;}
else if ($xkb=="LP"){
$nb="Laptop";
$hrg=7000000;}
else if ($xkb=="PR"){
$nb="Printer";
$hrg=500000;}
echo "Nama Pembeli = $xnp<br>";
echo "Nama Barang = $nb<br>";
echo "Harga Satuan = $hrg<br>";
echo "Jumlah Barang = $xjb<br>";
$th=$hrg*$xjb;
echo "Total Beli = $th<br>";
if($xjb>=5)
$dsk=$th*0.1;
else
$dsk=0;
echo "Diskon = $dsk<br>";
$tb=$th-$dsk;
echo "Total Bayar = $tb<br>";
?>
</pre>
</body>
</html>
Langganan:
Postingan (Atom)