因為在XML中 <,&是不准許的,轉換xml時會報錯
這時候會使用![CDATA[做標記避免此問題

像是java hibernate就常使用此標記,避免sql比較符導致xml格式錯誤

    <sql-query name="table">
        <![CDATA[
            select * from table where id < 10001 
          ]]>
    </sql-query>

新的問題:

我用的是opencart,這是完整的code:

<operation>
	<search index="0" offset="0">
		<![CDATA[
			if (!empty($data['filter_email'])) {
		]]>
	</search>

	<add position="before">
		<![CDATA[
			if (!empty($data['filter_company'])) {
				$implode[] = "a.company LIKE '%" . $this->db->escape($data['filter_company']) . "%'";
			}
		]]>
	</add>
</operation>

回答:

總結意思是 : 搜尋字串包含 if (!empty($data['filter_email'])) { 的第一組資料,在它之前添加以下程式碼:

if (!empty($data['filter_company'])) {
	$implode[] = "a.company LIKE '%" . $this->db->escape($data['filter_company']) . "%'";
}

舉例:

原始php代碼如下

if (!empty($data['filter_email'])) {
	//Logic
}
if (!empty($data['filter_email'])) {
	//Logic
}

系統會生成

if (!empty($data['filter_company'])) {
	$implode[] = "a.company LIKE '%" . $this->db->escape($data['filter_company']) . "%'";
}
if (!empty($data['filter_email'])) {
	//Logic
}
if (!empty($data['filter_email'])) {
	//Logic
}