Archive for 'Programming & PHP'

WordPress Stripping iFrame Elements? Here’s the Fix.

Posted by: Michael David

WordPress Stripping iFrame Elements? Here’s the Fix.

Is WordPress Stripping iFrame Elements From Your Content?

Elements like Google Map embeds get stripped out. Here’s the Fix.

If you have ever tried to enter a Google Map embed into a WordPress page or post, you’ve noticed that switching between “Visual” and “HTML” view in the page or post edit window strips the iFrame out–leaving you with broken code that displays nothing. Luckily, there is a fix.

You’ll need to ...

Read the Full Article Here...
9

MySQL String to Replace Postal Codes With State Names

Posted by: Michael David

MySQL String to Replace Postal Codes With State Names

I recently had to modify a mySql database to replace postal codes (i.e., "FL") with complete state names (i.e., "Florida"). I searched all over and did not find a ready-made string to accomplish this.

I am sure somewhere that someone will find this useful.

Simply replace "dbo_vwPRVDR" with your table name, and "State" with the column name, and you’ll be in business.

update dbo_vwPRVDR set State = replace(State,'AL','Alabama');
update dbo_vwPRVDR set State = replace(State,'AK','Alaska');
update dbo_vwPRVDR set State = replace(State,'AZ','Arizona');
update dbo_vwPRVDR set State = replace(State,'AR','Arkansas');
update ...

Read the Full Article Here...
0