<?php
/*
** DB Class
** @Author Round
*/
header("Content-type: text/html; charset=utf-8");
//编码
// 导入数据库配置文件,后续可通过传参实现多个连接
require_once "./db.cfg.php";
// 数据库类
require_once "./database.core.php";
// 新建数据库对象 $dbConfig
$db = new Database($dbConfig);
echo "<pre>";
// 一位数组
$sqlOne = 'select * from jcc_admin where id = 5';
$row = $db->getRow($sqlOne);
var_dump($row);
// 二维数组
$sqlList = 'select * from jcc_admin where id > 0';
$list = $db->getList($sqlList);
var_dump($list);
$sqlCount = 'select count(*) as num from jcc_admin where id > 0';
$count = $db->getCount($sqlCount);
var_dump($count);
return $data;
}
}
if ($_POST["action"] == "addLink") {
$link = $_POST["link"];
$text = $_POST["text"];
$text = htmlentities($text, null, "UTF-8");
$link = htmlentities($link, null, "UTF-8");
$link = str_replace("http:", "", $link);
$link = str_replace("//", "", $link);
$link = str_replace("www.", "", $link);
$link = Database::mres($link);
$text = Database::mres($text);
Database::execute("INSERT INTO links(name,link) VALUES('{$text}','{$link}')");
}
$data = Database::getList("SELECT name,link FROM links ORDER BY id DESC LIMIT 10");
?>
<!DOCTYPE>
<html>
<head>
<title>PostTheLink</title>
<meta name="viewport" content="width=device-width">
</head>
<body>
<div class="wrapper">
<div class="title_header">
<h1>PostTheLink</h1>
<p>Тут вы можете оставить ссылку и подпись к ней</p>
</div>
<div class="content">
<div class="form-block">
