Posts Tagged ‘blog’

Mysql-Partition Your Tables

Thursday, July 24th, 2008

Often you have a table in which only a few columns are accessed frequently. On a blog, for example, one might display entry titles in many places (e.g., a list of recent posts) but only ever display teasers or the full post bodies once on a given page. Horizontal vertical partitioning helps:
CREATE TABLE posts (
id int UNSIGNED NOT NULL AUTO_INCREMENT,
author_id int UNSIGNED NOT NULL,
title varchar(128),
created timestamp NOT NULL,
PRIMARY KEY(id)
);

CREATE TABLE posts_data (
post_id int UNSIGNED NOT NULL,
teaser text,
body text,
PRIMARY KEY(post_id)
);

The above represents a situation where one is optimizing for reading. Frequently accessed data is kept in one table while infrequently accessed data is kept in another. Since the data is now partitioned the infrequently access data takes up less memory. You can also optimize for writing: frequently changed data can be kept in one table, while infrequently changed data can be kept in another. This allows more efficient caching since MySQL no longer needs to expire the cache for data which probably hasn’t changed.

Search Engine Optimization-Directories

Tuesday, July 15th, 2008

Another way to generating inbound links is to submit your links to directories. I know of webmasters who swear by the benefits of such a strategy - the first thing that they do when starting a new site is to do the rounds of directories - submitting links to key pages with appropriate keywords in the links. There are loads of directories out there - many of which offer a free submission. Ari Paparo has compiled a list of blog directories that you might want to start with.

Search engine optimization-Quality Content

Tuesday, July 15th, 2008

here are all kinds of link generating systems out there but in my opinion the best way to get links to your blog is to write quality content that people will want to read. You can solicit links with others or sign up for different link building programs or even buy text links on other sites but the cheapest and probably safest approach is to build inbound links in a natural organic way as others link to your quality content.

Changing an HTML Web Page Link Color

Monday, July 14th, 2008

You can change the color of an individual HTML web page link by adding a font tag in front of your linked text.

Example Code:

<A HREF=”http://www.blog.tryangled.com”><FONT COLOR=”#FF0000″>Your Link</FONT></A>

Creating an HTML Escape From Frame Link

Monday, July 14th, 2008

If your web site gets trapped within someone’s frames, you can create a link to help your visitor escape. Place the following code within your HTML where you would like the link to appear.

<A HREF=”http://www.blog.tryangled.com/” TARGET=”_top”>Escape From Frame</A>

You’re actually just creating a link to your own website with the TARGET set to “Top.”

At one time, there were many sites designed with frames. However, as more and more people have realized that frames are not a good choice for designing a web site, the number of sites designed in frames has dropped considerably. For this reason, the chance of your site being trapped within someone’s frames is slim. However, you may still want to include this link at the bottom of your site.

Creating an HTML Mouseover Text Description

Monday, July 14th, 2008

You can create an HTML mouseover text description, similar to an image alt tag or pop up text description, that will be viewed when your mouse is placed over the text link. Place “title=”your text description”" within your HTML link code.

<A HREF=”http://www.blog.tryangled.com/” TITLE=”Web Designing Company”>Your Text</A>

Creating an HTML Status Bar Link Description

Monday, July 14th, 2008

You can display your HTML link description in the status bar of your browser. When the mouse is placed over a link, the text link description will be viewed in the status bar.

<A HREF=”http://www.blog.tryangled.com” onmouseover=”window.status=’Your text description’; return true” onmouseout=”window.status=”;return true”>Your linked text</a>

Seo:Domain Names

Monday, June 30th, 2008

Choosing the correct domain name for a business is vital to its success on the Internet. If your business is called “Intoweb Design” and your core product is “web design”, the domain name “intoweb.co.za” could work. However a better domain name would be the core business product, “blog.tryangled.com”. The reason being search engines read keyword rich domains and rank the domain higher if it contains a main keyword.

HTML:Meta refresh redirect

Monday, June 30th, 2008

This will redirect to a http://blog.tryangled.com after 5 seconds.
<META http-equiv=”refresh” content=”5;URL=http://blog.tryangled.com” />

PHP:smarty (php template engine) check for firefox useragent

Monday, June 30th, 2008

<!– Google FireFox –>
{if !eregi(”Firefox”,$smarty.server.HTTP_USER_AGENT)}

<div align=”center”>
{literal}
<script type=”text/javascript”><!–
google_ad_client = “pub-8425891275034886″;
google_ad_width = 110;
google_ad_height = 32;
google_ad_format = “110×32_as_rimg”;
google_cpa_choice = “CAAQ_-KZzgEaCHfyBUS9wT0_KOP143Q”;
//–></script>
<script type=”text/javascript” src=”http://pagead2.googlesyndication.com/pagead/show_ads.js”>
</script>
{/literal}
</div>
{/if}
<!– /Google FireFox –>
Note:
you should replace your own code between {literal} .. {/literal}
please check also google’s terms when you’ll get paid