[Tips] Role of Page Optimization in SEO

Been reading few articles in the READBUD.COM, until Me stumble upon yet another article about SEO, which is Page Optimization in SEO.

Get's me thinking a whole more course of it that I haven't been worked on yet.
It said that there are two types of Page Optimization in SEO:

1. On-Page Optimization
2. Off-Page Optimization

On-Page Optimization is what we do about our page that will improve the rating or it's visibility within the search engines. Like Customizing it, put some Page Optimization in SEO code in it, et cetera,et cetera...

The other one, which is Off-Page Optimization, is basically all of the other  process we do for improving our page outside the page itself. Like using some outside services to create link to our page (yes, Linking In or Backlink of our page does count very much in Page Optimization in SEO, see me previous post on SEO matter), pinging service, etc.

Here we will talk on the first option. Mainly it concern on our web page hidden features it-self, which will boost the likeliness of our page to be found when people go to the search engines, which is our main objective of Page Optimization in SEO. They are:

1. Title Tag

This is an area in a web page where the text is placed that shows the title of the website on the very top of the web browser window. Search engines use title tags to make a link in search results. Thus, make a glimpse of understanding for the people of what is our page about. So make it as descriptive as well as simple as possible yet attractive. Thus, in result is another way of Page Optimization in SEO.  

2. Meta Tag Description

A Meta Tag Description is a part of web page coding that gives the basic description about the website. This should focus on the website because Meta tag description plays a very important role in web page ranking which also contributes in the Page Optimization in SEO.

3. Meta Tag Keywords

Meta Tag Keywords play the similar role as meta tag description for highlighting the importance of a website Page Optimization in SEO.

4. Keyword Density

Page Optimization in SEO is also related to a particular percentage of keywords used on a web page for the Page Optimization in SEO related attempts which are called keyword density. A keyword for Page Optimization in SEO must be used in a web page from 2% to 8 % for good page ranking. This Page Optimization in SEO technique is the backbone of Search Engine Optimization in term of Page Optimization in SEO. (Do you see how much "Page Optimization in SEO" words in this paragraph alone, not to mention in this whole page? You may think is form of an abuse for the word "Page Optimization in SEO" :P Well, just hang on to that, because its' an example of the Keyword Density way itself, and this page is indeed all about Page Optimization in SEO).

5. URL Structure

If you want your website to rank well then your URL of website must be related to the context of the website, to also help boosting our Page Optimization in SEO. Well, you don't want to end up reading some of those Senior Citizen's "tools" garage sale, when you click on a click that says sexylingerie.com do you? ^__^

Why all the hassles, one may questioned. Well here is why:

When creating or updating a commercial website it should be taken into consideration that the products are made more attractive for the viewers. At the same time it must be taken into account that the ability o gain more exposure with a broader target audience has its own benefits. Most websites need to reach out to a larger target audience in order to enhance their business. On Page Optimization allows a higher page ranking and based on a specific keyword or phrases they enter. This process identifies those keywords that will benefit a particular website and uses them in such a way that it gets a higher page ranking when those keywords are searched. 

Most searchers only use first page displayed websites on their searches because this is where the pages with higher page rankings are displayed, which translates into these pages find the highest relevance to their keyword searches. This makes it even more vital that each website comprehends the significance and the knowledge necessary to adapt their websites to benefit from Search Engine Optimization. 

An understanding of Search Engine Optimization provides the website a higher ranking in the world of search engines. By taking advantage of optimization techniques, more searchers will gain faster access to the particular website. If the website has something worthwhile to offer then this strategy that should be implemented immediately.

REPRINT RIGHTS statement: This article is free for republishing by visitors provided the Author Bio box is retained as usual so that all links are Active/Linkable with no syntax changes. 

[Trick] Microsoft Excel - Copy, Cut, Paste and Paste feature Disabled

Issue

How to solve the issue when your Microsoft Excel’s Copy, Cut, Paste and Paste Special feature are disabled?

Answer

Troubleshooting steps: 1. Open MS Excel 2. Press Alt + F11 to get into Microsoft Visual Basic 3. Go to View and select Immediate Window or you can Press Ctrl + G, immediate window will pop up. 4. Type common application.commandbars("cell").reset and press Enter:   5. Then go back to Ms Excel and test it. The Copy, Cut, Paste and Paste Special feature are available.      You can close the MS Visual Basic.

Number to Word with MS-EXCEL (USD sample)

Continuing the previous post on how to spell number to Indonesian Words, here Me tried to share on how to do it in English.

Option Explicit

'Main Function

Function SpellNumber(ByVal MyNumber)

    Dim Dollars, Cents, Temp

    Dim DecimalPlace, Count

    ReDim Place(9) As String

    Place(2) = " Thousand "

    Place(3) = " Million "

    Place(4) = " Billion "

    Place(5) = " Trillion "

    ' String representation of amount.

    MyNumber = Trim(Str(MyNumber))

    ' Position of decimal place 0 if none.

    DecimalPlace = InStr(MyNumber, ".")

    ' Convert cents and set MyNumber to dollar amount.

    If DecimalPlace > 0 Then

        Cents = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & _

                  "00", 2))

        MyNumber = Trim(Left(MyNumber, DecimalPlace - 1))

    End If

    Count = 1

    Do While MyNumber <> ""

        Temp = GetHundreds(Right(MyNumber, 3))

        If Temp <> "" Then Dollars = Temp & Place(Count) & Dollars

        If Len(MyNumber) > 3 Then

            MyNumber = Left(MyNumber, Len(MyNumber) - 3)

        Else

            MyNumber = ""

        End If

        Count = Count + 1

    Loop

    Select Case Dollars

        Case ""

            Dollars = "No Dollars"

        Case "One"

            Dollars = "One Dollar"

         Case Else

            Dollars = Dollars & " Dollars"

    End Select

    Select Case Cents

        Case ""

            Cents = " and No Cents"

        Case "One"

            Cents = " and One Cent"

              Case Else

            Cents = " and " & Cents & " Cents"

    End Select

    SpellNumber = Dollars & Cents

End Function

     

' Converts a number from 100-999 into text

Function GetHundreds(ByVal MyNumber)

    Dim Result As String

    If Val(MyNumber) = 0 Then Exit Function

    MyNumber = Right("000" & MyNumber, 3)

    ' Convert the hundreds place.

    If Mid(MyNumber, 1, 1) <> "0" Then

        Result = GetDigit(Mid(MyNumber, 1, 1)) & " Hundred "

    End If

    ' Convert the tens and ones place.

    If Mid(MyNumber, 2, 1) <> "0" Then

        Result = Result & GetTens(Mid(MyNumber, 2))

    Else

        Result = Result & GetDigit(Mid(MyNumber, 3))

    End If

    GetHundreds = Result

End Function

     

' Converts a number from 10 to 99 into text.

Function GetTens(TensText)

    Dim Result As String

    Result = ""           ' Null out the temporary function value.

    If Val(Left(TensText, 1)) = 1 Then   ' If value between 10-19...

        Select Case Val(TensText)

            Case 10: Result = "Ten"

            Case 11: Result = "Eleven"

            Case 12: Result = "Twelve"

            Case 13: Result = "Thirteen"

            Case 14: Result = "Fourteen"

            Case 15: Result = "Fifteen"

            Case 16: Result = "Sixteen"

            Case 17: Result = "Seventeen"

            Case 18: Result = "Eighteen"

            Case 19: Result = "Nineteen"

            Case Else

        End Select

    Else                                 ' If value between 20-99...

        Select Case Val(Left(TensText, 1))

            Case 2: Result = "Twenty "

            Case 3: Result = "Thirty "

            Case 4: Result = "Forty "

            Case 5: Result = "Fifty "

            Case 6: Result = "Sixty "

            Case 7: Result = "Seventy "

            Case 8: Result = "Eighty "

            Case 9: Result = "Ninety "

            Case Else

        End Select

        Result = Result & GetDigit _

            (Right(TensText, 1))  ' Retrieve ones place.

    End If

    GetTens = Result

End Function

    

' Converts a number from 1 to 9 into text.

Function GetDigit(Digit)

    Select Case Val(Digit)

        Case 1: GetDigit = "One"

        Case 2: GetDigit = "Two"

        Case 3: GetDigit = "Three"

        Case 4: GetDigit = "Four"

        Case 5: GetDigit = "Five"

        Case 6: GetDigit = "Six"

        Case 7: GetDigit = "Seven"

        Case 8: GetDigit = "Eight"

        Case 9: GetDigit = "Nine"

        Case Else: GetDigit = ""

    End Select

End Function

Result:

Those routines (both with IDR or USD) are giving me quite headache to accomplish. So, May you find these Resourceful…

Thanks and regards,

Number to Word with MS-EXCEL (IDR sample)

This is the function to make my life easier (in the Excel Term though :^_^):

Function Terbilang(n As Long) As String 'max 2.147.483.647

    Dim satuan As Variant, Minus As Boolean

    On Error GoTo terbilang_error

   

    satuan = Array("", "Satu", "Dua", "Tiga", "Empat", "Lima", "Enam", "Tujuh", "Delapan", "Sembilan", "Sepuluh", "Sebelas")

    If n < 0 Then

        Minus = True

        n = n * -1

    End If

    Select Case n

        Case 0 To 11

            Terbilang = " " + satuan(Fix(n))

        Case 12 To 19

            Terbilang = Terbilang(n Mod 10) + " Belas"

        Case 20 To 99

            Terbilang = Terbilang(Fix(n / 10)) + " Puluh" + Terbilang(n Mod 10)

        Case 100 To 199

            Terbilang = " Seratus" + Terbilang(n - 100)

        Case 200 To 999

            Terbilang = Terbilang(Fix(n / 100)) + " Ratus" + Terbilang(n Mod 100)

        Case 1000 To 1999

            Terbilang = " Seribu" + Terbilang(n - 1000)

        Case 2000 To 999999

            Terbilang = Terbilang(Fix(n / 1000)) + " Ribu" + Terbilang(n Mod 1000)

        Case 1000000 To 999999999

            Terbilang = Terbilang(Fix(n / 1000000)) + " Juta" + Terbilang(n Mod 1000000)

        Case Else

            Terbilang = Terbilang(Fix(n / 1000000000)) + " Milyar" + Terbilang(n Mod 1000000000)

    End Select

    If Minus = True Then

        Terbilang = "Minus" + Terbilang

    End If

   

    Exit Function

terbilang_error:

    MsgBox Err.Description, vbCritical, "^_^Terbilang Error"

End Function

Here the sample of the result:

May you find this resourcefull...

Thanks and regards

[Tips] How to find out Nokia MAC Address

Just 4 Share.

In case you want to connect your Nokia to your office's Hotspot via your mobile but they need to recognize it first by the MAC Address. So flip in and out all your Nokia's menu but won't find any related to that. What should you do?

1. Call the service center (what a waste of time / money)
2. Read the manual book (of course...!! But it sit nicely and warm at your drawer back at home)
3. Ask for the service code to anyone you knew (this could be the salvation you seek, but unfortunately no one in your parameter would know that)

So here we are, trying to save you some hour of labor... The Service Code... (hurraayyy...!) :D

            *#62209526#     : MAC Address Number

            *#06#               : IMEI Serial Number

[Tips & Trick] PHP Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server:

As the title stated, quite a troublesome issue here at my work. Wasted quite enough time for Me to take a nap :P

All was started when Me got assigned to move certain web server to a new machine. The configurations are PHP inside the Mikocok Internet Information Services (IIS for short) using ISAPI and Mikocok SQL Server 2005 Express.

To make the story short, all preparation had been done. The MS-SQL is up and running. PHP installed using manual process, that's Unzipping the ZIP Package to C:\php, set the Windows' Path to Include it, Modified the php.ini to enable MSSQL and LDAP extensions, adding windows' Environment Variables (PHPRC=C:\php). Set the IIS to use PHP5ISAPI.DLL as a binding to PHP compiler and set the ".php" as the file extension used for PHP. Me also have checked the PHP configuration through function. All is well according the phpinfo data.

And then the merit paid-off... :(

All Me did was trying to connect to the MS-SQL DB and the Error Message goes:

PHP Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server:

Trying was all Me could do as quickly as Me could. Googling (if it even a word :D), Checking all the configs, the required files and even reinstalling the entire system to make sure all is mimicking the old one. None of them to bare any fruit.

And so days gone by to weeks, while the user is reverted to the old system. But managements are still at Me wit until this very day, when me come back to uncle Google to have another session. Finally, there's an article which me have failed to see before. Its' all about the version of one particular file which is used by the IIS to communicate with the MS-SQL DB. The One and Awesome:

NTWDBLIB.DLL (cheers and applause...!!!!)

as the article (you can find it here) said that:

"...ntwdblib.dll Version - On some systems the ntwdblib.dll version is too old to work correctly with PHP. If your version does not end in 80.194.0 it's probably too old..."

And so me check... Indeed Me version was still 2000.2.8.0! You could find this by pressing Alt+Enter at C:\php\ntwdblib.dll file.

And so Me download the file from the link provided in the above article, replace the file and Restart the IIS.And so Me problem solved. The Application is up and running now, with the DB Connection issue resolved.

For backup purpose, there was also a Mirror of the file to DOWNLOAD HERE.