Create a database on the sql server.
mysql> create database [databasename];
List all databases on the sql server.
mysql> show databases;
Switch to a database.
mysql> use [db name];
To see all the tables in the db.
mysql> show tables;
To see database’s field formats.
mysql> describe [table name];
To delete a db.
mysql> drop [...]
I’ve lost count of the number of Javascript scripts I’ve seen floating around
that include the equivalent of the following code snippet:
if (document.all) { element = document.all[id]; else { element = document.getElementById(id); }
document.all was introduced in Internet Explorer 4, because the W3C DOM hadn’t yet standardised a way of grabbing references [...]
All of us who are related to the web business and SEO is looking for way to position higher and higher in search engines. If I simplify things, there are two necessary steps you can do about it. First, write enough and quality content and second, build links. There are many different strategies of building [...]
If you are programming some VBA I/O application, where you are dealing with quotes in the string, like for example website URLs, you have to replace each quote in the string with ” & chr(34) & “
Example:
Original string:
<a href=”http://www.mptrader.com/images/charts/zmDDG23mC.gif” _mce_href=”http://www.mptrader.com/images/charts/zmDDG23mC.gif”></a>
VBA converted string:
<a href=” & chr(34) & “http://www.mptrader.com/images/charts/zmDDG23mC.gif” & chr(34) & [...]
An interesting website to check site profile:
Estimated Value
Estimated Revenue per ady, per month , per year
Estimated Pageviews per day, per month per year
Alexa Rank
Google Pagerank
Google Index
Yahoo Index
Bing Index
History
Site Title
Meta Keywords
Meta Description
If you are writing an article that will be published on the internet, you would probably like that as many visitors as possible would read it, don’t you? The question is, how can you achieve that? Well, the first thing you have to be aware of is, that visitors come to your website mostly through [...]
I have decided to share my ‘Stocks’ traffic stats with you for the first 10 months, to see what kind of progress you can achieve by using SIB tools for building your website.
Google has finally updated visible page rank and I can say I am very happy with it. The [...]
I have just programmed an sitemap generator. I have used Excel 2007 VBA for this purpose. The macro runs through a predefined directory and pulls out information required in the Sitemap.xml file: url, last modification and priority.
Why do you need sitemap and instruction about how the sitemap file should look like can be [...]
I know there are many tools out there which can help you in your link building strategy and SEO. However, there are many situations, when you need something particular, just a small piece of code that would ease your life by automating few simple tasks. In this case, you are not motivated in buying [...]
Categories
- Analytics (1)
- Blog Sites (1)
- Excel (3)
- HTML (1)
- JavaScript (1)
- Link Building (3)
- Link Exchange (1)
- MySQL (1)
- SBI (2)
- SEO (5)
- Uncategorized (1)
- VBA (3)
- Website Building (6)
Archives
- April 2012 (1)
- December 2011 (1)
- August 2011 (1)
- July 2011 (3)
- June 2011 (12)
Facebook Comment Box Integration
In this tutorial we will show you step by step how to integrate FB Comment box into your website. An example can be seen on the following picture: The official tutorial can be found here: http://developers.facebook.com/docs/reference/plugins/comments/ Facebook Setup If you would like to integrate FB comment box, you should first be logged [...]