| <?php |
| $user = $_POST["User"]; |
| $password = $_POST["Password"]; |
| $queries = $_POST["Queries"]; |
| $was_query = isset($queries); |
| if (!isset($user)) $user = ""; |
| if (!isset($password)) $password = ""; |
| if (!isset($queries)) $queries = ""; |
| ?> |
| |
| <HTML> |
| <HEAD> |
| <STYLE TYPE="text/css"> |
| TD |
| { |
| font-family: Arial, Helvetica, sans-serif; |
| font-size: 12px; |
| } |
| </STYLE> |
| </HEAD> |
| <BODY> |
| |
| <?php |
| print <<<EOD |
| <FORM ACTION="http://llvm.org/nightlytest/SQLQuery.php" METHOD="post" ID="MyForm"> |
| <TABLE> |
| <TR> |
| <TD>User:</TD> <TD><INPUT NAME="User" ID="User" TYPE="text" VALUE="$user" SIZE="30"><BR></TD> |
| </TR> |
| <TR> |
| <TD>Password:</TD> <TD><INPUT NAME="Password" ID="Password" TYPE="password" VALUE="$password" SIZE="30"><BR></TD> |
| </TR> |
| <TR> |
| <TD>Query:</TD> <TD><TEXTAREA ID="Queries" NAME="Queries" ROWS="10" COLS="100">$queries</TEXTAREA><BR></TD> |
| </TR> |
| </TABLE> |
| <BUTTON TYPE="submit" ID="Send" NAME="Send" VALUE="Send">Query</BUTTON><BR> |
| </FORM> |
| EOD; |
| |
| if ($was_query) { |
| $queries = split("\n", $queries); |
| |
| $mysql_link = mysql_connect("127.0.0.1", $user, $password, false, CLIENT_MULTI_STATEMENTS) or die("Error: could not connect to database!\n"); |
| mysql_select_db("nightlytestresults"); |
| |
| foreach ($queries as $query) { |
| $query = rtrim($query); |
| if (strlen($query) == 0) continue; |
| |
| if ($my_query = mysql_query($query)) { |
| print "<TABLE>\n"; |
| $heading = false; |
| |
| while ($row = mysql_fetch_assoc($my_query)) { |
| if (!$heading) { |
| print " <TR STYLE=\"font-weight: bold;\">"; |
| foreach ($row as $key => $value) { |
| print " <TD>$key</TD>"; |
| } |
| print " </TR>\n"; |
| $heading = true; |
| } |
| |
| print " <TR>"; |
| foreach ($row as $key => $value) { |
| print " <TD>$value</TD>"; |
| } |
| print " </TR>\n"; |
| } |
| |
| print "</TABLE><BR><BR><BR>\n"; |
| |
| mysql_free_result($my_query); |
| } else { |
| $error = mysql_error(); |
| print "<B>$error</B><BR><BR><BR>\n"; |
| } |
| } |
| |
| mysql_close($mysql_link); |
| } |
| |
| ?> |
| |
| </BODY> |
| </HTML> |
| |