itlivewire dev blogJust another web development blog…

woorkup features the top jquery plugins of 2009

http://woorkup.com/2009/12/27/10-popular-jquery-plugins-in-2009-you-can%E2%80%99t-miss/

includes the very impressive mapbox and jqtouch

You’re busy coding finishing your web app, you need to put a santa icon or coffecup icon , though google might help save you’re search time.
Youre hoping there is website out there with enough icon archive ready for download and use.

www.iconarchive.com is the answer

From their website:
The Icon Archive is a categorized collection of high quality desktop & web icon sets. We currently host over
27,300 icons in 971 sets from 226 icon authors. Icons can be used for Windows (XP, Vista, etc.), Macintosh (OSX, OS) and Linux (as PNG Files). Copyright of icons belong to original authors. Public usage license can be found on each icon set page.

What impressed me with the site
– quick find on icons.
– rare icons like (ex. giraffe or toaster). is available
– They have apps icons, icons we see usually on apps (save,add,delete update,trash bin).
– quick download, right click save, you’re done, copyright applies read copyright first.
– FILE FORMAT is only at png some have .ico but most of the time I will need a transparent png for my web app buttons or tool bars

syntaxhighlighter by Alex Gorbatchev.
clean
simple
and easy to use,
install it then you’re of to go
what i like the most are the color themes

Here is an example:

<?php
$os = array("Mac", "NT", "Irix", "Linux");
if (in_array("Irix", $os)) {
    echo "Got Irix";
}
if (in_array("mac", $os)) {
    echo "Got mac";
}
?>

Download at wordpress.com:
http://wordpress.org/extend/plugins/syntaxhighlighter/

Lets say we have this table the ORDERS TABLE

ID customer ordered
—————————-
1111 – John – pizza
2222 – Pete – salad
3333 – Rach – pizza
4444 – Maxx – pizza
5555 – Zigg – rice
1212 – Vinc – salad
4545 – Grac – sushi
1313 – Mark – cake
2424 – Phils – salad

We only want to show items which has been ordered more than 2 times here is our query

—————————————————————————————————————————
SELECT *,count(ordered) as cnt FROM ORDERS group by ordered having cnt > 2
—————————————————————————————————————————-
result:
1111 – John – pizza
3333 – Rach – pizza
4444 – Maxx – pizza
2222 – Pete – salad
1212 – Vinc – salad
2424 – Phils – salad

We use here the having keyword

note: having will work if you have group by on your query

Perl cgi are errors are diplayed like this
“500 Internal Server Error”
It’s not useful, in tracing the your problem

Here are some points that may help you resolve the issue.

Try ASCII mode
Perl scripts are ASCII files when tranferings files from dev machine to server use ASCII mode

Change File Permissions
chmod all .pl and .cgi files

chmod +x *.cgi
chmod +x *.pl

Sun Java is promoting the JAVA STORE, somewhat like an istore for javap apps and java fx apps.

From the sun java website:
The Java Store is a JavaFX-powered storefront that provides an easy and secure means of discovering and acquiring compelling Java and JavaFX applications. Social networking, games, productivity tools and business applications are examples of what you can download from the Java Store. This easy-to-use storefront is free, and is available for U.S. residents

There will be games and apps, a good way for more people to know and experience java apps in their homes

Command to generate a decent random password

openssl rand -base64 6

When dealing in PHP with imported data from excel spreadsheets , you might encounter that excel dates looks very different.

Excel time looks like this 40179
You cannot compare or compute dates in PHP if it looks like that, it should be on unixtime
which looks like this 1104537600

Here is a quick function to convert excel date to unixtime date

<?
$DayDifference = 25569; //Day difference between 1 January 1900 to 1 January 1970
$Day2Seconds = 86400;// no. of seconds in a day
$ExcelTime = 30128;//integer value stored in the Excel column
$ExcelTime = substr($ExcelTime,0,5);//trim excel time get only whole 5 digit
$UnixTime = ($ExcelTime - $DayDifference)*$Day2Seconds;
echo $UnixTime;
?>