batch/signup: provide feedback for signup failures

[sql-web.git] / tpl / main.php

<?php

include 'head.php';

if (isset($i_dropask)) {
	$dropdbs = array_keys($i_dropask);
	echo '<form method="post" action="', $URI,'">';
	foreach($dropdbs as $dbname) {
		$msg1[] = 'Are you sure you want to drop `'.$dbname.'`? <input style="position:absolute; right:20px;" type="submit" name="drop['.$dbname.']" value="Yes">';
	}
	echo '</form>';
}

?>
<h2>Databases</h2>

<form method="post" action="<?=$URI?>">
<?php printErrors($err1); ?>
<?php printMsgs($msg1); ?>
</form>

<table width="100%">
<form method="post" action="<?=$URI?>">
<?php
	$bytes = $User->getBytes();
	$usage = $bytes['nBytes'];
	$total = $bytes['nBytesHard'];
	if (!count($myDBs)) {
		echo '<tr><td width="100%"><em>You have no databases. Add one below.</em></td></tr>';
	} else
	foreach($myDBs as $db) {
		echo '<tr><td width="100%">';
		if ($total>0)
			$percentage = $db['nBytes']/$total;
		else $percentage = 0;
		echo printBar($percentage, $db['Name'], str_replace(' ', '&nbsp;', sprintSize($db['nBytes'])));
		echo '</td><td>';
		echo '<input type="submit" name="dropask[',$db['Name'],']" value="drop">';
		echo '</td></tr>';
	}
	if ($total>0) {
		$percentage = $usage/$total;
	} else {
		$percentage = 0;
	}
	echo '<tr><td colspan=2>';
	echo '<hr />';
	echo '</td></tr>';
	echo '<tr><td colspan=2>';
	echo printBar($percentage, '<b>TOTAL&nbsp;USED</b>', str_replace(' ', '&nbsp;', sprintSize($usage).' of '.sprintSize($total)));
	echo '</td></tr>';
?>
</form>
</table>

<form method="post" action="<?=$URI?>">
<p align="right"><span style="width: 150px;"><label for="p1">new database:</label></span> <input type="text" name="newdb">
<input type=submit value="add"></p>
</form>

<h2>Manage Data</h2>
<p>One interface we recommend for managing SQL data is <a href="https://scripts.mit.edu/~sql/phpMyAdmin/" target="_blank">phpMyAdmin</a>. Feel free to use it after you've created your databases.</p>

<?php

include 'foot.php';

?>