src/snac/server/database/SQL.php
/**
     * Get a single vocabulary record by Type and Value
     *
     * @param string $value The value of a vocabulary term
     *
     * @param string $type The type of a vocabulary term
     *
     * @return string[] A list with keys: id, type, value, uri, description
     *
     */
Get a single vocabulary record by Type and Value
@param string $value The value of a vocabulary term

@param string $type The type of a vocabulary term

@return string[] A list with keys: id, type, value, uri, description
Get a single vocabulary record by Type and Value @param string $value The value of a vocabulary term @param string $type The type of a vocabulary term @return string [] A list with keys : id type value uri description
public function selectTermByValueAndType($value, $type)
    {
        $qq = 's_term_by_value';
        $this->sdb->prepare($qq,
                            'select
                            id, type, value, uri, description
                            from vocabulary where value=$1 and type=$2');
        $result = $this->sdb->execute($qq, array($value, $type));
        $row = $this->sdb->fetchrow($result);
        $this->sdb->deallocate($qq);
        return $row;
    }
public function selectTermByValueAndType ( $ value , $ type ) { $ qq = 's_term_by_value' ; $ this -> sdb -> prepare ( $ qq , 'select
                            id, type, value, uri, description
                            from vocabulary where value=$1 and type=$2' ) ; $ result = $ this -> sdb -> execute ( $ qq , array ( $ value , $ type ) ) ; $ row = $ this -> sdb -> fetchrow ( $ result ) ; $ this -> sdb -> deallocate ( $ qq ) ; return $ row ; }
Get a single vocabulary record by Type and Value
 @param string $value The value of a vocabulary term
Get a single vocabulary record by Type and Value @param string $value The value of a vocabulary term