Tutorial Cara Membuat Print Preview PHP & Mysql Pada MasterCSS
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.
<body OnLoad="window.print()" OnFocus="window.close()">
<?php
include "../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
}//if
else{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>
Posting Komentar untuk "Tutorial Cara Membuat Print Preview PHP & Mysql Pada MasterCSS"