DataOperat PHP Exemples de code

Exemple #1

0

Afficher le fichier

Fichier : person.php Projet : keensting/MeetingManageSystem

<!DOCTYPE html>
<html>
<head lang="en">
    <meta charset="UTF-8">
    <title></title>
    <link rel="stylesheet" href="./bootstrap/css/bootstrap.min.css">
    <script type="text/javascript" src="./js/jquery-1.8.0.js"></script>
    <script type="text/javascript" src="bootstrap/js/bootstrap.min.js"></script>
    <?php 
include './parameter/mysql/DataOperat.php';
$mydb = new DataOperat();
$re = $mydb->fetch_person_details();
$num = count($re);
?>
</head>
<body style="background-color: #ffffff">
<div class="container">
    <div class="page-header">
        <h3><strong>员工信息</strong></h3>
    </div>
    <table class="table table-striped">
        <caption>
            <h4>员工信息一览</h4>

        </caption>

        <tr>
            <th>编号</th>
            <th>姓名</th>
            <th>性别</th>
            <th>部门</th>

Exemple #2

0

Afficher le fichier

Fichier : userPage.php Projet : keensting/MeetingManageSystem

    <script type="text/javascript" src="./js/jquery-1.8.0.js"></script>
    <script type="text/javascript" src="bootstrap/js/bootstrap.min.js"></script>
<?php 
include "./parameter/class/user.php";
include "./parameter/mysql/DataOperat.php";
/*
 * 验证是否是正常登录用户
 */
if (!$_POST) {
    $name = '';
    $pwd = '';
    $user = new user();
} else {
    $name = $_POST['name'];
    $pwd = $_POST['pwd'];
    $db = new DataOperat();
    $arr = $db->verify($name);
    $user = new user();
    if ($arr == 0) {
        ?>
        <script>
            alert("该账号不存在！请注册或重新登录！");
            document.location.href = './index.html';
        </script>



    <?php 
    } else {
        $user->setUser($arr);
    }

Exemple #3

0

Afficher le fichier

Fichier : roomsinfo.php Projet : keensting/MeetingManageSystem

        }


    </script>
    <?php 
include "./parameter/mysql/DataOperat.php";
include "./parameter/class/room.php";
/**初始化会议室使用情况
 * @param $arr
 */
function change($arr)
{
    $re = array(0 => array($arr['ONE1'], $arr['ONE2'], $arr['ONE3'], $arr['ONE4'], $arr['ONE5'], $arr['ONE6']), 1 => array($arr['TWO1'], $arr['TWO2'], $arr['TWO3'], $arr['TWO4'], $arr['TWO5'], $arr['TWO6']), 2 => array($arr['THREE1'], $arr['THREE2'], $arr['THREE3'], $arr['THREE4'], $arr['THREE5'], $arr['THREE6']));
    return $re;
}
$db = new DataOperat();
$re = $db->fetch_room_info();
$num = count($re);
?>


</head>
<body style="background-color: #ffffff">
<div class="container">
    <div class="page-header">
        <h3><strong>会场一览</strong></h3>
    </div>
    <table class="table   table-striped">

            <caption>未来3天内各会场使用情况</caption>
            <thead>

Exemple #4

0

Afficher le fichier

Fichier : meetingspace.php Projet : keensting/MeetingManageSystem

            $("#word").click(function()
            {
                $("#001").fadeIn(800);
            });
            $("#doc").click(function()
            {
                $("#002").fadeIn(800);
            });
        });
    </script>

    <?php 
include "./parameter/mysql/DataOperat.php";
include './parameter/class/doc.php';
$id = $_GET['mid'];
$db = new DataOperat();
$re1 = $db->fetch_doc($id);
$num1 = count($re1);
$re2 = $db->fetch_txt($id);
$num2 = count($re2);
?>

</head>
<body>
<div class="container">
    <div class="page-header">
        <h3><strong>会议文档空间</strong></h3>

    </div>
    <table class="table">
        <caption>文档集合</caption>

Exemple #5

0

Afficher le fichier

Fichier : addperson.php Projet : keensting/MeetingManageSystem

<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/html">
<head lang="en">
    <meta charset="UTF-8">
    <title></title>
    <script type="text/javascript" src="./js/jquery-1.8.0.js"></script>
    <link type="text/css" rel="stylesheet" href="bootstrap/css/bootstrap.min.css">
    <script type="text/javascript" src="bootstrap/js/bootstrap.min.js"></script>
    <?php 
include './parameter/mysql/DataOperat.php';
$db = new DataOperat();
$deps = $db->selectItem('departs', array("DEPART_ID", "NAME"));
$num = count($deps);
?>


</head>
<body>
<div class="container">
    <div class="page-header">
        <h3><strong>新增员工</strong></h3>
    </div>
    <form class="col-md-8" method="post" action="./deal_add_person_require.php">
        <fieldset class="form-horizontal" >
            <legend>填写员工信息</legend>

            <div class="form-group">
                <label for="name" class="col-md-4 control-label">姓名：</label>
                <div class="col-md-4">
                    <input type="text" id="name" name="name" placeholder="员工姓名" class="form-control" />
                </div>

Exemple #6

0

Afficher le fichier

Fichier : signin.php Projet : keensting/MeetingManageSystem

<!DOCTYPE html>
<html>
<head lang="en">
    <meta charset="UTF-8">
    <title>注册</title>
    <script type="text/javascript" src="./js/jquery-1.8.0.js"></script>
    <link type="text/css" rel="stylesheet" href="css/style.css">
    <link type="text/css" rel="stylesheet " href="./bootstrap/css/bootstrap.min.css">
    <link type="text/css" rel="stylesheet" href="./css/font.css">
    <?php 
include './parameter/mysql/DataOperat.php';
$db = new DataOperat();
$deps = $db->selectItem('departs', array("DEPART_ID", "NAME"));
$num = count($deps);
if ($_POST) {
    $name = $_POST['name'];
    $mail = $_POST['mail'];
    $pwd = $_POST['pwdb'];
    $pwda = $_POST['pwda'];
    $rname = $_POST['rname'];
    $sex = $_POST['sex'];
    $phone = $_POST['phone'];
    $depart = $_POST['depart'];
    $position = $_POST['position'];
    $max = $db->getMaxId("USER_ID", "user");
    $id = 0;
    if ($max == 0) {
        $id = 10000;
    } else {
        $id = $max + 1;
    }

Exemple #7

0

Afficher le fichier

Fichier : mymeeting.php Projet : keensting/MeetingManageSystem

            refresh_board(id);
            $("#inform").slideDown(600);
        }
    </script>

    <?php 
include './parameter/mysql/DataOperat.php';
include './parameter/class/meeting.php';
/*
 * 展示该用户所有的会议
 */
session_start();
if ($_SESSION) {
    $uid = $_SESSION['uid'];
    $db = new DataOperat();
    $re = $db->fetch_meeting($uid);
    $num = count($re);
} else {
    echo "<script> alert('请登录！');\ndocument.location.href='./index.html';\n            </script>";
}
?>

</head>
<body style="background-color: #ffffff">
        <div class="container">
            <div class="page-header">
                <h3><strong>我的会议</strong></h3>
            </div>
            <table class="table table-striped">
                <caption>

Exemple #8

0

Afficher le fichier

Fichier : delresponse.php Projet : keensting/MeetingManageSystem

<!DOCTYPE html>
<html>
<head lang="en">
    <meta charset="UTF-8">
    <title></title>
    <script type="text/javascript" src="./js/jquery-1.8.0.js"></script>
    <link type="text/css" rel="stylesheet" href="bootstrap/css/bootstrap.min.css">
    <script type="text/javascript" src="bootstrap/js/bootstrap.min.js"></script>
</head>
<?php 
include './parameter/mysql/DataOperat.php';
include './parameter/class/depart.php';
$id = $_GET['id'];
session_start();
$_SESSION['did'] = $id;
$mydb = new DataOperat();
$re = $mydb->fetch_depart_info();
$num = count($re);
?>

<body>
    <div class="container">
        <div class="page-header">
            <h3><strong>转移该部门的所有员工</strong></h3>
        </div>
        <form method="post" action="deal_del_depart_request.php" class="form col-md-8" >
            <div class="form-group ">
                 <label> 选择部门：</label>
                  <select class="form-control" id="depart" name="depart">
                      <?php 
$row = new depart();

Exemple #9

0

Afficher le fichier

Fichier : departinfo.php Projet : keensting/MeetingManageSystem

<!DOCTYPE html>
<html>
<head lang="en">
    <meta charset="UTF-8">
    <title></title>
    <link rel="stylesheet" href="./bootstrap/css/bootstrap.min.css">
    <script type="text/javascript" src="./js/jquery-1.8.0.js"></script>
    <script type="text/javascript" src="bootstrap/js/bootstrap.min.js"></script>
    <?php 
include "./parameter/mysql/DataOperat.php";
include "./parameter/class/depart.php";
$db = new DataOperat();
$re = $db->fetch_depart_info();
$num = count($re);
?>
</head>
<body >
<div class="container">
    <div class="page-header">
        <h3><strong>部门信息</strong></h3>
    </div>
    <div class="col-lg-8">
        <div class="panel-group" id="accordion"><!-- 整个版面-->

            <?php 
$row = new depart();
for ($i = 0; $i < $num; $i++) {
    $row->initDepart($re[$i]);
    ?>

                    <div class="panel panel-default"><!-- 单个伸缩项-->

Exemple #10

0

Afficher le fichier

Fichier : historymeeting.php Projet : keensting/MeetingManageSystem

<!DOCTYPE html>
<html>
<head lang="en">
    <meta charset="UTF-8">
    <title></title>
    <link rel="stylesheet" href="./bootstrap/css/bootstrap.min.css">
    <script type="text/javascript" src="./js/jquery-1.8.0.js"></script>
    <script type="text/javascript" src="bootstrap/js/bootstrap.min.js"></script>
    <?php 
include "./parameter/mysql/DataOperat.php";
$db = new DataOperat();
session_start();
$id = $_SESSION['uid'];
$re = $db->fetch_history_meeting($id);
$num = count($re);
?>



</head>
<body>
<div class="container">
    <div class="page-header">
        <h3><strong>历史会议</strong></h3>
    </div>

    <table class="table">
        <caption>已完成的会议</caption>
        <tr>
            <td>
                会议名称

Exemple #11

0

Afficher le fichier

Fichier : reserveDeal.php Projet : keensting/MeetingManageSystem

 * Date: 2015/7/6
 * Time: 10:27
 */
require_once './parameter/Medoo/Resource/medoo.php';
include "./parameter/mysql/DataOperat.php";
session_start();
$uid = $_SESSION['uid'];
$name = $_POST["name"];
$detail = $_POST['detail'];
$room = $_POST['room'];
$chkArr = $_POST['chk'];
$date = $_POST['date'];
$time = $_POST['time'];
$offset = mktime(0, 0, 0, date("m"), date("d") + $date, date("Y"));
$date_time = date("Y/m/d", $offset);
$mydb = new DataOperat();
$num = $mydb->getMaxId('MEETING_ID', 'meeting');
$num += 1;
$db = new medoo('meetingmanage');
//meeting
$db->insert('meeting', array('MEETING_ID' => $num, 'NAME' => $name, 'INSTRUCTION' => $detail, 'ROOM_ID' => $room, 'USER_ID' => $uid, 'DATE' => $date_time, 'DAY_AFTER' => $date, 'TIME' => $time, 'STATE' => 1, 'VALIDITY' => 0));
$time_re = '';
if ($time == 1) {
    $time_re = '8:00';
} elseif ($time == 2) {
    $time_re = "10:00";
} elseif ($time == 3) {
    $time_re = "13:00";
} elseif ($time == 4) {
    $time_re = "15:00";
} elseif ($time == 5) {

Exemple #12

0

Afficher le fichier

Fichier : conferenceinform.php Projet : keensting/MeetingManageSystem

<!DOCTYPE html>
<html>
<head lang="en">
    <meta charset="UTF-8">
    <title></title>
    <link rel="stylesheet" href="./bootstrap/css/bootstrap.min.css">
    <script type="text/javascript" src="./js/jquery-1.8.0.js"></script>
    <script type="text/javascript" src="bootstrap/js/bootstrap.min.js"></script>
    <?php 
include "./parameter/mysql/DataOperat.php";
include "./parameter/class/message.php";
session_start();
$mes = $_SESSION['mes'];
$id = $_SESSION['uid'];
$db = new DataOperat();
$mes_info = new message();
if ($mes == 0) {
} else {
    $arr = $db->fetch_single_notice($mes);
    $re = $arr[0];
    $re['STATE'] = 0;
    $re['NOTICE_ID'] = 0;
    $re['MEETING_ID'] = 0;
    $mes_info->initMes($re);
    $db->alter_single_item("user", array("MES" => 0), array("USER_ID" => $id));
    $_SESSION['mes'] = 0;
}
$result = $db->fetchNotice($id);
//读取所有通知列表
$num = count($result);
// var_dump($result);

Exemple #13

0

Afficher le fichier

Fichier : modifyperson.php Projet : keensting/MeetingManageSystem

<!DOCTYPE html>
<html>
<head lang="en">
    <meta charset="UTF-8">
    <title></title>
    <script type="text/javascript" src="./js/jquery-1.8.0.js"></script>
    <link type="text/css" rel="stylesheet" href="bootstrap/css/bootstrap.min.css">
    <script type="text/javascript" src="bootstrap/js/bootstrap.min.js"></script>
    <?php 
include './parameter/mysql/DataOperat.php';
$id = $_GET['id'];
session_start();
$_SESSION['uid'] = $id;
$mydb = new DataOperat();
$re = $mydb->fetch_person_details_single($id);
$arr = $re[0];
$dep = $mydb->fetch_depart_info();
$num = count($dep);
?>
</head>
<body>
<div class="container">
    <div class="page-header">
        <h3><strong>修改人员信息</strong></h3>
    </div>




    <form method="post" action="./deal_modify_person_require.php" class=" col-md-6" style="margin-left: 15%;" >

Exemple #14

0

Afficher le fichier

Fichier : confirm_notice.php Projet : keensting/MeetingManageSystem

    <script type="text/javascript" src="./js/jquery-1.8.0.js"></script>
    <script type="text/javascript" src="bootstrap/js/bootstrap.min.js"></script>


<?php 
/**
 * Created by PhpStorm.
 * User: KeenSting
 * Date: 2015/6/29
 * Time: 15:10
 */
include "./parameter/mysql/DataOperat.php";
session_start();
$uid = $_SESSION['uid'];
$nid = $_GET['nid'];
$db = new DataOperat();
$db->alter_single_item("notice", array("STATE" => 1), array("NOTICE_ID" => $nid));
$db->alter_board($nid, $uid);
?>
</head>

<body>
    <div class="container">
        <div class="page-header">
            <h3><strong>确认通知</strong></h3>
        </div>
            <div class="panel-body">
                <img class="img-circle" style="width: 110px;height: 110px;" src="./img/ok.png">
                <label> 通知已确认！即将返回！</label>

            </div>

Exemple #15

0

Afficher le fichier

Fichier : delDepart.php Projet : keensting/MeetingManageSystem

            {

                alert('部门已从列表中移除！');
                document.location.href='./delDepart.php';
            }
        }

        function modify(id)
        {
            document.location.href='./modify_depart_page.php?id='+id;
        }
    </script>
    <?php 
include './parameter/mysql/DataOperat.php';
include './parameter/class/depart.php';
$mydb = new DataOperat();
$re = $mydb->fetch_depart_info();
$num = count($re);
$counter = array();
?>
</head>
<body>
    <div class="container">
        <div class="page-header">
            <h3><strong>更多操作</strong></h3>
        </div>
        <table class="table table-striped">
            <caption> 部门信息一览</caption>
            <tr>
                <th>部门名称</th>
                <th>部门编码</th>

PHP DataOperat Exemples