Code quản trị CSDL bằng PHP

Tiêu đề: Code quản trị CSDL bằng PHP Sun Oct 17, 2010 7:19 pm

Đây là trang chủ quản trị CSDL (rất đơn giản)

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>Manage 1</title>
</head>

<body>
<center><h1>Quản lý</h1></center>
<pre>
<ul><li type="circle"><a href="loaisp.php">Quản lý loại sản phẩm</a></li>
<li type="circle"><a href="sanpham.php">Quản lý sản phẩm</a></li>
</ul>
</pre>
</body>
</html>

Những trang còn lại sẽ phức tạp hơn nhiều !!

Trang loaisp.php

Code:: <html>
<head>
<title>Loai sp</title>
</head>
<body>

<?php
include("dbconnect.php");
$manages=@mysql_query('select maloai,tenloai from loaisp');
if(!$manages){
exit('<p>Error retrieving manage from database!<br>'.'Error:'.mysql_error().'</p>');
}
while($manage=mysql_fetch_array($manages)){
$id=$manage['maloai'];
$name=htmlspecialchars($manage['tenloai']);
echo"<li>$name " .
"<a href='edit.php?id=$id'>edit</a> <a href='delete.php?id=$id'>delete</a></li>";
}
?>
<p><a href="new_ID.php">Them loai san pham moi</a></p>
<p><a href="manage_sp.html">Quay ve trang chu</a></p>
</body>
</html>

Trang xoá các thuộc tính trong CSDL

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>Untitled Document</title>
</head>

<body>
<?php
include("dbconnect.php");
$id=$_GET['id'];
$ok2=@mysql_query("delete from loaisp where maloai='$id'");
$ok3=@mysql_query("delete from sanpham where maloai='$id'");
if($ok2 and $ok3){
echo'<p>Du lieu da xoa thanh cong</p>';
}
else{
echo'<p> Xay ra loi !<br>'.'error:'.mysql_error().'</p>';
}
?>
<p><a href="loaisp.php">Quay ve danh sach loai san pham</a></p>
</body>
</html>

Trang cập nhật CSDL

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>Quan ly san pham</title>
</head>

<body>

<form action="capnhat.php" method="post">
<p>Nhap ten loai san pham moi</p>
<table>
<tr>
<td>Ma loai:</td>
<td><input type="text" name="maloai" /></td>
</tr>
<tr>
<td>Ten loai:</td>
<td><input type="text" name="tenloai" /></td>
</tr>
</table>
<input type="submit" value="Dong y" />
</form>
<p><a href="loaisp.php">Quay ve danh sach loai san pham</a></p>

</body>
</html>

Trang capnhat.php

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>Untitled Document</title>
</head>

<body>
<?php
include("dbconnect.php");
$code=$_POST['maloai'];
$name=$_POST['tenloai'];
$sql="insert into loaisp value ('$code','$name')";
if(@mysql_query($sql)){
echo '<p>Du lieu duoc nhap thanh cong</p>';
}
else{
echo '<p>Xay ra loi</p>';
}
?>
<p><a href="new_ID.php">Them loai san pham moi</a></p>
<p><a href="loaisp.php">Quay ve danh sach loai san pham</a></p>

</body>
</html>

Trang edit thuộc tính trong CSDL

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>Chinh sua du lieu</title>
</head>
<body>
<?php
include("dbconnect.php");
$code=$_POST['maloai'];
$name=$_POST['tenloai'];
$id=$_POST['id'];
$sql="UPDATE loaisp SET
maloai='$code',
tenloai='$name'
WHERE maloai='$id'";
if(@mysql_query($sql)){
echo'<p>Du lieu cap nhat thanh cong</p>';
}
else{
echo'<p>Xay ra loi</p>';
}
?>
<p><a href="loaisp.php">Quay ve danh sach</a></p>
<?php
$id=$_GET['id'];
$sql1=@mysql_query("SELECT maloai,tenloai FROM loaisp WHERE maloai='$id'");
if(!$sql1){
exit('<p>Co so du lieu bi loi</p>');
}
$sql2=mysql_fetch_array($sql1);

$code1=$sql2['maloai'];
$name1=$sql2['tenloai'];
$code1=htmlspecialchars($code1);
$name1=htmlspecialchars($name1);
?>
<form action="<?php echo $_SERVER['PHP_SELF'];?>" method="post">
<p>Edit loai san pham</p>
<table>
<tr>
<td>Ma loai:</td><td><input type="text" name="maloai" value="<?php echo $code1;?>" /></td>
</tr>
<tr>
<td>Ten loai:</td><td><input type="text" name="tenloai" value="<?php echo $name1;?>" /></td>
</tr>
</table>
<input type="hidden" name="id" value="<?php echo $id;?>" />
<input type="submit" value="Dong y" />
</form>

</body>
</html>

Còn trang kết nối với CSDL thì mình đã share cho các bạn rồi

Chúc các bạn thành công !!

Tiêu đề: Re: Code quản trị CSDL bằng PHP Tue Oct 19, 2010 8:17 am


	Mình vừa upload lên host xong, các bạn vào demo thử http://cutuan_demo.byethost7.com/manage_sp.html