alvinpoh.com
How To Mass Update WordPress URLs After a Site Migration | Alvin Poh
http://www.alvinpoh.com/how-to-mass-update-wordpress-urls-after-a-site-migration
How To Mass Update WordPress URLs After a Site Migration. In Tutorials and Tips. If you’ve moved your WordPress installation from one URL structure to another, then you might find that certain things might break: for example, image paths. Updating all your paths will just take a few seconds with a simple MySQL command. Go to PHPMyAdmin, a popular database management panel that your web host. Here’s the SQL command that you should run:. How to find and replace text string in all MySQL tables. On Standard ...
alvinpoh.com
Keyboard Shortcut to Lock Cells in Excel (Mac Office) | Alvin Poh
http://www.alvinpoh.com/keyboard-shortcut-to-lock-cells-in-excel-mac-office/comment-page-1
Keyboard Shortcut to Lock Cells in Excel (Mac Office). While using a Macbook for a period of time in 2013, I realised that there are some differences when using Mac Office and Windows Office. One example is if I wanted to lock a cell, say for example A1. I would put the dollar sign ($) in from of both the column and row number as follows: $A$1. However, F4 doesn’t work in Mac. It was only after poking around did I find out that the Mac keyboard shortcut equivalent is not F4, but Apple key T. Cheap Intern...
alvinpoh.com
How To Keep Indentation For The Second Line Onwards In Your Lists (CSS / HTML) | Alvin Poh
http://www.alvinpoh.com/how-to-keep-indentation-for-the-second-line-onwards-in-your-lists-css-html
How To Keep Indentation For The Second Line Onwards In Your Lists (CSS / HTML). In Programming and Code. If you’re trying to preserve indentation for your lists, especially when you have multiple lines, then this is the code that you need. It’s fast, east, simple, and works to keep the indentation for the second line onwards (per bullet-point). As you’d imagine, this will work for both ordered (OL) and unordered (UL) lists. Example FTP Session in UNIX. EBay’s New Pricing. Leave a reply: Cancel Reply.
alvinpoh.com
How to find and replace text string in all MySQL tables | Alvin Poh
http://www.alvinpoh.com/how-to-find-and-replace-text-string-in-all-mysql-tables
How to find and replace text string in all MySQL tables. In Programming and Code. The following tutorial is helpful if you have a MySQL database and need to find and replace all occurrences of a string, for example, replacing “www.YourOldDomain.com” with “www.YourNewDomain.com”. This is useful if you are moving or cloning your website to another domain, especially if you are using software such as WordPress. How To Create An Anonymous or Limited Access Only Account With MySQL. Alvin Poh lives in Singapor...
alvinpoh.com
Alvin Poh - Part 3
http://www.alvinpoh.com/page/3
How To Mass Update WordPress URLs After a Site Migration. In Tutorials and Tips. Best Protein Bar Review: Which Is The Healthiest Of Them All? Essential .htaccess Tips and Tricks. In Programming and Code. How To Easily Mass Update Multiple Email Messages With The Same Text. In Tutorials and Tips. As an email marketer, wouldn’t it be cool if you could have a set of text in all your different email messages, that you can change in one place, and have all your emails messages updated together? On Standard C...
alvinpoh.com
Essential .htaccess Tips and Tricks | Alvin Poh
http://www.alvinpoh.com/essential-htaccess-tips-and-tricks
Essential .htaccess Tips and Tricks. In Programming and Code. People running on a good web host. Should be able to make use of a .htaccess file, which is a plain text file that allows you to have configuration rules that affect your Unix web server on a per-directory basis. This is a good starting .htaccess file that beefs up your web server’s security, with rules from a post on 0x000000.com. OR] RewriteCond %{QUERY STRING} [a-zA-Z0-9 ]=/([a-z0-9 .]/? Regex Character Definitions For htaccess. Last rule: ...
alvinpoh.com
Wordpress | Alvin Poh
http://www.alvinpoh.com/tag/wordpress
How to find and replace text string in all MySQL tables. In Programming and Code. How To Redirect or Disable BBPress Registration Page. In Tutorials and Tips. Change WordPress Category / Archive Page From Full Content to Excerpt. In Programming and Code. These changes can be applied to the following files: index.php category.php archive.php archives.php …. On Standard Chartered (StanChart SCB) vs Saxo vs Interactive Brokers (IBKR) – Commissions Compared.
alvinpoh.com
Programming & Code | Alvin Poh
http://www.alvinpoh.com/category/programming-code
Category: Programming and Code. Coding, programming, scripting and everything related. How To Use Wildcard Characters in MySQL statements. In Programming and Code. How to correctly display CSV files (Excel 2013). In Programming and Code. How to redirect one domain to other domain with all query string variables (htaccess). In Programming and Code. How to find and replace a text string in all files on your cPanel / WHM / Linux / Unix server. In Programming and Code. In Programming and Code. On Standard Ch...
alvinpoh.com
The Best Investment Strategy – The Lazy Portfolio | Alvin Poh
http://www.alvinpoh.com/the-best-investment-strategy-the-lazy-portfolio
The Best Investment Strategy – The Lazy Portfolio. Embarrassingly, it was only until recently that I found the concept of “lazy portfolios”. Essentially buying the whole market, it was the perfect answer to what I was looking for: a mix of diversification, lowered risks, indifference to bull and more importantly bear market cycles, returns that beat market benchmarks, and most importantly, takes no time and effort at all to implement and maintain. Here are the 3 benefits of a lazy portfolio:. I considere...
learnpianofree.com
Learn Piano Free » History of the Piano
http://www.learnpianofree.com/history-of-the-piano
Free Piano Lessons To Learn How To Play The Piano. History of the Piano. The tall vertically strung upright grand was arranged with the soundboard and bridges perpendicular to keys, and above them so that the strings did not extend to the floor. Diagonally strung Giraffe, pyramid and lyre pianos employed this principle in more evocatively shaped cases. The term was later revived by many manufacturers for advertising purposes. One Response to “History of the Piano”. On 13 Nov 2008 at 6:08 am. Hi, my name ...