Adding uppercase to tags on ASEville

I worked out a way to use uppercase letters while still keeping the tag words seperated from the tagged items.

I basically have a table for the tag words (id,name) and for the tagging items (userid,type,typeid,tagid). All tags in the words are stored in lowercase.

It is done this way so I don't need to store the word in each tagged item, taking up more space than needed and it makes searching by tags much faster.

I have figured out an easy way to store some metadata on the case of the text. I have a new field, and integer field (4 bytes), and assign the upper case letters a binary 1 and lowercase a binary 0 in the position. I'll be limiting tags to 32 chars .

For instance, if I want to assign AronSchatz to something, the tag would be stored as aronschatz, but the 'case' field would be "(padding)1000100000" or reversed. I just have to figure out a fast way of doing it in PHP.

Is this what you're looking for?

Quote

echo getCaseField('AronSchatz', '0') . "\n";
echo getCaseFieldRev('AronSchatz', '0') . "\n";

function getCaseField($tword, $padding) {
$result = "";
for ($i = 0; $i < strlen($tword); $i++) {
$result .= (substr($tword, $i, 1) == strtolower(substr($tword, $i, 1)) ? '0' : '1');
}
return str_pad($result, 32, $padding, STR_PAD_LEFT);
}

function getCaseFieldRev($tword, $padding) {
return strrev(getCaseField($tword, $padding));
}

Something like that. I'll post the code for that when I'm finished with it.

strcmp uses less memory. This way, I don't need to worry about padding. And yes, I use single letter vars everywhere I can to conserve space and I'm lazy.

Gotta love programming Everyone has their own style. I'm still confused as to what the 'tags' thing does on here. Is it explained anywhere in the forum? There must be a better way with relational databases to peform the task that you're looking to do.

I am using a relational database approach. The tags are meta data assigned to the WebMarks by whomever.

I'll explain the tags a bit. Let's say I add ASE Labs to the WebMark area. I would then assign some tags to it like 'news computer technology awesome information'. I browse the web and find News.com and add it with tags 'news business technology'.

Now let's say I have 400 WebMarks and I want to see my news sources. I type 'news' into the tag search box and all the WebMarks with the tag 'news' comes up. You can join tags together as well (OR). 'news technology' would bring up both links. I'm going to be adding AND searching soon and a tag management area.

I have a FAQ system that I really should use... . I need to revamp it because I screwed up some stuff when making it.