if ($searchOper == 'eq') { $searchString = $searchString; } if ($searchOper == 'bw' || $searchOper == 'bn') { $searchString .= '%'; } if ($searchOper == 'ew' || $searchOper == 'en') { $searchString = '%' . $searchString; } if ($searchOper == 'cn' || $searchOper == 'nc' || $searchOper == 'in' || $searchOper == 'ni') { $searchString = '%' . $searchString . '%'; } $where = "{$searchField} {$ops} '{$searchString}'"; $advertisements = Advertisement::get_by_sql("SELECT * FROM " . T_ADVERTISEMENTS . " WHERE " . $where . " AND userid = " . $session->userid . " ORDER BY {$sidx} {$sord} LIMIT {$start} , {$limit}"); } else { $advertisements = Advertisement::get_by_sql("SELECT * FROM " . T_ADVERTISEMENTS . " WHERE userid = " . $session->userid . " ORDER BY {$sidx} {$sord} LIMIT {$start} , {$limit}"); } header("Content-type: text/xml;charset=utf-8"); $s = "<?xml version='1.0' encoding='utf-8'?>"; $s .= "<rows>"; $s .= "<page>" . $page . "</page>"; $s .= "<total>" . $total_pages . "</total>"; $s .= "<records>" . $count . "</records>"; foreach ($advertisements as $advertisement) { $s .= "<row id='" . $advertisement->id . "'>"; $s .= "<cell></cell>"; // action $s .= "<cell>" . $advertisement->appname . "</cell>"; $s .= "<cell>" . $advertisement->image . "</cell>"; $s .= "<cell>" . $advertisement->text . "</cell>"; $s .= "<cell>" . $advertisement->url . "</cell>";