/**
* 获取所有管理员
* @return multitype
*/
function getAllAdmin()
{
//$where = $where==null?null:$where;
$sql = "select id,username,email from imooc_admin";
$rows = fetchAll($sql);
return $rows;
}
function checkMilestone($class, $action)
{
if (!$class) {
$action();
return;
}
$milestones = fetchAll("SELECT points FROM milestone ORDER BY points ASC");
$startPoints = array_pop(calculatePoints($class)["points"]);
$action();
$endPoints = array_pop(calculatePoints($class)["points"]);
$achieved = [];
foreach ($milestones as $stone) {
if ($stone->points > $endPoints) {
break;
}
if ($stone->points > $startPoints) {
array_push($achieved, $stone->points);
}
}
if (empty($achieved)) {
return;
}
$classInfo = fetch("SELECT c.name, u.email FROM class AS c JOIN user AS u ON c.teacher = u.id");
$n = "";
if (count($achieved) > 1) {
$n = "n";
}
foreach (fetchAll("SELECT email FROM user WHERE role = :admin", ["admin" => ADMIN]) as $admin) {
own_mail($admin->email, "Etappe{$n} erreicht", "Guten Tag,\r\nDie Klasse \"{$classInfo->name}\" hat die Etappe{$n} " . implode(", ", $achieved) . " erreicht!\r\nDie Lehrkraft ist: {$classInfo->email} \r\n\r\nNachhaltige Grüße\r\nIhre Weltfairsteher-Website");
}
own_mail($classInfo->email, "Etappe{$n} erreicht", "Herzlichen Glückwunsch, Ihre Klasse \"{$classInfo->name}\" hat bei WeltFAIRsteher die Etappe{$n} " . implode(", ", $achieved) . " erreicht!\r\nSie erhalten demnächst eine Überraschung per Post\r\n\r\nNachhaltige Grüße\r\nIhr WeltFAIRsteher-Team");
}
function month_total_fee($month)
{
$year = explode('-', $month)[0];
$mon = explode('-', $month)[1];
//获取需要的月份相应交费记录并计算总费用
$sql = "select fee,date,dueDate from hh_fee";
$rows = fetchAll($sql);
$total = 0;
foreach ($rows as $row) {
$day1 = $row['date'];
$day2 = $row['dueDate'];
$fee = $row['fee'];
$T = ceil($fee / days_dis($day1, $day2));
//$T为 该笔学费每天的收入
$days = month_days($day1, $day2, $month);
if ($days) {
$total = $days * $T + $total;
}
}
$arr = array('year' => $year, 'month' => $mon, 'total' => $total);
//如果已存在相应日期记录，则进行更新操作，否则进行插入
$sql = "select count(total) from hh_totalFee where year={$year} and month={$mon}";
$result = fetchOne($sql)['count(total)'];
if ($result >= 1) {
update('hh_totalFee', $arr, "year={$year} and month={$mon}");
} else {
insert('hh_totalFee', $arr);
}
}
function getAdminByPage($page, $pageSize = 2)
{
$sql = "select * from imooc_admin";
//得到所有记录的记录数,这里把$totalRows变成全局变量，是方便listAdmin在判断总记录数，并判断显示页码时调用
global $totalRows;
$totalRows = getResultNum($sql);
//$pageSize记录每页显示几条，
$pageSize = 2;
//得到总页码数,这里把$totalPage设为全局变量，是方便listAdmin.php的总页数调用显示
global $totalPage;
$totalPage = ceil($totalRows / $pageSize);
//设置当前默认页数,这里把$page设为全局变量，是方便page.func.php在获取当前页时调用
global $page;
//判断是否小于1，是否为空，或者不是数字，则都为$page都为1
if ($page < 1 || $page == null || !is_numeric($page)) {
$page = 1;
}
if ($page >= $totalPage) {
$page = $totalPage;
}
$offset = ($page - 1) * $pageSize;
$sql = "select id,username,email from imooc_admin limit {$offset},{$pageSize}";
$rows = fetchAll($sql);
return $rows;
}
public function getMyArticles()
{
//$vConex = conexSys();
$tipos = $this->prepareTypes($this->types);
$Q_EPUB = "SELECT AR.Titulo as Titulo,\n AR.Descripcion as Descripcion,\n CA.Descripcion as categorias,\n AL.TipoProducto as TipProducto,\n AR.ProductoFab As Producto,\n AL.AlmacenCod As CodAlmacen,\n CA.CategoriCod as categoryId,\n CA.Imagen,\n CA.Descripcion as CategoryTitle,\n TP.Descripcion as DescripTipoProd,\n MA.IdFacturasCab,\n CA.Color\n FROM matriculas MA \n INNER JOIN almacen AL ON MA.Producto = AL.AlmacenCod \n INNER JOIN articulos AR ON AR.Producto = AL.Producto \n INNER JOIN categorias CA on AR.Categoria = CA.CategoriCod\n INNER JOIN tipoproducto TP on AL.TipoProducto = TP.TipoProductoId \n ";
if ($this->usuarioEntidad != null && $this->usuarioEntidad != '') {
$Q_EPUB .= " WHERE MA.Estado = 'Matriculado' AND MA.Cliente = '" . $this->usuarioEntidad . "Alumno' ";
} else {
if ($this->CodAlmacen != null && $this->CodAlmacen != '') {
$Q_EPUB .= " WHERE AL.AlmacenCod = '" . $this->CodAlmacen . "' ";
}
}
$Q_EPUB .= " AND (" . $tipos . ") ";
$MxEPUB = fetchAll($Q_EPUB);
//Creando un array para almacenar los cursos del programa
$jsonData = $this->getDefault($this->types);
foreach ($MxEPUB as $EPUB) {
foreach ($this->types as $key => $value) {
if ($EPUB->TipProducto == $value) {
$articlesType = $jsonData[$value]["articles"];
array_push($articlesType, $EPUB);
$jsonData[$value]["articles"] = $articlesType;
}
}
}
$jsonData["success"] = true;
WE(json_encode($jsonData));
}
function getUser($ar)
{
if (empty($ar['email']) || empty($ar['password'])) {
echo json_encode(['error' => 'empty parameter']);
return;
}
$res = fetchAll('SELECT * FROM users WHERE email=? AND password=?', [$ar['email'], $ar['password']]);
if (!empty($res)) {
foreach ($res as $key => $value) {
unset($res[$key]['password']);
}
} else {
echo json_encode(['error' => 'wrong combination']);
}
echo json_encode($res);
}
public function __call($name, $arguments)
{
if (in_array($name, $this->query) && $arguments) {
if (count($arguments) == 2) {
return $this->database->{$name}($this->table, $arguments[0], $arguments[1]);
} elseif (count($arguments) == 1) {
return $this->database->{$name}($this->table, $arguments[0]);
}
} elseif (in_array($name, $this->advanced) && $arguments) {
if ($name == 'query' && $arguments[1] == true) {
return $this->database->{$name}($arguments[0]) > fetchAll();
} else {
return $this->database->{$name}($arguments[0]);
}
} else {
throw new \Exception("暂不支持此操作", 1);
}
}
function getAdminByPage($pageSize = 2)
{
$sql = "select * from myshop_admin";
$totalRows = getResultNum($sql);
$pageSize = 2;
$totalPage = ceil($totalRows / $pageSize);
$page = $_REQUEST['page'] ? (int) $_REQUEST['page'] : 1;
if ($page < 1 || $page == null || !is_numeric($page)) {
$page = 1;
}
if ($page >= $totalPage) {
$page = $totalPage;
}
$offset = ($page - 1) * $pageSize;
$sql = "select id,username,email from myshop_admin limit {$offset},{$pageSize}";
$rows = fetchAll($sql);
return $rows;
}
function getAdminByPage($page, $pageSize = 2)
{
$sql = "select * from imooc_admin";
global $totalRows;
$totalRows = getResultNum($sql);
global $totalPage;
$totalPage = ceil($totalRows / $pageSize);
if ($page < 1 || $page == null || !is_numeric($page)) {
$page = 1;
}
if ($page >= $totalPage) {
$page = $totalPage;
}
$offset = ($page - 1) * $pageSize;
$sql = "select id,username,email from imooc_admin limit {$offset},{$pageSize}";
$rows = fetchAll($sql);
return $rows;
}
background-color:#1BAB3F;
padding: 10px;
height: auto;
text-align: center">
<h4 style="color: white;">Feedback: Einzelne Challenges bewerten</h4>
<a href="javascript:void(0)" onclick="return toggleArrow(this, '#feedback')" style="background-color: white; margin-top: 10px;
border: 2px solid white; border-radius: 30px;"
><i class="fa fa-arrow-down"></i></a><br>
<span id="feedback" style="display:none; font-size: 12px;">
Bitte jede Challenge-Bewertung einzeln abschicken. Die Daten gehen anonym ein.<br><br>
<form id="addFeedback" action="javascript:void(0);" onsubmit="sendForm(this)">
<b>Die Challenge:</b> <select style="color: black;" name="challenge">
<?php
foreach (fetchAll("SELECT id, name FROM challenge") as $c) {
?>
<option style="color: black;" value="<?php
echo e($c->id);
?>
"><?php
echo e($c->name);
?>
</option><br>
<?php
}
?>
</select>
<br><br>
<b>...machte den Schüler*innen Spaß:</b><br>
Nein:<input class="" type="radio" name="fun" value="1" /><br>
function getPageNumByPid($uid, $pid)
{
$sql = "select pid from zhx_post where uid={$uid} order by date desc";
$rows = fetchAll($sql);
$i = 0;
$n = 0;
foreach ($rows as $row) {
if ($i % pageSize == 0) {
$n++;
// echo $n." ".$i." and ".$row['pid']."<br>";
if ($row['pid'] < $pid) {
return $n - 1;
}
}
$i++;
}
return $n;
}
function editPro($active, $pro_id)
{
if ($active == 'editDetails') {
$arr = $_POST;
$sql = "select id,album_path from tuhao_album where pid={$pro_id}";
$rows = fetchAll($sql);
$srcNum = count($rows);
$path = "../uploads";
$uploadFiles = uploadFile($path);
$uploadNum = count($uploadFiles);
if ($uploadNum < $srcNum) {
$i = 0;
foreach ($uploadFiles as $uploadFile) {
$array = array('album_path' => $uploadFile['name']);
unlink("../uploads/" . $rows[$i]['album_path']);
update("tuhao_album", $array, "id={$rows[$i]['id']}");
$i++;
}
for ($j = $i; $j < $srcNum; $j++) {
delete("tuhao_album", "id={$rows[$j]['id']}");
unlink("../uploads/" . $rows[$j]['album_path']);
}
} elseif ($uploadNum == $srcNum) {
$i = 0;
foreach ($uploadFiles as $uploadFile) {
$updateArr = array('album_path' => $uploadFile['name']);
unlink("../uploads/" . $rows[$i]['album_path']);
update("tuhao_album", $updateArr, "id={$rows[$i]['id']}");
$i++;
}
} elseif ($uploadNum > $srcNum) {
$i = 0;
foreach ($rows as $row) {
$updateArr = array('album_path' => $uploadFiles[$i]['name']);
unlink("../uploads/" . $row['album_path']);
update("tuhao_album", $updateArr, "id={$row['id']}");
$i++;
}
for ($j = $i; $j < $uploadNum; $j++) {
$insertArr = array('pid' => $pro_id, 'album_path' => $uploadFiles[$j]['name']);
insert("tuhao_album", $insertArr);
}
}
if (update("tuhao_pro", $arr, "id={$pro_id}")) {
$message = array('success' => true, 'mes' => "编辑成功", 'pro_id' => $pro_id);
} else {
$message = array('success' => false, 'mes' => "编辑失败", 'pro_id' => $pro_id);
}
} elseif ($active == 'delete') {
if (delete("tuhao_pro", "id={$pro_id}") && delete("tuhao_album", "pid={$pro_id}") && delete("tuhao_comm", "pro_id={$pro_id}")) {
$message = array('success' => true, 'mes' => "删除成功");
} else {
$message = array('success' => false, 'mes' => "删除失败");
}
}
return json_encode($message);
}
/**
*得到商品ID和商品名称
* @return array
*/
function getProInfo()
{
$sql = "select id,pName from imooc_pro order by id asc";
$rows = fetchAll($sql);
return $rows;
}
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Insert title here</title>
</head>
<body>
<h1>商品列表</h1>
<?php
if ($pageCount) {
// 获取页码,以计算偏移值
$pageno = (int) $_GET['pageno'];
$pageno = $pageno <= 0 ? 1 : $pageno;
$pageno = $pageno > $pageCount ? $pageCount : $pageno;
$offset = ($pageno - 1) * $pagesize;
$sql = "SELECT id,proName,proPrice,status FROM products " . $where . " LIMIT {$offset},{$pagesize}";
$rowset = fetchAll($sql);
?>
<table width="100%" cellpadding="10" cellspacing="0" border="1">
<tr>
<td width="30">?</td>
<td>商品名称</td>
<td>销售价格</td>
<td>状态</td>
<td>操作</td>
</tr>
<?php
foreach ($rowset as $row) {
?>
<tr>
<td width="30">?</td>
<td><?php
function getSubTemas()
{
$sql = 'SELECT rs.* FROM (
SELECT
st.SubTemaCod, st.Descripcion, st.TituloArticulo,
st.NombreArchivo, st.Formato, st.TipoSubtema,
st.TipoTema, st.ContenidoArticulo, st.Entidad,
Ue.Codigo, ue.Usuario, ue.EntidadCreadora,
Us.Nombres AS EmpresaNombre, u.Carpeta, u.Nombres AS username, st.Tema, t.Curso
FROM subtema st
INNER JOIN tema t ON t.CodTema = st.Tema
INNER JOIN usuarios u ON st.Entidad = u.IdUsuario
INNER JOIN usuario_entidad ue ON u.Usuario = ue.Usuario
INNER JOIN usuarios us ON ue.EntidadCreadora = us.Usuario
WHERE
st.Componente IN (0, \'\')
AND st.TipoTema IN ( \'Documento\', \'Video\', \'Embebido\' )
) AS rs
LEFT JOIN archivocontenido ac ON rs.NombreArchivo = ac.Archivo
WHERE
ac.Archivo IS NULL';
return fetchAll($sql);
}
/**
* 得到所有分类
* @return array
*/
function getAllCate()
{
$sql = "select id,cName from imooc_cate";
$rows = fetchAll($sql);
return $rows;
}
function getAllAdmin()
{
$sql = "select id,username,email from biogas_admin";
$rows = fetchAll($sql);
return $rows;
}
<?php
/**
* Created by PhpStorm.
* User: ray
* Date: 7/29/15
* Time: 11:30 AM
*/
require_once '../include.php';
$cityname = fetchAll("select id,city from biogas_city");
$num_city = count($cityname);
$cName = array();
$cId = array();
$cGas = array();
$gas_total = 0;
for ($i = 0; $i < $num_city; $i++) {
$cName[$i] = $cityname[$i]['city'];
$cGas[$i] = queryTotalGas($cityname[$i]['id']);
$gas_total = $gas_total + $cGas[$i];
}
$res = array();
foreach ($cName as $k => $r) {
$res[] = array($cName[$k], $cGas[$k]);
}
$json_res = json_encode($res);
?>
<!DOCTYPE HTML>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</div>
<!--/.col-xs-6.col-lg-4-->
</div>
<!--/row-->
</div>
<!--/.col-xs-12.col-sm-9-->
<div class="col-xs-6 col-sm-3 sidebar-offcanvas" id="sidebar">
<div class="list-group">
<h2>点击排行</h2>
<ul class="list-inline row text-center">
<?php
$sql = "select * from video where type = {$_GET['type']} order by hint desc limit 0,6";
$rows = fetchAll($sql);
for ($i = 0; $i < count($rows); $i++) {
?>
<li class="col-xs-12 col-lg-6">
<img src="assets/images/<?php
echo $rows[$i]['pic'];
?>
" class="responsive img-thumbnail"/>
<p><a href="show.php?id=<?php
echo $rows[$i]['id'];
?>
"><?php
echo $rows[$i]['name'];
?>
</a>
function getSmallProsByCid($cid)
{
$sql = "select p.id,p.pName,p.iPrice from imooc_pro as p join imooc_cate c on p.cId=c.id where p.cid={$cid} limit 4,4";
$rows = fetchAll($sql);
return $rows;
}
function getUsersMBDevicesByUID($uid)
{
global $link;
$devidsRow = '';
$devices = array();
$query = "SELECT * FROM `dev_user` WHERE `uid` = {$uid} AND `devid` IN (SELECT `devid` FROM `dev_fields` WHERE `key` = 'devtypeid' AND `value` IN (SELECT `devtypeid` FROM `dev_types` WHERE `portal` = 1))";
$userDeviceTmp = fetchAll($query, $link);
foreach ($userDeviceTmp as $row) {
$devidsRow .= $row['devid'] . ',';
$userDevice[$row['devid']] = $row['uid'];
}
$devidsRow = substr($devidsRow, 0, -1);
if (!empty($devidsRow)) {
$query = "SELECT * FROM `dev_fields` WHERE `devid` IN ({$devidsRow})";
# по каждому новому абоненту выберем и соберём его оборудование из MikBiLL
$devicesTmp = fetchAll($query, $link);
# нужно "собрать" устройства
foreach ($devicesTmp as $device) {
$devices[$device['devid']][$device['key']] = $device['value'];
}
}
return $devices;
}
function getAvatarPath($id)
{
$db = dbConnect();
$sql = "SELECT u.id,u.avatar_id,m.url,m.extension FROM accounts u,media m WHERE u.id = {$id} AND u.avatar_id = m.id";
$getAvatar = $db->query($sql);
$rows = fetchAll($getAvatar);
return $rows[0]["url"] . "_100x100." . $rows[0]["extension"];
}
function getMemberScore($mid)
{
$sql = "select * from hh_score where mid={$mid} order by date desc";
$rows = fetchAll($sql);
return $rows;
}
function initLang()
{
$lang_default = query("SELECT * FROM localization");
$lang_default = fetchAll($lang_default);
foreach ($lang_default as $row) {
$lang_d[$row['tag']] = $row['EN'];
}
$lang_custom = query("SELECT * FROM `" . $this->user['database'] . "`.localization");
$lang_custom = fetchAll($lang_custom);
foreach ($lang_custom as $row) {
$lang_c[$row['tag']] = $row['EN'];
}
$this->lang = array_merge($lang_d, $lang_c);
}
<?php
require_once 'inc_admin.php';
mysql_query("set names utf8");
$rows = fetchAll("select * from video");
$totalNum = count($rows);
echo '<p>A total of ' . $totalNum . '<br/></p>';
?>
<!--PAGE CONTENT -->
<div id="content">
<div class="inner" style="min-height:1200px;">
<div class="row">
<div class="col-xs-12">
<h1>LIST OF VIDEO</h1>
<div class="table-responsive">
<table class="table table-hover">
<thead>
<tr>
<th>视频名字</th>
<th>视频类型</th>
<th>添加时间</th>
<th>播放次数</th>
<th>海报</th>
<th>视频简介</th>
<th>下载地址</th>
<th>下载次数</th>
<th>操作</th>
</tr>
</thead>
<tbody>
/**
* 得到所有分类
* @return array
*/
function getAllCate()
{
$sql = "select id,cName from category";
$rows = fetchAll($sql);
return $rows;
}
</div></li>
<?php
}
?>
</ul>
<a href="index_TZGG.php" class="more">更多>></a>
</div>
<div class="half right">
<h2>资源下载</h2>
<ul class="list_bullet">
<?php
$sql = "SELECT * FROM `index_ZYXZ` ORDER BY id DESC LIMIT 5";
$result = fetchAll($sql);
foreach ($result as $row) {
$id = $row['id'];
$title = $row['title'];
$times = $row['times'];
//分割时间字符串
$time = explode(" ", $times);
?>
<li ><a href = "index_ZYXZ.php?id=<?php
echo $id;
?>
"><?php
echo $title;
?>
</a><div style="float:right"><?php
/**
* 得到所有分类
* @return array
*/
function getAllCate()
{
$sql = "select type_id,type from tigris_user_type";
$rows = fetchAll($sql);
return $rows;
}
require_once '../include.php';
if (!empty($_POST['longnum'])) {
$usernum = $_POST['longnum'];
$numberArray = array();
$phonebook_one = array();
$phonebook_all = array();
$jsonArray = array();
$sql_contacts = "SELECT * FROM contacts where longnum ='{$usernum}'";
$user_arr = fetchOne($sql_contacts);
if ($user_arr != null) {
$user_pb = $user_arr['phonebook_id'];
$sql_phonebook = "SELECT * FROM phonebook where phonebook_id REGEXP '{$user_pb}'";
$phonebook_arr = fetchAll($sql_phonebook);
foreach ($phonebook_arr as $key => $value) {
$sql_contacts = "SELECT * FROM contacts where phonebook_id REGEXP '{$value['phonebook_id']}'";
$contacts_arr = fetchAll($sql_contacts);
$contacts_print = array();
foreach ($contacts_arr as $key_contacts => $value_contacts) {
$temp_arr = array();
$temp_arr['name'] = $value_contacts['name'];
$temp_arr['longnum'] = $value_contacts['longnum'];
$temp_arr['shortnum'] = $value_contacts['shortnum'];
array_push($contacts_print, $temp_arr);
}
$phonebook_one['book_id'] = $value['phonebook_id'];
$phonebook_one['book_version'] = $value['phonebook_version'];
$phonebook_one['book_name'] = $value['name'];
$phonebook_one['book_intr'] = $value['intr'];
$phonebook_one['book_logo'] = $value['logo'];
$phonebook_one['content'] = $contacts_print;
array_push($phonebook_all, $phonebook_one);
/**
* 根据商品id得到所有图片
* @param int $id
* @return array
*/
function getProImgsById($id)
{
$sql = "select albumPath from imooc_album where pid={$id} ";
$rows = fetchAll($sql);
return $rows;
}
