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                  $queryGenerate = $mysqli->query($query);         if ($queryGenerate){                                            $num = $queryGenerate->num_rows;          

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 SD Card     5. It will restart automatically and load the software package, and you can see ang windows deskto