Posts Tagged ‘website’

How to Copy and Share Google Docs

Wednesday, July 24th, 2013

This video tutorial will walk you through how to copy and share a Google Doc spreadsheet. Please post any comments or questions below.

Copy and Share Google Doc spreadsheet

Mobile Device Redirect for Your Website

Friday, January 13th, 2012

I will start this post the way I start all my developer posts, I am not a master coder and am still learning. I spent several hours working on this, so I’m posting to save others’ valuable time. There are probably many easier/better ways to do it, but this definitely works. If you have found a better way, please post it in the comments section.

Feel free to use this solution on any of your projects, but please leave the credits in there and provide for me here. Thanks.

The Situation
I created a mirror site for the main website that was optimized for mobile devices. Each page on the mirror site had the same filename as it’s counterpart on the main site, but the mobile optimized files were in a subdomain like What I wanted to do was have the website automatically detect whether the visitor was using a mobile device to view the site and if so, redirect them to the same page on the mobile optimized site. For example, if someone using a mobile device tried to go to, they woul automatically be redirected to

The Problem
I looked high and low and found a solution here that required editing the .htaccess file for the site (which I tried to no avail) and others that would redirect to the index page of the mobile optimized site regardless of which page the visitor on the mobile device was trying to visit.

The Solution
I ended up combining a couple of the solutions that I found along with some customization to get the job done. Here is what I ended up with (The comments in the code give credit to the sites that helped out).


// This code borrowed from 9 Lessons at

$iphone = strpos($_SERVER['HTTP_USER_AGENT'],"iPhone");
$android = strpos($_SERVER['HTTP_USER_AGENT'],"Android");
$palmpre = strpos($_SERVER['HTTP_USER_AGENT'],"webOS");
$berry = strpos($_SERVER['HTTP_USER_AGENT'],"BlackBerry");
$ipod = strpos($_SERVER['HTTP_USER_AGENT'],"iPod");

// This code borrowed from

function curPageURL()
$pageURL = 'http';
if ($_SERVER["HTTPS"] == "on") {$pageURL .= "s";}
$pageURL .= "://";
if ($_SERVER["SERVER_PORT"] != "80")
} else
return $pageURL;

$url = curPageURL(); // Gives the function a temporary variable
$mobile = str_replace('', '', $url); // Allows the returned url from curPageURL to be replaced with the redirect URL for mobile devices but still maintains the separate page file names

// This code also borrowed from 9 Lessons at

if ($iphone || $android || $palmpre || $ipod || $berry == true)
header('Location:' . $mobile);
echo "<script>window.location='" . $mobile . "'</script>";
} else


Be sure to:
1.) Make sure you have your mobile optimized mirror site built and setup at either a subdomain or subdirectory on your website.
2.) Paste the code above at the top of all of your webpages. NOTE: This must be the first thing in your website files. So, it must be placed before the DOCTYPE declaration.
3.) Change the URL above from to whatever your website URL is (on line 31 of the code snippet above).

If you want to make your code a bit cleaner, save the above code with your URL changes to a separate file (i.e., redirect-mobile-devices.php) and save it to the root of your website. Then, add the code 

<?php include ('redirect-mobile-devices.php') ?>

 on the first line of all your website files.

WordPress query pages (not posts) using custom fields

Monday, December 5th, 2011

First off, let me say that I am not a master coder and am still learning. Also, I spent many a precious hour trying to find a solution for this. There are probably many easier/better ways to do it, but this definitely works. If you have found a better way, please post it in the comments section.

The Situation
Now, let me explain what it was that I wanted to do. I had several WordPress pages (not posts) with custom fields already set up. I wanted to have only those pages with a particular custom field name appear on a certain page. So, I wanted to create a custom query that would return only those pages with the custom field name.

The Problem
The problem was that most every query that I tried would not return any of the pages. Each one would only return posts (not pages) with that custom field.

I originally started working with query_posts, but I kept running into a problem with the query returning pages that did not have the custom field and also returning multiple instances of the results (probably an issue with where I had placed the wp_reset_query). I also tried this solution with no luck.

The Solution
Many thanks to Ben at Binary Moon for this article and also to this thread on the WordPress forums that helped me quite a bit.

$pages = array(
'post_type' => 'page',
'meta_key' => 'your_custom_field_name',
'order' => 'asc'
$queryObject = new WP_Query($pages);

<?php if ( $queryObject->have_posts() )
while (
$queryObject->have_posts() ) :

<!-- Loop or custom code goes here -->

<?php endwhile; ?>

Be sure to:
1.) Set the custom field on your pages, and publish the pages.
2.) Paste the code above into your loop/page template file/wherever you want the results to appear.
3.) Change the bit with your_custom_field_name to the custom field that you have set up on the pages that you want to query.

For more ways to customize and use the information from the custom fields, check out Part I and Part II at the Perishable Press.

How To Set Up a Website

Thursday, August 25th, 2011

In order to have a website that is viewable on the internet, you must have at least three things. These are: 1.) a domain name, 2.) web hosting, and 3.) website files.

Domain Name

The domain name is the URL, or website address. The domain name of the website you are currently viewing is In order to claim ownership of a domain name, you must pay a domain name registrar to register the domain name for you. GoDaddy is probably the most commonly known domain name registrar. A registrar will most likely require you to set up an account. Domain name registration is NOT free, but the fees that registrars charge vary. Currently, domain name registration fees range anywhere from $14.95 to $29.99. These fees are recurring and are paid annually. Many registrars offer multi-year domain name registration, so that you do not have to pay each year. Most registrars are very good about notifying you when your domain name registration is about to expire and reminding you to renew; however, if you fail to renew your registration, it will expire, and someone else will be able to buy your domain name.

Web Hosting Provider

A web host is the server where you store the files that tell a web browser how to display your website. Most companies that offer domain name registration also offer web hosting. Some of the basic things that most web hosting providers offer are email accounts, mySQL databases, space on a server, and bandwidth. You should choose a web hosting provider that offers sufficient server space and bandwidth as well as a sufficient number of mySQL databases and email accounts to meet the needs of your website. Web hosting service is usually quoted at a monthly rate, but providers will usually ask you to pay for the entire time period (6 months, 12 months, etc.) up front. Currently, web hosting fees range anywhere from $3.95 per month to $14.95 per month. Many web hosting providers will offer discounts for longer periods of time (i.e., $9.99 per month for 12 months or $7.99 per month for 24 months). It’s a good idea to discuss which web hosting provider you should use with your web designer as many web designers prefer using web hosting providers that they are familiar with.

Website Files

Website files are the files, located on the web server, that actually tell the web browser what your website should look like, including colors, column width and height, where logos appear, etc. Creation of these files is what most people think of when they think of what a web designer does. Website files vary in type and can include anything from html, css, php, asp, javascript, sql, and more. For the purpose of this article, I won’t get into the differences between these file types. You do a quick search on your favorite search engine to learn more. Basically, when you surf the web and look at a web page, you are looking at a website file that is being rendered by your web browser (Internet Explorer, Firefox, Chrome, Safari, etc.). You can create website files yourself or hire someone to create them for you. The quality of your website (look and feel of the site) will depend on the knowledge and experience of the person creating the website files. An easy way for someone with little or no experience or knowledge to create website files is to use a content management system (CMS). However, if you want a truly unique and customized look and feel to your website, you will most likely need to find a web designer to create custom website files for you.

Words of Warning

Some small business owners who are not too technically savvy will ask their web designer to take care of all the “website stuff”, including the domain registration and web hosting. A trustworthy web designer will walk you through the process of registering the domain names and setting up the hosting account in YOUR name. A shady web designer will “take care” of it for you by registering the domain name and setting up the hosting account in THEIR name.

DO NOT let your web designer register the domain name or set up the hosting account in anyone’s name but yours. The domain name and the hosting is YOUR property, and YOU should have full control over it and access to it. If you bought a vehicle for your business, you would never consider putting the name of the salesperson who sold it to you on the title. You would be sure to put your name on it because it is your property. The same goes for domain name registration and hosting accounts.

As a small business owner, you may be very trusting and know a “great” person who is a web designer that would never do you wrong. Whether or not you are right about her/his character, you should still have everything in your name. This is because if the domain name registration and hosting account are in the name of your web designer and something happens to her/him (like death), you will have no way of proving that they actually belong to you, and you will have to start from scratch with a new domain name and hosting account.

Save yourself the hassle, and do it properly from the start.

What Is a CMS?

Monday, August 15th, 2011
Content Management Systems (CMS) - WordPress, Drupal, Joomla

Image from One Story Every Day

CMS (content management systems) use a WYSIWYG (What You See Is What You Get) system to create content for web pages. WYSIWYGs operate much like common word processing programs like Microsoft Word. They usually have text editors that include buttons to format the text and images you input with bold, italics, underline, right, left, and center justification, and much more. There are numerous CMS, but some of the most common ones are WordPress, Joomla, and Drupal. The common CMS are free to download and use, and there are many free templates available that will give you some options on the look and feel of your website. If you want a website that is unique and does not look like anyone else’s, you will need to design your own theme or hire someone to do it for you. For more info on CMS, go to Wikipedia.