111111111111111111111111111111111111111111111111
job.php
<?php
$conn = @mysql_connect('localhost','root','qingyun') or die('数据库连接失败!');
mysql_select_db('job1705',$conn);
$sql = 'select * from job';
$result = mysql_query($sql,$conn);
// $row = mysql_fetch_assoc($result);
$data = [];
while ( $row = mysql_fetch_assoc($result)) {
$data[] = $row;
}
?>
2222222222222222222222222222222222222222222222222222
job1.php
<?php
require('job.php');
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>工作</title>
</head>
<body>
<div style="margin-top:20px;margin-left:50px;">
<a href="add.html" style="cursor:pointer;">添加数据</a><br><br>
<form action="find.php">
<input type="text" style="height:20px;">
<input type="submit" value="查找">
</form>
<br>
<table style="border: solid 1px;">
<thead>
<tr style="height:40px;">
<th style="width:100px">id</th>
<th style="width:200px">姓名</th>
<th style="width:300px">应聘公司</th>
<th style="width:200px">公司所在城市</th>
<th style="width:200px">操作</th>
</tr>
</thead>
<tbody>
<?php foreach ($data as $key => $v) { ?>
<tr align="center" style="height:40px;">
<td><?php printf($v["id"])?></td>
<td><?php printf($v["name"])?></td>
<td><?php printf($v["company"])?></td>
<td><?php printf($v["city"])?></td>
<td style="cursor:pointer;">
<a href="" οnclick="del(<?php printf($v["id"])?>)">
删除
</a>
</td>
</tr>
<?php } ?>
<tr style="height:10px;"></tr>
</tbody>
</table>
</div>
</body>
</html>
<script src="http://apps.bdimg.com/libs/jquery/2.1.1/jquery.js"></script>
<script>
function del(id){
$.ajax({
url:"del.php",
type:"post",
dataType:'json',
data:{'id':id},
});
}
</script>
33333333333333333333333333333333333333333333333333333333333333333333
del.php
<?php
$conn = @mysql_connect('localhost','root','qingyun');
mysql_select_db('job1705',$conn);
$sql = 'delete from job where id =' . $_POST['id'];
mysql_query($sql);
?>
44444444444444444444444444444444444444444444444444444444444444444444444444
add.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Document</title>
</head>
<body>
<a href="job1.php">返回主页</a>
<br><br>
<form action="add1.php" method="post">
姓 名
<input type="text" name="a" style="width:200px;height:40px;font-size:20px;"><br><br>
公司名称
<input type="text" name="b" style="width:200px;height:40px;font-size:20px;"><br><br>
所在城市
<input type="text" name="c" style="width:200px;height:40px;font-size:20px;"><br><br>
<input type="submit">
</form>
</body>
</html>
5555555555555555555555555555555555555555555555555555555555555555555555555
add1.php
<?php
$add1 = @mysql_connect('localhost','root','qingyun');
mysql_select_db('job1705',$add1);
$add2 = "insert into job(name,company,city) values('$_POST[a]','$_POST[b]','$_POST[c]')";
$add3 = mysql_query($add2);
if($add3){
echo '添加数据成功';
}else{
echo '添加数据失败';
}
mysql_close($add1);
?>