Sunday, June 17, 2007

The Future of the Internet?

Here is a thought-provoking video that presents a vision of what the Internet might become before the end of the century. Will Google eventually attain world domination? Will copyright laws be one day a thing of the past? Enjoy the show!

Thursday, April 12, 2007

nonstandard property :: innerHTML (but is a de facto standard)

The innerHTML property is not part of the DOM. It isn't part of any standard. It is a proprietary addition created by Microsoft.

Normally, I wouldn't recommend using anything proprietary in JavaScript code (although the XMLHttpRequest object itself is a proprietary addition). However, the innerHTML property is exceptionally well supported, considering that it is nonstandard. It is, in effect, a de facto standard: it is supported in all the major browsers. The reason why innerHTML has been so widely adopted, without any endorsement from the W3C, is that it is very useful in certain situations.

DOM methods allow you to manipulate a document very precisely. You can create elements, attributes, and text, one node at a time. That is very powerful, but it is also quite time-consuming.

The innerHTML property uses brute force. If you read the innerHTML property of an element, you will receive a string of HTML. This is a read/write property, meaning that you can also assign a string of HTML to go inside an element.

Any HTML that was previously inside the element will be obliterated and replaced with the contents of the string.

Which you choose for your web app XML, JSON, or HTML?

If you are a Ajax developer you should know these three words XML, JSON & HTML (using innerHTML)

So which you will choose the best to get your data from server to manipulate on client browser? if you are not sure about this then read following article

What's Your Poison? XML, JSON, or HTML? by Jeremy Keith

which is a part of his book Bulletproof Ajax. The article is here:

As for my preference I use HTML as it is very easy way and safe also, read the article and decide what is best for you.

When Observing Users Is Not Enough

When observing users is not enough then read following article from Isabelle Peyrichoux

When Observing Users Is Not Enough: 10 Guidelines for Getting More Out of Users’ Verbal Comments

and learn what should be avoided and what should be adopted.

Opera 9.2 is out for lovers (all platforms)

Opera version 9.2 has been released. I’m sure everyone will find browsing faster and more enjoyable with Opera’s many new features

According to official opera blog:

9.2 is not only an important update with bug fixes and the new Speed Dial functionality, it’s also a milestone in spreading Opera to new users around the world: Opera 9.2 for Windows ships with 31 languages.

Download

Click here to download opera for Linux/UNIX, Window and Mac.

Wednesday, April 11, 2007

Copy MySQL database from one server to another remote server

Usually you run mysqldump to create database copy:
$ mysqldump -u user -p db-name > db-name.out

Copy db-name.out file using sftp/ssh to remote MySQL server:
$ scp db-name.out user@remote.box.com:/backup

Restore database at remote server (login over ssh):
$ mysql -u user -p db-name <>
How do I copy a MySQL database from one computer/server to another?

Short answer is you can copy database from one computer/server to another using ssh or MySQL client.

You can run all the above 3 commands in one pass using mysqldump and mysql commands (insecure method, use only if you are using VPN or trust your network):
$ mysqldump db-name | mysql -h remote.box.com db-name

Use ssh if you don’t have direct access to remote mysql server (secure method):
$ mysqldump db-name | ssh user@remote.box.com mysql db-name

You can just copy table called foo to remote database (and remote mysql server remote.box.com) called bar using same syntax:
$ mysqldump db-name foo | ssh user@remote.box.com mysql bar

This will not just save your time but you can impress your friend too ;).
Almost all commands can be run using pipes under UNIX/Linux oses.

MySQL connections can be made securely to a remote server via SSL. Just thought I would mention that as it is an additional option to consider. http://dev.mysql.com/doc/refman/5.0/en/secure-connections.html

Thursday, March 22, 2007

Web 3.0 : The future of Web APIs and Services

Read a thought about coming up Web 3.0

Web 3.0 : When Web Sites Become Web Services
Written by
Alex Iskold

It is really good thought that how the web is walking towards Web 3.0
The increasing number of APIs and Web Servicing Tools. Switching from Desktop Applications to Web Applications. We are entering into a new era of Web - The Whole New World of Internet

p.s: Read more articles from Alax Iskold are here.

Ajax Video Tutorials by Stefan Mischook

Again very good video tutorials to learn AJAX at Killerajax.com by Stefan Mischook. These video tutorials are again from the network of killersites.com the same as Actionscript Videos and PHP Videos and all the videos are not free. Few basic videos are free just to get the quality & measure the contents of paid videos. But even if they are paid its worth for it and will not pinch out your pockets. Just $19.99 to download all the videos. I think it is worth to spend money on Visual Learning then purchasing a book and fondling pages around not getting everything.

Video Highlights (from site):

  • Build a fully functional AJAX shopping cart.
  • Learn about Free AJAX tools to speed up your AJAX work.
  • Learn how to connect AJAX with PHP
  • Overt 3 hours of videos.

So if you are willing to learn some AJAX you must check out Killerajax.com

p.s: it is also a part of killersites.com network

Actionscript Videos Tutorials by Santo Romano

Great video tutorials for learning Flash Actionscript 2.0 at Killeractionscript.com by Santo Romano. These video tutorials are same like found on Killerphp.com but the only difference is that all the videos are not free. Few basic videos are free just to get the quality & measure the contents of paid videos. But even if they are paid its worth for it and will not pinch out your pockets. Just $19.99 to download all the videos. I think it is worth to spend money on Visual Learning then purchasing a book and fondling pages around not getting everything.

Video Highlights (from site):

  • Use HTML and CSS in Flash
  • Enable the browser 'back' button in Flash
  • Build a fast loading compartmental Flash site.
  • Load external text files into your Flash movies.
  • Build pre-loaders with Actionscript.
  • Become familiar with universal programming concepts and techniques.
  • Covers the same material taught in $300 classes!

So if you are willing to learn some Actionscirpt you must check out killeractionscript.com

p.s: it is also a part of killersites.com network

PHP Video Tutorials by Stefan Mischook

Stefan Mischook as done a great job by putting up some free video tutorials to learn PHP for starters at Killerphp.com

From Site:
This is a beginners website/course on PHP created for web designers who have little to no programming experience.
Where most other PHP tutorials and books assume you know programming (or at least, that's what is seems like ...)
killerphp.com assumes you need to have things explained (and demonstrated) in non-nerd terms.

Videos are of great quality and loads fast. These videos are also featured in to 'Web Designer Magazine'. It is such a good resource for starters to learn about PHP in a visual way. So wait no more and go to killerphp.com and learn PHP.

p.s: Stefan is adding more videos very soon in his collection. And it is a part of killersites.com network

Thursday, March 15, 2007

Video :: Dolphin massacre in Japan

One of my friend sent me this video and requested to make forwards. I am really disappointed on the acts of human kind on other creatures of planet. I am putting this in my blog with hope if any one capable of stopping the act shown in video sees this and acts for good.

(You must watch this but only if you are over the age of 14)Link to

Video:http://www.glumbert.com/media/dolphin

It will also be better if you share with others.

Hack MS Office Excel Sheet Protection Password

Yes this code does as it says. Following code hacks up the Excel sheet protection password and opens the protected sheet for you. I tried this code on most of the protected Excel sheets and it worked great.

Beware this hack is not for bad use, it is just for some fun. I used it to learn functionality of an Excel Cricket Schedule found on net. Not more than just learning.

So here are the instructions & code:
Open the workbook that has the protected sheet in it. Hit Alt+F11 to view the Visual Basic Editor. Hit Insert-Module and paste following code into the right-hand code window:

'CODE START:

Sub PasswordBreaker()

Dim i As Integer, j As Integer, k As Integer
Dim l As Integer, m As Integer, n As Integer
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 As Integer, i6 As Integer
On Error Resume Next
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
ActiveSheet.Unprotect Chr(i) & Chr(j) &amp;amp;amp;amp; Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If ActiveSheet.ProtectContents = False Then
MsgBox "One usable password is " &amp;amp;amp;amp; Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
ActiveWorkbook.Sheets(1).Select
Range("a1").FormulaR1C1 = Chr(i) &amp;amp;amp; Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
Exit Sub
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next

End Sub

'CODE END:

Now Close the VB Editor window. Navigate to the worksheet you want to unprotect. Click Tools-Macro-Macros and double-click PasswordBreaker in the list.

When the macro finishes the work the protected sheet will be unprotected and you can fool around with sheet.

But I remind you, this hack routine provides a password to unprotect your worksheet. However, it may not give you the original password that was used and don't use this hack for bad job.

Thanks & Enjoy!

Tuesday, March 13, 2007

Cricket World Cup Schedule

Great news for fans and supporters of cricket! Due to the upcoming Cricket World Cup tournament, Excely.com presented a wonderfully crafted schedule called AceFixtures for Cricket World Cup. It is designed for MS Excel, contains no macros and works fully automatically. It fills in group tables without delay according to the game results you specify, which is very convenient. Cricket World Cup Schedule is just a thing for a devoted cricket supporter!

The observation of the game results is remarkably simple in schedule. All you need to do for working with this schedule is to fill in match results. Specify the winning team by marking the field next to it with any symbol, like + or W and leave the defeated team's field untouched. Everything else will be done right away by Cricket World Cup Schedule. It will automatically work out teams positions in a group and show the contenders from the Second Stage to the great Final. The way AceFixtures is organized makes it a valuable helper for any ardent fan.

With Cricket World Cup schedule you will always be aware when your favorite team starts playing since it is possible to choose the country you are supporting, highlighting matches of the team from the selected country. Choose your favorite and see with whom and when the team is to compete.

Follow up the results of every game in a marvelous schedule dedicated to Cricket World Cup. With AceFixtures you'll be ahead of the game and know about every event in the tournament. The team needs your support, so don't miss Cricket World Cup Schedule and enjoy a good competitive spirit!

Here is the download link:
http://www.excely.com/cricket/world-cup-schedule.html

Thursday, March 1, 2007

Good & Useful cheat * Cheat Sheets *

It's very difficult to be regular on blog but i am trying my best. It's been couple of days i was away again but again i am back with some sweet knowledge.

The most useful thing to a developer or designer or someone else like gamer or something is Cheat Sheet. If you don't know what it is let me tell you a little.

What is Cheat Sheet?
A cheat sheet is a physical piece of paper, often filled with equations and facts in compressed writing. Various tools can be used to produce cheat sheets, besides pen and paper.

The computer industry has many cheat sheets due to the high number of commands and actions one must learn to use programming languages and command-line interfaces. Professionally prepared cheat sheets for some subjects are available for purchase.

But i am not here to sell any of those, i am here with few links to freely available Cheat Sheets and to me all are very useful. Here the links ( i am not giving any download, have it yourself )

It's not necessary that only programming languages has Cheat Sheets, Cheat Sheets can relate to any information available. Following are more links to useful Cheat Sheets most users of Internet should have.
I think i have taken a lot space on screen. Links are countless and i have tried to be as short as possible and as good content as possible. Open the links get the Cheat Sheet you like and have fun with it. I will keep updating this post as i get more links & time.

PS: The most thanks to Jack Daniel as he has worked on great Cheat Sheets. You can check his website at http://ilovejackdaniels.com. Thanks Jack!

Monday, February 26, 2007

Need to show live clock on your blog/web page?

  • you want to show a live clock (digital/analog) on your website?
  • Don't know or have the code to do so?
  • Not able to develop a script to do the work for you?
  • You have script/code but it is not fancy enough to suit your website?

well i have a link to all of above questions (point me if i missed one).

The Internet is full of amazing tools and amazing people who are working hard to develop the cool tools for people like us you just enjoy it. Well this is enough i tell you the link.

Yesterday i was looking for good live clock script in javascript to show a digital clock on a web-application, i had one with me but it was not good enough and i didn't want to hack the script so i went to Lord of knowledge base 'Google' and ask him to give me the solution and he put this link in my search bucket.

I am writing about a site named
ClockLink.com, they company who owns it has produced an amazing tool for Internet and free of cost. If you need to show an fancy and themed clock on your website or blog or any personal page, just go to ClockLink.com and select a clock from their gallery, click on it and copy code from new opened window to your page. Nothing else to do. Now go to page you just added their code and see the clock just right there where you pasted it in your page. More information can be taken from their website like how to paste there code on different blog sites to show up the clock.

They provide you flash or javascript code, choose whichever suits your need (some blog sites does not allow javascript codes, you can embed a flash object to show clock). They will also guide you according to your blog site.

It is really cool tool and A beautiful demo is on right top corner of this blog as you have noticed already on the home page of this blog. Here is another one below:


Back to myBlog with few Database Connections

Last two weeks were very hactic and tiring. I attended lots of work and meetings in these days and didn't get time to post on myBlog.

Well here i am again with some cool and new stuff i found on net in these days, ready to share with readers and implement in my programming.

I will try to be regular on posting from now on, i really missed it. Well all this later, now to the point.

Last week, while searching on net i again found a useful site named
Connectionstrings.com

What is this About?

(from the website)
The idea of ConnectionStrings.com is to provide an easy reference for connection strings.Today there is 178 connection strings in the database wich have been collected from other internet sites, books, help files, msdn etc or have been submitted by fellow developers from all around the world, Thank You!


(From Me)
As it says (not clearly) the website provides you the connection strings to connect to different database through programming languages like .NET and/or more.

Well it is not much useful for me now but may be in future, as it does not relate to PHP. But hey it is a useful site and should be mentioned here.

Go
here and check out yourself that if they provide connection string you are looking for.

Enjoy !

Wednesday, February 14, 2007

Fixing PNG transperency for Internet Explorer (MSIE): A Little Hack

Recently I have started using PNG format images for my web application icons because of its lossless data compression and variety of transparency options. More on PNG can be found on Wikipedia. (http://en.wikipedia.org/wiki/png)

Problem I faced with PNG images:
Well it is good to use PNG but there is one problem for PNG images with Internet Explorer (thanks to Microsoft and Bill Gates). Internet Explorer (IE) does not render PNG's transparency properly so background is shown for transparent PNG images. It was really bad hit for my development. But i believe 'where there is will, there is a way' or you can say 'where there is a problem, there is a solution'.

Solution I found and Implemented:
While searching for solution on Internet, I found a simple and useful solution to the problem. I implemented it and it worked great as the author said so. Well it is a little javascript hack for only Internet Explorer which renders PNG images as SPAN and displays the image as it is meant. The hack uses Microsoft's AlphaImageLoader filter to display the transparency of PNG images. The little javascript code only works with IE and does not bother other browsers.

Where to get it:
I have pasted the code at bottom of this post but i will recommend to go to official site for updated version of the code. The code is placed at the website
http://homepage.ntlworld.com/bobosola/. I didn't get the name of author, I feel sorry for I was not able to mention his/her name here. I didn't find it on site, if someone gets it please let me know. But the author has thanked many people on his website.

Disadvantages:
The hack is based on javascript and works only for Internet Explorer 5.5 and 6 on Windows. If javascript is OFF the images are shown as with background. (but i don't bother for that because my most web applications are based on Ajax so it is meant only for user with javascript ON). There are few more cons in hack which are explained on the site mentioned above.

The Code:
There are two ways of using the hack.


  1. Put following code to head section of your web page. (just copy/paste)

    <!--[if lt IE 7]>
    <script
    language="JavaScript">
    function correctPNG() // correctly handle PNG
    transparency in Win IE 5.5 & 6.
    {
    var arVersion =
    navigator.appVersion.split("MSIE")
    var version =
    parseFloat(arVersion[1])
    if ((version >= 5.5)
    && (document.body.filters))

    {
    for(var i=0;
    i<document.images.length;
    i++)

    {
    var img
    =
    document.images[i]

    var imgName =
    img.src.toUpperCase()

    if (imgName.substring(imgName.length-3, imgName.length) ==
    "PNG")

    {

    var imgID = (img.id) ? "id='" + img.id + "' " :
    ""

    var imgClass = (img.className) ? "class='" + img.className + "' " :
    ""

    var imgTitle = (img.title) ? "title='" + img.title + "' " : "title='" + img.alt
    + "'
    "

    var imgStyle = "display:inline-block;" + img.style.cssText

    if (img.align == "left") imgStyle = "float:left;" +
    imgStyle

    if (img.align == "right") imgStyle = "float:right;" +
    imgStyle

    if (img.parentElement.href) imgStyle = "cursor:hand;" +
    imgStyle

    var strNewHTML = "<span " + imgID + imgClass + imgTitle + " style=\"" +
    "width:" + img.width + "px; height:" + img.height + "px;" + imgStyle + ";"
    +
    "filter:progid:DXImageTransform.Microsoft.AlphaImageLoader" + "(src=\'" +
    img.src + "\', sizingMethod='scale');\"></span>"

    img.outerHTML =
    strNewHTML

    i = i-1

    }
    }
    }
    }
    window.attachEvent("onload",
    correctPNG);
    </script>
    <![endif]-->

  2. Second is save the above code in file and name it pngfix.js and copy the following code to head section of your web page.

    <!--[if lt IE 7]>

    <script defer type="text/javascript" src="pngfix.js"></script>

    <![endif]-->

Help for implementation:
If you need any help for implementing the code just visit the website of the author where he has explained it in a simple and effective way with demos. And secondly you can post comment here for help and I will help if I am able to.

Keep Sharing !

Thursday, February 8, 2007

Google's PageRank :: what is it?

While searching on net about Google's PageRank, I came across very detailed article on Google's PageRank. Not to forget the article is written by Phil Craven and this articles explains the depths of Google's PageRank. Don't be curious the link is here:
http://www.webworkshop.net/pagerank.html

Another interesting and informational site I found is
www.webrankinfo.com/english/, it is enough informational to get around SEO stuff (Search Engine Optimization) and it has one module for Google only.

OK for further readers i have very interesting and useful information, specially for webmasters. If you need to see your web page's PageRank without installing Google Toolbar then you need to see following link:

  • MyGooglePageRank.com :- They give you javascript code to paste on your web pages which will display current page's Google PageRank. You can also check your web pages rank on their website. The service is totally free.
  • Firefox & Mozilla Extension :- This will install an extension to your browser to show current page's Google PageRank in status bar.
  • Webmastereyes.com :- It is another tool to check your Google PageRank online and you can also show a form on your site to let users check their page ranks by pasting some code from this site.
  • Prchecker.info :- This is also an cool tool to use. They simply provide little HTML code to paste into your page to show current page's Google PageRank.

There are more tools but i am not willing to search more as i am satisfy with the above available, but if you are interested to dig more just Google for 'Google PageRank' and see 30,900,000 results and pick suitable one for yourself.

I will prefer prchecker.info as this tool is simple to use and can work even if scripts are disabled in user's browser because they provide HTML code which will be rendered by every known browser arround. The following is the DEMO and my blog's current Google PageRank

Page Rank Tool

p.s: well my blog's page rank is not good at this time. I hope for good ranking in future.

Hey!Watch :: Online Video Encoding Platform

This is an addition to my list of amazing tools on web and i was looking for this tool for long time and it came up to me in a sudden. To check out click here or keep reading further.

To use this tool you need to register first nothing else to do and you get a lot of features to convert your video files to any format you like. It has following features to enjoy:

  • Video encoding in any format you want
  • Well aware of today's growing number of multimedia devices
  • Grabbing Video Clips from Web Sites (even when there is no download link)
  • Smart notification - RSS and Ping
  • Customizable video encoding and file format conversion
  • Video encoding platform - API
  • Usability, interface and ease of use
  • Accessible from everywhere and from any device
They are providing two types of accounts, one is totally free but limited to some features (as limited monthly encode sessions etc.) and few less features then paid account but believe me after using this tool you will love to pay them for beautiful work they are doing for you. They ask for very little amount which will not pinch your pocket ($5/month & $40/year)

So stop reading here and check out the cool tool.

The Link: http://heywatch.com

Free MegaShare account

One of the most popular file hosting site Megashare is giving away limited number of premium accounts. That means no waiting for file download and always open sockets for fast downloading. The most admiring offer is the account you register will never expires. What else you need from them?

Just go to following UR L and grab one premium account for yourself before the box gets empty


The link is
http://www.megashare.com/free_prem.php