I recently put together an Ajax autocomplete example using PHP and Mysql so I could post it on my blog, but after getting it working outside wordpress on an independent page I had trouble getting it into wordpress. I had used plugins in the past which allowed for php code to be used with shortcodes, …
Category Archives: PHP
Allow Email as Username within WP-Members Plugin
Today I figured out how to let people use their email to login instead of their username to the WordPress driven site called Jacked Pack. I had already installed the WP-Members plugin in order to add custom registration fields to the WordPress account page (for the “HUGEness profile”), but when I tried installing the WP …
Continue reading “Allow Email as Username within WP-Members Plugin”
How to Easily Prepare Database Import Using Perl
I’m revisiting this topic because in my last post about translating Excel data into a text file for database import I used a php script and yet still had some manual steps (the one that bugged me most was adding custom line termination characters for multiline data). I mentioned the idea that if I wanted …
Continue reading “How to Easily Prepare Database Import Using Perl”
How to Convert Excel Spreadsheets to SQL Statements
Last week I told a client he could send me a file in excel and I could import that into the mysql database directly. When I got the file I learned that it wasn’t quite that easy. I had planned to just save it as tab delimited text or CSV, but there was a “description” …
Continue reading “How to Convert Excel Spreadsheets to SQL Statements”
How to Add the Sidebar to WordPress Twenty Eleven Theme Single Posts
This is my first post since splitting off my technical posts into a new blog focused in that area. Part of the process was setting up a new wordpress blog, and of course I wanted to try a new theme, the Twenty Eleven theme. After I began importing a few posts I realized that there …
Continue reading “How to Add the Sidebar to WordPress Twenty Eleven Theme Single Posts”