20180831 租房子（管理员） 增加 删除 修改 发布

数据库（一个后台验证密码的表   另一个跟租房子（用户）的那个一样 ）      文件路径

                     

 

 

 

login.html   代码

 

 

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>无标题文档</title>
</head>
<body>
<fieldset>
<form action="chuli/login.php" method="post">
    <legend>登录页面</legend>
    用户名: <input type="text" name="uid"><br>
    密码： <input type="text" name="pwd"><br>
    <button>登录</button>
</form>
</fieldset>
</body>
</html>

　　

 

login.PHP

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
<?php
session_start();//开启session
/*连接数据库*/
$db = new MySQLi("localhost","root","","z_0705");
!mysqli_connect_error() or die("数据库连接错误");
$db->query("set names utf8");
 
/*接收前端传过来的数据*/
$uid = $_POST['uid'];
$pwd = $_POST['pwd'];
 
/*查询用户表*/
$sql = "select * from zfz_user";
$res = $db->query($sql);
$arr = $res->fetch_all();//结果集返回数组
//var_dump($arr);
//die;
/*比对返回结果*/
$name = "";//
foreach($arr as $v){
    if($uid == $v[0] && $pwd == $v[1]){
        $name = $v[2];//如果密码和名字都对了就输出登陆者的名字
        break;
    }
}
//比对结果正确跳转首页
if($name == "张三" ){
    $_SESSION["uid"] = $uid;//获取uid
    $_SESSION["uname"] = $name;//获取登录者的名字
    header("location:../html/shouye.html");//成功跳转到管理员首页
}else{
    header("location:../yh.html");//成功跳转到用户首页
}

　　

 

shouye.html

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>无标题文档</title>
<script type="text/javascript" src="../../jquery-3.2.1.min.js"></script>
<script type="text/javascript" src="../js/shouye.js"></script>
</head>
 
<body>
欢迎你：<span id="uid">加载中...</span><br>
<a href="tianjia.html">添加信息</a>
<a href="../login.html">退出系统</a>
<table id="tab" width="100%" border="1"></table>
</body>
</html>

　　

 

shouye.js

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
// JavaScript Document
/*页面加载完成*/
$(function(){
    /*调用ajax方法*/
    ajaxFun();
})
 
/*页面加载完成就调用这个方法上后台取数据*/
function ajaxFun(){
    $.ajax({
        url:"../chuli/shouye.php",//请求路径
        success:function(data){//执行成功回调
            var attr = data.split("~");
            $('#uid').html(attr[1]);
            strToArr(attr[0]);//回调方法
        }
    });
}
/*将字符串转换为数组*/
function strToArr(str){
    var arr = str.split('^'),
        brr = [];
    for(var i=0;i<arr.length;i++){
        brr.push(arr[i].split(","));
    }
    addHtml(brr);
}
 
/*组织html代码*/
function addHtml(arr){
    var str = `<tr>
                <th>关键字</th>
                <th>区域</th>
                <th>使用面积</th>
                <th>租金</th>
                <th>租赁类型</th>
                <th>房屋类型</th>
                <th>操作</th>
            </tr>`;
    for(var i in arr){
        str += `<tr>
                <td>`+arr[i][1]+`</td>
                <td>`+arr[i][2]+`</td>
                <td>`+arr[i][3]+`</td>
                <td>`+arr[i][4]+`</td>
                <td>`+arr[i][5]+`</td>
                <td>`+arr[i][6]+`</td>
                <td><button onClick="show(this)" data="`+arr[i][0]+`">删除</button>
                  <button onClick="updateFun(this)" data="`+arr[i][0]+`">修改</button></td>
            </tr>`;
    }
    $('#tab').html(str);
}
 
//删除的方法
function show(obj){
    var id = $(obj).attr('data');
    $.ajax({
        url:"../chuli/shouye.php",
        data:{id:id,type:'del'},
        success:function(data){
            strToArr(data.split("~")[0]);
        }
    })
}
//修改的方法
function updateFun(obj){
    var id=$(obj).attr("data");
    $.ajax({
        url:"../chuli/update.php",
        data:{id:id,type:"save"},
        success:function(data){
            location.href="update.html";
        }
    })
}

　　

 

 

 

shouye.PHP

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
<?php
session_start();
/*连接数据库*/
$db = new MySQLi("localhost","root","","z_0705");
!mysqli_connect_error() or die("数据库连接错误");
$db->query("set names utf8");
/*接收前端传过来的数据*/
$uname = $_SESSION["uname"];
$uid = $_SESSION["uid"];
/*删除操作*/
if(!empty($_GET)){
    $id = $_GET['id'];
    $sql = "delete from house where id = $id";
    $res = $db->query($sql);
}
/*查询用户表*/
$sql = "select * from house ";
$res = $db->query($sql);
$arr = $res->fetch_all();
 
 
/*转成字符串返回*/
echo arrToStr($arr)."~".$uname;
function arrToStr($arr){
    $brr = array();
    foreach($arr as $v){
        $temp = implode(",",$v);
        $brr[] = $temp;
    }
    return implode("^",$brr);
}

　　

 

tianjia.html

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>发布页面</title>
<script type="text/javascript" src="../../jquery-3.2.1.min.js"></script>
</head>
<body>
   <a href="shouye.html">查看信息</a>
   <a href="../login.html">退出系统</a>
<div>信息发送：</div>
<form action="../chuli/tianjia.php">
    关键字：<input type="text" name="gjz"><br>
    区域：<input type="text" name="qy"><br>
    使用面积：<input type="text" name="symj"><br>
    租金：<input type="text" name="zj"><br>
    租赁类型：<input type="text" name="zplx"><br>
    房屋类型：<input type="text" name="fwlx"><br>
        <button   type="submit"  value="添加">添加</button>
        <button   type="reset"   value="复位">复位</button>
</form>
</body>
</html>

　　

 

tianjia.PHP

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
<?php
session_start();
 
/*连接数据库*/
$db = new MySQLi("localhost","root","","z_0705");
!mysqli_connect_error() or die("数据库连接错误");
$db->query("set names utf8");
 
/*接收前端传过来的数据*/
$gjz = $_GET["gjz"];
$qy = $_GET["qy"];
$symj = $_GET['symj'];
$zj = $_GET['zj'];
$zplx = $_GET['zplx'];
$fwlx = $_GET['fwlx'];
/*查询用户表*/
$sql = "insert into house(keyword,area,squaremeter,rent,rentype,housetype) values('$gjz','$qy','$symj','$zj','$zplx','$fwlx')";
$res = $db->query($sql);
if($res){
    header("location:../html/shouye.html");
}else{
    echo "<a href='../html/shouye.html'>添加错误</a>";
}

　　

 

update.html

 

 

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>无标题文档</title>
<script type="text/javascript" src="../../jquery-3.2.1.min.js"></script>
</head>
<body>
<form action="../chuli/update.php">
<input type="hidden" name="type" value="insert">
    关键字：<input type="text" name="gjz"><br>
    区域：<input type="text" name="qy"><br>
    使用面积：<input type="text" name="symj"><br>
    租金：<input type="text" name="zj"><br>
    租赁类型：<input type="text" name="zplx"><br>
    房屋类型：<input type="text" name="fwlx"><br>
    <button>确认修改</button>
</form>
</body>
</html>
<script>
$(function(){
    //ajax//请求数据
    var url="../chuli/update.php",
        data={type:"select"};
    ajaxFun(url,strToArr,data)
})
//处理数据
function strToArr(str){
    var arr=str.split(",");
    $("input[name='gjz']").val(arr[1])
    $("input[name='qy']").val(arr[2])
    $("input[name='symj']").val(arr[3])
    $("input[name='zj']").val(arr[4])
    $("input[name='zplx']").val(arr[5])
    $("input[name='fwlx']").val(arr[6])
}
    //封存一个ajax方法
    function ajaxFun(url,f1,data={},type="get",dtype="text"){
        $.ajax({
            url:url,
            data:data,
            dataType:dtype,
            success:function(data){
                f1(data);
            }
        })
    }
</script>

　　

 

update.PHP

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
<?php
session_start();
 
if(!empty($_GET) && $_GET["type"] == "save"){
    $_SESSION['id'] = $_GET["id"];
}
/*连接数据库*/
$db = new MySQLi("localhost","root","","z_0705");
!mysqli_connect_error() or die("数据库连接错误");
$db->query("set names utf8");
/*查数据*/
$type = $_GET["type"];//判断来后台干什么
switch($type){
    case "select"://查询数据
        $id = $_SESSION['id'];
        $sql = "select * from house where id = $id";
        $res = $db->query($sql);
        $arr = $res->fetch_row();
        echo implode(',',$arr);
        break;
    case "insert"://添加数据
        /*接收前端传过来的数据*/
$gjz = $_GET["gjz"];
$qy = $_GET["qy"];
$symj = $_GET['symj'];
$zj = $_GET['zj'];
$zplx = $_GET['zplx'];
$fwlx = $_GET['fwlx'];
/*查询用户表*/
$sql = "insert into house(keyword,area,squaremeter,rent,rentype,housetype) values('$gjz','$qy','$symj','$zj','$zplx','$fwlx')";
$res = $db->query($sql);
if($res){
    header("location:../html/shouye.html");
}else{
    echo "<a href='../html/shouye.html'>添加错误</a>";
}
}

　　

 

posted @   街角的守护  阅读(290)  评论(0)  编辑  收藏  举报
点击右上角即可分享
微信分享提示