$s .= "<th>" . $rr . "</th>"; $temparr = array($r[1] => $r[0]); $cat = array_merge($cat, $temparr); } } print_r($cat); $s .= "</tr>"; $sql_string = "select * from sec_attribute order by name;"; $result = pg_exec($dbconn, $sql_string); if ($result) { while ($r = pg_fetch_row($result)) { $s .= "<tr><td>" . $r[1] . "</td>"; $s .= "<td>" . $type[$r[3]] . "</td>"; $s .= "<td>" . $r[2] . "</td>"; foreach ($cat as $c => $k) { $s .= "<td align=\"center\">"; $sql_string2 = "select * from sec_cat_attr where cat_id={$k} AND attr_id=" . $r[0] . ";"; $result2 = pg_exec($dbconn, $sql_string2); $ch = pg_num_rows($result2) > 0 ? "X" : " "; $s .= $ch; $s .= "</td>"; } $s .= "</tr>"; } } $s .= "</table>\n"; // --------------------------------------- pg_close($dbconn); $s .= sec_footer(); fwrite($f1, $s); fclose($f1);
$error_string = $max_xml_error; } else { if ($result == '' or strpos($result, "error") > 0) { $error = 1; //I can't understand why $result is empty when error occurs in sec_server.php !!! // $f1 = fopen("$secdir/temp/testserver.xml",'r'); // $error_string = fgets($f1); // fclose($f1); $error_string = $result; } else { $p = votable_parse($result); if ($p == '') { $error = 1; $error_string = "XML parsing error"; } else { echo $p; // save TXT file $vot = votable_parse_text($result); $res = fopen("{$secdir}/xml/{$txt1}", 'w'); fwrite($res, $vot); fclose($res); } } } unset($soapclient); } if ($error > 0) { echo "<H2>Error</H2><H3>{$error_string}</H3><br>"; } echo sec_footer();
function sec_error($msg) { echo '<h2>ERROR</h2>'; echo $msg; echo sec_footer(); }