Banner Design Logo Placement Tips

When designing skyscraper banners (160×600 and 130×160…etc.) try incorporating your logo in to the top and bottom portions of your banner layouts.
If you only want to include one logo, try positioning the logo in the top or middle portions of the banner.
If you only include your brand identity at the bottom, it’s will most likely fall below the fold (below the initial browser window area) and out of view of the user. Having a logo atop of the banner insures the viewer will be able to identity the brand associated with the message and call to actions.

Fix SQL INSERT problems with PHP addslashes function

If you’ve created you own custom content management system using PHP, you may have noticed problems inserting data. One of the problems could be that your data may have characters that prevent it from being inserted. Some of the character that would cause this type of problem are single or double quotes, backslash, and NUL characters.

You can escape these problematic characters using the PHP function addslashes(). As explained by the PHP manual: It returns a string with backslashes before characters that need to be quoted in database queries etc. These characters are single quote (), double quote (), backslash (\) and NUL (the NULL byte).

As you can see from my example below, I first run the content through the addshashes function and than return it to the same named string “$Page_Content” before passing it to my SQL UPDATE or INSERT statement.

$Page_Content = addslashes($Page_Content);
$query = "UPDATE site_content SET Page_Title='$Page_Title', Page_Content='$Page_Content' WHERE id_f='$id_f'";
query_db($query);

How to backup MySQL Database via SSH

First you log in using your terminal application by typing the flowing SSH command:

ssh yourusername@hostname-or-ipaddress

After that, you will be prompted to enter your password. As you enter your password, the text will be hidden. Next we should switch to the “root” user. You can do so by typing the following in your terminal window:

su – root

You will have to enter a password once more. Now navagate to where you would like to store your MySQL database file. For an example of changing the directory to the “public_html” direcotry, type this:

cd /var/www/html_public

Now you can back up your db here using the following command. This command will backup all of your databases. I also chose to compress them after the pipe “|” as a gzip file. Type the following but be sure to change the user name and password to your info:

mysqldump -u yourusername -p yourpassword –all-databases | gzip >databasebackup.sql.gz

You can also target single database using the following:

mysqldump -u yourUserName -p yourDBName | gzip >databasebackup.sql.gz

Free Hot Simple WordPress Themes

Here are a few WordPress themes I thought were buzz worthy. I’ve included a link to each demo and template download file.

1) Clip The Photo (Demo | Download )

WordPress Theme Clip the Photos

2) Upstart Blogger (Demo | Download)

ubmodicus

3) AI (Demo | Download)

Picture 2

How to validate Flash absolute url paths

You may want to dynamically change the way your flash file behaves based on where it’s hosted. To do so, you should utilize the “_url” variable to obtain the absolute path of your flash file. Continue Reading »

Adium and Yahoo IM Not Working

Did you notice that your Yahoo login stopped working lately? That is because Yahoo changed the way their im protocol works. You will have to download 1.3.5 update from Adium from here: Continue Reading »

How to Swap Depth using AS3 via setChildIndex

How to swap depth using AS3 via setChildIndex. This will fix the Warning: 1060: Migration issue: The method getNextHighestDepth is no longer supported. Continue Reading »

PHP Remove last character from string

Want to remove the last character from your text. Just use Substr_Replace. This is how. Continue Reading »

Flash and SEO. Why not?

Google learns to crawl Flash
Google has been developing a new algorithm for indexing textual content in Flash files…
Source: http://googleblog.blogspot.com/2008/06/google-learns-to-crawl-flash.html

How to SEO Flash
•    Search Engines and Flash
•    Requirements for Successful Use of Flash
•    SEO Flash Programming
•    Example: Making Flash Home Page Spiderable
•    Scalable Inman Flash Replacement
Source: http://www.hochmanconsultants.com/articles/seo-friendly-flash.shtml

Here are a few comments on this topic from SearchEngineGuide.com:
“Stoney, You hit the nail on the head and pounded it down with one stroke. I completely agree, I have turned down clients in my own business due to flash sites. Now that I am with an agency I find Flash more common, as many of the businesses are big enough and niched enough where they feel that they don’t need SEO for their website. Oddly enough they are often right. Unfortunately SEO can have a big effect on PPC marketing, and most of these accounts suffer from bad keyword quality scores and thus higher click costs in AdWords.”

“Susan: I disagree slightly. Mostly because it all comes down to the intent. Building a flash only website for Ozzy Osbourne is fine, but e-commerce is not. I think you know what I mean”

“ Working on seo for hotel sites, I’ve come across some stunning creative sites designed with Flash. If the designers had thoughtfully used the Flash applications to “wow” site visitors, ie embedding in otherwise SE-friendly pages, it could be a win-win situation.
Perhaps all of you have seen the June info about making Flash SE-friendly. ( http://googleblog.blogspot.com/2008/06/google-learns-to-crawl-flash.html )”
Source: http://www.searchengineguide.com/stoney-degeyter/why-i-still-wont-seo-flash-websites.php

And from SearchEngineJournal.com:
“Disney does it. And so does Oprah. Even my favorite pizza place does it…  Granted these are extreme cases of sites which use flash extensively, but there are other cases where even a little flash can be improperly used. There are also cases where flash is not only appropriate, it is recommended. The question then becomes how to best use flash without affecting search engine rankings”

“Yeah this article doesn’t help a bit. I thought after reading I would be able to find a solution for my all flash website for seo purposes. Thefwa.com is an all flash website, they rank no.1, they didn’t follow your mumbo jumbo about not using too much flash” (Note from Alex: TheFWA.com does not rank no.1. They rank 31,905. Still not bad for an all flash site.)
Source: http://www.searchenginejournal.com/flash-and-seo-using-flash-on-websites/2247/

Cool online tool that will probe a flash file:

http://www.flashprobe.com/

Select UNIQUE or DISTINCT MySQL/PHP Queries

How to filter / remove duplicate items in your database query result using DISTINCT

Continue Reading »

Page 1 of 512345