[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 433
  • Last Modified:

Compare and find similar strings in 2 fields and insert into MYSQL

I need to compare 2 items find the similar string and insert that into a row in MYSQL.

Here is an example.
SKU = abcdx
KEY= 123abcdy
The common characters in this example would be value= abcd

I want to insert into MYSQL SKU, KEY and then the value which are the common characters.
$p="";
$i=0;
do
{
  if ($i) $p = "@".$i;
  if ($record["CLASS/COLORGROUP/PRODUCT/KEY".$p])
  {
    $key = $record["CLASS/COLORGROUP/PRODUCT/KEY".$p];
    $color_code = $record["CLASS/COLORGROUP/PRODUCT/COLOR_CODE".$p];
    $color_code_description = $record["CLASS/COLORGROUP/PRODUCT/COLOR_DESCRIPTION".$p];
    $sql_ModelGroups= "insert into ModelGroups set
			
			
		                          SKU= '".mysql_real_escape_string( $record["CLASS/SKU"])."',
					`key`= '".mysql_real_escape_string($key )."',
					color_code='".mysql_real_escape_string($color_code)."',
					color_code_description='".mysql_real_escape_string($color_code_description)."'
					";
				   mysql_query($sql_ModelGroups) or die(mysql_error());
				  
	
  }$i++;
} while($record["CLASS/COLORGROUP/PRODUCT/KEY".$p]);

Open in new window

0
danjen
Asked:
danjen
  • 4
  • 3
1 Solution
 
Ray PaseurCommented:
See if this is what you had in mind.  Best regards, ~Ray
<?php // RAY_longest_common_substring.php
error_reporting(E_ALL); // THROWS A NOTICE IN THE FUNCTION
 
 
// TEST DATA FROM THE OP
$SKU = "abcdx";
$KEY = "123abcdy";
 
// FIND LONGEST COMMON STRING
$lcs = strlcs($KEY, $SKU);
var_dump($lcs);
 
// CREATE A QUERY, ETC...
$sql = "INSERT INTO ModelGroups SET lcs = \"$lcs\" WHERE sku = \"$SKU\"";
 
 
 
 
// FUNCTION FROM HERE: http://en.wikibooks.org/wiki/Algorithm_implementation/Strings/Longest_common_substring#PHP
function strlcs($str1, $str2)
{
   $m = strlen($str1);
   $n = strlen($str2);
   $L = array();
   $z = 0;
   $ret = "";
 
   for($i=0; $i<$m; $i++){
      $L[$i] = array();
      for($j=0; $j<$n; $j++){
         $L[$i][$j] = 0;
      }
   }
 
   for($i=0; $i<$m; $i++){
      for($j=0; $j<$n; $j++){
         if( $str1[$i] == $str2[$j] ){
            $L[$i][$j] = $L[$i-1][$j-1] + 1;
            if( $L[$i][$j] > $z ){
               $z = $L[$i][$j];
               $ret = "";
            }
            if( $L[$i][$j] == $z )
               $ret .= substr($str1, $i-$z+1, $z);
         }
      }
   }
   return $ret;
}

Open in new window

0
 
danjenAuthor Commented:
I get the following error.

Fatal error: Call to undefined function strlcs() in xml.php on line 119
0
 
Ray PaseurCommented:
That function is defined at line 20 in the code sample (tested and working) I just posted.  Please post the code that you used to get the error message.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
danjenAuthor Commented:
ok - maybe I don't understand. I thought the code at the bottom was just for reference. Which code listed should I use in the program?
0
 
danjenAuthor Commented:
I figured out the issue. Thank you so much for your help and for replying so quickly!!
0
 
danjenAuthor Commented:
Thank you so much for your help!
0
 
Ray PaseurCommented:
Thanks for the points - it's a great question! ~Ray
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now