81 Billion

Websites in Singapore that are highly effective and visually appealing

Excel has detected that “filename” is a SYLK file but cannot load it …

This error occurs when the first 2 characters in the file is “ID”. It tells Excel that the file is SYLK or “SYmbollic LinK” when actually it’s not. Changing the “ID” to lower case like “id” will solve the problem.

Export mysql data to Excel

<?PHP // Original PHP code by Chirp Internet: www.chirp.com.au include(“source/includes/database.php”); function cleanData(&$str) { // escape tab characters $str = preg_replace(“/\t/”, “\\t”, $str); // escape new lines $str = preg_replace(“/\r?\n/”, “\\n”, $str); // convert ‘t’ and ‘f’ to boolean values if($str == ‘t’) $str = ‘TRUE’; if($str == ‘f’) $str = ‘FALSE’; // force certain number/date […]

Customising WordPress

Changing WordPress Login URL Add following to the top of the .htaccess file: RewriteRule ^login$ http://YOUR_SITE.com/wp-login.php [NC,L] Changing the style of Visual Editor in Admin add_filter(‘mce_css’, ‘my_editor_style’); function my_editor_style($url) { if ( !empty($url) ) $url .= ‘,’; // Change the path here if using sub-directory $url .= trailingslashit( get_stylesheet_directory_uri() ) . ‘editor-style.css’; return $url; } […]


    This is an area on your website where you can add text. This will serve as an informative location on your website, where you can talk about your site.

    Subscribe to our feed