我如何用静态值动态替换产品名称从数据库中获取所有产品名称,但我想创建一个函数,将在从数据库中获取所有记录后替换产品名称中的一些单词。
例如"Zon Stock"是一个从数据库中获取的产品名称,我希望系统只替换Stock
,不应该替换Zon Stock
完成的产品名称
问题是,我的代码是工作良好,但只与硬代码工作,不与动态记录
静态代码
$a="this is testing script STOCK,stock,Stock";
$replaceWord=array("
STOCK " => "UAE PRODUCTS",
"stock" => "uae products",
"Stock" => "Uae Products");
$new_test= strtr($a, $replaceWord);
echo $new_test;
但相同的代码不工作与product name field
从数据库获取
$query=mysql_query("select pnames from products order by pid asc");
while($row=mysql_fetch_array($query))
{
$a = $row['pnames'];
$replaceWord=array("
STOCK " => "UAE PRODUCTS",
"stock" => "uae products",
"Stock" => "Uae Products");
$new_test= strtr($a, $replaceWord);
echo $new_test;
}
谢谢你我已经完成了我的脚本在这里
here my script
$query=mysql_query("select pnames from products order by pid asc");
$row=mysql_fetch_array($query);
$a=$row['pnames'];
$replaceWord=array(
$a="STOCK" => "UAE DUBAI",
$a="stock" => "uae dubai",
$a="Stock" => "Uae Dubai");
echo $new_row['Name'] = strtr($row['pnames'], $replaceWord);
试试这个代替…
$query = mysql_query("select pnames from products order by pid asc");
while($row=mysql_fetch_array($query)) {
$a = $row['pnames'];
// for simplicity I'm using function here
$get_result = word_replace($a);
}
function word_replace($key) {
// array of static words
$replaceWord = array(
"STOCK " => "UAE PRODUCTS",
"stock" => "uae products",
"Stock" => "Uae Products"
);
// Find in array
if (array_key_exists($key, $replaceWord)) {
// replace that string
$replace_string = $replaceWord[$key];
} else {
$replace_string = $key;
}
return $replace_string;
}
也许这个对你有帮助。