register('getImageHREF'); function getImageHREF($name, $size) { // Catch error of no name if ($name =="") { return new soap_fault('Client','','Must supply a valid name.'); } if(!mysql_connect("localhost")) { /* Add some kind of error message or function for the none existence of the database server. */ echo "File was not valid1"; exit; } else { $db=mysql_connect("localhost"); if(!mysql_select_db("image_database")) { /* Add some kind of error message or function for the none existence of the database. This is less likely than the error above. Probably will arise due to maintenance or other similar reasons. */ echo "File was not valid2"; exit; } else { mysql_select_db("image_database"); } } $sql = 'SELECT `filename`,`name` FROM `image`,`taxon` WHERE `name` LIKE \''.$name.'%\' '; $sql .= 'AND `taxon` = `taxon_id` AND `taxon_type_image` = `id` '; $result = mysql_query($sql); $num = mysql_num_rows($result); $db_result = array('num'=>0, 'hrefs'=>'NULL', 'jpegs'=>'NULL', 'names'=>'NULL'); if ($num != 0) { // name exist in database for ($i = 0; $i < $num; $i++) { $filename = mysql_result($result,$i,0); $string = substr($_SERVER["REQUEST_URI"],0,(strlen($_SERVER["REQUEST_URI"])-16)); $taxon_names[$i] = mysql_result($result,$i,1); $hrefs[$i] = 'http://'.$_SERVER["SERVER_NAME"].$string.'upload/user_uploads/'.$filename; $jpegs[$i] = 'http://'.$_SERVER["SERVER_NAME"].$string.'upload/thumbCreate.php?filename='.$filename.'&size='.$size; } $db_result['names'] = $taxon_names; $db_result['hrefs'] = $hrefs; $db_result['jpegs'] = $jpegs; $db_result['num'] = $num; } mysql_free_result($result); return $db_result; } $s->service($HTTP_RAW_POST_DATA); ?>