Skip to main content

Posts

Showing posts from 2013

DNS Servers List (PLDT / Globe)

Source:  http://hostingtutorials.ph/knowledgebase/whcp/webhosting%20issues/dns2 PLDT DNS Servers: * 58.69.254.3 * 58.69.254.4 * 58.69.254.8 * 58.69.254.9 * 58.69.254.43 * 58.69.254.46 * 58.69.254.70 * 58.69.254.72 * 58.69.254.103 * 58.69.254.104 * 58.69.254.106 * 58.69.254.134 * 58.69.254.137 * 202.57.96.4 * 203.87.128.3 * 203.172.11.21 * 203.172.11.25 * 203.172.11.26 Globe DNS Servers: * 202.52.163.6 * 202.52.163.7 * 202.126.40.5 * 202.95.226.66 * 202.52.162.39 * 202.52.162.40 * 202.95.226.66 * 202.95.226.77 These dns servers are free to all.This will improve your browsing speed with following DNS servers. Open DNS Servers: (Highly Recommended) http://www.opendns.com * 208.67.222.222 * 208.67.220.220 Advantage DNS Servers: (Alternative) http://www.dnsadvantage.com * 156.154.70.1 * 156.154.71.1

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...

Responsive Text Size

HTML Design: Responsive Text Size Tested: Bootstrap Framework 1vw = 1% of viewport width 1vh = 1% of viewport height 1vmin = 1vw or 1vh, if smaller  1vmax = 1vw or 1vh, if larger  Example:   h1 { font-size: 5.9vw; }  h2 { font-size: 3.0vh; }  p { font-size: 2vmin; }

Unable to setup Default Printer, error message: 0X00000709

Unable to setup Default Printer, error message: 0X00000709 Open Registry Editor Goto  HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\Windows Right-Click Windows->Permission Checked Allow Full Control Delete Device Key Restart Computer

Search Value from the list (Excel VLOOKUP Function)

Excel VLOOKUP Function Syntax: VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) Scenario: You want to check if a certain word exists from the list and get the corresponding  row value. Procedure: Select the array of data.In below image I selected  A1 to C4 .   So, if you want to get the address of Toshiba. we can do it like this. =VLOOKUP("Toshiba",A1:C4,2,FALSE) Note: lookup_value is not case sensitive. if you want to get the price of Toshiba. we can do it like this. =VLOOKUP("Toshiba",A1:C4,3,FALSE) We only change the col_index_num into 3.