ChQuotesDb.php

Go to the documentation of this file.

<?php
 
require_once( CH_DIRECTORY_PATH_CLASSES . 'ChWsbModuleDb.php' );
 
define('CH_QUOTES_TABLE', 'ch_quotes_units');
 
/*
* Quotes module Data
*/
class ChQuotesDb extends ChWsbModuleDb
{
    var $_oConfig;
    /*
    * Constructor.
    */
    function __construct(&$oConfig)
    {
        parent::__construct();
 
        $this->_oConfig = $oConfig;
    }
 
    function getRandomQuote()
    {
        return $this->getRow("SELECT `Text`, `Author` FROM `" . CH_QUOTES_TABLE . "` ORDER BY RAND() LIMIT 1");
    }
    function getQuote($iID)
    {
        return $this->getRow("SELECT * FROM `" . CH_QUOTES_TABLE . "` WHERE `ID`= ? LIMIT 1", [$iID]);
    }
    function getAllQuotes()
    {
        return $this->getAll("SELECT * FROM `" . CH_QUOTES_TABLE . "`");
    }
    function deleteUnit($iID)
    {
        return $this->query("DELETE FROM `" . CH_QUOTES_TABLE . "` WHERE `ID`= ? LIMIT 1", [$iID]);
    }
}