<?php

include "tete.php3";

function displayform($dbname, $query) {
	echo "<font face=\"verdana, arial, helvetica\" size=-1>";
	echo "<form name=\"dbquery\" method=post action=\"querysql.php3\">";
	echo "<b>Nombre del base de datos:</b><br>";
	echo "<input type=text name=\"dbname\" size=10 value=\"$dbname\"><p>";
	echo "<b>SQL Query:</b><br>";
	echo "<textarea name=\"query\" cols=60 rows=10>$query</textarea><br>";
//	echo "<input type=radio name=\"type\" value=\"select\" checked>  SELECT  <input type=radio name=\"type\" value=\"other\"> OTHER<p>";
	echo "<input type=submit value=\"GO\"><p>";
}

$select = strstr($query, "select");

if ($dbname && $query && $select) {

	$conn = pg_pconnect("dbname=$dbname user=mike");

	$querydata = pg_exec($conn, $query);
	$row = 0;
	$field = 0;

	echo "<font size=+2>SQL QUERY RESULTADOS</font><br>";
	echo "<b>DB:</b>  $dbname<br>";
	echo "<b>Query:</b>  $query<br></br>";
	echo "<table border=0 cellspacing=2 cellpadding=2>";
	echo "<tr>";	

	do {
		echo "<th bgcolor=#8080ff><font face=\"verdana, arial, helvetica\" size=-1>".pg_fieldname($querydata, $field)."</th>";
		$field++;
	} while ($field < pg_numfields($querydata));
	
	echo "</tr>";
	
	if (pg_numrows($querydata) != 0) {
		do {
			$fieldnum = 0;
			echo "<tr>";
			$getdata = pg_fetch_row($querydata, $row);
			do {		
				echo "<td bgcolor=#BFBFFF><font face=\"verdana, arial, helvetica\" size=-1>$getdata[$fieldnum]</td>";
				$fieldnum++;
			} while ($fieldnum < pg_numfields($querydata));
			$row++;
			echo "</tr>";
		} while ($row < pg_numrows($querydata));
	} else {
		echo "<tr>";
		echo "<td bgcolor=#BFBFFF colspan=".pg_numfields($querydata)." align=left><font face=\"verdana, arial, helvetica\" size=-1><i>No hay datos</i></td>";
		echo "</tr>";
	}

	echo "</table>";
	displayform($dbname, $query);

} 

if ($dbname && $query && !$select) {

	echo "<font size=+2>SQL QUERY RESULTADOS</font><br>";
	echo "<b>DB:</b>  $dbname<br>";
	echo "<b>Query:</b>  $query<br></br>";
	echo "Su query se llev&oacute; al cabo...<p>";

	$conn = pg_pconnect("dbname=$dbname user=mike");
	$querydata = pg_exec($conn, "$query");

	displayform($dbname, $query);
}


if (!$dbname || !$query) {

	echo "<font size=+2>Ejecutar un SQL Query</font><br></br>";
	displayform($dbname, $query);
}




?>
