public function __construct($url)
{
$db = new DBconnect();
$query = "SELECT * FROM news WHERE url ='{$url}'";
$res = $db->getData($query);
$this->title = $res['tittle'];
$this->date = $res['date'];
$this->pre_text = $res['pre_text'];
$this->content = $res['content'];
}
function select($id)
{
$db = new DBconnect();
$conn = $db->open();
$sql = "select * from news where id = " . $id;
$result = mysql_query($sql, $conn);
$row = mysql_fetch_array($result);
$arr = array('id' => $row['id'], 'typeid' => $row['typeid'], 'title' => $row['title'], 'content' => $row['content'], 'time' => $row['time']);
mysql_free_result($result);
//释放结果集
$db->close($conn);
return $arr;
}
function update($id, $rid, $title, $editer, $image, $time)
{
$db = new DBconnect();
$msg = "";
$conn = $db->open();
$sql = "update lzu_st_news set rid='{$rid}',title='{$title}',editer='{$editer}',image='{$image}',time='{$time}' where id=" . $id;
if (mysql_query($sql, $conn)) {
$msg = "任务更新成功";
} else {
$msg = "任务更新失败";
}
$db->close($conn);
return $msg;
}
function __construct()
{
$this->DBconnect = DBconnect::getInstance();
$this->personal['surname'] = $_SESSION['surname'];
$this->personal['name'] = $_SESSION['name'];
$this->personal['id'] = $_SESSION['id'];
$this->terminy = TerminDAO::getTerminyPedagoga($this->personal['id']);
}
function __construct()
{
$this->DBconnect = DBconnect::getInstance();
$this->personal['surname'] = $_SESSION['surname'];
$this->personal['name'] = $_SESSION['name'];
$this->personal['id'] = $_SESSION['id'];
$this->terminyVypsane = StudentDAO::getVypsaneTerminy($this->personal['id']);
$this->terminyZapsane = StudentDAO::getZapsaneTerminy($this->personal['id']);
}
public static function getMistnosti()
{
$rooms = array();
$DBconnect = DBconnect::getInstance();
$query = 'SELECT * FROM mistnosti m';
$table_result = $DBconnect->query($query);
while ($row = $table_result->fetch_assoc()) {
array_push($rooms, $row);
}
return $rooms;
}
public static function getTerminyProId($id)
{
$terminy = array();
$DBconnect = DBconnect::getInstance();
$query = 'SELECT * FROM Vypsane_terminy v
WHERE v.id_terminu = ' . $id;
$table_result = $DBconnect->query($query);
while ($row = $table_result->fetch_assoc()) {
array_push($terminy, $row);
}
return $terminy;
}
public static function getSubjects($id)
{
$subjects = array();
$DBconnect = DBconnect::getInstance();
$query = 'SELECT * FROM pedagogove_predmety p
WHERE p.Pedagogove_kod_pedagoga = ' . $id;
$table_result = $DBconnect->query($query);
while ($row = $table_result->fetch_assoc()) {
array_push($subjects, $row);
}
return $subjects;
}
public function delete($item)
{
$dbs = new DBconnect();
$doc = $dbs->find($item);
if ($doc) {
if ($doc->delete()) {
return Response::json(array('message' => 'success'));
} else {
return Response::json(array('message' => 'error'));
}
} else {
$doc = $dbs->where('memberName', $item);
if (isset($doc->get()[0])) {
if ($doc->delete()) {
return Response::json(array('message' => 'success'));
} else {
return Response::json(array('message' => 'error'));
}
} else {
return Response::json(array('message' => 'not found'));
}
}
}
<?php
include_once '../Controler/DBconnect.php';
$connect = DBconnect::getInstance();
session_start();
$table = getTable();
$query = 'SELECT * FROM ' . getTable() . ' WHERE prijmeni = \'' . $_POST['username'] . '\' AND heslo = \'' . $_POST['password'] . '\'';
$redirectTo = '';
$table_result = $connect->query($query);
if ($table_result->num_rows > 0) {
$_SESSION['logged'] = 1;
$table_row = $table_result->fetch_assoc();
if ($table == 'studenti') {
$redirectTo = $_POST['role'];
$_SESSION['id'] = $table_row['kod_studenta'];
$_SESSION['name'] = $table_row['jmeno'];
$_SESSION['surname'] = $table_row['prijmeni'];
$_SESSION['page'] = "student";
} else {
$redirectTo = $_POST['role'];
$_SESSION['id'] = $table_row['kod_pedagoga'];
$_SESSION['name'] = $table_row['jmeno'];
$_SESSION['surname'] = $table_row['prijmeni'];
$_SESSION['page'] = "teacher";
}
print 'Přihlášení úspěšné';
} else {
print 'Přihlášení neúspěšné, zkuste se přihlásit znovu prosím.';
}
header("Refresh:2; url=../index.php?page=" . $redirectTo, true, 303);
function getTable()
<?php
/*
*/
include 'admin/dbconnect.php';
include 'smarty_init.php';
//从数据库中取出相关信息
$dbconnect = new DBconnect();
$conn = $dbconnect->open();
//显示
$sql = "select * from lzu_st_news order by id desc ";
$res = mysql_query($sql, $conn);
$i = 1;
if (mysql_num_rows($res) > 0) {
while ($row = mysql_fetch_array($res)) {
if ($row['rid'] == 0) {
$t0[$i]['title'] = $row['title'];
$t0[$i]['time'] = $row['time'];
$t0[$i]['id'] = $row['id'];
$i++;
continue;
}
if ($row['rid'] == 1) {
$t1[$i]['title'] = $row['title'];
$t1[$i]['time'] = $row['time'];
$t1[$i]['id'] = $row['id'];
$i++;
continue;
}
if ($row['rid'] == 2) {
$t2[$i]['title'] = $row['title'];
public function connection()
{
$database_connect = new DBconnect();
$connection = $database_connect->connect();
return $connection;
}
<?php
session_start();
//初始化信息
include 'smarty_init.php';
include "dbconnect.php";
include 'checklogin.php';
//header("Content-Type:text/html;charset=utf-8");
$dbconnect = new DBconnect();
$conn = $dbconnect->open();
check_admin();
$action = $_GET['action'];
$q_id = $_GET['id'];
switch ($action) {
case 'selectone':
//查询单条相关信息
$sql = "select title,starttime,stoptime,user,content from list where id=" . $q_id;
$res = mysql_query($sql);
$row1 = mysql_fetch_array($res);
$rc = "../{$row1['content']}";
$filename = $rc;
$fe = fopen($filename, 'rt');
$content = fread($fe, filesize($filename));
fclose($fe);
$smarty->assign('title', $row1['title']);
$smarty->assign('starttime', $row1['starttime']);
$smarty->assign('stoptime', $row1['stoptime']);
$smarty->assign('user', $row1['user']);
$smarty->assign('content', $content);
$smarty->display('singleNews.html');
break;
<?php require_once $_SERVER['DOCUMENT_ROOT'] . "/mvc/app/models/DBconnect.php"; $db_news = new DBconnect(); $query_news = "SElECT * FROM news"; $data_news = $db_news->getData($query_news);
