<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<script language="javascript" type="text/javascript">
function thongbao()
{
return confirm("Bạn Có Muốn Xóa không?");
}
</script>
<?php
include_once "ketnoi.php";
if (isset($_REQUEST["masachxoa"])) {
$masach = $_REQUEST["masachxoa"];
$caulenh = "select masach from ctdondh where masach={$masach}";
if (mysql_num_rows(doc_bang($caulenh)) > 0) {
echo "<script>alert('Sách này đã có , không thể xóa')</script>";
} else {
$caulenh = "delete from sach where masach={$masach}";
doc_bang($caulenh);
echo "<script>alert('Xóa Thành Công')";
echo "<script>location.replace('trangquantri.php?loai=2')</script>";
}
}
$bangsach = doc_bang("select * from sach");
echo "<table border='1' cellpadding='1' cellspacing='1' width='800'><tr><td width='20'>STT</td><td width='150'>Tên Sách</td>\n<td width='80'>Đơn giá </td><td width='100'>Hình</td><td width='300'>Mô Tả</td><td width='100'>Cập Nhật</td></tr>";
$stt = 1;
while ($sach = mysql_fetch_row($bangsach)) {
$mota = $sach[5];
echo "<tr><td>STT</td><td>{$sach['2']}</td><td>{$sach['3']}</td><td><img src='hinh_anh/{$sach['4']}' width='120'/></td><td>{$mota}</td><td><a href='TH_sach.php?masachcapnhat={$sach['0']}&&loai=5'>Sửa</a> <a href='trangquantri.php?masachxoa={$sach['0']}&&loai=2' onclick='return thongbao();'>Xóa</a></td></tr>";
$stt++;
}
echo "<tr><td colspan='3' align='right'><a href='TH_sach.php?loai=5&&themmoisach=1'>Thêm mới </a></td></tr>";
echo "</table>";
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php
if (isset($_POST["thanhphan"])) {
$thanhphan = $_POST["thanhphan"];
$giatu = $_POST["tu"];
$giaden = $_POST["den"];
include_once "ketnoi.php";
$caulenh = "select*from sach where mota like '%{$thanhphan}%'";
if (is_numeric($giatu) == true && is_numeric($giaden) == true) {
$caulenh .= " and {$giatu} <= dongia and dongia <= {$giaden} ";
} elseif (is_numeric($giatu) == true) {
$caulenh .= " and dongia >= {$giatu} ";
} elseif (is_numeric($giaden) == true) {
$caulenh .= " and dongia <= {$giaden} ";
}
$phanloai = doc_bang($caulenh);
$vt = 0;
echo "<table width='800px'>";
while ($sach = mysql_fetch_array($phanloai)) {
if ($vt % 2 == 0) {
echo "<tr>";
}
echo "<td>";
echo "<table width='400px'>";
echo "<tr>";
echo "<td width='200px'>";
echo "<img src='hinh_anh/" . $sach["hinh"] . "' width='200px' height='200px'/>";
echo "</td>";
echo "<td>";
echo "<h1><b>" . $sach["tensach"] . "</h1></b>";
echo "<i>Gia Ban :</i>" . number_format($sach["dongia"]) . " vnd<br>";
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php
include_once "ketnoi.php";
if (isset($_REQUEST["giao"])) {
$sodhgiao = $_REQUEST["giao"];
$caulenh = "update dondh set dagiao=1 where sodh={$sodhgiao}";
doc_bang($caulenh);
echo "<script>alert(' Ban da giao don hang {$sodhgiao}')</script>";
}
if (isset($_REQUEST["xoadonhang"])) {
$sodhxoa = $_REQUEST["xoadonhang"];
$caulenh = "delete * from ctdondh where sodh={$sodhxoa}";
doc_bang($caulenh);
$caulenh = "delete * from dondh where sodh={$sodhxoa}";
echo "<script>alert('Da xoa don dat hang {$sodhxoa}')</script>";
}
$bangdondh = doc_bang("select dondh.*,HoTen from dondh join khachhang on dondh.Makh=khachhang.Makh where dagiao=0");
echo "<table width='100%' border='1' cellpadding='0' cellspacing='0'";
echo "<tr><td width='5%'>STT</td><td width='20%'>Họ Tên</td><td width='15%'>Ngày dh</td><td width='40%'>Địa Chỉ Giao Hàng</td><td>Cập Nhật</td></tr>";
$stt = 0;
echo "<script> alert('" . $donhang['Sohd'] . "') </script>";
while ($donhang = mysql_fetch_array($bangdondh)) {
echo "<tr><td>{$stt}</td><td>" . $donhang['HoTen'] . "</td><td>" . $donhang['Ngaydh'] . "</td><td>" . $donhang['Dia_chi'] . "</td><td><a href='trangquantri.php?loai=3&&giao=" . $donhang['Sodh'] . "'>Giao Hàng</a><a href='trangquantri.php?loai=3&&chitiet=" . $donhang['Sodh'] . "'>Chi Tiết</a><a href ='trangquantri.php?loai=3&&xoadonhang=" . $donhang['Sodh'] . "'>Xóa</td></tr>";
$stt++;
}
echo "</table>";
if (isset($_REQUEST["chitiet"])) {
include_once "chitiettest.php";
}
<?php
include_once "ketnoi.php";
$phanloai = doc_bang("select*from loaisach");
while ($loai = mysql_fetch_array($phanloai)) {
echo "<a href='trang1.php?maloai=" . $loai["Maloai"] . "'>" . $loai["Tenloai"] . "<br>";
}
<?php
include_once "ketnoi.php";
if (isset($_REQUEST["chitiet"])) {
$sodh = $_REQUEST["chitiet"];
echo "<p align='center' style='font-size:24'> Chi Tiết Đơn Hàng {$sodh}</p>";
$caulenh = "select ctdondh.*,tensach from ctdondh join sach on ctdondh.masach=sach.masach where sodh={$sodh} ";
echo "<table width='100%' border='1' cellpadding='0' cellspacing='0'><tr><td width='5%'>STT</td><td width='30%'>Tên Sách</td><td width='10%'>Số Lượng</td><td width='10%'>Đơn Giá</td></tr>";
$bangct = doc_bang($caulenh);
$stt = 1;
$tongtien = 0;
while ($ct = mysql_fetch_array($bangct)) {
$tensach = $ct["tensach"];
$dg = $ct["Dongia"];
$sl = $ct["Soluong"];
$tt = $sl * $dg;
$tongtien += $tt;
echo "<tr><td>{$stt}</td><td>{$tensach}</td><td>{$sl}\n\t\t</td><td>{$dg}</td><td>" . number_format($tt) . "</td></tr>";
}
echo "<tr><td colspan='5' align='right'>Tổng Tiền:" . number_format($tongtien) . " vnd</td></tr></table>";
}
$maloai = $_POST["loai"];
$tensach = $_POST["ten_sach"];
$mota = $_POST["mo_ta"];
$giaban = $_POST["gia_ban"];
$hinh = $_FILES["hinh"]["name"];
if (isset($_SESSION["masachcapnhat"])) {
$masach = $_SESSION["masachcapnhat"];
if ($hinh != "") {
$caulenh = "update sach set tensach='{$tensach}',maloai={$maloai},dongia={$giaban},hinh='{$hinh}',mota='{$mota}' where masach={$masach}";
} else {
$caulenh = "update sach set tensach='{$tensach}',maloai={$maloai},dongia={$giaban},mota='{$mota}' where masach={$masach}";
}
} else {
$caulenh = "insert into sach (maloai,tensach,dongia,hinh,mota) value({$maloai},'{$tensach}','{$giaban}','{$hinh}','{$mota}')";
}
doc_bang($caulenh);
if ($hinh != "") {
move_uploaded_file($_FILES["hinh"]["tmp_name"], "hinh_anh/" . $_FILES["hinh"]["name"]);
}
if (isset($_SESSION["masachcapnhat"])) {
unset($_SESSION["masachcapnhat"]);
}
echo "<script>alert('Đã Thêm Sách Thành Công')</script>";
}
?>
<form action="" method="post" enctype="multipart/form-data" name="form1">
<br>
<table width="70%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#E6F6D9">
<tr bgcolor="#D7F2C5">
<td colspan="2" bgcolor="#006699"><div align="center" class="style4 style1"> THÊM SÁCH MỚI </div></td>
}
</script>
<?php
include_once "ketnoi.php";
if (isset($_REQUEST["xoadonhang"])) {
$sodhxoa = $_REQUEST["xoadonhang"];
$caulenh = "delete from ctdondh where sodh={$sodhxoa}";
doc_bang($caulenh);
$caulenh = "delete from dondh where sodh={$sodhxoa}";
doc_bang($caulenh);
echo "<script>alert('Đã Xóa Đơn Hàng {$sodhxoa}')</script>";
}
echo "<script>windows.location = 'trang1.php'</script>";
if (isset($_REQUEST["makhdonhang"])) {
$makh = $_REQUEST["makhdonhang"];
$bangdonhang = doc_bang("select dondh.*,HoTen from dondh join khachhang on dondh.Makh=khachhang.Makh where khachhang.makh={$makh}");
echo "<table width='100%' border='1' cellpadding='0' cellspacing='0'";
echo "<tr><td width='10%'>STT</td><td width='20%'>Họ Tên</td><td width='20%'>Ngày ĐH</td><td width='30'>Địa Chỉ Giao Hàng</td><td>Trạng Thái</td></tr>";
$stt = 1;
while ($donhang = mysql_fetch_array($bangdonhang)) {
echo "<tr><td>{$stt}</td><td>" . $donhang['HoTen'] . "</td><td>" . $donhang['Ngaydh'] . "</td><td>" . $donhang['Dia_chi'] . "</td>";
if ($donhang["dagiao"] == 1) {
echo "<td>Đã Giao <a href='trangdathang.php?chitiet=" . $donhang['Sodh'] . "&&makhdonhang={$makh}'>Chi Tiết</a>";
} else {
echo "<td><a href='trangdathang.php?chitiet=" . $donhang['Sodh'] . "&&makhdonhang={$makh}'>Chi Tiết</a><a href ='trangdathang.php?xoadonhang=" . $donhang['Sodh'] . "' onClick='return ThongBao();'>Xóa</td></tr>";
}
$stt++;
}
echo "</table>";
}
if (isset($_REQUEST["chitiet"])) {
function thongbao()
{
return confirm("Bạn Có Muốn Xóa không?");
}
</script>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php
include_once "ketnoi.php";
if (isset($_REQUEST["maloaixoa"])) {
$maloai = $_REQUEST["maloaixoa"];
$bang = "select count(*) as sosach from sach where maloai={$maloai}";
$bangsach = doc_bang($bang);
$sach = mysql_fetch_array($bangsach);
if ($sach["sosach"] > 0) {
echo "<script> alert ('Loại Sách đã có sẵn không thể xóa')</script>";
} else {
$bang = "delete from loaisach where maloai={$maloai}";
doc_bang($bang);
echo "<script> alert ('Bạn đã xóa thành công')</script>";
}
}
$bangloaisach = doc_bang("select * from loaisach");
$stt = 1;
echo "<table border='1' cellpadding='0' cellspacing='0' width='100%'>";
echo "<tr><td width='10'>STT </td><td width='70%'>Tên loại </td><td>Cập Nhật</td></tr>";
while ($loaisach = mysql_fetch_array($bangloaisach)) {
echo "<tr><td> {$stt}</td><td>" . $loaisach["Tenloai"] . "</td><td><a href='trangquantri.php?maloaixoa=" . $loaisach["Maloai"] . "&&loai=1' onclick='return thongbao();'>Xóa <a href='trangquantri.php?maloaisua=" . $loaisach["Maloai"] . "&&loai=4'>Sửa</a></td></tr>";
$stt++;
}
echo "<tr><td colspan='3' align='right'><a href='trangquantri.php?loai=4&&themmoiloaisach=1'>Thêm mới </a></td></tr>";
echo "</table>";
<?php
if (isset($_POST["ten_dn"])) {
$tendn = $_POST["ten_dn"];
$matkhau = $_POST["mat_khau"];
$caulenh = "select *from khachhang where tendn = '{$tendn}' and matkhau = '{$matkhau}'";
include_once "ketnoi.php";
$bangkh = doc_bang($caulenh);
if (mysql_num_rows($bangkh) > 0) {
$kh = mysql_fetch_array($bangkh);
$_SESSION["makh"] = $kh["Makh"];
$_SESSION["tenkh"] = $kh["HoTen"];
$_SESSION["email"] = $kh["Email"];
$_SESSION["quyen"] = $kh["quyen"];
if (isset($_POST["chkluu"])) {
setcookie("makh", $kh["Makh"], time() + 7 * 24 * 60 * 60);
setcookie("tenkh", $kh["HoTen"], time() + 7 * 24 * 60 * 60);
setcookie("email", $kh["Email"], time() + 7 * 24 * 60 * 60);
setcookie("quyen", $kh["quyen"], time() + 7 * 24 * 60 * 60);
}
echo "<script> window.open(location.reload(true)) </script>";
} else {
echo "<script>alert('thông tin đăng nhập sai');</script>";
}
}
?>
<style type="text/css">
<!--
.style1 {color: #000000}
-->
</style>
if (isset($_SESSION["maloaisua"])) {
$maloaisua = $_SESSION["maloaisua"];
$caulenh = "update loaisach set Tenloai='{$tenloai}' where maloai={$maloaisua}";
} else {
$caulenh = "insert into loaisach(Tenloai) value ('{$tenloai}')";
}
doc_bang($caulenh);
if (isset($_SESSION["maloaisua"])) {
unset($_SESSION["maloaisua"]);
}
echo "<script>window.location='trangquantri.php?loai=1'</script>";
}
}
if (isset($_REQUEST["maloaisua"])) {
$maloaisua = $_REQUEST["maloaisua"];
$phanloai = doc_bang("select * from loaisach where Maloai={$maloaisua}");
$loai = mysql_fetch_array($phanloai);
$tenloai = $loai["Tenloai"];
$_SESSION["maloaisua"] = $maloaisua;
}
?>
<form name="form1" method="post" action="">
<table width="355" border="1">
<tr>
<td colspan="2" align="center"><?php
if (isset($_REQUEST["maloai"])) {
echo "Cập nhật Loại Sách";
} else {
echo "Thêm Mới Loại Sách";
}
?>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php
include_once "ketnoi.php";
$maloai = 1;
if (isset($_REQUEST["maloai"])) {
$maloai = $_REQUEST["maloai"];
}
$phanloai = doc_bang("select * from sach where maloai = {$maloai}");
echo "<table width='700px'>";
$vt = 0;
while ($loaisach = mysql_fetch_array($phanloai)) {
if ($vt % 3 == 0) {
echo "<tr>";
}
echo "<td width='300px'> <a href='trangchitiet.php?masach=" . $loaisach["masach"] . "' ><img src='hinh_anh/" . $loaisach["hinh"] . "'width='150px' heigh='150px'/></a><br>";
echo $loaisach["tensach"] . "<a href = 'xl_giohang.php?masach=" . $loaisach["masach"] . "&&maloai=" . $loaisach["maloai"] . "&&tensach=" . $loaisach["tensach"] . "&&dongia=" . $loaisach["dongia"] . "'><br><img src='hinh_anh/gio_hang.jpg'/></a><br>";
echo "<i> Đơn Giá </i>" . number_format($loaisach["dongia"]) . "VND </td>";
$vt++;
if ($vt % 3 == 0) {
echo "</tr>";
}
}
echo "</table>";
