private function get_elements_private_status_by_value($search_string, $element_name = "Title", $collection_id = 4) { $db = get_db(); $config = $db->getAdapter()->getConfig(); $db_hack = new Zend_Db_Adapter_Pdo_Mysql(array('host' => $config["host"], 'username' => $config["username"], 'password' => $config["password"], 'dbname' => $config["dbname"])); if (!$db->getConnection()) { _log("__CONNECTION ROTTEN IN get_elements_private_status_by_value"); return false; } $sql = self::illegal_sql_generator($search_string, false, $element_name, $collection_id); $stmt = $db_hack->prepare($sql); $stmt->execute(); $itemId = $stmt->fetch(); if ($itemId) { if (array_key_exists("id", $itemId)) { $sql2 = self::illegal_sql_generator(false, $itemId["id"], "Privacy Required", $collection_id); $stmt = $db_hack->prepare($sql2); $stmt->execute(); $item = $stmt->fetch(); if ($item) { if (array_key_exists("text", $item)) { if ($item["text"] == "ja") { return true; } } } } } return false; }
private function _getMysqlColumns($tsql, Zend_Db_Adapter_Pdo_Mysql $dbh) { $sth = $dbh->prepare($tsql); $sth->execute(); $colcount = $sth->columnCount(); for ($i = 0; $i < $colcount; $i++) { $coll = $sth->getColumnMeta($i); $cols[] = $coll['name']; } //print_r($cols); return $cols; }