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.
Freebies: The following freebies are for use in conjunction with the search script. They will allow
you to add entries to a database table via your browser. Configure
addentries.php using a text-only editor.
FTP the files in ASCII mode to the same directory and then call entryform.php from your browser. Please note that no
support is included with freebies.
The demo is set to allow partial matching so that, for example, the characters th will return results with the
words earth, that, and birthday, among others in the demo. A common word search over the partial matching
character limit that you set will return zero results as per the MySQL stop list. Numerical ranks are displayed,
and graphics can also be displayed when PHP is GD enabled. The default search is the and boolean. This script has
been configured to give users the most relevant results first, with page breaks when necessary.
This script does not index sites or create database tables; however an example file for a database table is
provided with the script. Also, this script does not come with a banner ads script. If you have questions,
please ask before you buy.
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.
ThinkDing License Agreement:
Software herein is defined to include all of the ThinkDing LLC files and supporting documentation. ThinkDing LLC
software is not free software and is not open source software. All rights to the ThinkDing LLC software not expressly
granted under this license are reserved to ThinkDing LLC.
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.