oxstate.php

Go to the documentation of this file.

<?php

class oxState extends oxI18n
{

    protected $_sClassName = 'oxstate';

    public function __construct()
    {
        parent::__construct();
        $this->init("oxstates");
    }

    public function getIdByCode($sCode, $sCountryId)
    {
        $oDb = oxDb::getDb();

        return $oDb->getOne(
            "SELECT oxid FROM oxstates WHERE oxisoalpha2 = " . $oDb->quote(
                $sCode
            ) . " AND oxcountryid = " . $oDb->quote($sCountryId)
        );
    }

    public function getTitleById($iStateId)
    {
        $oDb = oxDb::getDb();
        $sQ = "SELECT oxtitle FROM " . getViewName("oxstates") . " WHERE oxid = " . $oDb->quote($iStateId);
        $sStateTitle = $oDb->getOne($sQ);

        return (string) $sStateTitle;
    }
}