 |
 ThinkDing |
|
| tdSearch - PHP MySQL Boolean Search Script | |
|
tdSearch: ThinkDing is offering a PHP MySQL boolean search script that displays results from your
MySQL database table. You can use and (+), or (?), not (-) to perform boolean searches, use double quotes to search
for a phrase, or use a combination of both! This script even allows partial matching of words up to the number of
characters that you allow.
Notes: tdSearch can understand the following characters in a search, provided that your PHP setlocale can be set to, and the content you wish to search is encoded as, ISO-8859-1, ISO-8859-2, ISO-8859-5, ISO-8859-6, ISO-8859-7, ISO-8859-8, or ISO-8859-9 encoding: A through Z, 0 through 9, various punctuation such as ' and -, and extended ASCII: ¡¢£¤¥¦§¨©ª«¬_®¯°±²³´µ¶·¸¹º»¼½¾¿ ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞß àáâãäåæçèéêëìíîïðñòóôõö÷øùúûüýþÿ Note that tdSearch can search just one MySQL database table and that only one encoding is allowed. tdSearch does create and use a FULLTEXT index and use LIKE queries up to a character allowance to perform boolean searches. If your table is large, you may "turn off" the LIKE queries, but note that if LIKE queries are not allowed, your search results will be as described at the following web sites: tdSearch works well on a smaller sized table. The script has also been used on a table of about 100K, but at 100K the script can show a performance hit, especially when LIKE queries are allowed. For example, using a table of about 100K and 20,000 rows, searching on two letters takes about 10 seconds, searching on three letters takes about 7 seconds, and searching on four letters takes about 4 seconds. tdSearch has the option to set the number of characters to be used in LIKE queries. The table type for tdSearch is to be MyISAM, and columns are to be TEXT or VARCHAR types. tdSearch allows the searching of two to three columns and can display information from three to five columns. There must be the following three columns in the table: a title column, a description column, and a URL or ID column. If you are concerned about your table size, or have questions in general, please ask before you buy. Requirements: PHP 4.3.x+ and MySQL 4.0.x+ highly recommended; PHP 4.1.2+, MySQL 3.23.47+, and CSS support required. Pricing: $25.00 USD (includes one-year access to download from members area). By purchasing ThinkDing software, you are agreeing to the below License Agreements. After successful completion of the PayPal purchase process, you are given access to immediately download the software you purchased in ZIP format. Note that purchases are available through 2CheckOut upon request.
Copies of Software: Only one copy of a licensed version of ThinkDing LLC software may used on one website for each license purchased. Multiple licenses must be purchased to use ThinkDing LLC software at multiple locations. Access to Software: A subscription grants the licensee access to the members area where newer versions of the software may be downloaded for one year from the date of purchase. After a subscription expires, licensee may continue to use, according to the terms of this license, the last version of the software that licensee downloaded prior to subscription expiration, or make another purchase to gain access to the latest version. Distribution of Software: Distributing the ThinkDing LLC software, commercial or otherwise, without prior written permission from ThinkDing LLC, is strictly forbidden, regardless of whether the licensee modifies the software. Copyright of Software: All copyright notices, including links, contained in the ThinkDing LLC software must remain unchanged and visible at all times, unless a branding free option was purchased. Branding Free Option: A branding free option allows licensee to remove the copyright notices, including links, that are present when viewing a webpage. Copyright notices in the source code itself must not be removed. URL to Website: All licensees must submit the URL where the software will be used, and must keep this URL up to date. The URL may be submitted via the members area. License Transfers or Refunds: Sale prices or price reductions are not applied retroactively. Fees are non-refundable, and the license is non-transferable, regardless of whether the licensee installs the ThinkDing LLC software. Revocation of License: If any of the terms of this license are violated, ThinkDing LLC reserves the right to revoke the license at any time. Changes to License: Any or all terms of this license may be modified at any time. Disclaimer of Warranty: THE SOFTWARE AND ACCOMPANYING DOCUMENTATION ARE PROVIDED "AS IS" AND WITHOUT ANY WARRANTIES AS TO PERFORMANCE, MERCHANTABILITY, FITNESS OR OTHER PURPOSES, WHETHER EXPRESSED OR IMPLIED. ALL EXPRESSED OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. THE LICENSEE MUST ASSUME THE ENTIRE RISK OF USING THE SOFTWARE. IN NO CASE SHALL THINKDING LLC OR ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, CONSEQUENTIAL, OR OTHER DAMAGES OR LOSS, INCLUDING, WITHOUT LIMITATION, LOST PROFITS OR THE INABILITY TO USE EQUIPMENT OR ACCESS DATA, WHETHER SUCH DAMAGES ARE BASED UPON A BREACH OF EXPRESS OR IMPLIED WARRANTIES, BREACH OF CONTRACT, NEGLIGENCE, STRICT TORT, OR ANY OTHER LEGAL THEORY. THIS IS TRUE EVEN IF THINKDING LLC OR ITS CONTRIBUTORS IS ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. IN NO CASE WILL THE LIABILITY OF THINKDING LLC OR ITS CONTRIBUTORS EXCEED THE AMOUNT OF THE LICENSE FEE PAID BY LICENSEE TO THINKDING LLC. ANY LIABILITY OF THINKDING LLC OR ITS CONTRIBUTORS IS LIMITED EXCLUSIVELY TO PRODUCT REPLACEMENT OR REFUND OF THE PURCHASE PRICE. THINKDING LLC OR ITS CONTRIBUTORS IS NOT LIABLE FOR ANY CONTENT DISPLAYED ON A WEBSITE POWERED BY THINKDING LLC SOFTWARE. THIS LICENSE SHALL BE GOVERNED BY THE LAWS OF THE STATE OF PENNSYLVANIA. MIT License Agreement: Software herein is defined to be the functions.php file, save a couple of small functions. The software falls under the MIT Open Source Public License which reads as follows: Copyright © 2001 David A. Altherr. Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE. |
All times are GMT. The time now is 12:00 PM.