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

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


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:


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) & 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 ” & Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
Range(“a1″).FormulaR1C1 = Chr(i) & 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


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!

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:

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!

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 !

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.

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)

  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.

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 !

1 2 3 4 5  Scroll to top