Prosze wprowadzic parametry bazy i zapytania

uzytkownik:   serwer:
baza:   haslo:  
zapytanie:


Brak poprzedniego zapytania

"; echo "
Powrot do strony glownej"; exit; } $sserver = $_POST['sserver']; $suser = $_POST['suser']; $sdbase = $_POST['sdbase']; $spass = $_POST['spass']; if (!isset($_POST['sdbase']) ) { $db = "host=$sserver port=5432 user=$suser"; } else { $db = "host=$sserver port=5432 user=$suser dbname=$sdbase"; } $conn = pg_connect ("$db"." password=$spass"); if (!$conn) { echo "
An error occured!
\$db: ($db)\n"; echo pg_last_error($conn); exit; } $today = date ("G:i:s, j-n-Y"); echo "

Wynik zapytania z $today

"; echo "

Baza: \"$db\"

"; $query = $_POST['squery']; $result = pg_query ($conn, "$query"); if (!$result) { echo "An error occured.\n"; echo pg_result_error($result); exit; } echo "

Zapytanie: \"$query\"

"; echo "

Wynik zapytania w tabeli z nazwami i typami pol

"; echo "

"; $fie = pg_num_fields($result); echo ""; } echo "
Rekord"; for ($i=0; $i < $fie; $i++) { $r = pg_field_name ($result,$i); $t = pg_field_type ($result,$i); echo " $r ($t)"; } $num = pg_num_rows($result); for ($i=0; $i < $num; $i++) { echo "
$i"; $r = pg_fetch_row($result, $i); for ($j=0; $j < count($r); $j++) { echo " $r[$j]"; } echo "

"; pg_free_result($result); pg_close($conn); echo "
Powrot do strony glownej"; } ?>