 |
Submit Your Code | |
 |
SEO Monitor | |
 |
UpTime Monitor | |
 |
PHP Code Contest | |
 |
My Favorite Examples | |
|
My Favorite Articles | |
 |
Update Your Profile | |
|
|
| More Weber Sites | ||
| PHP Code Search | ||
| Web Development Forums | ||
| Learn MySQL Playing Trivia | ||
| PHPBB2 Templates | ||
| Web Development Index | ||
| PHP Web Logs (BLogs) | ||
| Web Development Resources | ||
| Web Development Content | ||
| Recommended Links | ||
| PHPClasses | ||
| PHP Editor | ||
| PHP Jobs | ||
| Vision.To Design | ||
| Ajax Tutorials | ||
| PHP Programming Help | ||
| PHP/MySQL Programming | ||
| Webmaster Resources | ||
| Webmaster Forum | ||
| XML meta language | ||
| website builder | ||
| Recommended | ||
| Submit Site | ||
| Forex Trading Online forex trading platform | ||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Code | ||||||||||||||
<?php /* the function below was written by Michael Patrick. This code is available for free use. Go ahead and strip it and include it in your own programs, I know you would anyway. So, why tell you not to do it without my express written permission? If you have any questions, please contact me at mpatrick@xtn.net. I am afraid, however, that I can only give limited support for this software. There are probably several ways to simplify this code, but it works... ;-) The function creates only the WHERE clause of the SQL statement dynamically. An example is shown at the end of the code. An example can be found at: http://commerce.xtn.net/automaxx2/index.php?page=products Or, if it has moved, try: http://automaxx.com/index.php?page=products */ function makeboolean($sqlfieldname, $keywordstr) { // pass into this function the sqlfieldname that you want to search by and the original string // that the user entered into the form field on the search engine. // After you get back the result from this function, include it into your complete search string. // Note, you may want to call this function repeatedly to search through various fields in your // tables. $keyword = $keywordstr; // Convert String To Lower Case $keyword = strtolower($keyword); // Replace Word Operators With Single Character Operators $keyword = ereg_replace(" and ","+",$keyword); $keyword = ereg_replace(" or ","|",$keyword); $keyword = ereg_replace(" not ","-",$keyword); // Build The Keywords String Based On Operators Assigned Above $operatorcount = 0; $len = strlen($keyword); for ($z = 0; $z < $len; $z++) { if(($keyword[$z] == "+") || ($keyword[$z] == "|") || ($keyword[$z] == "-")) { $operatorpos[$operatorcount] = $z; $operatorcount++; } } if ($operatorcount != 0) { for ($z = 0; $z < $operatorcount; $z++) { if($z == 0) { $startpos = 0; $endpos = $operatorpos[$z]; } else { $startpos = $operatorpos[$z - 1] + 1; $endpos = $operatorpos[$z]; } $word = $endpos - $startpos; $keystring = substr($keyword,$startpos,$word); $keystring = ereg_replace("\(","",$keystring); $keystring = ereg_replace("\)","",$keystring); $keywords[$z] = $keystring; $operator_pos = $operatorpos[$z]; $operators[$z] = $keyword[$operator_pos]; } // end the for loop $wordcount = $operatorcount + 1; $startpos = $operatorpos[$z - 1] + 1; $len2 = strlen($keyword) - $startpos; $linestr = substr($keyword,$startpos,$len2); //store the line into the keywords array $keywords[$wordcount - 1] = $linestr; //loop through all of the words in the words array replacing them in the original string with a LIKE clause for ($z=0; $z < $wordcount; $z++) { $replacekeyword = $keywords[$z]; $y = $z -1; if ($operators[$y] != "-") //odd case is in a NOT...must do something different! $keyword = ereg_replace($replacekeyword,"$sqlfieldname LIKE '% $replacekeyword%'",$keyword); else $keyword = ereg_replace($replacekeyword,"$sqlfieldname NOT LIKE '% $replacekeyword%'",$keyword); } // Replace Our Operators With The Correct SQL Operators $keyword = ereg_replace("\+"," AND ", $keyword); $keyword = ereg_replace("\|"," OR ", $keyword); $keyword = ereg_replace("\-"," AND ", $keyword); //I fudged in the above statement so this possible :-) } // end if operatorcount != 0 else { //there were no operators in the string $replacekeyword = $keyword; if ($keyword != "") { $keyword = ereg_replace($replacekeyword,"$sqlfieldname LIKE '% $replacekeyword%'",$keyword); } } return($keyword); } //end the makebooleanstatement function /* NOTE: Here is a sample call to the function assuming keyword is the form field where the user entered their search criteria into their search engine form. Let's assume that you have a form with a keyword input field and a submit button. Sample form: <form name=keywordsearch> Keyword: <input type=text name=keyword> <input type=submit name="Submit Query" value="Submit Query"> </form> Sample PHP Code: <? $keyword = makeboolean("keyword",$keyword); $statement = "SELECT * FROM sometablename WHERE $keyword"; $result = mysql("somedatabase",$statement); ?> */ ?> | ||||||||||||||
| Related Code Examples | ||||||||||||||
| User Comments | ||||||||||||||
|
||||||||||||||
