PHP task::getFromDB方法代码示例

function listTasksByUser($inuserid)
{
    $tasks = array();
    $dbhandle = db_connect();
    $query = "SELECT TaskID FROM Tasks WHERE Lister={$inuserid}";
    $result = $dbhandle->query($query);
    while ($row = $result->fetch_array()) {
        $newtask = new task();
        $newtask->getFromDB($row['TaskID']);
        if ($newtask->active == 0) {
            continue;
        }
        array_push($tasks, $newtask);
    }
    $dbhandle->close();
    return $tasks;
}

<?php

require_once 'db_connect.php';
require_once 'task_class.php';
//Is run by the server periodically to check if a task has ended.
$dbhandle = db_connect();
$stmt = $dbhandle->stmt_init();
$stmt->prepare("SELECT TaskID, (EndDateTime - ?) AS TimeRemaining FROM Tasks WHERE Active=1 HAVING TimeRemaining<=0");
$stmt->bind_param("i", time());
$stmt->execute();
$stmt->store_result();
$stmt->bind_result($taskID, $tmptime);
while ($stmt->fetch()) {
    $task = new task();
    $task->getFromDB($taskID);
    $task->endTask();
    unset($task);
}
$stmt->close();
$dbhandle->close();

    session_start();
}
//get the id of the task to be reviewed, blank page if none
$intaskid;
if (isset($_GET['id'])) {
    $intaskid = $_GET['id'];
} else {
    die;
}
if (!isset($_SESSION['userid'])) {
    die;
}
$error = array();
//get the task info
$task = new task();
$error = $task->getFromDB($intaskid);
if ($error != NULL) {
    die;
}
//review form was submitted
if (isset($_POST['submit'])) {
    //prepare review info to be sent to POST
    $_POST['taskid'] = $intaskid;
    $review = new review();
    $error = $review->getFromPOST($_POST);
    if (count($error) == 0) {
        $_SESSION['msg_reviewed'] = "Review placed";
        header("Location: /ViewTask.php?id=" . $intaskid);
        die;
    } else {
        die;

 public function initialize($info)
 {
     $error = array();
     //check if task exists
     $task = new task();
     if (isset($info['taskid']) && $task->checkExistence($info['taskid'])) {
         $this->taskid = $info['taskid'];
     } else {
         $error['taskid'] = true;
     }
     //check if task is already rated
     //strip tags from comment before adding
     if (isset($info['comment'])) {
         $this->comment = strip_tags($info['comment']);
     } else {
         $error['comment'] = true;
     }
     //check if rating is a number between 0 and 5 inclusive
     if (isset($info['rating']) && is_numeric($info['rating']) && $info['rating'] >= 0 && $info['rating'] <= 5) {
         $this->rating = $info['rating'];
     } else {
         $error['rating'] = true;
     }
     //1 if a Doer rating, 0 if a Lister rating
     //determine if Lister or Doer
     $task->getFromDB($this->taskid);
     $bidwinner = $task->getBidLeaderID();
     //Must be logged in
     if (!isset($_SESSION['userid'])) {
         $error['login'] = true;
     } else {
         //If you're the winner, you are leaving a review for the Lister
         if ($_SESSION['userid'] == $bidwinner) {
             $this->reviewee_uid = $task->userid;
             $this->listerOrDoer = false;
         } else {
             if ($_SESSION['userid'] == $task->userid) {
                 $this->reviewee_uid = $bidwinner;
                 $this->listerOrDoer = true;
             } else {
                 $error['notinvolved'] = true;
             }
         }
     }
     $this->timestamp = time();
     return $error;
 }

<?php

require_once 'task_class.php';
if (isset($_POST['taskid'])) {
    $task = new task();
    $task->getFromDB($_POST['taskid']);
} else {
    $error['invalidtaskid'] = true;
    echo json_encode($error);
    return;
}
if (isset($_POST['bidderid']) && isset($_POST['bidamt'])) {
    $error = $task->addBid($_POST['bidderid'], $_POST['bidamt']);
    if ($error == null) {
        $error['Success'] = true;
    }
    echo json_encode($error);
} else {
    $error['invalidbidderidorbidamt'] = true;
    echo json_encode($error);
}