Skip to main content

Posts

Showing posts from November, 2013

PHP - Export MySQL data to EXCEL Example

I found an PHP function from the internet that can write data into true excel not just csv, and i adopted it into my project to put data from MySQL. Thanks to that site (i forgot the link). 1. download this file excel_function.php . 2. in your php file add this code <?php          function cleanData($str) {         $str = preg_replace("/\t/", "\\t", $str);         $str = preg_replace("/\r?\n/", "\\n", $str);         if(strstr($str, '"')) $str = '"' . str_replace('"', '""', $str) . '"';         return $str;     }         include('excel_function.php');     $query = "SELECT * FROM tablename";     if ($query){           include ('connect.php'); // connect to database     ...

Windows CE install/update/upgrade/restore

Windows CE install/update/upgrade/restore to factory default. I am having a problem with my wireless book(Netbook or Pocketbook) w/ windows CE 6.0 it was stuck at "Loading Drivers" and nothing happens afterwards. The only solution i can think is to reinstall WinCE 6.0 Prepare:     - 1GB SD Card (Format it as Normal not Quick in FAT)       - Charge the battery of Netbook up to 100% (in my experience, installation may failed if low battery)     - Download  WinCE 6.0 or in http://www.poodwaddle.com/netbook/WinCE.rar      - Extract that file into SD Card root folder (when you open you SD Card in explorer you can see that there is folder named "Script".    - That's all for the preparation Procedure:     1. Turn-off Netbook     2. Insert the SD Card     3. Turn-on netbook     4. It will automatically read and execute the content of the S...