|
Dynamically generate searchable sortable tables. |
Frequently throughout my pages I like to print out reports of data. The jquery tablesorter plugin is an excellent way to take this tabular data and make it sortable by column. However, since I do this so frequently, I wanted to create a script that would set up the plugin and add some other features, like an itunes like lazy search feature and highlighted hovered rows. So, on my pages, after my table is created I include the following javascript.
Note: This requires jquery and the jquery tablesorter plugin.
|
|
I use this function to run SQL queries from bash scripts.
fRunQuery(){
# This function should always be preceeded by a SQL statement
# Loaded into the variable SQL
# ie) SQL="SELECT * FROM table"; fRunQuery
# The results of the query will be loaded into the variable
# $RESULT:
RESULT=`mysql --skip-column-names -h${dbhost} $db -u${dbuser} -e"${SQL}" -p${dbpass}`
return 0
}
|
|
Javascript to format date like mm/dd/yyyy hh:mm:ss |
var today = new Date();
var dd = today.getDate();
var mm = today.getMonth()+1;//January is 0!
var yyyy = today.getFullYear();
var hours = today.getHours();
var minutes = today.getMinutes();
var seconds = today.getSeconds();
if(dd<10){dd='0'+dd}
if(mm<10){mm='0'+mm}
d=mm+'/'+dd+'/'+yyyy+' '+hours+':'+minutes+':'+seconds
|
The following code snippet will display a waiting indicator during any AJAX request.
//Adds a wait indicator to any ajax requests
$('body').ajaxStart(function() {
$('#loading').show();
});
$('body').ajaxStop(function() {
$('#loading').hide();
});
|
|
Just another IE6 layout hack. |
These just seem to add up.
<!--[if IE 6]>
<style type='text/css'>
div{zoom:1}
</style>
<![endif]-->
|
|
|
|
|
|
Page 1 of 3 |
