Date is a import for repoarting system. Sometime, we forget about the date(). I forget about some function in date() and I have many problem occur in reporting system.

First thing is minute. I though, minute is a m and so I use like that date(“h:m:s”); It was wrong. Minute use i not m.  You can check in there. Another problem is a time zon. date() also retrive the UTF time zone and we need to config it. I found that in php.net. It’s very suitable but I use like that.

putenv(“TZ=Singapore”);
$sg_day=date(“m-d-y H:i”);

It’s a short and easy to understand. So, I use like that and config timezone to singapore. Now, my reporting system corrected and I was happy for learning about date() function.

Cheer!!

I seeing movie in you tube and sometime I want to download it. When I am working , I can’t see you tube. I want to see after the work without buffer loading. I use youtube grabber for this condition. You can just add link in Youtube grabber and it will be download to your document. It’s so nice and I am happy it. I can see movie when I finsihed the work.

Download Youtube Grabber

We can crack WEP wireless with Ubuntu. We need to install these package.

$sudo apt-get install aircrack-ng

I think, iw package will be install. iw package is need for WEP wireless cracking. For sure, try this

$sudo apt-get install iw

After that, you can see in WEP cracking with backtrack 3. It same like in Ubuntu. But Ubuntu need sudo in all of the command. If you don’t want, you need to type this command.

$sudo bash

After that sudo command don’t need it. You can do like in youtube.

If we want to change excel file to mysql, we can change with MySQL Migration Toolkit that contain in MySQL GUI Tool.

1. Change .Excel file to MS Access. You can import excel file in MS Access.

2. Open MySQL Migration Toolkit and choose MS Access. You will do setp by step with wizard. It’s easy, don’t worry it.

3. You will see new database in mysql. Ok. Export only tables from phpmyadmin and then import the another database that you want to import.

It’s easy and you can do csv to mysql like that. You need to open csv with excel and save as xls. After that you can do from step 1.

Cheer!!!