PHP bug?? and FullText search..

[lordgreg]

okay,

1. PHP bug?
   it is like this.. this works fine:
   echo "word1".$foo."word2";

but i tried to make that a path, so the word1 is the root of my sys: c:\ so i did:

echo "c:\".$foo."word2";
and i get error i don't know about what anymore. how come the last char in word1 cannot be backslash?

2. fulltext
   2.1 if the blob is the same like text, how come you cannot use fulltext search in blob column? is there any way that you can use this in any type of column?

2.2 if i have a table with more than 10000 rows is the fulltext search the fastest way to search the table or is there a better way?

sorry for my bad english
thank you very much,

lordgreg

[[deleted]]

1. The backslash is an "escape" character. It tells PHP to treat the following character as a letter, not as PHP code.
   So in this case, the quote after the slash becomes part of the string. That leaves you with 3 quotes, and that's bad.

2.1 Read the MySQL manual, it explains this.

2.2 That depends on how much data 1000 rows is, and what you are searching for. If you only want to search of particular keywords, then a keyword search engine could be faster.

[Anon]

No bug in PHP...
either use 'c:\' or "c:\"

why? because the content between the "'s gets 'parsed' by PHP. For instance, if you want a double quote inside your string you could do

"djsdjslkqjqlk \" idfljlk"

the \ makes sure the " in the middle doesn't indicate the end of the string. In your case, PHP thinks the " after the \ is also part of the string, and thus it doesn't find a closing ". If you want to put a \ in your string, you have to escape the \ with another . That's why you need to use \... Or use single quotes instead of double quotes, because php doesn't parse the content between single quotes...

Another example : in PHP you could do something like this :

echo "hello $name";

this would replace (parse) $name with the value of the variable, even though it's between quotes (some other languages don't allow you to do this...
Now what if you want $name to be echo'd litterally, and not it's value? do it like this :
echo "hello \$name"; // escape the $
or
echo 'hello $name'; // use single quotes

Hope this helps you...

Sven Magnus

[Anon]

vincent,

Where can I find any information about keyword search engine?Can you explain something about it?

Thank you for answer

[[deleted]]

Read the article here, called "slapping together a search engine"