list_new.php

<?php session_start(); ?>
<?php
$title = "Sách bán chạy"; 
require_once("./includes/connect.php");
include("./includes/function.php");
include("./includes/header.php");
include("./includes/sidebar-a.php");
?>

<div class="noidung">

	<!-- SACH MOI PHAT HANH -->
	<?php 
		// Phân trang
		$tableName=" sach ORDER BY sach_id DESC ";// Ten Table		
		$targetpage = "list_new.php"; // Ten trang dang dc dung phan trang
		$limit = 20;// So hang hien thi cua du lieu
		include("includes/phantrang1.php");
		?>
		<div class="sach_sap_phat_hanh" style="margin-top: 10px;background: url(./style/images/bg-listsp.png) no-repeat;width:740px;">
			<div class="header_sach_sap_phat_hanh">

				<li class="title_sach_sap_phat_hanh">
					<h2>
						<a href="" title="">Sản phẩm mới</a>
						<img src="style/images/new.gif">
					</h2>
				</li><!-- end title_sach_sap_phat_hanh -->
			</div><!-- end header_sach_sap_phat_hanh -->
			<div style="clear:both"></div>
			<div class="sach_sap_phat_hanh_body">
				<?php 
	//$s = "SELECT * FROM sach WHERE dmuc_id='$page'";
	//$q = mysql_query($s) or die("Không thể hiện thị sách");
				if (mysql_num_rows($result) > 0) {
					while ($r = mysql_fetch_assoc($result)) {
			//---- Tinh so tien ban ---//
						$a   = $r['dongia'];
						$b   = $r['giamgia'] * 0.01;
						$c   = $a * $b;
						$ban = $a - $c;
			//Hien thi san pham
						
						echo "<div class='product'>
						<div class='product_images'>
						<a href='#' title=''><img src='./style/images/img_sach/$r[hinhanh]'></a>
						</div> <!-- end product_images -->

						<div class='product_tieu_de'>
						<a href='#'>$r[sach_name]</a>
						</div> <!-- end product_tieu_de -->

						<div class='product_thong_tin'>
						<li>Tác giả: $r[tacgia]</li>
						<li>Giá bìa: <span class='gia_bia_index'>".number_format($r['dongia'],"0",",",".")."đ</span></li>
						<li>Giá bán: <span class='gia_bia_ban'>".number_format($ban,"0",",",".")."đ</span></li>
						<li>Giảm giá: <span class='tr_gia_giam'>$r[giamgia]%</span></li>
						</div> <!-- end product_thong_tin -->
						
						<div class='product_chitiet'>
						<a href='chitiet.php?ct=$r[sach_id]'><img src='./style/images/chi_tiet.png'></a>
						</div> <!-- end product_chitiet -->

						</div> <!-- end product -->";


		}// end while
	} else {
		echo "<p class='error'>Không có sản phẩm</p>";
	}// end IF NUM_ROWS
	
	?>
</div> <!-- end sach_sap_phat_hanh_body -->

<div class="sach_sap_phat_hanh_footer"></div>

</div> <!-- end sach_sap_phat_hanh -->
<!-- END SACH MOI PHAT HANH -->


<?php include("includes/phantrang2.php"); ?>
</div><!-- end noidung -->
<?php 
include("./includes/footer.php");
?>