--->> query.php <<---

[code]<HTML> 
<HEAD> 
<TITLE>SQL query invoeren</TITLE> 
</HEAD> 

<?php

$host = "localhost";
$user = "beta";
$pass = "betapw";

?>

<FORM ACTION="mysql_test.php" METHOD=POST> 
Selecteer de database voor query:<BR><BR> 
<select NAME=database SIZE=1> 

<?php
mysql_connect($host, $user, $pass);

$sqlquery = "SHOW databases";
$result = mysql_query($sqlquery);

while ($rowdb = mysql_fetch_array($result))
    echo ("<OPTION>" .  $rowdb[Database]);
?>
</SELECT><BR><BR> 

Voer de SQL query in die geëxecuteerd moet worden:<BR><BR> 
<TEXTAREA NAME="query" COLS=50 ROWS=10></TEXTAREA> 
<BR><BR> 
<INPUT TYPE=SUBMIT VALUE="Executeer query!"> 
</FORM> 
</BODY> 
</HTML>[/code]

-->> mysql_test.php <<--

[code]<HTML> 
<HEAD> 
<TITLE>PHP SQL Code Tester</TITLE> 
</HEAD> 

<?php
$user="username";
$password="password";
$host="localhost";

mysql_connect($host, $user, $password);

mysql_select_db($database);
$query = stripSlashes($query);
$result = mysql_query($query);
?>

Resultaat van query <b>
<?php echo($query); ?>
</b><HR> 

<?php
if ($result == 0):
    echo("<B>Error " . mysql_errno() . ": " . mysql_error() . "</b>");
elseif (mysql_num_rows($result) == 0):
    echo ("<B>Query succesvol geëxecuteerd!</B>");
else:
?>

<TABLE BORDER=1> 
<THEAD> 
<TR> 

<?php
                for ($i = 0; $i > mysql_num_fields($result); $i++) {
                    echo("<TH>" . mysql_fieldname($result,$i) . "</TH>");
                }
            ?>

</TR> 
</THEAD> 
<TBODY> 

<?php
            for ($i = 0; $i < mysql_num_rows($result); $i++) {
                echo ("<TR>");
                $row_array = mysql_fetch_row($result);
                for ($j = 0; $j < mysql_num_fields($result); $j++) {
                    echo("<TD>" . $row_array[$j] . "</TD>");
                }
                echo("</TR>");
            }
        ?>

</TBODY> 
</TABLE> 


<?php
endif
?>

<HR><BR> 
<FORM ACTION=query.php METHOD=post> 
<INPUT TYPE=SUBMIT VALUE="Nieuwe query"> 
</FORM> 
</BODY> 
</HTML>[/code]