Bài viết này sẽ hướng dẫn cách tải dữ liệu từ datbase vào thẻ(list) của HTML thông qua một ví dụ đơn giản.
Trước tiên ta cần lên danh sách các công việc cần thực hiện:
- Tạo bảng group_catalogue
- Tạo trang Config.php
- Tạo trang LoadDataToList.php
Đầu tiên ta sẽ bảng group_catalogue trên database như sau:
create table group_catalogue
(
id int not null auto_increment,
name varchar(100) not null,
taborder int,
status boolean not null,
primary key(id)
) ENGINE = INNODB;
insert into group_catalogue(name,taborder,status) values('product',1,true);
(
id int not null auto_increment,
name varchar(100) not null,
taborder int,
status boolean not null,
primary key(id)
) ENGINE = INNODB;
insert into group_catalogue(name,taborder,status) values('product',1,true);
Tạo trang Config.php
<?php
// Replace the variable values below with your specific database information.
$host = "host";
$user = "user";
$pass = "pass";
$db = "database";
// This part sets up the connection to the database (so you don't need to reopen the connection again on the same page).
$ms = mysql_pconnect($host, $user, $pass);
if ( !$ms )
{
echo "Error connecting to database.\n";
}
// Then you need to make sure the database you want is selected.
mysql_select_db($db);
?>
// Replace the variable values below with your specific database information.
$host = "host";
$user = "user";
$pass = "pass";
$db = "database";
// This part sets up the connection to the database (so you don't need to reopen the connection again on the same page).
$ms = mysql_pconnect($host, $user, $pass);
if ( !$ms )
{
echo "Error connecting to database.\n";
}
// Then you need to make sure the database you want is selected.
mysql_select_db($db);
?>
Tạo trang LoadDataToList.php
<?php
include("Config.php");
if($_SERVER['REQUEST_METHOD'] == 'POST') {
$groupname = addslashes($_POST['tf_groupname']);
$grouptaborder = addslashes($_POST['tf_grouptaborder']);
$groupstatus = addslashes($_POST['lb_groupstatus']);
//echo $groupname . "," . $grouptaborder . "," . $groupstatus;
$sql = "INSERT INTO group_catalogue(name, taborder, status) VALUES ('$groupname', '$grouptaborder', '$groupstatus')";
if(!mysql_query($sql)) {
die('Error: ' . mysql_error());
} else {
header("location: Add_Catalogue.php");
}
}
?>
<!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>
<form action="Add_Catalogue.php" method="post" enctype="multipart/form-data" name="action">
<select name="list_catalogue" size="10" style="width:170px" >
<?php
$sql = "SELECT * FROM group_catalogue";
$resault = mysql_query($sql);
while($row = mysql_fetch_array($resault)) {
echo "<OPTION value=" . $row[id] . "><column>" . $row[taborder] . " | </column><column>" . $row[status] . " | </column><column>" . $row[name] . "</col></OPTION>";
}
?>
</select>
</form>
</body>
</html>
include("Config.php");
if($_SERVER['REQUEST_METHOD'] == 'POST') {
$groupname = addslashes($_POST['tf_groupname']);
$grouptaborder = addslashes($_POST['tf_grouptaborder']);
$groupstatus = addslashes($_POST['lb_groupstatus']);
//echo $groupname . "," . $grouptaborder . "," . $groupstatus;
$sql = "INSERT INTO group_catalogue(name, taborder, status) VALUES ('$groupname', '$grouptaborder', '$groupstatus')";
if(!mysql_query($sql)) {
die('Error: ' . mysql_error());
} else {
header("location: Add_Catalogue.php");
}
}
?>
<!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>
<form action="Add_Catalogue.php" method="post" enctype="multipart/form-data" name="action">
<select name="list_catalogue" size="10" style="width:170px" >
<?php
$sql = "SELECT * FROM group_catalogue";
$resault = mysql_query($sql);
while($row = mysql_fetch_array($resault)) {
echo "<OPTION value=" . $row[id] . "><column>" . $row[taborder] . " | </column><column>" . $row[status] . " | </column><column>" . $row[name] . "</col></OPTION>";
}
?>
</select>
</form>
</body>
</html>
Bạn có thể download toàn bộ ví dụ ở liên kết bên dưới.
No comments:
Post a Comment