Web & DatabaseTutorial
Cara Membuat Print Preview PHP & MySQL
Oleh Afa HernandesDiperbarui 2 menit baca
Kali ini saya akan membagikan sebuah tutorial bagaimana caranya membuat print preview menggunakan php. berikut ini adalah contoh source code nya. silahkan dicoba dan dikembangkan dan semoga ilmunya bisa bermanfaat.
<style type="text/css">body {width: 100%;} </style><body OnLoad="window.print()" OnFocus="window.close()"><?phpinclude "../konmysqli.php";echo"<link href='../ypathcss/$css' rel='stylesheet' type='text/css' />";$YPATH="../ypathfile";
$pk="";$field="status";$TB="$tbadmin";$item="Admin";
$sql="select * from `$TB` order by `$field` asc";if(isset($_GET["pk"])){$pk=$_GET["pk"];$sql="select * from `$TB` where `$field` ='$pk' order by `$field` asc";}?>
<h3><center>Laporan Data <?php echo $item;?> <?php echo ($pk);?></h3>
<table width="98%" border="0"><tr><th width="3%">No</td><th width="5%">IDAdmin</td><th width="46%">Nama Admin</td><th width="15%">Telepon</td><th width="18%">Email</td><th width="12%">Keterangan</td></tr><?php
$jum=getJum($conn,$sql);$no=0;if($jum > 0){$arr=getData($conn,$sql);foreach($arr as $d) {$no++;$id_admin=$d["id_admin"];$nama_admin=strtoupper($d["nama_admin"]);$email=$d["email"];$telepon=$d["telepon"];$username=$d["username"];$password=$d["password"];$status=$d["status"];$keterangan=$d["keterangan"];$color="#dddddd";if($no %2==0){$color="#eeeeee";}echo"<tr bgcolor='$color'><td>$no</td><td>$id_admin</td><td><b>$nama_admin</b><td>$telepon</td><td>$email</td><td>$keterangan</td></tr>";
}//while}//ifelse{echo"<tr><td colspan='7'><blink>Maaf, Data $item Belum Tersedia...</blink></td></tr>";}/*+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*/
function getJum($conn,$sql){$rs=$conn->query($sql);$jum= $rs->num_rows;$rs->free();return $jum;}
function getData($conn,$sql){$rs=$conn->query($sql);$rs->data_seek(0);$arr = $rs->fetch_all(MYSQLI_ASSOC);
$rs->free();return $arr;}
?>
</table>