$DB->commit(); $_POST['item']['id'] = $id; } } } } catch (Exception $e) { $DB->rollBack(); addMessage($e->getMessage()); } } else { $_POST['item'] = array(); if ($id) { $_POST['item'] = fetchItem($id); } else { if (@$_GET['clone']) { $_POST['item'] = fetchItem($_GET['clone']); unset($_POST['item']['id']); // very important! } else { $_POST['item']['sql'] = "SELECT COUNT(*)\nFROM some_table\nWHERE created BETWEEN \$FROM AND \$TO\n"; } } } } $SELECT_DSNS = array(); foreach ($DB->select("SELECT id, name FROM dsn ORDER BY name") as $row) { $SELECT_DSNS[$row['id']] = $row['name']; } $SELECT_ITEMS = array(); $seenArchived = 0; foreach ($DB->select("SELECT id, name, archived FROM item ORDER BY archived, name") as $row) {
$res = dbQuery("insert into queries (name, description, query, created) values({$_POST['name']}, {$_POST['description']}, {$_POST['query']}, NOW())"); $query_id = $db->insert_id; } if ($db->affected_rows >= 1) { $info = "Query saved"; } } else { if ($action == 'runquery') { $query = fetchItem("select query from queries where query_id=" . $_POST['query_id']); $res = dbQuery($query); if ($res) { $info = 'Query successfully returned ' . $res->num_rows . ' rows.'; $output = exportTSV($res); #$info.= "<pre>".str_replace("\n", '<br/>', $output)."</pre>"; $res = dbQuery('update queries set executed=NOW() where query_id=' . $_POST[query_id]); $executed = fetchItem('select executed from queries where query_id = ' . $_POST[query_id]); } echo "error = \"{$error}\"; info=\"{$info}\"; executed=\"" . str_replace(' ', '<br/>', $executed) . "\";"; exit; } } } } } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <title>Minerva Project Query Manager</title> <meta http-equiv="Content-Type" content="text/html;charset=utf-8" />