Innerblogger.com

Most servers have a php spell functionality already installed. Check with your host whether php has been compiled with "pspell".

You can easily add a spell check feature on your website using pspell.

Here's a very simple script to demonstrate the use of pspell. Try it by creating a new empty file called "phpspell.php" and copy and paste the following code into it. To use it, enter in your browser the URL
http://yourdomain.com/phpspell.php?word=tesst

(replace tesst with any word to check)

This little script will give you the best alternative suggestion for the word.

This is just a simple example. You can get a full spell checker functionality with pspell. Naka Gadjov has made a nice script which I have used with success. Check out his free script to make the most of pspell functionality:

PHP Spell Checker

I have been working hard lately to try to understand how MySQL databases work. MySQL is a very efficient way of storing data for your web pages and calling the data with simple php routines.

Here are some of my notes on getting mysql to work:

I had some text files with data that I needed to import to MySQL. You may have some csv files, too.

how to import a text file database (flat file) to a mysql database:

you should have a text file that has delimiters for fields. often the delimiter is TAB, or comma. csv files use a comma.

for instance, a row in your flat file should look like.
john doe,5557359,elm street,tinseltown

you need to create a mysql database, and within the database create a table that has the exact number of columns that are in the text file. this you can do using the graphical interface phpMyAdmin, or an sql query.

for instance:
CREATE TABLE mycustomers(customername VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY(customername), phonenumber INT NOT NULL, address VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, INDEX(phonenumber), city VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL;

if you need to create multiple tables, you can also make a php script to do this for you. First, you need a php script to connect to your database:

save that as connectdb.php

then make another file, e.g. create_table.php with the following code in it:

you can copy-paste that line as many times as you want, then just use a text editor to find/replace the table name with another table name, so you can create multiple tables from the same php script.

next, you need to import the file. i recommend that you name your text file exactly the same as the table you want to import it into. for instance, if you want to import to table mycustomers, name the file mycustomers.txt. if you want to import the file from your local server, use the following:

if you dont have file privileges, or if you don't know what file privileges are, then you need to use this mysql query:
LOAD DATA LOCAL INFILE '/home/path/path1/path2/mycustomers.txt' INTO TABLE mycustomers FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'

if you want to have file privileges, do the following:
using ssh, logon to your server shell as root. type mysql. if you access is denied then you don't have root privileges. check with your hosting provider.

at the mysql prompt type:
GRANT FILE ON *.* TO 'username'@'localhost';
note, that in the above line, replace username with the username you want to grant the file privileges and leave localhost as is.

then this works:
LOAD DATA INFILE '/home/yourdir/dir2/dir3/dir4/file.txt'
INTO TABLE yourtablename FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'

but you need these permissions for this to worK
files 644
all directories leading to the file 755

remember to set them back to their original ones after working.

if your query only loads one row into the MySQL database, check the that the line endings are correct, i.e. is it \n or \r ?

you need to use the absolute path to the file:
to find out a your absolute path, create a file absolute.php into the directory that you want to know the absolute path to, and paste the following code and run it:

before you create a table, plan it carefully. big tables are slow to alter afterwards. have an id auto_increment row so you can get adjacent rows in searches.

how do you add fields to existing tables? with this mysql query:
ALTER TABLE r ADD customer INT NOT NULL;
ALTER TABLE r ADD phonenumber INT NOT NULL;
ALTER TABLE r ADD id MEDIUMINT NOT NULL;
ALTER TABLE r ADD INDEX (id) AUTO_INCREMENT;

hope this helps!

Here's a little php file I made for tracking your site's conversions. Especially for those who are trying to fund their website through affiliate marketing.

The trick is to create a "go" page instead of linking directly to the affiliate sites. This way you can use your own stats program, Google Analytics or whatever, to easily track your affiliate links' performance.

Create a file called "go.php". Place it in your website's root.

Here is the entire content you'll need in the file:

Now, in your website, instead of linking to an affiliate program directly, link to the go page.

For instance, if your own website is called example.com and your affiliate landing page is http://www.affiliatewhatever.com/myid

Your link should look like this:
http://example.com/go.php?site=http://www.affiliatewhatever.com/myid

Just add your stats code to where it says on the code, and you should be able to follow your affiliate links' performance very effectively and make adjustments to increase the performance.

Reader questions!

I’m new to wp and I am using the above theme.Can you help me with 2 questions,(I’ve tried wp support forum,but got no response).

How do you enter the text into those tabs you have at the top of your blog ? ads by google,wordpress blog,.etc

This question has been answered in: How to Insert Ad Code in Wordpress Template

One more question ,if I may: I use Bluehost as well. If I want to try a different theme,do I simply create a new directory,and upload the zip files to it ? Will this interfere with any other blogs,or are they all treated as separate ?

Yes, just upload and unzip the files to the themes directory. Wordpress should be able to find them, and you can just change your theme using the "Presentation" link in your WP dashboard. You can always change back to your original theme, it's safe to test other themes and play around. Won't affect your other blogs. The specific instructions are here: How to install a Wordpress Theme

Re your other question, I'm not exactly sure what you meant - did you want to have a static landing page with just one entry and have your blog running separately? If so, check here: How to Create a Static Start Page for Wordpress.

Otherwise Wordpress will just display your entries in the order in which they were posted.

Good luck!
Josh

Here are a few tips to get you started in the domain name game. In this article you'll find links to resources that I've found useful in my search for valuable domain names.

Speculation with domain names has become a multibillion-dollar industry. Recently, single domain names have been sold for almost 10 million dollars. Wow. I got into the domain name game about a year ago in the hopes of making some extra money by registering domain names and then selling them for a profit. Right now I've got a domain portfolio of about 600 names. I've sold a few for a modest profit, but haven't yet landed a big sale.

It's an exciting game though. You can register a domain name for as low as $0.99, and then you just wait for the right buyer to come along, and you might be looking at a nice profit. However, the problem is that most good domain names have already been registered, and if you want a nice name for yourself, you're most likely going to have to buy it from a domainer, and the prices can be steep. It's not easy to make money buying and selling domains, but it's certainly possible, and anyway it's worth registering a few hundred just in case you land a winner! You could develop a portfolio of about 500 names for as low as $500 if you register .info domains exclusively. For .com domains, registrations start at $6.95, so a portfolio of a hundred names would cost you about $700.

There are hundreds of domain registration service providers to choose from. Competition is fierce, so it's worth looking around for the best deals. Just do a google search for "domain registration" and you'll be sure to find lots of ads by companies eager to sign you up for their services.

Personally, I use my own domain reseller account for registrations. You can use it too if you wish. Thanks to the reseller system, I can offer very reasonable prices for domain registrations - I don't think you can get domains any cheaper from anyone else. It's secure, there is 24/7 support, and you can't beat the simplicity of the process. If you like the sound of that, check out my service at UNEC Domain Registrations. Also, since you know the owner (me), this way you'll know who to talk to if you have questions or trouble. Send me an email if you join up, and I'll be sure to add you to my InnerBlogger VIP list!

Domain Name Appraisals and Valuation

What is a domain name worth? This is the question for those in the domain name game. How does one valuate a domain name? How can one know which domains to register or buy?

To answer this question, are a variety of domain name appraisal services have been made available on the Internet. There are two types of appraisal services: automated appraisals and human appraisals. Automated appraisals are scripts that analyze a domain name according to some metrics that supposedly have predictive value for the commercial potential of a domain name. These are often free of charge. Professional human appraisals are just that, valuations done by human evaluation of the domain name. These are often offered by domain registration services and domain marketplace services.

You can order a professional appraisal at SEDO.com for €49 ($65). You can also get a domain appraisal at GoDaddy for as low as $5.99. Personally I would recommend the SEDO appraisal, if you have a domain name that is already obviously valuable.

Automated appraisals on the Web are mostly free, and most of them can be very unpredictable. The most accurate free automated domain appraisals are provided by EstiBot.com Domain Appraisals. That is my site, so you'll know who to turn to if you have complaints…but it really is the best, just give it a try and see for yourself. It is statistically more accurate than many paid appraisals. It also gives you a nice keyword analysis report on your names.

Of the other free automated appraisal systems, possibly the most popular is Leapfish.com. It does give reasonably good appraisals in about 20-30% of cases, but you should always check with other appraisal tools, too. It does not match EstiBot in accuracy, not even close. DomainScore.com is a nice tool for purely English keyword domain names. It cannot handle brandable names or numeric names. It will not give you a dollar value, but a score, which you can then compare to their so-called Premium domains, which all have to get a certain score. It's not a bad tool, but is limited to pure keyword domains.

Domain Registration and Reseller Accounts

If you plan to register a lot of domain names, it's a good idea to purchase a Reseller account. This will enable you to register your own domains at a significant discount, plus has the additional advantage of enabling you to set up your own domain registration business. With a reseller account, you can sell domain registration and web hosting to others. It's a nice way to earn some extra money, setting up an account and starting your own domain name business is very easy and risk-free. The main company will handle 24/7 support and hosting your website so you can just sit back and enjoy your new business. Everything is automated. You can buy a reseller account from me if you wish (so you'll know who to turn to with questions), just go to ProfitCash Domain Reseller Accounts.

Drop me an email if you have further questions about these things - I'll be happy to help you get started with domaining.