php mysql string replacement method_PHP tutorial

This article shares an article about the method of replacing strings in php mysql. Students in need can refer to it.

The code is as follows  代码如下 复制代码 function replace(){ $sql = db_query("SELECT field_languages_value,nid FROM {content_type_company_profile} WHERE field_languages_value like '%Mandarin Chinese%'"); while($result = db_fetch_object($sql)){ $a = explode("Mandarin Chinese",$result->field_languages_used_value); $b = $a[].'Chinese'.$a[1]; db_query("UPDATE content_type_company_profile SET field_languages_used_value = '%s' WHERE nid = % d",$b,$result->nid); } } ?>

Copy code

function replace(){
$sql = db_query("SELECT field_languages_value,nid FROM {content_type_company_profile} WHERE

field_languages_value like '%Mandarin Chinese%'");
while($result = db_fetch_object($sql)){
$a = explode("Mandarin Chinese",$result->field_languages_used_value);
$b = $a[].'Chinese'.$a[1];
db_query("UPDATE content_type_company_profile SET field_languages_used_value = '%s' WHERE nid = %

www.bkjia.comhttp: //www.bkjia.com/PHPjc/632942.htmlTechArticleThis article shares an article about the php mysql string replacement method. Students in need can refer to it. The code is as follows Copy the code ?php function replace(){ $sql = db_query(SELECT field_l...