Solved

search mysql column with similar_text() matching percentage

Posted on 2013-06-14
24
1,307 Views
Last Modified: 2013-07-01
i want to echo one value from mysql column which is 90% similar to php variable. echo only the value that is 90% similar to php value. i think like clause wont help in this case.

<?php
  $x = $_GET[x];
  $con=mysqli_connect("example.com","peter","abc123","my_db");
  $res =  mysqli_query($con,"SELECT * FROM text");
  while ($row = mysql_fetch_assoc($res))
 {
     $string[] = $row['text'];
 }
  foreach ($string as $y)
 {
  similar_text($x, $y, $percent);
 }
  if ($percent>"90")
 {
   echo $string ; 
  ?>

Open in new window



i think the above code has many mistakes. i welcome some new solution for my task.
0
Comment
Question by:chrisvee
  • 9
  • 9
  • 4
  • +1
24 Comments
 
LVL 108

Expert Comment

by:Ray Paseur
ID: 39247440
Welcome to EE, chrisvee.  Here are some general guidelines to make your use of this site more enjoyable and productive for you...

At EE, the experts exchange answers and advice for points.  If you look at the questions awaiting answers in this zone, you will see a lot of 500 point questions.  Your question is competing for the experts' attention among those high-point questions.  So as a matter of simple economics you might be able to envision which questions will get the experts' attention first.   Just a thought.

We are experts, but not mind readers.  Inquiries that are broad, vague and hypothetical may not get answers that are as succinct and effective as inquiries that have actual URLs, complete code examples, and clearly expressed questions.  "It doesn't work" is not an error message.  Whenever possible, please provide the inputs and tell us what you want for the outputs.  An incredibly important concept is the SSCCE; please read the online page and embrace the SSCCE strategy.  If you do not have the SSCCE, stop what you're doing and create one, and post it with your question.  And please accept that sometimes the right answer is, "Don't do that -- it doesn't work that way."

If you want us to be able to share working code, we need you to show us where you have put your test data.  If you have no test data, please create some.  We do not want you to post "live" passwords and such.  Instead, please set up a testbed and show us the links to that, instead of the live data.

We answer questions and provide teaching examples, but we cannot build applications for you.  If you do not understand the basics of computer science and the programming languages involved in your applications, you might be better off to hire a developer.  Often a great deal of trial and error, plus a depth of knowledge and background information is necessary to get a piece of an application working.  The experts will try to help, but sometimes the only reasonable answer is, "Please read the fine manuals" or "Be respectful of your time; don't take a year learning information technology -- hire a professional developer and you'll get good results in a couple of weeks."

All of us who have been at EE for a while have seen questions like, "How do I do 'X' in 'Y' language, and by the way, I do not know anything about 'Y' language."  For some reason we never see anyone ask, "I want to play a piano sonata, and by the way, I have never taken piano lessons."  It is hardly a sin if you do not know a particular programming language -- I do not know most of them -- but it is not reasonable to expect that you will learn a programming language by asking questions in an online forum, any more than you could learn to play the piano by asking questions in an online forum.  Instead your best question might be, "What are good learning resources to get a foundation in 'Y' language?"  We are glad to help with that.

Here are some good learning resources for PHP.
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/A_11769-And-by-the-way-I-am-new-to-PHP.html

Best regards, ~Ray
0
 

Author Comment

by:chrisvee
ID: 39247484
hi ray, i am just asking a sample of code to achieve % matching search in mysql column. myself php developer and i can build php web applications.
0
 
LVL 108

Expert Comment

by:Ray Paseur
ID: 39247503
The only thing I see wrong with the code snippet is that the last line should not be ?> (never use the close PHP tag if you can avoid it).  Instead it should be } to close the control structure.
0
 

Author Comment

by:chrisvee
ID: 39247533
i want to output only the value from mysql column which is 90% similar to php variable.

 similar_ text()  between _GET variable and 90% similar string in mysql column.
0
 

Author Comment

by:chrisvee
ID: 39247555
waiting for the correct code?
0
 
LVL 108

Expert Comment

by:Ray Paseur
ID: 39247594
Please review the post here.
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/Q_28157402.html#a39247440

See especially the part about the SSCCE.  Waiting for your test data.
0
 
LVL 51

Expert Comment

by:Julian Hansen
ID: 39247649
You could do it like this as well - eliminating the superfluous second loop
<?php
$x = $_GET[x];
$con=mysqli_connect("example.com","peter","abc123","my_db");
$res =  mysqli_query($con,"SELECT * FROM text");
while ($row = mysql_fetch_assoc($res)) {
  if (similar_text($x, $y, $percent) > 90) {
    echo $row['text'] . "<br/>";
    // Save only strings > 90% here $string[] = $row['text']
  }
   // Save all strings here $string[] = $row['text'];
}
?>

Open in new window

0
 

Author Comment

by:chrisvee
ID: 39247662
Academy Engraved LETAgency FBAharoniAlgerianAndalusAngsana NewAngsanaUPCAparajitaArabic TypesettingArialArial BlackArial NarrowArial Rounded MT BoldArial Unicode MSBaskerville Old FaceBatangBatangCheBauhaus 93Bell MTBerlin Sans FBBerlin Sans FB DemiBernard MT CondensedBlackadder ITCBlackletter686 BTBodoni MTBodoni MT BlackBodoni MT CondensedBodoni MT Poster CompressedBook AntiquaBookman Old StyleBookshelf Symbol 7Bradley Hand ITCBritannic BoldBroadwayBroadway BTBrowallia NewBrowalliaUPCBrush Script MTCalibriCalifornian FBCalisto MTCalligraph421 BTCambriaCambria MathCandaraCastellarCataneo BTCentaurCenturyCentury GothicCentury SchoolbookChillerColonna MTComic Sans MSConsolasConstantiaCooper BlackCopperplate Gothic BoldCopperplate Gothic LightCorbelCordia NewCordiaUPCCourierCourier NewCurlz MTDFKai-SBDaunPenhDavidDilleniaUPCDokChampaDotumDotumCheEbrimaEdwardian Script ITCElephantEngravers MTEras Bold ITCEras Demi ITCEras Light ITCEras Medium ITCEstrangelo EdessaEucrosiaUPCEuphemiaFangSongFelix TitlingFixedsysFootlight MT LightForteFrankRuehlFranklin Gothic BookFranklin Gothic DemiFranklin Gothic Demi CondFranklin Gothic HeavyFranklin Gothic MediumFranklin Gothic Medium CondFreesiaUPCFreestyle ScriptFrench Script MTGabriolaGaramondGautamiGeorgiaGigiGill Sans MTGill Sans MT CondensedGill Sans MT Ext Condensed BoldGill Sans Ultra BoldGill Sans Ultra Bold CondensedGishaGloucester MT Extra CondensedGoudy Old StyleGoudy StoutGulimGulimCheGungsuhGungsuhCheHaettenschweilerHarlow Solid ItalicHarringtonHigh Tower TextHighlight LETHolidayPi BTImpactImprint MT ShadowInformal RomanIrisUPCIskoola PotaJasmineUPCJohn Handy LETJokermanJokerman LETJuice ITCKaiTiKalingaKartikaKhmer UIKodchiangUPCKokilaKristen ITCKunstler ScriptLa Bamba LETLao UILathaLeelawadeeLevenim MTLilyUPCLucida BrightLucida CalligraphyLucida ConsoleLucida FaxLucida HandwritingLucida SansLucida Sans TypewriterLucida Sans UnicodeMS GothicMS MinchoMS OutlookMS PGothicMS PMinchoMS Reference Sans SerifMS Reference SpecialtyMS Sans SerifMS SerifMS UI GothicMT ExtraMV BoliMagnetoMaiandra GDMalgun GothicMangalMarlettMatura MT Script CapitalsMeiryoMeiryo UIMekanik LETMicrosoft HimalayaMicrosoft JhengHeiMicrosoft New Tai LueMicrosoft PhagsPaMicrosoft Sans SerifMicrosoft Tai LeMicrosoft UighurMicrosoft YaHeiMicrosoft Yi BaitiMilano LETMingLiUMingLiU-ExtBMingLiU_HKSCSMingLiU_HKSCS-ExtBMiriamMiriam FixedMisterEarl BTMistralModernModern No. 20Mongolian BaitiMonotype CorsivaMoolBoranNSimSunNarkisimNiagara EngravedNiagara SolidNyalaOCR A ExtendedOdessa LETOld English Text MTOldDreadfulNo7 BTOne Stroke Script LETOnyxOrange LETPMingLiUPMingLiU-ExtBPalace Script MTPalatino LinotypePapyrusParchmentParkAvenue BTPerpetuaPerpetua Titling MTPlantagenet CherokeePlaybillPoor RichardPristinaPump Demi Bold LETQuixley LETRaaviRage ItalicRage Italic LETRavieRockwellRockwell CondensedRockwell Extra BoldRodRomanRuach LETSakkal MajallaScriptScript MT BoldScruff LETSegoe PrintSegoe ScriptSegoe UISegoe UI LightSegoe UI SemiboldSegoe UI SymbolShonar BanglaShowcard GothicShrutiSimHeiSimSunSimSun-ExtBSimplified ArabicSimplified Arabic FixedSmall FontsSmudger LETSnap ITCSquare721 BTStaccato222 BTStencilSylfaenSymbolSystemTahomaTempus Sans ITCTerminalTimes New RomanTiranti Solid LETTraditional ArabicTrebuchet MSTungaTw Cen MTTw Cen MT CondensedTw Cen MT Condensed Extra BoldUniversity Roman LETUtsaahVaniVerdanaVictorian LETVijayaViner Hand ITCVivaldiVladimir ScriptVrindaWebdingsWestwood LETWide LatinWingdingsWingdings 2Wingdings 3

Open in new window


html page collects fonts like above through javascript and sends it to php page. fonts are different for different browsers.but those are almost same in all browsers. we store fonts  mysql column.

 I want to find  similar fonts string($_GET)  with already stored fonts in database.

Normally WHERE clause is used to find exact match. But here in this case, return only above 90% matching.
0
 

Author Comment

by:chrisvee
ID: 39247729
julionH  what is   $y ?
0
 
LVL 23

Expert Comment

by:nemws1
ID: 39247742
You'd have to tokenize everything (meaning break things down to individual words), but you might be able to use SOUNDEX()

http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_soundex

To find similar matches.  There's nothing that will easily give you a "90%" match. (Genetic pattern matching algorithms might let you specify a '.9' match, but there isn't anything that I know of in MySQL or PHP besides SOUNDEX() that can do "close" matches).
0
 
LVL 108

Expert Comment

by:Ray Paseur
ID: 39247768
The test data looks a little garbled, but this will work for an example.  You can adapt it to your own data base.  Moving parts are at the end.
http://www.laprbass.com/RAY_temp_chrisvee.php?q=wingding
http://www.laprbass.com/RAY_temp_chrisvee.php?q=wing

<?php // RAY_temp_chrisvee.php
error_reporting(E_ALL);

// USE AN ARRAY TO SIMULATE A DATA BASE TABLE
$dat = array
( 'Academy'
, 'Engraved'
, 'LETAgency'
, 'FBAharoniAlgerianAndalusAngsana'
, 'NewAngsanaUPCAparajitaArabic'
, 'TypesettingArialArial'
, 'BlackArial'
, 'NarrowArial'
, 'Rounded'
, 'MT'
, 'BoldArial'
, 'Unicode'
, 'MSBaskerville'
, 'Old'
, 'FaceBatangBatangCheBauhaus'
, '93Bell'
, 'MTBerlin'
, 'Sans'
, 'FBBerlin'
, 'Sans'
, 'FB'
, 'DemiBernard'
, 'MT'
, 'CondensedBlackadder'
, 'ITCBlackletter686'
, 'BTBodoni'
, 'MTBodoni'
, 'MT'
, 'BlackBodoni'
, 'MT'
, 'CondensedBodoni'
, 'MT'
, 'Poster'
, 'CompressedBook'
, 'AntiquaBookman'
, 'Old'
, 'StyleBookshelf'
, 'Symbol'
, '7Bradley'
, 'Hand'
, 'ITCBritannic'
, 'BoldBroadwayBroadway'
, 'BTBrowallia'
, 'NewBrowalliaUPCBrush'
, 'Script'
, 'MTCalibriCalifornian'
, 'FBCalisto'
, 'MTCalligraph421'
, 'BTCambriaCambria'
, 'MathCandaraCastellarCataneo'
, 'BTCentaurCenturyCentury'
, 'GothicCentury'
, 'SchoolbookChillerColonna'
, 'MTComic'
, 'Sans'
, 'MSConsolasConstantiaCooper'
, 'BlackCopperplate'
, 'Gothic'
, 'BoldCopperplate'
, 'Gothic'
, 'LightCorbelCordia'
, 'NewCordiaUPCCourierCourier'
, 'NewCurlz'
, 'MTDFKai-SBDaunPenhDavidDilleniaUPCDokChampaDotumDotumCheEbrimaEdwardian'
, 'Script'
, 'ITCElephantEngravers'
, 'MTEras'
, 'Bold'
, 'ITCEras'
, 'Demi'
, 'ITCEras'
, 'Light'
, 'ITCEras'
, 'Medium'
, 'ITCEstrangelo'
, 'EdessaEucrosiaUPCEuphemiaFangSongFelix'
, 'TitlingFixedsysFootlight'
, 'MT'
, 'LightForteFrankRuehlFranklin'
, 'Gothic'
, 'BookFranklin'
, 'Gothic'
, 'DemiFranklin'
, 'Gothic'
, 'Demi'
, 'CondFranklin'
, 'Gothic'
, 'HeavyFranklin'
, 'Gothic'
, 'MediumFranklin'
, 'Gothic'
, 'Medium'
, 'CondFreesiaUPCFreestyle'
, 'ScriptFrench'
, 'Script'
, 'MTGabriolaGaramondGautamiGeorgiaGigiGill'
, 'Sans'
, 'MTGill'
, 'Sans'
, 'MT'
, 'CondensedGill'
, 'Sans'
, 'MT'
, 'Ext'
, 'Condensed'
, 'BoldGill'
, 'Sans'
, 'Ultra'
, 'BoldGill'
, 'Sans'
, 'Ultra'
, 'Bold'
, 'CondensedGishaGloucester'
, 'MT'
, 'Extra'
, 'CondensedGoudy'
, 'Old'
, 'StyleGoudy'
, 'StoutGulimGulimCheGungsuhGungsuhCheHaettenschweilerHarlow'
, 'Solid'
, 'ItalicHarringtonHigh'
, 'Tower'
, 'TextHighlight'
, 'LETHolidayPi'
, 'BTImpactImprint'
, 'MT'
, 'ShadowInformal'
, 'RomanIrisUPCIskoola'
, 'PotaJasmineUPCJohn'
, 'Handy'
, 'LETJokermanJokerman'
, 'LETJuice'
, 'ITCKaiTiKalingaKartikaKhmer'
, 'UIKodchiangUPCKokilaKristen'
, 'ITCKunstler'
, 'ScriptLa'
, 'Bamba'
, 'LETLao'
, 'UILathaLeelawadeeLevenim'
, 'MTLilyUPCLucida'
, 'BrightLucida'
, 'CalligraphyLucida'
, 'ConsoleLucida'
, 'FaxLucida'
, 'HandwritingLucida'
, 'SansLucida'
, 'Sans'
, 'TypewriterLucida'
, 'Sans'
, 'UnicodeMS'
, 'GothicMS'
, 'MinchoMS'
, 'OutlookMS'
, 'PGothicMS'
, 'PMinchoMS'
, 'Reference'
, 'Sans'
, 'SerifMS'
, 'Reference'
, 'SpecialtyMS'
, 'Sans'
, 'SerifMS'
, 'SerifMS'
, 'UI'
, 'GothicMT'
, 'ExtraMV'
, 'BoliMagnetoMaiandra'
, 'GDMalgun'
, 'GothicMangalMarlettMatura'
, 'MT'
, 'Script'
, 'CapitalsMeiryoMeiryo'
, 'UIMekanik'
, 'LETMicrosoft'
, 'HimalayaMicrosoft'
, 'JhengHeiMicrosoft'
, 'New'
, 'Tai'
, 'LueMicrosoft'
, 'PhagsPaMicrosoft'
, 'Sans'
, 'SerifMicrosoft'
, 'Tai'
, 'LeMicrosoft'
, 'UighurMicrosoft'
, 'YaHeiMicrosoft'
, 'Yi'
, 'BaitiMilano'
, 'LETMingLiUMingLiU-ExtBMingLiU_HKSCSMingLiU_HKSCS-ExtBMiriamMiriam'
, 'FixedMisterEarl'
, 'BTMistralModernModern'
, 'No.'
, '20Mongolian'
, 'BaitiMonotype'
, 'CorsivaMoolBoranNSimSunNarkisimNiagara'
, 'EngravedNiagara'
, 'SolidNyalaOCR'
, 'A'
, 'ExtendedOdessa'
, 'LETOld'
, 'English'
, 'Text'
, 'MTOldDreadfulNo7'
, 'BTOne'
, 'Stroke'
, 'Script'
, 'LETOnyxOrange'
, 'LETPMingLiUPMingLiU-ExtBPalace'
, 'Script'
, 'MTPalatino'
, 'LinotypePapyrusParchmentParkAvenue'
, 'BTPerpetuaPerpetua'
, 'Titling'
, 'MTPlantagenet'
, 'CherokeePlaybillPoor'
, 'RichardPristinaPump'
, 'Demi'
, 'Bold'
, 'LETQuixley'
, 'LETRaaviRage'
, 'ItalicRage'
, 'Italic'
, 'LETRavieRockwellRockwell'
, 'CondensedRockwell'
, 'Extra'
, 'BoldRodRomanRuach'
, 'LETSakkal'
, 'MajallaScriptScript'
, 'MT'
, 'BoldScruff'
, 'LETSegoe'
, 'PrintSegoe'
, 'ScriptSegoe'
, 'UISegoe'
, 'UI'
, 'LightSegoe'
, 'UI'
, 'SemiboldSegoe'
, 'UI'
, 'SymbolShonar'
, 'BanglaShowcard'
, 'GothicShrutiSimHeiSimSunSimSun-ExtBSimplified'
, 'ArabicSimplified'
, 'Arabic'
, 'FixedSmall'
, 'FontsSmudger'
, 'LETSnap'
, 'ITCSquare721'
, 'BTStaccato222'
, 'BTStencilSylfaenSymbolSystemTahomaTempus'
, 'Sans'
, 'ITCTerminalTimes'
, 'New'
, 'RomanTiranti'
, 'Solid'
, 'LETTraditional'
, 'ArabicTrebuchet'
, 'MSTungaTw'
, 'Cen'
, 'MTTw'
, 'Cen'
, 'MT'
, 'CondensedTw'
, 'Cen'
, 'MT'
, 'Condensed'
, 'Extra'
, 'BoldUniversity'
, 'Roman'
, 'LETUtsaahVaniVerdanaVictorian'
, 'LETVijayaViner'
, 'Hand'
, 'ITCVivaldiVladimir'
, 'ScriptVrindaWebdingsWestwood'
, 'LETWide'
, 'Latin'
, 'Wingdings'
, 'Wingdings 2'
, 'Wingdings 3'
)
;

// IF THERE IS A GET REQUEST
$q = !empty($_GET['q']) ? strtoupper($_GET['q']) : NULL;
if (!$q) die();

// SIMULATE A DATA BASE LOOKUP
$num = 0;
foreach ($dat as $str)
{
    $new = strtoupper($str);
    similar_text($q, $new, $pct);
    if ($pct > 90.0)
    {
        $num++;
        echo PHP_EOL . $str;
    }
}
if (!$num) echo PHP_EOL . "NO MATCH FOR $q";

Open in new window

0
 
LVL 23

Expert Comment

by:nemws1
ID: 39247777
similar_text() in PHP!  Hmm.   Learn something new every day. :)
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 108

Expert Comment

by:Ray Paseur
ID: 39247779
This might not work as expected... the return value is the matching character count.

if (similar_text($x, $y, $percent) > 90)

If you want a value greater than 90% matched, you would want to test the $percent variable.
http://php.net/manual/en/function.similar-text.php
0
 

Author Comment

by:chrisvee
ID: 39247780
nemws1  Similar_Text()  gives % percent matching. but how to search in mysql column and return which is 90% similar.
0
 
LVL 108

Expert Comment

by:Ray Paseur
ID: 39247786
@nemws1:  Here's a teaching example showing some of the ways to compare strings.

<?php // RAY_similar_strings.php
error_reporting(E_ALL);
echo "<pre>" . PHP_EOL;


// SHOW SOME WAYS OF LOOKING AT IMPRECISELY MATCHED INFORMATION


// THINGS TO COMPARE
$strings = array
( array( '12345.1', '12345. 1'  )
, array( 'kitten',  'kitty'     )
, array( 'CATALOG', 'Catalog'   )
, array( 'cell',    'sell'      )
, array( 'super',   'souper'    )
, array( 'mi niña', 'mi nina'   )
, array( 'mi niña', 'mi ninia'  )
, array( 'ça va!',  'ca va!'    )
, array( 'Plaçe',   'Place'     )
, array( 'ça va!',  'sa va!'    )
, array( 'ca va!',  'sa va!'    )
, array( 'Yeehah',  'Yee-hah'   )
, array( 'toxic',   'poisonous' )
, array( 'glad',    'unglad'    )
, array( 'McLean',  'MacLean'   )
)
;

foreach ($strings as $string)
{
    $x = $string[0];
    $y = $string[1];
    echo PHP_EOL;
    echo "<b>COMPARING $x TO $y</b>";
    echo PHP_EOL;


    // http://php.net/manual/en/function.soundex.php
    echo PHP_EOL;
    echo 'SOUNDEX()';
    echo PHP_EOL;
    var_dump(soundex($x));
    var_dump(soundex($y));

    // http://php.net/manual/en/function.metaphone.php
    echo PHP_EOL;
    echo 'METAPHONE()';
    echo PHP_EOL;
    var_dump(metaphone($x));
    var_dump(metaphone($y));

    // http://php.net/manual/en/function.levenshtein.php
    echo PHP_EOL;
    echo 'LEVENSHTEIN()';
    echo PHP_EOL;
    var_dump(levenshtein($x, $y));

    // http://php.net/manual/en/function.similar-text.php
    echo PHP_EOL;
    echo 'SIMILAR_TEXT()';
    echo PHP_EOL;
    echo "COMMON CHARACTERS: " . similar_text($x, $y);
    echo PHP_EOL;
    similar_text($x, $y, &$pct);
    echo "PERCENT ALIKE: " . number_format($pct,1) . '%';

    echo PHP_EOL;
}

Open in new window

Best regards, ~Ray
0
 

Author Comment

by:chrisvee
ID: 39247859
@Ray_Paseur

$_GET wont be like array format. It is like above snippet font only.
0
 
LVL 51

Expert Comment

by:Julian Hansen
ID: 39247939
0
 
LVL 51

Expert Comment

by:Julian Hansen
ID: 39247941
... and $y was supposed to be changed to $row['text']
0
 
LVL 108

Expert Comment

by:Ray Paseur
ID: 39248061
$_GET wont be like array format. It is like above snippet font only.
I don't know what that means.  Sorry.
0
 

Accepted Solution

by:
chrisvee earned 0 total points
ID: 39266873
finally myself i found the solution for this and its working too.
<?php
$con=mysqli_connect("localhost","user","pass","table");
$dbf = mysqli_real_escape_string($con, $f);
if(mysqli_num_rows($qf) == 0){
		// if the number of lines exceeds 50% of the total, no line is returned,
		// the following query ensures that this does not occur
	$qf = mysqli_query($con, "SELECT * FROM table WHERE MATCH(f) AGAINST ('$dbf' IN BOOLEAN MODE)");
	if(mysqli_num_rows($qf) == 0){
			// echo "it's not matches  above 90%";
	}else{
		$percent = 0;

		while($row = mysqli_fetch_row($qf)){
			similar_text($row[2], $f, $percent);
			if($percent >= 90){
				$id = $row[0];
break;
			}
		}
	}
}else{
	
	$row = mysqli_fetch_row($qf);

	$percent = 0;
	
	similar_text($row[2], $f, $percent);

	if($percent >= 90){
		$id = $row[0];
}
}
?>

Open in new window

0
 
LVL 108

Expert Comment

by:Ray Paseur
ID: 39267121
On line 4, the $qf variable appears to be undefined.  You might want to raise the error_reporting() level to E_ALL so you can catch these things!
0
 
LVL 108

Expert Comment

by:Ray Paseur
ID: 39279865
At Experts-Exchange it is traditional to award points when you have exercised the volunteer community.  Now it seems that you want to close the question without awarding any points.

It is not our job to write working code for you (although you got several examples of working code here).  For that, you need to hire a paid professional developer.  Our role here in the EE community is to help you find answers to your questions.  I thought we did a pretty good job of that.

So what you're saying to us is that there was nothing here at all that helped you in any way?  You already knew all about similar_text()?  You already knew how to set up test data and simulate queries?
0
 

Author Closing Comment

by:chrisvee
ID: 39289414
this is the only working code as well as tested.
0
 
LVL 51

Expert Comment

by:Julian Hansen
ID: 39289522
Except your solution does not match the question asked which dealt with similar text and a percentage
i want to echo one value from mysql column which is 90% similar to php variable
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

This article discusses how to create an extensible mechanism for linked drop downs.
Since pre-biblical times, humans have sought ways to keep secrets, and share the secrets selectively.  This article explores the ways PHP can be used to hide and encrypt information.
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now