100 lines
3.6 KiB
PHP
100 lines
3.6 KiB
PHP
<head>
|
|
<link rel="icon" type="image/x-icon" href="https://ww3.tw/blog/icon/original.ico">
|
|
<title>文章列表</title> <!-- 标题 -->
|
|
</head>
|
|
<body id=wallpaper>
|
|
<!-- 背景 -->
|
|
<div id="div_1">
|
|
<?php
|
|
// 设定数据库路径
|
|
$db_path = '/var/www/owp/open-ww3-project-ww3-tw/databases/sqlite/owp.db';
|
|
|
|
try {
|
|
// 连接数据库
|
|
$db = new SQLite3($db_path);
|
|
// 连接成功输出连接成功
|
|
echo "<!--数据库连接成功-->";
|
|
// 如果连接成功，但是内部状态有问题
|
|
if ($db->lastErrorCode() !==0) {
|
|
// 依旧显示为连接失败
|
|
die("数据库连接失败");
|
|
}
|
|
|
|
// 内容区
|
|
// 执行sql命令 查询表单
|
|
$select_id_date_title_from_posts_btos /*查询posts表单中的id date title id从大到小排列*/ = $db->query('SELECT id, date, title FROM posts ORDER BY id DESC'); // 执行查询posts表单中的id date title id从大到小排列的命令
|
|
// 循环 写入
|
|
|
|
echo "<a href='https://ww3.tw' style='background-color: rgba(147, 185, 255, 0.644);position: absolute;'>返回首页</a>";
|
|
echo "<center><b><h2>全部文章</h2></b></center>";
|
|
echo "<br>";
|
|
echo "文章如下↓";
|
|
echo "<br>";
|
|
echo "<br>";
|
|
echo "<br>";
|
|
|
|
echo "<div id='content'>"; # 内容排版
|
|
|
|
while ($row = $select_id_date_title_from_posts_btos->fetchArray(SQLITE3_ASSOC)) {
|
|
|
|
echo "文章id: " . $row['id'] . "<br>";
|
|
echo $row['date'] . " " . "文章标题: " . $row['title'] . "<br>";
|
|
echo "<a href='https://ww3.tw/blog/post/s/?id=" . $row['id'] . "'>页面跳转</a><br><br>";
|
|
}
|
|
|
|
echo "</div>"; # 内容排版
|
|
|
|
|
|
|
|
// 关闭数据库连接
|
|
$db->close();
|
|
|
|
// 捕获php报错
|
|
} catch (Exception $e) {
|
|
// 依旧显示为连接失败
|
|
die("数据库连接失败");
|
|
// 关闭数据库连接
|
|
$db->close();
|
|
}
|
|
|
|
// 随机变换图床api
|
|
|
|
$wallpaper_apis = ['https://www.loliapi.com/acg/pc/', 'https://api.sretna.cn/api/pc.php', 'https://www.api.plus/API/dongman/', 'https://moe.jitsu.top/img/?sort=pc', 'https://www.dmoe.cc/random.php', 'https://api.r10086.com/樱道随机图片api接口.php?图片系列=猫娘1', 'https://api.mtyqx.cn/tapi/random.php', 'https://api.ww3.tw/touhou'];
|
|
$suiji_wallpaper = rand(0, count($wallpaper_apis) - 1);
|
|
$wallpaper = $wallpaper_apis[$suiji_wallpaper];
|
|
// 显示图床url在页面
|
|
echo "<div id='wallpaper_url'>图片来源: " . $wallpaper . "</div>";
|
|
?>
|
|
</div>
|
|
</body>
|
|
|
|
<style>
|
|
#wallpaper {
|
|
background-image: url(<?php
|
|
echo $wallpaper;
|
|
?>); /*图片地址*/ /* https://api.sretna.cn/api/pc.php */
|
|
background-repeat: no-repeat; /*禁止平铺*/
|
|
background-size: 100% 100%; /*图片占满100%*/
|
|
margin: 0; /* 外边框为0 */
|
|
/*padding: 0;*/
|
|
|
|
}
|
|
|
|
#div_1 {
|
|
height: 100%;
|
|
color: rgb(0, 0, 0);
|
|
font-size: 19px;
|
|
background-color: rgba(169, 169, 169, 0.48);
|
|
}
|
|
|
|
#content {
|
|
/* up、right、down、left */
|
|
margin: 0px 0px 0px 100px;
|
|
}
|
|
|
|
#wallpaper_url {
|
|
color: rgba(255, 0, 0, 0.354);
|
|
/* up、right、down、left */
|
|
margin: 20% 0px 0px 75%;
|
|
}
|
|
</style>
|