Bookmarking and Feed Widgets

Here is a selection of bookmarking and feed widgets you can place on your site

AddThis http://www.addthis.com
Shareomatic http://shareomatic.com/
FeedPass http://www.feedpass.com/
addtoany http://www.addtoany.com/

These widgets are gather rather interesting data
read http://www.techcrunch.com/2007/03/05/addthis-widget-gathering-lots-of-interesting-data/
http://datamining.typepad.com/data_mining/2007/03/addthis_the_met.html

Google Adds Ad Review

Google has finally step up to the table where other advertisers have been gathered and will has begun to allow certain advertisers to review the ads being placed on their site.

This is a most welcomed move. You can read more at at the Google Adsense Blog on Ad Reivew

Google is dealing with Accidental Clicks

Google is moving to reduce accidental clicks.

This post post explains it well http://blogoscoped.com/archive/2007-11-13-n42.html but you can read it at Google Adsense Blog. This could mean decrease in revenue for some. Despite that I think it is a fair change as it gives the advertisers better value for their money. I am not sure why it was not like this from before.

Happy advertisers are likely to keep on advertising. This quote from the the article sums it up. It says, "By reducing accidental clicks, we hope to increase advertiser campaign value and satisfaction, encouraging additional spend and facilitating higher monetization for all publishers."

wordpress and mobile

Wordpress Mobile Plugin
http://www.andymoore.info/wordpress-mobile-plugin/ - best

http://lesterchan.net/wordpress/readme/wp-wap.html
http://lesterchan.net/portfolio/programming.php
http://wordpress.org/extend/plugins/wphone

Monetise
http://www.admob.com/s/home/publish
http://google.com/adsense

Directing
http://www.andymoore.info/php-to-detect-mobile-phones/

Emulators
http://ready.mobi/launch.jsp

Documentation
http://www.w3.org/TR/mobile-bp/#OneWeb
http://dev.mobi/

Usage
http://www.admob.com/s/home/live

Web analytics

Web analytics
http://www.clicktracks.com/product.php


http://www.webtrends.com/Resources/WebAnalyticsGlossary.aspx
http://www.webtrends.com/Resources/WhitepapersAndGuides.aspx
http://www.iab.net/standards/richmedia.asp
http://www.iab.net/standards/uap/analysis.asp

Web Traffic Comparison

Web Traffic Comparison

http://www.alexa.com/
http://www.compete.com/
http://www.ranking.com/
http://www.feedburner.com/fb/a/home
http://www.quantcast.com/

http://www.antezeta.com/web-analytics/web-statistics-suppliers.html#WS18

Ad & Affliate Networks
http://www.cpxinteractive.com/sign_up.php
http://www.casalemedia.com/
http://www.adtegrity.com/
http://www.oridian.com/
http://www.text-link-ads.com/
http://www.cpxinteractive.com
http://www.tradedoubler.com
http://www.cj.com
http://www.webgains.com/

Interesting Tools
http://synergy2.sourceforge.net/about.html
http://www.mattcutts.com/blog/page/3/

I insert data in to multiple tables in MySql

I saw this question on Techjamaica forum and noted it. Interesting question and interesting answer.

Basically here is the question. Can I insert data in to multiple tables in MySQL using one insert SQL statement?

Seems like the answer is no

Can I you insert data multiple times into the same table with one statement too.

INSERT INTO employees VALUES
(DEFAULT,'Hicks','Freddy','crew'),
(DEFAULT,'Harris','Joel','crew'),
(DEFAULT,'Davis','Julie','manager');

Examples taken from:
http://www.tizag.com/sqlTutorial/sqlinsert.php
http://www.desilva.biz/mysql/insert.html

You Tube

Now that you are posting your videos and YouTube ensure that you benefit as much as YouTube(Google) does.

Here are three sites and great tips

• How to increase blog traffic with Youtube
• Using Youtube to drive Traffic to your site
• 75 Ways to increase to Sales Traffic

My List

1. Ensure you are the first two subscribers.
2. URl at the beginning of the description
   e.g Jamaica-elections.com: This is
3. RSS feed promote
   http://youtube.com/rssls

FireFox Add ons Anyone

FireFox Add ons

• http://webworkerdaily.com/2007/07/20/6-firefox-extensions-for-web-workers/
• http://nicht.untergeord.net/wordpress/index.php/2007/07/22/8-firefox-add-ons-every-web-developer-should-know-about/
• http://zia.blogspot.com/2007/07/7-months-later-15-firefox-extensions-i.html

What are your top 5 firefox add-ons/extensions?

color schemes

Color
------------
http://www.colorsontheweb.com/colorschemes.asp?search=&category=Corporate
http://www.colorschemer.com/
http://www.articleinsider.com/article/229290
http://www.colorschemer.com/galleria_info.php
http://colorschemer.com/schemes/?start=331
http://www.webwhirlers.com/colors/colorschemes.asp
http://dianev.com/web-design-help/web_design_basics/color.html
http://dianev.com/web-design-help/web_design_basics/website_color_schemes.html
http://www.smashingmagazine.com/category/color/

examples
----------------
http://www.aviva.com/
http://www.norwichunion.com/

http://mobile.ups.com
pda.sky.com
bbc.co.uk/mobile
mobile.wunderground.com
pdaportal.com
pdahomepage.com
http://www.purelymobile.co.uk/

• Google (http://www.google.com/m/products)
• Yahoo Messenger (http://mm.yahoo.com)
• News.com (http://m.news.com)
• CNET Mobile (http://m.cnet.com)
• Weather.com (http://palm.xhtml.weather.com/xhtml/)
• Digg (http://mobits.com/digg/)
• Reuters (http://mobile.reuters.com/)
• New York Times (http://mobile.nytimes.com/)
• Business Week (http://pda.businessweek.com/index.html)
• Dictionary.com (http://dictionary.com/wml/)
• StreetIQ podcasts (http://m.streetiq.com/)
• Amazon.com (http://www.amazon.com/gp/aw/h.html)
• Flickr (http://m.flickr.com/)
• GameGeeks (http://www.geek.com/gaming/portable/)

http://blogs.techrepublic.com.com/hiner/?p=487?tag=1-1-11-0-0

http://www.mobidish.com/
Adshandy.com
http://www.enpocket.com/


http://realplayer.com/blog/?pageid=broadBandHomePage&pageregion=footer&src=realhome_bb_0_3_1_0_0_1_0&pcode=rn&opage=realhome_bb
http://archives.neohapsis.com/archives/fulldisclosure/2008-03/0157.html
http://www.download.com/8301-2007_4-9890945-12.html

Mysql Group By

More on Group By, Having, in your SELECT queries
http://www.databasejournal.com/features/mysql/article.php/3469351
http://rpbouman.blogspot.com/2007/05/debunking-group-by-myths.html

http://www.mysql.com/news-and-events/newsletter/2003-06/a0000000190.html

MYSQL Documentation
http://dev.mysql.com/doc/refman/4.1/en/select.html
last comment very useful
http://dev.mysql.com/doc/refman/4.1/en/group-by-modifiers.html
OPtimisations
http://dev.mysql.com/doc/refman/4.1/en/select-speed.html
http://dev.mysql.com/doc/refman/4.1/en/where-optimizations.html
http://dev.mysql.com/doc/refman/4.1/en/query-cache-in-select.html

String manipulation

proper case strings
http://www.php.net/manual/en/function.strtoupper.php#68340
http://www.sitepoint.com/blogs/2005/03/15/title-case-in-php/

Mobile Stuff

Mobile is back....

General information

http://forum.nokia.com/main/resources/technologies/browsing/support/xhtml_developer_faq.html
http://forum.nokia.com/main/resources/technologies/browsing/support/xhtml_developer_faq.html#22
http://developer.openwave.com/documentation/xhtml_mp_css_reference/xhtml-ref5.html
http://philip.greenspun.com/seia/mobile/
http://mobile.kaywa.com/wap/index.html

http://mobile.yahoo.com/business/advertiser/demo
http://chw.ariadne.mobi/tags/a.xhtml
http://mobile.kaywa.com/wap/wap-wtai.html

http://www.developershome.com/wap/wcss/
http://www.developershome.com/wap/wapServerSetup/
http://www.developershome.com/wap/xhtmlmp/
http://www.developershome.com/wap/uaprofRef/


http://www.w3.org/Mobile/planet
http://www.w3.org/TR/mobileOK-basic10-tests/
http://www.w3.org/TR/mobile-bp/
http://validator.w3.org/mobile/
http://www.w3.org/2006/12/digital_divide/public.html
http://www.w3.org/Mobile/
http://www.w3.org/2007/02/mwbp_flip_cards


http://www.w3.org/International/tutorials/tutorial-char-enc/
http://www.w3.org/International/articles/serving-xhtml/Overview.en.php
http://www.w3.org/International/technique-index


http://www.stopdesign.com/log/2004/12/16/small-screens.html
http://studiohyperset.wordpress.com/2006/10/06/detecting-and-automatically-redirecting-website-visitors-who-visit-a-standard-webpage-website-on-mobile-handheld-wireless-pda-or-cel-cell-phone-devices-browsers-to-a-mobile-version-of-the-webpage-or-w/
http://www.studiohyperset.com/resources/redirect.zip

tutorials
http://www.xml.com/pub/a/2004/04/14/mobile.html
http://www.xml.com/lpt/a/1398
http://www.oreillynet.com/pub/a/wireless/2004/02/06/mobile_browsing.html
http://www.oreillynet.com/pub/a/wireless/2004/02/20/mobile_browsing.html
http://www.littlespringsdesign.com/design/styleguides/
http://www.passani.it/gap/

detection
http://www.passani.it/switcher/
http://wurfl.sourceforge.net/php/index.php

validators
http://www.w3.org/2001/03/webdata/xsv
http://www.w3.org/QA/Tools/#validators
http://pc.mtld.mobi/
http://www.dan.co.uk/viewsource/

emulators
http://emulator.mtld.mobi/emulator.php
http://www.operamini.com/demo/?url=[URL]
http://www.operamini.com/demo/

tools kits
http://pc.dev.mobi/node/123
http://developer.openwave.com/dvl/member/downloadManager.htm?softwareId=23
http://www.forum.nokia.com/info/sw.nokia.com/id/db2c69a2-4066-46ff-81c4-caac8872a7c5/NMB40_install.zip.html
http://pc.dev.mobi/node/223
http://pc.dev.mobi/user/register

Google Gadgets

http://www.google.com/apis/gadgets/basic.html
http://www.google.com/apis/gadgets/remote-content.html#Fetch_JSON
http://www.google.com/apis/gadgets/reference.html#Userprefs_Ref

More Character Issues

Mysql

Mysql dump and character issues

PHP

http://www.php.net/htmlspecialchars
http://www.php.net/manual/en/function.htmlentities.php
http://www.php.net/manual/en/function.html-entity-decode.php

http://www.dragonwinds.com/resources/html-codes.shtml
http://www.htmlhelp.com/reference/html40/entities/latin1.html
http://www.w3.org/TR/html401/sgml/entities.html
http://www.icemelon.com/php/htmlentities.htm
http://www.icemelon.com/tutorials.php?id=3&/PHP/Generate%20RSS%20Feeds/
http://feedvalidator.org/

https://htmlentities.dev.java.net/

character set
A character set determines which characters are allowed within a document. A restrictive character set only allows certain types of characters. For example, a restrictive character set may only allow uppercase characters, and as its name suggests, a broad character set allows many characters. For example, a broad character set may include Arabic characters.
read more at http://www.developerfusion.co.uk/show/3802/5/

Banner design Tips

Banner tips from

http://www.siteprocentral.com/lessons/0082.html
http://www.businessknowhow.com/marketing/bannertips.htm
http://www.clickz.com/showPage.html?page=829391
http://www.microsoft.com/australia/smallbusiness/themes/marketing/10_tips_for_creating_an_effective_banner_ad_campaign.mspx
http://developers.evrsoft.com/articles/p_10_effective_ways_to_boost_banner_click_through.shtml

PHP E-mail Injections

Sending mail from a web page using a php script is easy, but can be dangerous if not done right.

http://php.net/manual/en/ref.mail.php
http://php.net/manual/en/function.mail.php

Useful guides and tips in securing PHP e-mail script
http://www.tutorialtastic.co.uk/page/php_mail_form_secure_and_protected
http://www.nyphp.org/phundamentals/email_header_injection.php
http://www.securephpwiki.com/index.php/Email_Injection

Useful Links

http://www.shoemoney.com/page/5/
http://www.pronetadvertising.com/
http://www.calacanis.com/
http://www.downloadsquad.com/
http://searchengineland.com/
http://www.dnscoop.com/

Dynamic Add html
http://javascript.internet.com/forms/adding-html-controls.html
http://www.dustindiaz.com/add-and-remove-html-elements-dynamically-with-javascript/
http://www.madirish.net/?article=141
http://www.thescripts.com/forum/thread90303.html
http://www.faqts.com/knowledge_base/view.phtml/aid/1785
http://www.java-scripts.net/javascripts/Dynamic-Fields.phtml



WYSIWYG
http://www.openwebware.com/products/openwysiwyg/

Form Tricks
http://www.dynamicdrive.com/dynamicindex11/selectform.htm
http://www.dynamicdrive.com/dynamicindex16/maxlength.htm


Ajax simple example
http://www.edouble-u.nl/testcases/autocomplete/index.htm


http://www.webcheatsheet.com/index.php

Html Special characters

Everynow and then you need to know how to deal with some pesky little characters like copyright [©] and registered [ ®]

http://www.shopfitter.com/html-special-characters.htm
http://www.chami.com/tips/Internet/050798I.html
http://www.degraeve.com/reference/specialcharacters.php
http://www.utexas.edu/learn/html/spchar.html
http://www.w3.org/TR/html401/sgml/entities.html

Robots.txt and Search Engines

It is not sexy but it useful. The robots.txt is suppose to tell robots/bots/crawlers where they can crawl on a web site. The robots.txt must be placed in the root folder. The Robot Exclusion Standard (RES) is a proposed proposed that has never been agreed on. However, the respectable search engines on the web voluntarily follow it with extensions. There are however reported cases when they allegedly fail to comply with instructions in the robots.txt


Key points

• # indicate that any follow it is a comment
• * - wild card meaning everything
• User-agent - The name of the robot/bot/spider/crawler
• Disallow: - Allow access to all of site
• Disallow: / - Disallow access to all of site
• Disallow: /images/ - do not crawl the images folder
• Disallow: /folder/filename.html - do not crawl filename.html in folder
  

Sample File
----------------------------------------------------

# pervent access of all user agents to the follow folders
User-agent: *
Disallow: /cgi-bin/
Disallow: /images/

# Specific intructions for specific user-agents
User-agent: msnbot
Disallow: /cgi-bin/
Disallow: /images/
Crawl-delay: 10

User-agent: Teoma
Disallow: /cgi-bin/
Disallow: /images/
Crawl-delay: 10

User-agent: Slurp
Disallow: /cgi-bin/
Disallow: /images/
Crawl-delay: 10

------------------------------------------------------------

Allow: and Crawl-delay: are not part of the standard but supported by MSN and Yahoo

Information on what, why and how see
http://www.robotstxt.org/wc/faq.html

What the Big Three plus one say

ASK
http://about.ask.com/en/docs/about/webmasters.shtml

Yahoo
http://help.yahoo.com/help/us/ysearch/slurp/slurp-02.html

Using the robots.txt analysis tool
http://www.google.com/support/webmasters/bin/topic.py?topic=8475

MSN
http://search.msn.com.sg/docs/siteowner.aspx?t=SEARCH_WEBMASTER_REF_RestrictAccessToSite.htm

Tougher action

see:

Using .htaccess for site control
http://linuxreviews.org/webdesign/htaccess/

How to keep bad robots, spiders and web crawlers away
http://www.fleiner.com/bots/



robots.txt generator
http://www.mcanerin.com/EN/search-engine/robots-txt.asp


http://www.outfront.net/tutorials_02/adv_tech/robots.htm

PHP coding guidelines

We don't like guidelines but they are good.

Below are 3 useful links on PHP coding guidelines

http://www.buxaprojects.com/en/php_coding_guidelines.htm

http://framework.zend.com/manual/en/coding-standard.html

http://www.evolt.org/article/PHP_coding_guidelines/18/60247/