public static function isValidContext($contextDesc) { $db = Zend_Registry::get('my_db'); $context = new Contexts($db); $where = "lower(context_desc) = lower('{$contextDesc}')"; $result = $context->fetchAll($where); if ($result->count() > 0) { return true; } else { return false; } }
public static function checkContextExist($contextName) { $db = Zend_Registry::get('my_db'); $c = new Contexts($db); $quotedName = $db->quote($contextName); $result = $c->fetchAll("upper(context_desc) = upper({$quotedName})"); $rows = $result->count(); if ($rows == 0) { return false; } else { switch (DB_TYPE) { case 'mysql': $_SESSION['CONTEXT_ID'] = $result[0]->context_id; break; case 'oci8': $_SESSION['CONTEXT_ID'] = $result[0]->CONTEXT_ID; break; } return true; } }
private function buildContexts($domElement, $dom) { $db = ZitDBAdapter::getDBAdapter(); $contexts = new Contexts($db); // $query = "select context_desc from context"; // $result = $db->fetchAll($query); $result = $contexts->fetchAll(); foreach ($result as $row) { $contextNode = $dom->createElement('SIF_Context'); switch (DB_TYPE) { case 'mysql': $contextNode->appendChild($dom->createTextNode($row->context_desc)); break; case 'oci8': $contextNode->appendChild($dom->createTextNode($row->CONTEXT_DESC)); break; } $domElement->appendChild($contextNode); } return $domElement; }