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>