itlivewire dev blogJust another web development blog…

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;
?>

Error:
PHP ERROR Allowed memory size of 8388608 bytes exhausted
In php it means your memory use has exceeded the memory limit set by to execute a function.

Solution:
Type this above the function you are trying to excute
ini_set(”memory_limit”,”16M”);
or any desired memory size you wish

On snow leopard the bundled version of PHP installed is 5.3 And it’s new PHP mysql driver is mysqlnd not the old one (ext/mysql)

This might cause the following error:
mysqlnd cannot connect to MySQL 4.1+ using old authentication

Solution:
type in mysql

SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

Findings:
Because mysqlnd has a bigger password hash it will not be compatible anymore with the password written beforehand.

Ref:
http://dev.mysql.com/doc/refman/5.1/en/old-client.html

So Easy to use on your web apps
You can customize the css,colors
Lightsize,clean code
Compatible with ie6,ie7,ie8,firefox, safari and chrome
Web 2.0 style buttons
http://www.p51labs.com/simply-buttons-v2/

A very promising java web development framework
build your java web apss fast using the play framework
nice templating style, easy integration of java libraries and many more

Here is a nice vid on play framework

A web app in 10 minutes using Play! from zenexity on Vimeo.

Don’t do everything that is possible only what is necessary