function display($db)
{
$selected_all = select_all($db);
echo '<ul>';
foreach ($selected_all[0] as $key => $value) {
echo '<li><h3>' . $key . '</h3></li>';
}
echo '</ul>';
for ($i = 0; $i < count($selected_all); $i++) {
echo '<ul>';
foreach ($selected_all[$i] as $key => $value) {
if ($key != 'img') {
echo '<li>' . $value . '</li>';
} else {
echo '<li width=auto height=auto><img src=../' . $selected_all[$i]['img'] . '></li>';
}
}
echo '</ul>';
}
}
$link = trim($_POST["link"]) ? $_POST["link"] : "";
// 插入数据
insert("INSERT INTO jl_friend(friend_name,friend_link) VALUES('{$name}','{$link}')");
}
// 页数
$datacount = countNum("jl_friend");
$total_record = count($datacount);
// 每页记录数
$per_record = 5;
// 总页数（总记录数/每页记录数）
$page_num = ceil($total_record / $per_record);
// 当前页数
$cur_id = isset($_GET["page"]) ? (int) $_GET["page"] : 1;
$offset = ($cur_id - 1) * $per_record;
// 查询数据
$data = select_all("SELECT * FROM jl_friend ORDER BY friend_id DESC LIMIT {$offset},{$per_record}");
// 编号
$i = 1;
if (isset($_POST["delSubmit"])) {
// var_dump($_POST);
// 删除数据
delMore("del", "jl_friend", "friend_id", $_SERVER["PHP_SELF"]);
}
?>
<!DOCTYPE html>
<html lang="zh-CN">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<?php
/**
* 头部文件
*/
$data = select_all("SELECT * FROM jl_nav ORDER BY nav_id ASC");
?>
<div id="header">
<img src="images/index-campany-logo.png" style="margin:14px 0 0 66px;" />
<ul class="top">
<li><a href="./admin"> > 超级管理员登陆</a></li>
<li style="background:url(images/homeLogo.png) no-repeat scroll 6px 3px;"><a href="">设为首页</a></li>
<li style="background:url(images/bookLogo.png) no-repeat scroll 6px 5px;"><a href="">收藏本站</a></li>
</ul>
<div class="clear"></div>
<div class="navigator">
<img src="images/index-navigator-left.png">
<ul>
<?php
foreach ($data as $value) {
?>
<li><a href="<?php
echo $value["nav_link"];
?>
"><?php
echo $value["nav_name"];
?>
</a></li>
<?php
}
?>
<?php
require "../include/init/init.php";
// 页数
$datacount = countNum("jl_document");
$total_record = count($datacount);
// 每页记录数
$per_record = 5;
// 总页数（总记录数/每页记录数）
$page_num = ceil($total_record / $per_record);
// 当前页数
$cur_id = isset($_GET["page"]) ? (int) $_GET["page"] : 1;
$offset = ($cur_id - 1) * $per_record;
// 查询数据
$data = select_all("SELECT * FROM jl_document ORDER BY document_id DESC LIMIT {$offset},{$per_record}");
// 编号
$i = 1;
if (isset($_POST["delSubmit"])) {
// var_dump($_POST);
// 删除数据
delMore("del", "jl_document", "document_id", $_SERVER["PHP_SELF"]);
}
?>
<!DOCTYPE html>
<html lang="zh-CN">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<?php
}
//種類の集計結果を表示
if ($kind == true) {
?>
<table border=1>
<tr>
<th>種類の番号</th>
<th>種類名</th>
<th>種類の割合</th>
<th>SNSの番号</th>
<th>カテゴリーの番号</th>
</tr>
<?php
$result_kind = select_all('kind');
foreach ($result_kind as $result_kind) {
?>
<tr>
<td><?php
echo $result_kind['kindID'];
?>
</td>
<td><?php
echo $result_kind['kindName'];
?>
</td>
<td><?php
echo $result_kind['kindPercentage'];
?>
</td>
$img = $_FILES["img"]["name"];
}
insert("INSERT INTO jl_products(products_name,products_img,products_content) VALUES('{$name}','{$img}','{$content}')");
}
// 页数
$datacount = countNum("jl_products");
$total_record = count($datacount);
// 每页记录数
$per_record = 5;
// 总页数（总记录数/每页记录数）
$page_num = ceil($total_record / $per_record);
// 当前页数
$cur_id = isset($_GET["page"]) ? (int) $_GET["page"] : 1;
$offset = ($cur_id - 1) * $per_record;
// 查询数据
$data = select_all("SELECT * FROM jl_products ORDER BY products_id DESC LIMIT {$offset},{$per_record}");
// 编号
$i = 1;
if (isset($_POST["delSubmit"])) {
// var_dump($_POST);
// 删除数据
delMore("del", "jl_products", "products_id", $_SERVER["PHP_SELF"]);
}
?>
<!DOCTYPE html>
<html lang="zh-CN">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<tr>
<th>Автор</th>
<th>Название</th>
<th>Год издания</th>
<th>Цена, руб.</th>
<th>В корзину</th>
</tr>
<?php
/*
ЗАДАНИЕ 2
- С помощью функции selectAll() получите выборку всех товаров
- В цикле выведите все товары на экран
- Значение ячейки "В корзину" оформите в виде гиперссылки на
документ add2basket.php, добавив параметр id с идентификатором(поле id) товара
*/
$all_product = select_all();
//echo '<pre>';
//print_r($all_product);
//echo '</pre>';
foreach ($all_product as $item) {
echo '<tr>';
echo "<td>{$item['author']}</td>";
echo "<td>{$item['title']}</td>";
echo "<td>{$item['pubyear']}</td>";
echo "<td>{$item['price']}</td>";
echo "<td><a href='add2basket.php?id={$item['id']}'>В корзину</a></td>";
echo '</tr>';
}
?>
</table>
</body>
<?php
require "include/init/init.php";
session_start();
// 产品
$data2 = select_all("SELECT * FROM jl_products ORDER BY products_id DESC LIMIT 0,5");
// 新闻
$data3 = select_all("SELECT * FROM jl_news ORDER BY news_id DESC LIMIT 0,5");
// 通知
$data4 = select_all("SELECT * FROM jl_notice ORDER BY notice_id DESC LIMIT 0,5");
// 友链
$data5 = select_all("SELECT * FROM jl_friend ORDER BY friend_id DESC LIMIT 0,20");
// 网站设置
$optiondata = select_row("SELECT * FROM jl_option");
// 公司简介
// $data6=select_row("SELECT * FROM jl_document WHERE document_id=1");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html;charset=UTF-8" />
<title></title>
<meta name="keywords" content="<?php
echo $optiondata["keyword"];
?>
" />
<meta name="description" content="<?php
echo $optiondata["description"];
?>
" />
<link rel="stylesheet" type="text/css" href="css/reset.css">
function get()
{
global $base_url;
$id = $_GET['id'];
$action = $_GET['action'];
$edit_link = '';
$contents = '';
$title = '';
$page_link = '';
if ($action == 'edit') {
login();
if (!$id) {
$id = 1;
}
$piki_page = select($id);
if (!$piki_page) {
header("Location: " . $base_url . "?action=new");
exit;
}
$title = htmlspecialchars($piki_page['title']);
$body = htmlspecialchars($piki_page['body']);
$cansel_url = $base_url . '?id=' . $id;
$title_read_only = '';
$contents = <<<EOS
<form method="post">
<input type="text" name="title" value="{$title}" size="30" /><br />
<textarea name="body" rows=20 cols=80>{$body}</textarea><br />
<input type="hidden" name="id" value="{$id}" />
<input type="hidden" name="action" value="edit" />
<input type="submit" value="Save" />
<a href="{$cansel_url}">Cansel</a>
</form>
EOS;
if ($id != 1) {
$contents .= <<<EOS
<form method="post" onSubmit="return confirm('Are you sure?')">
<input type="hidden" name="id" value="{$id}" />
<input type="hidden" name="action" value="delete" />
<input type="submit" value="Delete" />
</form>
EOS;
}
} else {
if ($action == 'new') {
login();
$cansel_url = $base_url;
$contents = <<<EOS
<form method="post">
<input type="text" name="title" value="{$title}" size="30" /><br />
<textarea name="body" rows=20 cols=80></textarea><br />
<input type="submit" value="Save" />
<input type="hidden" name="action" value="new" />
<a href="{$cansel_url}">Cansel</a>
</form>
EOS;
} else {
if (!$id) {
$id = 1;
}
$piki_page = select($id);
if (!$piki_page) {
header("Location: " . $base_url . "?action=new");
exit;
}
$title = htmlspecialchars($piki_page['title']);
$page_link = "<a href=\"{$base_url}?id={$id}\">{$title}</a>";
$edit_link = "<a class=\"action\" href=\"{$base_url}?id={$id}&action=edit\">edit</a>";
$contents = '<h2>' . $page_link . '</h2>' . $edit_link;
$contents .= '<pre>' . htmlspecialchars($piki_page['body']) . '</pre>';
}
}
$piki_pages = select_all();
$list .= '<ul>';
foreach ($piki_pages as $piki_page) {
$page_id = $piki_page['id'];
$page_title = htmlspecialchars($piki_page['title']);
if ($id == $page_id) {
$list .= "<li class=\"current_page\">> <a href=\"{$base_url}?id={$page_id}\">{$page_title}</a></li>";
} else {
$list .= "<li><a href=\"{$base_url}?id={$page_id}\">{$page_title}</a></li>";
}
}
$list .= '</ul>';
echo <<<EOS
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<style type="text/css">
#header {
padding: 6px 0;
}
#header h1 {
display: inline;
margin: 4px 0;
}
#header h1 a {
color: #FF00AE;
}
#page {
border-left: dotted 1px silver;
padding:6px 12px;
float: left;
width: 80%;
}
#page h2 {
display: inline;
margin: 0 0 4px 0;
}
#page h2 a {
color: black;
}
#sidebar {
float: left;
width: 16%;
}
#footer {
clear: both;
}
#sidebar ul {
padding: 0;
margin: 16px 0;
}
#sidebar li {
margin: 1px 0;
padding: 1px 2px;
list-style-type: none;
}
#sidebar li.current_page {
color: black;
}
#sidebar li.current_page a {
color: black;
}
#contents {
margin: 0;
}
a {
color: #0063F7;
}
a.action {
margin: 0 8px;
color: #CCCCCC;
}
a.action:hover {
color: #0063F7;
}
</style>
<title>{$title} - Piki</title>
</head>
<body>
<div id="header">
<h1><a href="{$base_url}">Piki</a></h1>
<a class="action" href="{$base_url}?action=new">new</a>
</div>
<div id="sidebar">
{$list}
</div>
<div id="page">
<div id="contents">{$contents}</div>
</div>
<div id="footer"></div>
</body>
</html>
EOS;
}
?>
"></td>
<td><input id="txtNewUserSignDate" class="form-control" name="username" type="text"
placeholder="<?php
echo $user['userSignDate'];
?>
"></td>
<td><input id="txtNewUserLastLoginDate" class="form-control " name="username" type="text"
placeholder="<?php
echo $user['userLastLoginDate'];
?>
"></td>
<td>
<select class="form-control" id="selNewRoleTitle">
<?php
$roles = select_all('tblroles');
foreach ($roles as $role) {
?>
<option value="<?php
echo $role['id'];
?>
"><?php
echo $role['roleTitle'];
?>
</option>
<?php
}
?>
</select>
</td>
<td>
if ($db == true) {
$insert_category = insert_category($categoryName, $categoryPercentage, $snsID);
}
}
//エラーが発生しなければ表示
if (!isset($insert_category) && $db == true) {
echo 'カテゴリーの集計結果をDBに追加しました。<br> . <br>';
} else {
echo 'カテゴリーの集計結果<br> . <br>';
}
?>
</table>
<?php
echo "<br>";
//カテゴリーの集計結果を取得
$select_category = select_all('category');
?>
<table border=1>
<tr>
<th>種類名</th>
<th>種類の割合</th>
<th>SNSの番号</th>
<th>カテゴリーの番号</th>
</tr>
<?php
//カテゴリーごとに種類の集計結果を取得
for ($i = 0; $i < $num; $i++) {
//種類ごとの件数を取得
$result_kind = kind_calc($snsID, $select_category[$i]['categoryName']);
//カテゴリーごとのレコード件数を取得
$result_category_count = count_category_calc($snsID, $select_category[$i]['categoryName']);
curl_setopt($curl, CURLOPT_POST, true);
curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($curl, CURLOPT_HTTPAUTH, CURLAUTH_BASIC);
curl_setopt($curl, CURLOPT_URL, $url);
curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
curl_setopt($curl, CURLOPT_SAFE_UPLOAD, false);
curl_setopt($curl, CURLOPT_POSTFIELDS, $params);
$result = curl_exec($curl);
$code = curl_getinfo($curl, CURLINFO_HTTP_CODE);
curl_close($curl);
//アクセストークンの表示
echo $result;
} else {
//画像認識の処理
//画像のURLをDBから取得
$photo_array = select_all('photo');
//photoIDと配列番号を同じにする処理
$first_array = $first - 1;
$last_array = $last - 1;
$url = 'https://api.clarifai.com/v1/tag/';
$curl = curl_init();
$header = array('Authorization: Bearer ' . TOKEN);
$connect_url = null;
//入力した範囲の画像のURLを連結
for ($i = $first_array; $i <= $last_array; $i++) {
$photo_url = 'url=' . $photo_array[$i]['photoURL'] . '&';
$connect_url = $connect_url . $photo_url;
}
$params = $connect_url . 'language=ja&model=general-v1.3';
//APIに画像をPOSTする処理
curl_setopt($curl, CURLOPT_POST, true);
<?php
require "../include/init/init.php";
$notice_num = select_all("SELECT notice_id FROM jl_notice");
$products_num = select_all("SELECT products_id FROM jl_products");
$meg_num = select_all("SELECT meg_id FROM jl_meg");
?>
<!DOCTYPE html>
<html lang="zh-CN">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<link rel="icon" href="">
<title>金陵后台管理</title>
<link href="../css/bootstrap.min.css" rel="stylesheet">
<link href="../css/dashboard.css" rel="stylesheet">
</head>
<body>
<?php
require "../include/admin_header.php";
?>
<div class="col-sm-12 col-sm-offset-3 col-md-10 col-md-offset-2 main">
<!-- 更改即可 -->
<h3 class="page-header"><strong>网站统计</strong></h3>
<div class="row placeholders">
<div class="col-xs-6 col-sm-4 placeholder">
<h2><?php
echo count($notice_num);
$email = trim($_POST["email"]) ? $_POST["email"] : "";
// 插入数据
insert("INSERT INTO jl_admin(admin_username,admin_password,admin_email) VALUES('{$name}','{$pass}','{$email}')");
}
// 页数
$datacount = countNum("jl_admin");
$total_record = count($datacount);
// 每页记录数
$per_record = 5;
// 总页数（总记录数/每页记录数）
$page_num = ceil($total_record / $per_record);
// 当前页数
$cur_id = isset($_GET["page"]) ? (int) $_GET["page"] : 1;
$offset = ($cur_id - 1) * $per_record;
// 查询数据
$data = select_all("SELECT * FROM jl_admin ORDER BY admin_id DESC LIMIT {$offset},{$per_record}");
// 编号
$i = 1;
if (isset($_POST["delSubmit"])) {
// var_dump($_POST);
// 删除数据
delMore("del", "jl_admin", "admin_id", $_SERVER["PHP_SELF"]);
}
?>
<!DOCTYPE html>
<html lang="zh-CN">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
/**
* 总记录数函数
*/
function countNum($tablename)
{
$datacount = select_all("SELECT * FROM {$tablename}");
return $datacount;
}
<?php
require "../include/init/init.php";
// 页数
$datacount = countNum("jl_meg");
$total_record = count($datacount);
// 每页记录数
$per_record = 5;
// 总页数（总记录数/每页记录数）
$page_num = ceil($total_record / $per_record);
// 当前页数
$cur_id = isset($_GET["page"]) ? (int) $_GET["page"] : 1;
$offset = ($cur_id - 1) * $per_record;
// 查询数据
$data = select_all("SELECT * FROM jl_meg ORDER BY meg_id DESC LIMIT {$offset},{$per_record}");
// 编号
$i = 1;
if (isset($_POST["delSubmit"])) {
// var_dump($_POST);
// 删除数据
delMore("del", "jl_meg", "meg_id", $_SERVER["PHP_SELF"]);
}
?>
<!DOCTYPE html>
<html lang="zh-CN">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<?php
require_once '../common/api_dbaccesUtil.php';
?>
<!DOCTYPE html>
<html lang="ja">
<head>
<meta charset="UTF-8">
</head>
<body>
<?php
//画像認識の結果を重複を除いてDBから取得
$select_recognition = group_by_recognition();
//リストの取得
$select_list = select_all('list');
?>
<table border=1>
<tr>
<th>リストの名前</th>
<th>種類名</th>
<th>カテゴリー名</th>
</tr>
<?php
//認識結果1と一致するものがリストに存在するかを確認
foreach ($select_recognition as $value_recognition) {
$flag = false;
foreach ($select_list as $value_list) {
if ($value_recognition['result1'] == $value_list['listName']) {
$flag = true;
}
$description = trim($_POST["description"]) ? $_POST["description"] : "";
// 插入数据
insert("INSERT INTO jl_news(news_name,news_link,news_description,news_time) VALUES('{$name}','{$link}','{$description}','{$time}')");
}
// 页数
$datacount = countNum("jl_news");
$total_record = count($datacount);
// 每页记录数
$per_record = 5;
// 总页数（总记录数/每页记录数）
$page_num = ceil($total_record / $per_record);
// 当前页数
$cur_id = isset($_GET["page"]) ? (int) $_GET["page"] : 1;
$offset = ($cur_id - 1) * $per_record;
// 查询数据
$data = select_all("SELECT * FROM jl_news ORDER BY news_id DESC LIMIT {$offset},{$per_record}");
// 编号
$i = 1;
if (isset($_POST["delSubmit"])) {
// var_dump($_POST);
// 删除数据
delMore("del", "jl_news", "news_id", $_SERVER["PHP_SELF"]);
}
?>
<!DOCTYPE html>
<html lang="zh-CN">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<?php
require "../include/init/init.php";
session_set_cookie_params(3600);
session_start();
// 退出登陆
if (isset($_SESSION["is_login"]) == 1) {
session_destroy();
}
if ($_POST) {
$name = $_POST["name"];
$pass = $_POST["pass"];
$yz_code = $_POST["yz_code"];
$yz_session = $_SESSION["code"];
$admindata = select_all("SELECT admin_password FROM jl_admin WHERE admin_username='******'");
if (!empty($admindata)) {
foreach ($admindata as $value) {
if ($value["admin_password"] == $pass && strtolower($yz_code) == strtolower($yz_session)) {
$_SESSION["is_login"] = 1;
$_SESSION["name"] = $name;
success("登陆成功", "./index.php");
} else {
error("验证码错误");
}
}
} else {
error("登陆失败");
}
}
?>
<!DOCTYPE html>
