Skip to content
Permalink
master
Switch branches/tags

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?
Go to file
 
 
Cannot retrieve contributors at this time
</div>
</div>
<div class="span3">
<div id="blog-sidebar" role="complementary">
<ul id="sidebar-widgets">
<li id="text-5" class="widget widget_text">
<h2 class="widget-title" >Colleges Query</h2>
<div class="textwidget">
<form class="form-horizontal">
<div class="control-group">
<input type="hidden" value="true" name="query_submitted_univ">
<span class="input-prepend input-append date">
<input type="text" class="input-small" name="start_date" id="start_date" size="10" maxlength="10" placeholder="Start Date" >
<span class="add-on"><i class="icon-calendar"></i></span>
</span>
<br /><br />
<span class="input-prepend input-append date">
<input type="text" class="input-small" name="end_date" id="end_date" size="10" maxlength="10" placeholder="End Date">
<span class="add-on"><i class="icon-calendar"></i></span>
</span>
<br /><br />
<input type="submit" name="submit" value="Submit" id="submitbutton" class="btn btn-primary" />
<!--<button type="button" class="btn btn-secondary" onclick="Print();">Print Query</button>-->
</div>
</form>
<hr />
<?php
$query_submitted = $_GET['query_submitted_univ'];
$start_date = $_GET['start_date'];
$end_date = $_GET['end_date'];
if($query_submitted == "true"){
mysql_connect($dbhost,$dbuser,$dbpass);
@mysql_select_db($dbname) or die("Unable to select database");
echo'<br>
<div>
<table class="report_table">
<tr>
<th>Report Between: <br />' . $start_date . ' and ' . $end_date . '</th>
</tr>
<tr>
<th class="col1">University Name</th>
</tr>';
$query_admin = "SELECT DISTINCT `institution`
FROM `cs_pkg`
WHERE (DATE(`time`) BETWEEN '$start_date' AND '$end_date')
GROUP BY `institution`
DESC";
$result_admin=mysql_query($query_admin);
while($row_admin = mysql_fetch_assoc($result_admin)){
echo "<tr><td>" . $row_admin['institution'] . "</td></tr>";
}
echo '</table></div>';
}
mysql_close();
?>
</table>
</div>
</li>
</ul>
</div>
</div
</div>
</div><!--#uc-main-->
<div id="uc-footer">
<div class="container">
<ul id="uc-footer-links" class="clearfix">
<li>
© <a href="http://uconn.edu">University of Connecticut</a>
</li>
<li>
<a href="http://uconn.edu/disclaimers-and-copyrights.php">Disclaimers, Privacy &amp; Copyright</a>
</li>
<li>
<a href="http://financialaid.uconn.edu/wp-admin/">Webmaster Login</a>
</li>
<li id="menu-item-2208" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2208">
<a href="http://financialaid.uconn.edu/student-consumer-information/">Student Consumer Information</a>
</li>
</ul>
</div>
</div>
</body>
</html>