check field for certain string (against array), remove, then update field.

[mrsocks]

HI,

I would like to create a script that takes a title of a product, reads it, checks to see if there is a string the same as a brand in the brand array and if so remove that brand in the title, then update the title in that feild.

EX:
read row 1 title field. (FORD Mustang 5.0)
check against band array (Chevy, FORD, GMC, Pontiac)
Remove "FORD" from title. (Mustang 5.0)
Update row 1 title field with (Mustang 5.0)

Now, i know i could while each row, then have it step through the brands in the array. That seems a bit inefficient considering that i have about 5000 rows and about 200 brands.

i dont have to do this often, only once actually.

is there a simpler way or am i missing something.

thanks.

[khaine]

You could just use str_replace in a loop its not a very good way of doing it regularly but you say your only doing this once so it shoulden't matter.

<?

$arr1=array("Chevy","FORD", "GMC", "Pontiac");
$str1="FORD Mustang 5.0";

for ( $loop=0; $loop<count($arr1); $loop++ )
{
    $tmp_str=str_replace($arr1[$loop], " ", $str1);
    $str1=trim($tmp_str);
}
echo $str1;

?>

Something like that will do it.

Mark.

[mrsocks]

yea, that is pretty much what i was thinking origianlly, but i just wanted to bounce this off the pros here to see if there was a more efficient way.

thanks for the reply.

[khaine]

If it was something that was being done on a regular basis it would be worth writing something more efficient and probably faster but for a one off. It will suffice just be carefull of timeouts.

Mark.

[Weedpacket]

You can pass arrays of strings to str_replace ... for all three arguments...

[khaine]

ah now that I diden't know. It would speed the whole thing up a hell of a lot. nice one weedpacket🙂

[mrsocks]

ok, maybe i am doing something wrong here. I am createing an array of brands, then calling the products and then stepping through the brands array for each title.

here is the code:
#######################
#######################
$sqlB = "SELECT name FROM brands ORDER by 'name' ASC";
$resultB = mysql_query($sql😎;
while ($rowB = mysql_fetch_array($result😎)
{
$name = $rowB["name"];
$brand_array[] = $name;
}

#####################
$sql = "SELECT id,title,brand FROM ITEMS ORDER by 'id' ASC";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result))
{
$id = $row["id"];
$title = $row["title"];
$brand = $row["brand"];

##############

while ($rowA = each($brand_array))
	{
	$a_string = $rowA['value'];
	$tmp_str = str_replace("$a_string","",$title);
	$titleD = trim($tmp_str);
	}

$sqlD = "update ITEMS SET title = '$titleD' where id = '$id'";
$sql_result_brandD = mysql_query($sqlD) or die ("count update title!");
######################

}

#######################
#######################

what i am able to get work is if i pull out the str_replace and only do it for one brand. if i use the each() (which i replaced from the for loop, just to check.) and i am getting the same result. the first title is used to update each record with the UN str_replaced title.

help!?
thanks.

[mrsocks]

ok,
this is what i am getting. I can get it to work ONE row at a time f i use the LIMIT attribute.

i am trying to use a for statement to count up a limiter number but that doesnt work.

the only time i am ablke to get this to work is if i manually enter the # into the first LIMIT attribute (ex. LIMIT 6,1)

any ideas?
thanks

#####################
#####################

$brand_array = array();

#####################
$sqlB = "SELECT name FROM brands ORDER by 'name' ASC";
$resultB = mysql_query($sql😎;
while ($rowB = mysql_fetch_array($result😎)
{
$name = $rowB["name"];
$brand_array[] = $name;
}
#####################
$click = 0;

$sqlNUM = "SELECT id,title FROM ITEMS";
$resultNUM = mysql_query($sqlNUM);
//$rows = mysql_num_rows($resultNUM);

$rows = 10;

for ( $loopD=0; $loopD <= $rows; $loopD++ )
{
#####################
$sql = "SELECT id,title FROM ITEMS ORDER by id ASC LIMIT $loopD,1";
$result = mysql_query($sql);

$row = mysql_fetch_array($result);
$id = $row["id"];
$title = $row["title"];

##############

while ($rowA = each($brand_array))
	{
	$a_string = $rowA["value"];
	$s_check = strpos($title,$a_string);

		if ($s_check === 0)
		{
		$tmp_str = str_replace($a_string,"",$title);
		$titleD = trim($tmp_str);
		echo $titleD;

		$sqlD = "update ITEMS SET title = '$titleD' where id = '$id'";
		$sql_result_brandD = mysql_query($sqlD) or die ("count update title!");
		}

	}

######################
}
##################