itlivewire dev blogJust another web development blog…

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

Karmic Koala ubuntu 9.10

http://www.ubuntu.com/GetUbuntu/download

The release names continues from Jaunty Jakalope to Karmic Koala… next stop is L****** L******

In dealing with files on ci use the file helper
http://codeigniter.com/user_guide/helpers/file_helper.html

It is loaded using this line
$this->load->helper(‘file’);

read a file with read_file()
$data = read_file(‘./path/to/file.php’);

write a file with write_file();
write_file(‘./path/to/file.php’, $data, ‘w+’);

CI recommends “r+” but its better to use “w+”

It came at the right time with android coming up, a feature, loooonged to be open and freeeee, how will this affect the paid turn by turn navi? I don’t know, but this one being free is a hit and this will change android’s game level from zero to hero