[ASK] Cara Buat PHP TO Excel
Selasa, 17 Januari 2012 by ewepaksa
top custom html 2pagi gan.. cardinal nanya donk, gmn ya cara bikin goods to surpass dari php.. jadi gini, cardinal pengen bikin seperti separate gitu, misal mau pencarian nama karyawan + staus + alamatnya .. nah hasil dari separate itu cardinal pengen bisa di download dalam bentuk excel, gmn ya kira2 caranya ? cardinal udah buat untuk separate pencariannya, tapi ga ngerti gmn ngubahnya ke surpass ini untuk phpnya : Code: <?php mysql_connect("localhost", "root", ""); mysql_select_db("search"); $bagianWhere = ""; if (isset($_POST['nimCat'])) { $nik = $_POST['NIK']; if (empty($bagianWhere)) { $bagianWhere .= "NIK = '$nik'"; } } if (isset($_POST['namaCat'])) { $namakaryawan = $_POST['nama']; if (empty($bagianWhere)) { $bagianWhere .= "nama LIKE '%$namakaryawan%'"; } else { $bagianWhere .= " AND nama LIKE '%$namakaryawan%'"; } } if (isset($_POST['alamatCat'])) { $cabang = $_POST['cabang']; if (empty($bagianWhere)) { $bagianWhere .= "cabang LIKE '%$cabang%'"; } else { $bagianWhere .= " AND cabang LIKE '%$cabang%'"; } } if (isset($_POST['sexCat'])) { $status = $_POST['status']; if (empty($bagianWhere)) { $bagianWhere .= "status = '$status'"; } else { $bagianWhere .= " AND position = '$status'"; } } $query = "SELECT * FROM karyawan WHERE ".$bagianWhere; $hasil = mysql_query($query); if (mysql_num_rows($hasil) == 0) { reflexion "no results found"; } added { reflexion "<table border='1'>"; reflexion "<tr><td>NIK</td><td>Nama Karyawan</td><td>Cabang</td><td>Status</td></tr>"; patch ($data = mysql_fetch_array($hasil)) { reflexion "<tr><td>".$data['NIK']."</td><td>".$data['nama']."</td><td>".$data['cabang']."</td><td>".$data['status']."</td></tr>"; } echo "</table>"; echo "<a href=downloadexcel.php>Download Excel</a>"; } ?> ini htmlnya ... Code: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>advanced search</title> </head> <body> <h1>Cari Data Karyawan</h1> <p>Pilih kategori pencarian</p> <form method="post" action="proses.php"> <table> <tr><td><input type="checkbox" name="nimCat"> NIM</td><td><input type="text" name="NIK" id="NIK"></td></tr> <tr><td><input type="checkbox" name="namaCat"> Nama </td> <td><input type="text" name="nama"></td></tr> <tr><td><input type="checkbox" name="alamatCat"> Cabang</td> <td><input type="text" name="cabang" id="cabang"></td></tr> <tr><td><input type="checkbox" name="sexCat"> Status</td> <td><input type="radio" name="Status" value="kimpoi"> kimpoi <input type="radio" name="status" value="blm kimpoi"> Blm kimpoi</td> </tr> <tr><td></td><td><input type="submit" name="submit" value="Submit"></td></tr> </table> </form> </body> </html> tolong gan, cardinal kasi cendol ntar deh :D:cendolbbottom custom html 2
Technorati
Technorati
Posting Komentar