要求

PHP 连接 mysql 输出数据表

效果图

index.php代码

<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <title></title>
    <style>
        body {
            background-color: #dedede;

        }
a{
    text-decoration: none;
    color: #000;
}
a:hover{
    color: deeppink;
}
.edit{
    color: #0e84b5;
}
.del{
    color: #9A0000;
}
        .main {
            border: 7px dotted #00bcff;
            width: 1666px;
            height: 555px;
            margin: 123px auto;
            text-align: center;
            font-size: 28px;
        }

        table {
            border-collapse: collapse;
            margin: 0 auto;
        }

        tr {
            text-align: center;
        }
        td{
            padding: 20px  40px;
        }
    </style>
</head>
<body>

<?php
$link = mysqli_connect("www.shuju.com", "root", "root");
if (!$link) {
    echo die("数据库链接失败") . mysqli_error();
} else {
    //选择数据库
    mysqli_query($link, "use zhuang");
    //选择表
    $result = mysqli_query($link, "select * from xinxi");
    $arr = array();
    while ($row = mysqli_fetch_row($result)) {
        $arr[] = $row;
    }
}
// echo "<pre>";
// print_r($arr);
// echo "</pre>";
mysqli_free_result($result);
?>
<div class="main">
    <h1>展示员工信息</h1>
    <table border="1" style="border-collapse: collapse;">
        <tr>
            <th>ID</th>
            <th>姓名</th>
            <th>所属部门</th>
            <th>出生日期</th>
            <th>入职日期</th>
            <th>相关操作</th>

        </tr>
        <?php
        foreach ($arr as $v) :
        ?>
            <tr>
            <?php
                foreach ($v as $key => $a) :
            ?>
                <td><?php echo $a; ?> </td>
        <!--   <td><?php echo $a[1]; ?> </td>
			   <td><?php echo $a[2]; ?> </td>
			   <td><?php echo $a[3]; ?> </td>
			   <td><?php echo $a[4]; ?> </td> -->
                <?php endforeach; ?>
                <td> <a href="#" onclick="alert('Error：编辑失败');"><span class="edit">✎</span>编辑</a>
                    &nbsp; &nbsp; &nbsp;
                    <a href="#" onclick="alert('Error：删除失败');"><span class="del">✘</span>删除</a></td>

            </tr>
        <?php endforeach; ?>

    </table>
</div>

</body>
</html>

data代码

CREATE TABLE xinxi
(ID int,
姓名 char (8)  NOT NULL,
所属部门 text,
出生日期 datetime,
入职时间 datetime
)

INSERT INTO `xinxi`(`ID`, `姓名`,`所属部门`, `出生日期`, `入职时间`) VALUES 
('1','张三', '市场部','2008-04-03 13:33:00','2014-09-22 17:53:00'),
('2','李四', '开发部','2008-04-03 13:33:00','2013-10-24 17:53:00'),
('3','王五', '媒体部','2008-04-03 13:33:00','2015-04-21 13:33:00'),
('4','赵六', '销售部','2008-04-03 13:33:00','2015-03-20 17:54:00')

演示效果： http://www.bealei.com/demo/php/zsygxx/index.php

文章由极客之音整理，本文链接：https://www.bmabk.com/index.php/post/83741.html