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);