Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- ini_set('display_errors',0);
- //=============koneksi====================
- $host = "localhost";
- $user = "root";
- $password = "";
- $dbname = "dbwholesale";
- $con = mysql_connect($host, $user, $password);
- if (!$con) {
- die('Could not connect: ' . mysql_error());
- }
- mysql_select_db($dbname);
- //===========query list nama dan bulan==================
- $q = mysql_query("SELECT id_tour, nama_tour FROM tour WHERE negara='Africa' ORDER BY id_tour ", $con);
- while ($rows = mysql_fetch_array($q)) {
- $nama_list[] = $rows;
- }
- //======================KALAU UDAH ADA QUERY PENCARIAN==============
- if ($_GET['id_tour']) {
- $nama = mysql_real_escape_string($_GET['id_tour']);
- $q = mysql_query("SELECT * FROM tour where id_tour='$nama' ORDER BY id_tour", $con);
- while ($rows = mysql_fetch_array($q)) {
- $data_list[] = $rows;
- }
- }
- ?>
- <html>
- <head><title>Tambah Departure </title>
- </head>
- <body background="images/backadmin7.png">
- <center><h4>Tambah Departure</h4></center>
- <table align="center" border = "5" bgcolor='#F0E68C'>
- <form action="produk2.php" enctype="multipart/form-data" method="POST">
- <center>Pilih Nama Tour: <select name="id_tour">
- <?php foreach ($nama_list as $value) { ?>
- <option value="<?php echo $value['id_tour'] ?>"<?php if ($_GET['id_tour'] == $value['id_tour']) echo " selected" ?>>
- <?php
- echo $value['nama_tour'];
- ?></option>
- <?php } ?>
- </select>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement