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

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.