Many'ax Script: Pemrograman PHP - Membuat Form Anggota

Contoh Program Php - Membuat Form Anggota

Contoh Pemrograman PHP

Membuat Form Anggota

Pertama kita buat dulu Database dengan nama “dbanggota1”. Dengan struktur tabel seperti dibawah ini :

Struktur Tabel Anggota

create table anggota(

nomor int(6)primary key,

nama varchar(40)not null,

email varchar(50)not null,

alamat varchar(80)not null,

kota varchar(50)not null

);

insert into anggota values(1,'Ema Mitsikuri','mitsikuri@gmail.com','Jl.ketapang','Jambi');

insert into anggota values(2,'Tono Subroto','tono@yahoo.com','Jl.Dr.Soetomo','Padang');

insert into anggota values(3,'Budi Krniawan','budi@plasa.com','Jl.Anggrek','Pekanbaru');

insert into anggota values(4,'Ani Mariani','ani@yahoo.com','Jl.Mawar','Jambi');

insert into anggota values(5,'Dian Nur Cahaya','dian@yahoo.co.id','Jl.Beringin','Jakarta');

Gambar 1 - Form Input_anggota.

Kode program - input_anggota.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Input Anggota</title>

<!--

.style1 {color: #FFFFFF}

-->

</style>

</head>

<body>

<td colspan="2"><div align="center"><span class="style1">INPUT ANGGOTA </span></div></td>

</tr>

<td width="85">Nomor</td>

</tr>

</tr>

<td>Email</td>

</tr>

<td align="left" valign="top">Alamat</td>

</tr>

</tr>

<a href="ListAnggota.php">List Anggota

</a>

</div></td>

</tr>

</table>

</form>

</body>

</html>

Kode Program - Simpan.php

<html>

<head>

<title>Simpan data Anggota</title>

</head>

<?php

require("ConnectDb.php");

$link=open_connection();

$tablename="anggota";

$sqlstr="INSERT INTO $tablename

VALUES('$nomor','$nama','$email','$alamat','$kota')";

if (!mysql_query ($sqlstr))

{

echo("Invalid Query!<br>Please register again...<br>");

exit;

}

mysql_close($link);

echo("Terima Kasih Telah Mengisi Data Anggota...<p>");

</h3>

</font>

|<a href="InputAnggota.php"> Back</a> | <a href="ListAnggota.php">Lihat Data</a> | </font>

</body>

</html>

Gambar 2 Simpan_data_anggota.

Kode Program ConnectDb.php

<?php

function open_connection()

{

$host="localhost";

$username="root";

$password="";

$databasename="dbanggota1";

$link=mysql_connect($host,$username,$password) or die ("Database tidak dapat dihubungkan!");

mysql_select_db($databasename,$link);

return $link;

}

Gambar 3 – ListAnggota.

<html>

<head>

<title>Movie database</title>

TD{color:#353535;font-family:verdana}

TH{color:#FFFFFF;font-family:verdana;background-color:#336699}

.style2 {color: #400080}

.style3 {

font-family: Verdana, Arial, Helvetica, sans-serif;

font-size: 24px;

}

</style>

</head>

<body>

<h2 align="center" class="style2">DAFTAR NAMA ANGGOTA </h2>

</blockquote>

<table border="1" width="774" cellspacing="1" cellpadding="3"

bgcolor="" align="center">

<tr> <td> Nomor </td>

<td>Nama Anggota </td>

<td>Email</td>

<td> Alamat </td>

</tr>

<tr>

Input Anggota Baru <a href="inputanggota.php"> [ADD]</a></td>

</tr>

<?php

require("ConnectDb.php");

$link=open_connection();

$tablename="anggota";

$sqlstr="select * from $tablename";

$result = mysql_query ($sqlstr) or die ("Kesalahan pada perintah SQL!");

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

<tr>

</tr>

<?php

}

</table>

</body>

</html>

Gambar 4 - Delete Anggota.

<html>

<head>

<title>Movie database</title>

TD{color:#353535;font-family:verdana}

TH{color:#FFFFFF;font-family:verdana;background-color:#336699}

.style2 {color: #400080}

.style3 {

font-family: Verdana, Arial, Helvetica, sans-serif;

font-size: 24px;

}

</style>

</head>

<body>

<h2 align="center" class="style2">DAFTAR NAMA ANGGOTA </h2>

</blockquote>

<table border="1" width="774" cellspacing="1" cellpadding="3"

bgcolor="" align="center">

<tr> <td> Nomor </td>

<td>Nama Anggota </td>

<td>Email</td>

<td> Alamat </td>

<td>Action</td>

</tr>

<tr>

Input Anggota Baru <a href="inputanggota.php"> [ADD]</a></td>

</tr>

<?php

require("ConnectDb.php");

$link=open_connection();

$tablename="anggota";

$sqlstr="select *from $tablename";

$result = mysql_query ($sqlstr) or die ("Kesalahan pada perintah SQL!");

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

<tr>

<td bgcolor="#FFFFFF" width="25%"><a href="delete.php?&nomor=<?php echo $row['nomor']?>">[Delete]</a></td>

</tr>

<?php

}

</table>

</body>

</html>

Kode Program - Delete.php

<?php

// COMMIT ADD

require("ConnectDb.php");

$link=open_connection();

$tablename="anggota";

$sql = "Delete from $tablename where nomor='$nomor' ";

$result = mysql_query($sql) or die("Invalid query: " . mysql_error());

<p align="center" style="color:#FF0000"> Berhasil DiDelete..! <a href="list2.php">Back to</a>

</p>

<?php

Gambar 5 - Proses Hapus.

Gambar 6 - Update Anggota.

Kode Program - List4.php

<html>

<head>

<title>Movie database</title>

TD{color:#353535;font-family:verdana}

TH{color:#FFFFFF;font-family:verdana;background-color:#336699}

.style2 {color: #400080}

.style3 {

font-family: Verdana, Arial, Helvetica, sans-serif;

font-size: 24px;

}

</style>

</head>

<body>

<h2 align="center" class="style2">DAFTAR NAMA ANGGOTA </h2>

</blockquote>

<table border="1" width="774" cellspacing="1" cellpadding="3"

bgcolor="" align="center">

<tr> <td> Nomor </td>

<td>Nama Anggota </td>

<td>Email</td>

<td> Alamat </td>

<td>Action</td>

</tr>

<tr>

Input Anggota Baru <a href="inputanggota.php"> [ADD]</a></td>

</tr>

<?php

require("ConnectDb.php");

$link=open_connection();

$tablename="anggota";

$sqlstr="select *from $tablename";

$result = mysql_query ($sqlstr) or die ("Kesalahan pada perintah SQL!");

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

<tr>

<td bgcolor="#FFFFFF" width="25%"><a href="delete.php?&nomor=<?php echo $row['nomor']?>">[Delete]</a>

</tr>

<?php

}

</table>

</body>

</html>

Kode Program - Update.php

<?php

// COMMIT ADD

require("ConnectDb.php");

$link=open_connection();

$tablename="anggota";

$sql = "update $tablename set nomor='$nomor', nama='$nama', email= '$email',alamat='$alamat', kota='$kota' where nomor='$nomor' ";

$result = mysql_query($sql) or die("Invalid query: " . mysql_error());

?> <p align="center" style="color:#FF0000"> Berhasil DiUpdate..! <a href="list4.php">Back to</a>

</p>

Gambar 7 – Proses Update.

Gambar 8 - Tampilupdate.

<?php

require("ConnectDb.php");

$link=open_connection();

$tablename="anggota";

$sql1 = "SELECT * FROM $tablename WHERE nomor = $nomor ";

$result = mysql_query($sql1)

or die(" Test Invalid query: " . mysql_error());

$row = mysql_fetch_array($result);

$nomor= $row['nomor'];

$nama= $row['nama'];

$email = $row['email'];

$alamat = $row['alamat'];

$kota = $row['kota'];

<html>

<head>

<title>Update Anggota</title>

<!--

.style1 {color: #FFFFFF}

-->

</style>

</head>

<body>

<td colspan="2"><div align="center"><span class="style1">UPDATE ANGGOTA </span></div></td>

</tr>

<td width="85">Nomor</td>

</tr>

</tr>

<td>Email</td>

<td><input name="email" type="text" id="email" value="<? echo $email ?> " size="50" maxlength="80" /></td>

</tr>

<td align="left" valign="top">Alamat</td>

</tr>

</tr>

<a href="List4.php">List Anggota

</a>

</div></td>

</tr>

</table>

</form>

</body>

</html>

Sumber : Praktikum Pemrograman WEB, STMIK Mercusuar – 2010 | Download Article.

Many'ax Script

Rabu, 07 Juli 2010

Pemrograman PHP - Membuat Form Anggota

1 komentar:

Lihat-lihat Yuk . . . .

Followers

Blog Archive

Labels

About Me