<?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">