function addImage($newImage, $config) { if (selectDb($config)) { return mysql_query('INSERT INTO `images`(`file`, `descr`) VALUES (\'' . $newImage['file'] . '\', \'' . $newImage['descr'] . '\')'); } return false; }
<?php require "include/inic.php"; $data1 = selectDb("SELECT * FROM `wd_document` WHERE document_id=3"); ?> <!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"> <title>文豆集团-首页</title> <!-- Bootstrap --> <link rel="stylesheet" href="css/bootstrap.min.css"> <link rel="stylesheet" href="css/base.css"> <link rel="stylesheet" href="css/child.css"> <!--[if lt IE 9]> <script src="http://cdn.bootcss.com/html5shiv/3.7.2/html5shiv.min.js"></script> <script src="http://cdn.bootcss.com/respond.js/1.4.2/respond.min.js"></script> <![endif]--> </head> <body> <?php require "include/header.php"; ?> <div class="guestbook"> <div class="container"> <ol class="breadcrumb"> <li><a href="#">首页</a></li>
$caseTime = strtotime($_POST["caseTime"]); $caseCate = $_POST["caseCate"]; if ($_FILES) { upload_file("caseFileImg"); $caseFileImg = $_FILES["caseFileImg"]["name"]; } //插入sql语句 $sql = "INSERT INTO `wd_case`(\n\t\t\t`case_title`,\n\t\t\t `case_link`,\n\t\t\t `case_add_time`, \n\t\t\t `case_img_url`,\n\t\t\t `case_description`,\n\t\t\t `case_cate_id`\n\t\t\t ) VALUES (\n\t\t\t '{$caseName}',\n\t\t\t '{$caseLink}',\n\t\t\t '{$caseTime}',\n\t\t\t '{$caseFileImg}',\n\t\t\t '{$caseDescription}',\n\t\t\t '{$caseCate}')"; mysql_query($sql); if (mysql_affected_rows() > 0) { success("更新成功", $_SERVER["PHP_SELF"]); } else { error("更新失败"); } } $data = selectDb("SELECT * FROM `wd_case` LEFT JOIN `wd_case_cate` ON wd_case.case_cate_id=wd_case_cate.case_cate_id"); ?> <!doctype html> <html lang="zh-ch"> <!-- container-fluid --> <head> <title>文豆-后台管理</title> <meta charset="UTF-8" /> <meta name="viewport" content="width=device-width, initial-scale=1.0" /> <meta http-equiv="Content-Type" content="; charset=utf-8" /> <link rel="stylesheet" href="bootstrap.min.css" /> <link rel="stylesheet" href="../css/bootstrap-responsive.min.css" /> <link rel="stylesheet" href="../css/unicorn.main.css" /> <link rel="stylesheet" href="../css/uniform.css" /> <link rel="stylesheet" href="../css/unicorn.grey.css" class="skin-color" /> </head>
<?php /** * wengdo首页 * @author: Jeffery * create time: 2015-09-05 */ require "include/inic.php"; //查询通知 $noticeData = selectDb("SELECT * FROM `wd_article_cate` LEFT JOIN `wd_article` ON wd_article_cate.article_cate_id=wd_article.article_cate_id WHERE wd_article_cate.article_cate_id=1 ORDER BY article_id DESC"); //查询新闻 $newsData = selectDb("SELECT * FROM `wd_article_cate` LEFT JOIN `wd_article` ON wd_article_cate.article_cate_id=wd_article.article_cate_id WHERE wd_article_cate.article_cate_id=2 ORDER BY article_id DESC"); // 查询广告 $adData = selectDb("SELECT * FROM `wd_ad` ORDER BY ad_id DESC"); $caseData = selectDb("SELECT * FROM `wd_case` ORDER BY case_id DESC LIMIT 0,5"); // 查询sql语句 $sql = "SELECT * FROM `wd_option`"; $res = mysql_query($sql); $optiondata = array(); if (mysql_num_rows($res) > 0) { $rows = mysql_fetch_assoc($res); $optiondata = $rows; } ?> <!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="keywords" itemprop="keywords" content="<?php
function processSetup() { global $i, $c; $i = 0; $c = 0; // Database Connectivity Checking if ($error = checkDb($_POST)) { $_SESSION['ERROR'][$i]['type'] = 'Done'; $_SESSION['ERROR'][$i]['reason'] = 'Connected to Database'; $i++; $c++; } else { $_SESSION['ERROR'][$i]['type'] = 'Error'; $_SESSION['ERROR'][$i]['reason'] = 'Error Connecting to Database :' . mysql_error(); $i++; } // Database Name Check if ($error = selectDb($_POST)) { $_SESSION['ERROR'][$i]['type'] = 'Done'; $_SESSION['ERROR'][$i]['reason'] = 'Selected Database "' . $_POST['db_name'] . '"'; $i++; $c++; } else { $_SESSION['ERROR'][$i]['type'] = 'Error'; $_SESSION['ERROR'][$i]['reason'] = 'Error Selecting Database :' . mysql_error(); $i++; } // Creating Tables if ($error = createTables($_POST)) { $_SESSION['ERROR'][$i]['type'] = 'Done'; $_SESSION['ERROR'][$i]['reason'] = 'Tables Created Successfully'; $i++; $c++; } else { $_SESSION['ERROR'][$i]['type'] = 'Error'; $_SESSION['ERROR'][$i]['reason'] = 'Error Creating Tables :' . mysql_error(); $i++; } // Sample Questions if ($_POST['sample_qstn'] == 'yes') { if ($error = insertSQstn($_POST)) { $_SESSION['ERROR'][$i]['type'] = 'Done'; $_SESSION['ERROR'][$i]['reason'] = 'Sample Questions inserted Successfully'; $i++; } else { $_SESSION['ERROR'][$i]['type'] = 'Error'; $_SESSION['ERROR'][$i]['reason'] = 'Error Inserting Sample Questions :' . mysql_error(); $i++; } } // Creating Admin Account if ($error = createAdmin($_POST)) { $_SESSION['ERROR'][$i]['type'] = 'Done'; $_SESSION['ERROR'][$i]['reason'] = 'Admin Account Created Successfully'; $i++; $c++; } else { $_SESSION['ERROR'][$i]['type'] = 'Error'; $_SESSION['ERROR'][$i]['reason'] = 'Error Creating Admin Account :' . mysql_error(); $i++; } // Creating Mail Settings if ($error = addMailSett($_POST)) { $_SESSION['ERROR'][$i]['type'] = 'Done'; $_SESSION['ERROR'][$i]['reason'] = 'Mail Settings Updated Successfully'; $i++; } else { $_SESSION['ERROR'][$i]['type'] = 'Error'; $_SESSION['ERROR'][$i]['reason'] = 'Error Updating Mail Settings :' . mysql_error(); $i++; } // Create Config File if ($c >= 4) { if ($error = createConfig($_POST)) { $_SESSION['ERROR'][$i]['type'] = 'Done'; $_SESSION['ERROR'][$i]['reason'] = 'Config File Created Successfully'; $mail = new PHPMailer(); PQmail($mail, $_POST); $i++; $c++; } else { $_SESSION['ERROR'][$i]['type'] = 'Error'; $_SESSION['ERROR'][$i]['reason'] = 'Error Creating Config File '; $i++; } } }
if ($_POST) { // 删除函数 delMore("del", "wd_contact", "contact_id", "./opinion.php"); } $datacount = selectDb("SELECT * FROM wd_contact"); // 总记录数 $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 = selectDb("SELECT * FROM wd_contact ORDER BY contact_id DESC LIMIT {$offset},{$per_record}"); ?> <!doctype html> <html lang="zh-ch"> <!-- container-fluid --> <head> <title>文豆-后台管理</title> <meta charset="UTF-8" /> <meta name="viewport" content="width=device-width, initial-scale=1.0" /> <meta http-equiv="Content-Type" content="; charset=utf-8" /> <link rel="stylesheet" href="bootstrap.min.css" /> <link rel="stylesheet" href="../css/bootstrap-responsive.min.css" /> <link rel="stylesheet" href="../css/unicorn.main.css" /> <link rel="stylesheet" href="../css/uniform.css" /> <link rel="stylesheet" href="../css/unicorn.grey.css" class="skin-color" /> </head>
<?php /** * wengdo新闻页面 * @author: Jeffery * create time: 2015-09-06 */ require "include/inic.php"; // 查询sql语句 (分类找文章)article_cate_id=2 是新闻 $noticeData = selectDb("SELECT * FROM `wd_article_cate` LEFT JOIN `wd_article` ON wd_article_cate.article_cate_id=wd_article.article_cate_id WHERE wd_article_cate.article_cate_id=2 ORDER BY article_id DESC"); mysql_close($conn); // 新闻编号 $i = 1; ?> <!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"> <title>文豆集团-首页</title> <!-- Bootstrap --> <link rel="stylesheet" href="css/bootstrap.min.css"> <link rel="stylesheet" href="css/base.css"> <link rel="stylesheet" href="css/child.css"> <!--[if lt IE 9]> <script src="http://cdn.bootcss.com/html5shiv/3.7.2/html5shiv.min.js"></script> <script src="http://cdn.bootcss.com/respond.js/1.4.2/respond.min.js"></script> <![endif]--> </head>
<?php /** * wengdo后台所有留言 * author: Jeffery * create time: 2015-09-08 */ require "../include/inic.php"; if ($_POST) { delMore("del", "wd_document", "document_id", "./document_list.php"); } $data = selectDb("SELECT * FROM `wd_document`"); ?> <!doctype html> <html lang="zh-ch"> <!-- container-fluid --> <head> <title>文豆-后台管理</title> <meta charset="UTF-8" /> <meta name="viewport" content="width=device-width, initial-scale=1.0" /> <meta http-equiv="Content-Type" content="; charset=utf-8" /> <link rel="stylesheet" href="bootstrap.min.css" /> <link rel="stylesheet" href="../css/bootstrap-responsive.min.css" /> <link rel="stylesheet" href="../css/unicorn.main.css" /> <link rel="stylesheet" href="../css/uniform.css" /> <link rel="stylesheet" href="../css/unicorn.grey.css" class="skin-color" /> </head> <body> <!-- 包含头部 --> <?php require "../include/admin_header.php";
<?php require "../include/inic.php"; $data = selectDb("SELECT case_id FROM wd_case"); $data1 = selectDb("SELECT article_id FROM wd_article"); $data2 = selectDb("SELECT meg_id FROM wd_meg"); $data3 = selectDb("SELECT friend_links_id FROM wd_friend_links"); $data4 = selectDb("SELECT register_id FROM wd_register"); $case_num = count($data); $article_num = count($data1); $meg_num = count($data2); $friend_num = count($data3); $user_num = count($data4); ?> <!doctype html> <html lang="zh-ch"> <!-- container-fluid --> <head> <title>文豆-后台管理</title> <meta charset="UTF-8" /> <meta name="viewport" content="width=device-width, initial-scale=1.0" /> <meta http-equiv="Content-Type" content="; charset=utf-8" /> <link rel="stylesheet" href="bootstrap.min.css" /> <link rel="stylesheet" href="../css/bootstrap-responsive.min.css" /> <link rel="stylesheet" href="../css/unicorn.main.css" /> <link rel="stylesheet" href="../css/unicorn.grey.css" class="skin-color" /> </head> <body> <?php require "../include/admin_header.php"; ?>
<?php /** * wengdo后台所有回收 * author: Jeffery * create time: 2015-09-08 */ require "../include/inic.php"; if ($_POST) { // 删除函数 delMore("del", "wd_nav", "article_id", "./article.php"); } // 查询 $data = selectDb("SELECT * FROM wd_article LEFT JOIN wd_article_cate ON wd_article.article_cate_id=wd_article_cate.article_cate_id"); ?> <!doctype html> <html lang="zh-ch"> <!-- container-fluid --> <head> <title>文豆-后台管理</title> <meta charset="UTF-8" /> <meta name="viewport" content="width=device-width, initial-scale=1.0" /> <meta http-equiv="Content-Type" content="; charset=utf-8" /> <link rel="stylesheet" href="bootstrap.min.css" /> <link rel="stylesheet" href="../css/bootstrap-responsive.min.css" /> <link rel="stylesheet" href="../css/unicorn.main.css" /> <link rel="stylesheet" href="../css/uniform.css" /> <link rel="stylesheet" href="../css/unicorn.grey.css" class="skin-color" /> </head> <body> <!-- 包含头部 -->
if ($_POST) { // 删除函数 delMore("del", "wd_nav", "nav_id", "./nav.php"); } $datacount = selectDb("SELECT * FROM wd_nav"); // 总记录数 $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 = selectDb("SELECT * FROM wd_nav ORDER BY nav_id DESC LIMIT {$offset},{$per_record}"); ?> <!doctype html> <html lang="zh-ch"> <!-- container-fluid --> <head> <title>文豆-后台管理</title> <meta charset="UTF-8" /> <meta name="viewport" content="width=device-width, initial-scale=1.0" /> <meta http-equiv="Content-Type" content="; charset=utf-8" /> <link rel="stylesheet" href="bootstrap.min.css" /> <link rel="stylesheet" href="../css/bootstrap-responsive.min.css" /> <link rel="stylesheet" href="../css/unicorn.main.css" /> <link rel="stylesheet" href="../css/uniform.css" /> <link rel="stylesheet" href="../css/unicorn.grey.css" class="skin-color" /> </head>
session_set_cookie_params(3600); session_start(); // 退出登陆 if (isset($_GET["logout"]) && isset($_GET["logout"]) == 1) { // session_unset(); // 删除两个以上的session /* 清除COOKIE setcookie("is_login",0,time()-1); setcookie('username',$name,time()-1); */ session_destroy(); } if ($_POST) { $name = $_POST["username"]; $pass = $_POST["password"]; $resdata = selectDb("SELECT register_password FROM wd_register WHERE register_name='{$name}'"); foreach ($resdata as $value) { if ($pass == $value["register_password"]) { // 设置是否登陆 // setcookie("is_login",1,time()+60*60); $_SESSION["is_login"] = 1; // 设置值 //setcookie('username',$name,time()+60*60); $_SESSION["username"] = $name; success("登陆成功", "./index.php"); } } error("登陆失败"); } ?> <!DOCTYPE html>
require "../include/inic.php"; if ($_POST) { delMore("del", "wd_friend_links", "friend_links_id", "./friend_links.php"); } $datacount = selectDb("SELECT * FROM wd_friend_links"); // 总记录数 $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 = selectDb("SELECT * FROM wd_friend_links ORDER BY friend_links_id DESC LIMIT {$offset},{$per_record}"); ?> <!doctype html> <html lang="zh-ch"> <!-- container-fluid --> <head> <title>文豆-后台管理</title> <meta charset="UTF-8" /> <meta name="viewport" content="width=device-width, initial-scale=1.0" /> <meta http-equiv="Content-Type" content="; charset=utf-8" /> <link rel="stylesheet" href="bootstrap.min.css" /> <link rel="stylesheet" href="../css/bootstrap-responsive.min.css" /> <link rel="stylesheet" href="../css/unicorn.main.css" /> <link rel="stylesheet" href="../css/uniform.css" /> <link rel="stylesheet" href="../css/unicorn.grey.css" class="skin-color" /> </head>
<?php /** * wengdo前台友链列表 * author: Jeffery * create time: 2015-09-08 */ // 此处报错BUG require "config.php"; // 查询wd_article表 $friendData = selectDb("SELECT * FROM `wd_friend_links` ORDER BY friend_links_id DESC"); // 查询sql语句 $sql = "SELECT * FROM `wd_option`"; $res = mysql_query($sql); $optiondata = array(); if (mysql_num_rows($res) > 0) { $rows = mysql_fetch_assoc($res); $optiondata = $rows; } ?> <footer> <div class="container"> <div class="row"> <div class="col-md-6"> <p>文豆集团 <?php echo $optiondata["copyright"]; ?> </p> <p>法律顾问:广东晟晨律师事务所-张勇律师</p> </div> <div class="col-md-6">
require "../include/inic.php"; if ($_POST) { delMore("del", "wd_meg", "meg_id", "./meg_list.php"); } $datacount = selectDb("SELECT * FROM wd_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 = selectDb("SELECT * FROM wd_meg ORDER BY meg_id DESC LIMIT {$offset},{$per_record}"); ?> <!doctype html> <html lang="zh-ch"> <!-- container-fluid --> <head> <title>文豆-后台管理</title> <meta charset="UTF-8" /> <meta name="viewport" content="width=device-width, initial-scale=1.0" /> <meta http-equiv="Content-Type" content="; charset=utf-8" /> <link rel="stylesheet" href="bootstrap.min.css" /> <link rel="stylesheet" href="../css/bootstrap-responsive.min.css" /> <link rel="stylesheet" href="../css/unicorn.main.css" /> <link rel="stylesheet" href="../css/uniform.css" /> <link rel="stylesheet" href="../css/unicorn.grey.css" class="skin-color" /> </head>
* wengdo后台添加导航 * author: Jeffery * create time: 2015-09-08 */ require "../include/inic.php"; $id = isset($_GET["id"]) ? (int) $_GET["id"] : 0; $id_data = editTable("SELECT * FROM wd_nav WHERE nav_id={$id}"); // 表单接收 if ($_POST) { $navName = $_POST["navName"]; $navLink = $_POST["navLink"]; $nav_pid = $_POST["nav_pid"]; // 修改sql语句 updateTable("UPDATE `wd_nav` SET \n\t\t`nav_name`='{$navName}',\n\t\t`nav_pid`='{$navLink}',\n\t\t`nav_links`='{$nav_pid}' WHERE nav_id={$id}", "./nav.php"); } $navpiddata = selectDb("SELECT * FROM wd_nav WHERE nav_pid=0"); // var_dump($id_data); ?> <!doctype html> <html lang="zh-ch"> <!-- container-fluid --> <head> <title>文豆-后台管理</title> <meta charset="UTF-8" /> <meta name="viewport" content="width=device-width, initial-scale=1.0" /> <meta http-equiv="Content-Type" content="; charset=utf-8" /> <link rel="stylesheet" href="bootstrap.min.css" /> <link rel="stylesheet" href="../css/bootstrap-responsive.min.css" /> <link rel="stylesheet" href="../css/unicorn.main.css" />
<?php require "include/inic.php"; $guestbookData = selectDb("SELECT * FROM `wd_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"> <title>文豆集团-首页</title> <!-- Bootstrap --> <link rel="stylesheet" href="css/bootstrap.min.css"> <link rel="stylesheet" href="css/base.css"> <link rel="stylesheet" href="css/child.css"> <!--[if lt IE 9]> <script src="http://cdn.bootcss.com/html5shiv/3.7.2/html5shiv.min.js"></script> <script src="http://cdn.bootcss.com/respond.js/1.4.2/respond.min.js"></script> <![endif]--> </head> <body> <?php require "include/header.php"; ?> <div class="guestbook"> <div class="container">
<?php /** * wengdo头部 * @author Jeffery * create time: 2015-09-05 */ require "config.php"; $data = selectDb("SELECT * FROM `wd_nav` WHERE nav_pid=0"); foreach ($data as $key => $value) { $sub_nav_item = array(); $sub_nav = array(); $sql = "select nav_name,nav_links from wd_nav where nav_pid =" . $value['nav_id']; $res = mysql_query($sql); if (mysql_num_rows($res) > 0) { while ($row = mysql_fetch_row($res)) { $sub_nav_item['nav_name'] = $row[0]; $sub_nav_item['nav_links'] = $row[1]; $sub_nav[] = $sub_nav_item; } } $data[$key]['sub_nav'] = $sub_nav; } ?> <header class="header"> <nav class="navbar navbar-default navbar-static-top navbar-fixed-top nav-height nav-bg"> <div class="container"> <div class="navbar-header"> <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar"> <span class="sr-only">Toggle navigation</span> <span class="icon-bar"></span>
* author: Jeffery * create time: 2015-09-08 */ require "include/inic.php"; $datacount = selectDb("SELECT * FROM wd_case"); // 总记录数 $total_record = count($datacount); // 每页记录数 $per_record = 6; // 总页数(总记录数/每页记录数) $page_num = ceil($total_record / $per_record); // 当前页数 $cur_id = isset($_GET["page"]) ? (int) $_GET["page"] : 1; $offset = ($cur_id - 1) * $per_record; // 查询 $casedata = selectDb("SELECT * FROM wd_case ORDER BY case_id DESC LIMIT {$offset},{$per_record}"); ?> <!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"> <title>文豆集团-首页</title> <!-- Bootstrap --> <link rel="stylesheet" href="css/bootstrap.min.css"> <link rel="stylesheet" href="css/base.css"> <link rel="stylesheet" href="css/child.css"> <link rel="stylesheet" href="css/ihover.min.css"> <!--[if lt IE 9]>
require "../include/inic.php"; if ($_POST) { delMore("del", "wd_register", "register_id", "./user_gl.php"); } $datacount = selectDb("SELECT * FROM wd_register"); // 总记录数 $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 = selectDb("SELECT * FROM wd_register ORDER BY register_id DESC LIMIT {$offset},{$per_record}"); ?> <!doctype html> <html lang="zh-ch"> <!-- container-fluid --> <head> <title>文豆-后台管理</title> <meta charset="UTF-8" /> <meta name="viewport" content="width=device-width, initial-scale=1.0" /> <meta http-equiv="Content-Type" content="; charset=utf-8" /> <link rel="stylesheet" href="bootstrap.min.css" /> <link rel="stylesheet" href="../css/bootstrap-responsive.min.css" /> <link rel="stylesheet" href="../css/unicorn.main.css" /> <link rel="stylesheet" href="../css/uniform.css" /> <link rel="stylesheet" href="../css/unicorn.grey.css" class="skin-color" /> </head>