Posts

Showing posts from 2015

Sanitize Form Input in PHP to Prevent SQL Injection and Spam

I had to create a custom form recently for my website in Wordpress and had to ensure I cleaned up the input to prevent SQL injection and SPAM.  I could use the Contact Form 7 plugin but I had to format the input before sending via email. I used the strip_tags() and trim() PHP functions to sanitize the input $name = strip_tags(trim($name)); So if the input in the form field for name was:  <a href="www.scam.com" target="_blank">    WIN</a> The output after using these two functions would just be WIN The trim() function cleared the whitespace before the word "win" and the HTML or PHP tags were removed completely

Add Google Conversion Tracking Code to Prestashop CMS page

If you've created a custom thank you or confirmation page in Prestashop and need to place Google Conversion Tracking code in this page follow these steps: In your "themes" folder locate your active theme folder and download the Smarty template file named "cms.tpl" This is the one template file for all CMS pages Because Prestashop uses Smarty the coding differs slightly from PHP Add the following code to the end of the "cms.tpl" file {if $cms->id == 1} {literal} Google Conversion Tracking Code Snippet Goes Here {/literal} {/if} Change 1 to the corresponding ID number in your Prestashop admin site when you create your page. Upload "cms.tpl" back into theme folder

Syncing iTunes playlist on Windows PC to iPhone

After you've installed iTunes on your Windows PC (I use Windows 7 Professional) go to your Music folder and inside the iTunes folder create a folder to store all your media for your phone i.e.: Music, Videos, Tones, eBooks  You can name the folder "Data Store" Open iTunes and go to the relevant media tab e.g.: Music Click on File->Add File to Library... Locate your folder, in this case Data Store and choose the file Once the file is in your iTunes library you sync your library with your iPhone The files in my iTunes library are only for syncing with my phone.  I use VLC Media Player for all my media on my PC otherwise. Connect your iPhone USB data cable.  iTunes will detect your iPhone In iTunes click on the mobile phone icon (top left) Under "Settings" on the left-hand-side ensure you have the Sync option selected for your media types Under "On My Device" on the left-hand-side click on your media type and click "Sync"

Generate SALT Keys for Wordpress

When setting up your Wordpress site make sure you add SALT keys to your wp-config.php file. Get these keys generated here: https://api.wordpress.org/secret-key/1.1/salt/ Just copy and paste the 8 lines from the page above into your config file Refresh to generate new keys