Eclipse
11-10-2008, 02:55 PM
Siapkan dulu tabel di MySQL untuk misi ini. Misalnya kita punya tabel pelanggan seperti berikut ini..
CREATE TABLE pelanggan (
id varchar(10),
nama varchar(20)
)
Terus isi data ke dalam tabel tersebut seperti berikut ini.
INSERT INTO pelanggan VALUES ('1', 'sony');
INSERT INTO pelanggan VALUES ('2', 'agus');
INSERT INTO pelanggan VALUES ('3', 'udin');
INSERT INTO pelanggan VALUES ('4', 'dita');
INSERT INTO pelanggan VALUES ('5', 'dyah');
INSERT INTO pelanggan VALUES ('6', 'doni');
INSERT INTO pelanggan VALUES ('7', 'dedi');
INSERT INTO pelanggan VALUES ('8', 'budi');
INSERT INTO pelanggan VALUES ('9', 'dina');
INSERT INTO pelanggan VALUES ('10', 'abdi');
INSERT INTO pelanggan VALUES ('11', 'lina');
INSERT INTO pelanggan VALUES ('12', 'luki');
INSERT INTO pelanggan VALUES ('13', 'tata');
INSERT INTO pelanggan VALUES ('14', 'dion');
Setelah itu buat script sbb :
<?php
$server = "localhost";
$username = "user_kamu";
$password = "pass_kamu";
$db_name = "database_name_kamu";
$db = mysql_connect($server,$username,$password) or DIE("Connection to database failed, perhaps the service is down !!");
mysql_select_db($db_name) or DIE("Database name not available !!");
?>
<html>
<head></head>
<body>
<form method="post" action="#?">
<select name="pelanggan">
<?php
$pelanggan = mysql_query("select * from pelanggan order by nama", $db);
for ($i = 0; $i < mysql_num_rows($pelanggan); $i++) {
$id = mysql_result($pelanggan, $i, "id");
$nama = mysql_result($pelanggan, $i, "nama");
?>
<option value="<?php echo $id;?>"><?php echo $nama;?></option>
<?php
}
?>
</select>
</form>
</body>
</html>
CREATE TABLE pelanggan (
id varchar(10),
nama varchar(20)
)
Terus isi data ke dalam tabel tersebut seperti berikut ini.
INSERT INTO pelanggan VALUES ('1', 'sony');
INSERT INTO pelanggan VALUES ('2', 'agus');
INSERT INTO pelanggan VALUES ('3', 'udin');
INSERT INTO pelanggan VALUES ('4', 'dita');
INSERT INTO pelanggan VALUES ('5', 'dyah');
INSERT INTO pelanggan VALUES ('6', 'doni');
INSERT INTO pelanggan VALUES ('7', 'dedi');
INSERT INTO pelanggan VALUES ('8', 'budi');
INSERT INTO pelanggan VALUES ('9', 'dina');
INSERT INTO pelanggan VALUES ('10', 'abdi');
INSERT INTO pelanggan VALUES ('11', 'lina');
INSERT INTO pelanggan VALUES ('12', 'luki');
INSERT INTO pelanggan VALUES ('13', 'tata');
INSERT INTO pelanggan VALUES ('14', 'dion');
Setelah itu buat script sbb :
<?php
$server = "localhost";
$username = "user_kamu";
$password = "pass_kamu";
$db_name = "database_name_kamu";
$db = mysql_connect($server,$username,$password) or DIE("Connection to database failed, perhaps the service is down !!");
mysql_select_db($db_name) or DIE("Database name not available !!");
?>
<html>
<head></head>
<body>
<form method="post" action="#?">
<select name="pelanggan">
<?php
$pelanggan = mysql_query("select * from pelanggan order by nama", $db);
for ($i = 0; $i < mysql_num_rows($pelanggan); $i++) {
$id = mysql_result($pelanggan, $i, "id");
$nama = mysql_result($pelanggan, $i, "nama");
?>
<option value="<?php echo $id;?>"><?php echo $nama;?></option>
<?php
}
?>
</select>
</form>
</body>
</html>