1：user表：
CREATE
TABLE
`
user
` (
`id`
int
(
11
)
NOT
NULL
AUTO_INCREMENT,
`name`
varchar
(
32
)
NOT
NULL
,
PRIMARY
KEY
(`id`)
) ENGINE
=
MyISAM
DEFAULT
CHARSET
=
utf8
2：mysqltools.php (mysql工具类)
<?
php
class
MySqlTools{
private
$host
='127.0.0.1'
;
private
$uname
='root'
;
private
$pwd
='mysql'
;
private
$dbname
='test'
;
private
$conn
;
function
__construct(){
$this
->conn=
mysql_connect
(
$this
->host,
$this
->uname,
$this
->
pwd)
or
die
('mysql_connect error:'.
mysql_error
());
mysql_select_db
(
$this
->
dbname)
or
die
('mysql_select_db error:'.
mysql_error
());
mysql_query
("set names 'utf8'"
);
}
function
exec_dql(
$sql
){
$result
=
mysql_query
(
$sql
,
$this
->
conn);
$arr
=
array
();
while
(
$row
=
mysql_fetch_assoc
(
$result
)){
$arr
[]=
$row
;
}
mysql_free_result
(
$result
);
return
$arr
;
}
function
exec_dml(
$sql
){
return
mysql_query
(
$sql
,
$this
->
conn);
}
function
free(){
mysql_close
(
$this
->
conn);
}
}
?>
3:index.php (首页)
<html>
<head>
<title>Index</title>
</head>
<body>
<?
php
require_once
'mysqltools.php'
;
$mysql
=
new
MySqlTools();
$sql
='select id,name from user'
;
$users
=
$mysql
->exec_dql(
$sql
);
?>
<table style="width:50%;">
<tr>
<th>ID</th>
<th>Name</th>
<th>Oper</th>
</tr>
<?
php
foreach
(
$users
as
$user
){
?>
<tr align="center">
<td><?php
echo
$user
['id'];?></td>
<td><?php
echo
$user
['name'];?></td>
<td>
<a href="show.php?id=<?php echo
$user
['id'];?>">详情</a>
<a href="delete.php?id=<?php echo
$user
['id'];?>">删除</a>
</td>
</tr>
<?php }?>
</table>
<hr/>
<h2><a href="add.php">Add a
new
user</a></h2>
</body>
</html>
4:add.php （增加新用户）
<html>
<head>
<title>Add</title>
<meta http-equiv="content-type" content="text/html;charset=utf-8"/>
</head>
<body>
<h1>Add</h1><a href="index.php">Index</a><br/>
<?
php
if
(!
empty
(
$_POST
['uname'
])){
$name
=
$_POST
['uname'
];
require_once
'mysqltools.php'
;
$sql
="insert into user(name) values('
$name
')"
;
$mysql
=
new
MySqlTools();
if
(
$mysql
->exec_dml(
$sql
)){
echo
'<h3>Add Success!</h3>'
;
}
else
{
echo
'<h3>Add Error!</h3>'
;
}
}
?>
<form method="post">
Name
:<input type="text" name="uname"/>
<input type="submit" value="Add"/>
</form>
</body>
</html>
5:delete.php (删除操作)
<?
php
$id
=
$_GET
['id'
];
if
(
isset
(
$id
)){
require_once
'mysqltools.php'
;
$mysql
=
new
MySqlTools();
$sql
="delete from user where id=
$id
"
;
$mysql
->exec_dml(
$sql
);
}
header
('Location: index.php'
);
?>
6：show.php (显示详细信息页面)
<?
php
header
('Conent-Type:text/html;charset=utf-8'
);
$id
=
$_GET
['id'
];
$name
=''
;
if
(
isset
(
$id
)){
require_once
'mysqltools.php'
;
$mysql
=
new
MySqlTools();
$sql
="select name from user where id=
$id
limit 1"
;
$arr
=
$mysql
->exec_dql(
$sql
);
$name
=
$arr
[0]['name'
];
}
echo
"ID:
$id
<br/>Name:
$name
<br/>"
;
echo
'<h3><a href="index.php">Index</a></h3>'
;
?>
