youtube-mp3-converter - wwwroot - lib - suggest - SOURCE CODE

<?php
define ( "FREQ_THRESHOLD", 40 );
define ( "SUGGEST_DEBUG", 0);
define ( "LENGTH_THRESHOLD", 2 );
define ( "LEVENSHTEIN_THRESHOLD", 2 );
define ( "TOP_COUNT", 1 );
define ("SPHINX_20",false);
//database PDO
$ln = new PDO( 'mysql:host=localhost;dbname=songtexts;charset=utf8', 'root', 'rouTer99' );

//Sphinx PDO
$ln_sph = new PDO( 'mysql:host=localhost;port=9306;charset=utf8', 'root', 'rouTer99' );
?>

<?php

function BuildTrigrams($keyword) 
{
	$t = "__" . $keyword . "__";
	$trigrams = "";
	for ($i = 0; $i < strlen($t) - 2; $i++)
		$trigrams .= substr($t, $i, 3) . " ";
	return $trigrams;
}

function MakeSuggestion($keyword,$ln) 
{
	$trigrams = BuildTrigrams($keyword);
	$query = "\"$trigrams\"/1";
	$len = strlen($keyword);

	$delta = LENGTH_THRESHOLD;
	$weight = 'weight()';
	if(SPHINX_20 == true) {
	    $weight ='@weight';
	}
	$stmt = $ln->prepare("SELECT *, $weight as w, w+:delta-ABS(len-:len) as myrank FROM suggest WHERE MATCH(:match) AND len BETWEEN :lowlen AND :highlen
			ORDER BY myrank DESC, freq DESC
			LIMIT 0,:topcount OPTION ranker=wordcount");

	$stmt->bindValue(':match', $query, PDO::PARAM_STR);
	$stmt->bindValue(':len', $len, PDO::PARAM_INT);
	$stmt->bindValue(':delta', $delta, PDO::PARAM_INT);
	$stmt->bindValue(':lowlen', $len - $delta, PDO::PARAM_INT);
	$stmt->bindValue(':highlen', $len + $delta, PDO::PARAM_INT);
	$stmt->bindValue(':topcount',TOP_COUNT, PDO::PARAM_INT);
	$stmt->execute();


	if (!$rows = $stmt->fetchAll())
		return false;
	// further restrict trigram matches with a sane Levenshtein distance limit
	foreach ($rows as $match) {
		$suggested = $match["keyword"];
		if (levenshtein($keyword, $suggested) <= LEVENSHTEIN_THRESHOLD)
			return $suggested;
	}

	return $keyword;
}

function MakePhaseSuggestion($words,$query,$ln_sph) 
{
	$suggested = array();

... [truncated, 37 more lines] ...