browse.php

<?php
/*

SQL Buddy - Web based MySQL administration
http://www.sqlbuddy.com/

browse.php
- browse table - just grabs variables and passes them to include_browse.php

MIT license

2008 Calvin Lough <http://calv.in>

*/

include "functions.php";

loginCheck();

requireDatabaseAndTableBeDefined();

if (isset($db))
	$conn->selectDB($db);

//run delete queries

if (isset($_POST['runQuery'])) {
	$runQuery = $_POST['runQuery'];
	
	$queryList = splitQueryText($runQuery);
	foreach ($queryList as $query) {
		$conn->query($query);
	}
}

if ($conn->getAdapter() == "sqlite") {
	$query = "SELECT * FROM '$table'";
} else {
	$query = "SELECT * FROM `$table`";
}

$queryTable = $table;

if (isset($_POST['s']))
	$start = (int)($_POST['s']);
else
	$start = 0;

if (isset($_POST['sortKey']))
	$sortKey = $_POST['sortKey'];

if (isset($_POST['sortDir']))
	$sortDir = $_POST['sortDir'];
else if (isset($sortKey))
	$sortDir = "ASC";

if (isset($_POST['view']) && $_POST['view'] == "1")
	$view = 1;
else
	$view = 0;

if (isset($sortKey) && $sortKey != "" && isset($sortDir) && $sortDir != "") {
	$sort = "ORDER BY `" . $sortKey . "` " . $sortDir;
} else {
	$sort = "";
}

require "includes/browse.php";

?>