PHP Database::select_query Examples

Example #1

File: ContentOnUser.php Project: therubberduck/norn

 public static function get()
 {
     include_once 'Content.php';
     $whereString = "cu." . self::USERID . "='" . $_POST['userid'] . "'";
     if (isset($_POST['visible']) && $_POST['visible']) {
         $whereString .= " AND c." . Content::VISIBLE . "='" . $_POST['visible'] . "'";
     }
     $query = "SELECT cu." . self::ID . ", cu." . self::CONTENTID . ", cu." . self::NUMBER . ", cu." . self::DETAIL . ", c." . Content::TITLE . "\n                FROM " . self::TABLE_NAME . " AS cu INNER JOIN " . Content::TABLE_NAME . " AS c ON cu." . self::CONTENTID . " = c." . Content::ID . "\n                WHERE " . $whereString;
     $result = Database::select_query($query);
     echo json_encode($result);
 }