smithi_3000
37a2ae2c2d
Everything previously under www/src now are under www/ Moved style.CSS under www/ressources, to allow blocking http requests to www/lib completly Moved <head> and <header> generation under lib/PHP/output/sections.php to reduce redundancy within files. Also implemented a system to allow them to generate relatif paht for href to ressources depending on their deepness within www/ hierarchy.
57 lines
1.3 KiB
PHP
57 lines
1.3 KiB
PHP
<?php
|
|
require_once '../lib/PHP/session/begin.php';
|
|
require_once '../lib/PHP/session/continue.php';
|
|
require_once '../lib/PHP/session/sessiontest.php';
|
|
require_once '../lib/PHP/session/nosessiontest.php';
|
|
require_once '../lib/PHP/output/sections.php';
|
|
?>
|
|
|
|
<html>
|
|
<?php print_website_meta(1, 'Direct Query - Project BDEE'); ?>
|
|
<body>
|
|
|
|
<?php print_website_header(1); ?>
|
|
|
|
<main>
|
|
<h1> Send a direct SQL request </h1>
|
|
<hr>
|
|
|
|
<form method="POST" action=direct_query.php>
|
|
<textarea name="query" id="query1" label="please enter a valid non-destructive SQL query" required='required' autofocus='autofocus' cols='50' rows='6' >
|
|
</textarea>
|
|
<input type="hidden" name="submited" value="True" />
|
|
<input type="submit" name="submitbut" value="envoyer" />
|
|
</form>
|
|
|
|
<?php
|
|
|
|
if(!isset($_POST["submited"])) { exit(0); }
|
|
|
|
require_once '../lib/PHP/db_connection/admin.php';
|
|
require_once '../lib/PHP/result_parsing/echo_table.php';
|
|
|
|
//The split queries and print result section.
|
|
echo "<hr>";
|
|
$queries = $_POST["query"];
|
|
$queries_arr = explode(';', $queries);
|
|
array_pop($queries_arr);
|
|
|
|
foreach($queries_arr as $query)
|
|
{
|
|
$query .= ';';
|
|
$result = sql_query($query, $db_connection);
|
|
echo "<h2> $query </h2>";
|
|
|
|
print_db_query_table($result); // PRINTING
|
|
|
|
$result->closeCursor();
|
|
}
|
|
|
|
close_db_connection($db_connection);
|
|
|
|
?>
|
|
|
|
</main>
|
|
|
|
</body>
|
|
</html>
|