In this article I’ll show you a healthy sandwich that will help you in your weight loss goals. Meals like this have helped me lose a dramatic amount of weight. I went from 248 lbs to 167lbs in 5 months and I did that by eating more. If you want to see more about my diet check out this You on a Diet.
Now on with the sandwich. It is full of foods that are both low in calories and foods that make you feel full. Here are the ingredients in my healthy sandwich.
Mtsurov wrote in and asked How to Find a Domain Name, meaning a good one! In this article and video I’ll show you the exact steps to follow to find a great domain name no matter what your site is about.
Specifically I’ll show you how to find the best available name based on celebrity gossip, because that seems to be a favorite topic on the web. To find this wonderful domain name you just need a few free tools:
You can either watch the video, or read everything in detail after the video. You could also do both š
First Steps to Find a Domain Name
The first thing I do when I want to start a new site is analyze which websites currently are getting the traffic I want. So since I’m looking to create a celebrity gossip site, I type celebrity gossip into Google. Here are the top sites for celebrity gossip:
Now that I have a list of my competitors, it is now time to find out what keywords they used to get to the top. This is where the Google Adwords Keyword Tool comes in. Just go to that site and enter the websites above one at a time. Here are the results if you entered perezhilton.com
This is an abbreviation of the results but I’ll explain what your looking at. This tool will analyze either keywords or websites. I always scan websites for their best keyword phrases and then dump all those into the keyword box to find the best.
Then you see all of the information found separated into columns. The first column is the keyword phrase itself. The competition column gives you an idea of how hard it would be for you to capture that keyword phrase for your site. You always want to go after phrases that have little to no competition. So in this example go after “latest gossip in hollywood” instead of “selena gomez stuff to buy”.
The other columns show you approximately how many times the phrase is searched for per month. Don’t look at these numbers as a fact, but instead just rate them based off of size comparison.
If you click on the competition title the list will display the phrases with the most competition and vice versa. What you need to do now is search for the phrases with the least competition and the most searches for every website. After I did that I came up with this list:
| Phrase | Matches | Exact Matches |
|---|---|---|
| gossip in hollywood | 37,200,000 | 11,400 |
| gossip from hollywood | 38,800,000 | 97,700 |
| hollywood and gossip | 41,400,000 | 91,800 |
| celebrities and gossip | 19,900,000 | 312,000 |
| rumors celebrity | 8,990,000 | 11,400 |
| hot celebrity gossip | 7,310,000 | 113,000 |
| famous people | 32,300,000 | 5,420,000 |
| star news | 112,000,000 | 2,300,000 |
| celebrity gossip | 61,700,000 | 15,800,000 |
| gossip news | 25,900,000 | 2,010,000 |
| celebrity blog | 86,600,000 | 711,000 |
Above you can see the best phrases I was able to find from all of those websites. I then go and double check that they are accurate by typing the phrase into Google to see how many matches I get. I then search for the exact phrase by searching for the phrase surrounded by quotes.
Is the Domain Name Taken?
Now that I have my list I jump over to Go Daddy to see if the names are taken. Sadly my best domain name is taken being gossipinhollywood.com š But, guess what? Four of the best domain names are not taken being:
Special Note: When you click on any of these names you’ll get a 37% discount off your next domain name purchase at Go Daddy.
So there you have it. Get a great domain name on any subject. I wrote a few more articles that will help you find even better domain names:
You will also be interested in this article on how to make money blogging How to Make Money Blogging
If you have any questions or comments leave them below.
Till Next Time
Think Tank
A while back I analyzed what all the superstars do to consistently get more views on YouTube. Here is that original article, along with a mashup of the greatest vlogger of all time ZeFrank How to Video Blog.
In this video tutorial I go over all that I learned about vlogging back then through today. I personally follow only a few of these tips for success and if you want to see more on what I do check out Become a YouTube Partner.
Whatever you do in your videos just understand that you will only be successful if you post a large number of videos. By doing so you will improve your ability to make good videos, but also you will increase the odds that you hit on a subject that nobody else does as well as you.
If you have any other questions or comments on YouTube or anything else leave them below.
In this web design and programming video tutorial I will review a lot of what you have been taught previously. I’ll review many topics by showing you how to make drop down boxes that are populated from data stored in a database. If you don’t completely understand everything don’t worry about it. That’s why it is a review.
All of the code from the video follows the video. I included additional comments in the code that you can better understand what is going on. You also should print out the code and refer to it as you watch the video for better comprehension.
Here is a dump file for the database Database Dump File.
If you have any questions or comments leave them below, otherwise enjoy the video š
Code From the Video
In this video tutorial I cover how to do numerous things with MySQL. I show you how to:
And a bunch more…
All of the MySQL statements follow the video. If you have any questions or comments leave them below.
In the next tutorial I’ll be getting into how to use MySQL with PHP.
SQL Statements from the Video
select prod_type,pt_id from product_id;
describe manufacturer_id;describe model_numbers;
SELECT DISTINCT Manufacturer_ID.Manufacturer,Manufacturer_ID.Man_ID FROM Manufacturer_ID, Model_Numbers
WHERE ((Manufacturer_ID.Man_ID = Model_Numbers.Man_ID) AND (Model_Numbers.PT_ID = 45)) order by Manufacturer;
use customer;
show tables;
describe customer;
alter table customer add index state_id (state_id);
describe customer;
alter table customer add index phone_id(phone_id);
drop index state_id on customer;
alter table customer add UNIQUE state_id(state_id);
drop index state_id on customer;
alter table customer add index state_id (state_id);
describe customer;
alter table customer add index order_id(order_id);
create index index_name on tbl_name(columnsToIndex);
alter table customer add column comments varchar(40);
describe customer;
alter table customer change column comments comments text;
describe customer;
alter table customer rename as newTableName;
alter table customer add fulltext index (comments);
show create table customer \G
select * from customer;
describe phone;
insert into phone values (NULL, ‘412-876-7878′,’Work’);
insert into customer values(‘Sally’,’Smith’,’234 Main St’,’Happy Town’,3,15234,SHA(‘Monkey2′),2,NULL,NULL,’Really nice lady who loves cats’);
update customer set comments=’Crazy man who has 2 cats named Peekaboo and Sophie’ where cust_id=1;
insert into customer values(‘Paul’,’Smith’,’234 Main St’,’Happy Town’,3,15234,SHA(‘pw1234′),2,NULL,NULL,’Sally Smiths husband he wants a dog’);
select first_name, comments from customer where match (comments) against (‘crazy’);
insert into customer values(‘Mark’,’Marks’,’194 South St’,’Happy Town’,3,15234,SHA(‘abc1234′),3,NULL,NULL,’Craziest man I ever met. Loves dogs’);
select first_name, last_name, comments from customer where match(comments) against(‘craz*’ in boolean mode);
select first_name, last_name, comments from customer where match(comments) against(‘+craz* -cat*’ in boolean mode);
All day I have been taking advantage of my new YouTube Partner Benefits. You have been sending me a bunch of questions on these benefits and in this article I will answer them.
The main question I have been getting is, “Can I become a YouTube Partner if I don’t live in the United States?”
The YouTube Partner Program is only available to users in Australia, Brazil, Canada, Germany, Spain, France, the United Kingdom, Ireland, Israel, Italy, Japan, Mexico, the Netherlands, and the United States.
I’ve also received questions on what benefits you actually receive as a YouTube Partner. Here is the list of what you can do:
Last week I became a YouTube Partner and I received a bunch of requests on how I did it. SackettGraphics also asked me how I make my videos. I cover both of these topics in the video below.
I created a detailed formula on how to become successful vlogger in the article How to Video Blog. If you missed it? Almost everyone that is successful online copies from the first great vlogger named ZeFrank.
As per the software I use:
If you are on a PC, I recommend that you use the following free tools:
If you have any questions or comments leave them below.
In this video tutorial I show you how to do many things with MySQL. I cover the following MySQL Statements in depth:
In this video tutorial I show you the many ways to insert information into MySQL. I specifically show you how to enter the information:
I then go into some other basic queries you need to understand to use MySQL. All of the code used follows the video.
Previously I covered many of the WordPress problems you were having in WordPress How To and WordPress How To Pt 2. In this video I’ll answer a recent request from Dan to help him better:
And a bunch more…
In this video tutorial I explain how to create efficient tables using SQL. Specifically I’ll show you how to create Atomic Databases. A table is considered Atomic when it focuses on describing just one thing. Here is an article that goes more into this subject MySQL Atomic Tables.
Once you make all of your tables you should make sure they are Normalized. A Normalized Table is a table that follows the 3 Normalized table rules.
A while back I did a series of tutorials on MySQL. However, because you guys requested a more example heavy MySQL tutorial I’m now going to provide that.
If you want to check out the previous tutorial I have it in both text and video format here:
I especially am happy with the articles!
In this video, I go over the basics of using MySQL. For example: Creating Tables, Data Types, Entering Information, Deleting Tables and Basic MySQL commands.
If you have any questions or comments leave them below.
Here is the whole New Think Tank Website organized for your convenience.
Psychology / Indirect Hypnosis / NLP Articleās
ļ»æ
In this PHP video tutorial I’ll show you how to work with exception handling.
When an error occurs in your code this code is referred to as an exception. Meaning the code runs fine Except if the user of the code does certain things. When these Exceptions occur an error is thrown and handled by code that lies somewhere else in your code.
I specifically cover the following topics in the video:
In this PHP video tutorial I’ll cover how to manipulate files with PHP. Specifically I cover the following:
Here is a link to the first article and video for this series, if you haven’t seen it Web Design and Programming.
All of the code follows the video. Use it in anyway. Leave any questions or comments below.
Code from the Video
<html>
<head>
<title><?php echo “Object Oriented Programming”;?></title>
</head>
<body>
<?php
# Creates a file descriptor and assigns it to $file
# The second attribute opens the file for read only purposes
# You can access any file online with this same function
# r+ – Read and Write from beginning of file
# w – Write only to beginning of file
# w+ – Delete contents and read and write to file
# a – Write only to the end of the file
# a+ – Read and Write to the end of the file
$file = fopen(“customers.txt”, “r”);
# While the end of file hasn’t been met print lines to screen
while (!feof($file))
{
# fgets() returns all the characters up to a newline or EOF
# You can also specify the number of characters to return in the 2nd attribute
echo fgets($file). “<br />”;
}
echo “<br />”;
# You can also read a file into an array
$customers = file(“customers.txt”);
foreach ($customers as $customer)
{
list($name,$street,$city,$state) = explode(“,”, $customer);
$state = trim($state);
echo “Name: ” . “$name <br />”;
echo “Street: ” . “$street <br />”;
echo “City: ” . “$city <br />”;
echo “State: ” . “$state <br /><br />”;
}
# Close the file
fclose($file);
$file4 = fopen(“customers.txt”, “a”);
$newCustomer = “\nRick,219 Almond St,Pittsburgh,PA”;
fwrite($file4, $newCustomer);
fclose($file4);
# You can also read a file into a string
$customers = file_get_contents(“customers.txt”);
$customers = explode(“\n”,$customers);
foreach ($customers as $customer)
{
list($name,$street,$city,$state) = explode(“,”, $customer);
$state = trim($state);
echo “Name: ” . “$name <br />”;
echo “Street: ” . “$street <br />”;
echo “City: ” . “$city <br />”;
echo “State: ” . “$state <br /><br />”;
}
$file2 = fopen(“http://www.wikileaks.ch/static/html/faq.html”, “rt”);
while (!feof($file2))
{
$faqs .= fgetss($file2, 1024);
}
fclose($file2);
$file3 = fopen(“justthefaqs.txt”, “wt”);
fwrite($file3, $faqs);
fclose($file3);
?>
</body>
</html>
I while back I created my second most popular tutorial of all time on Illustrator CS5s new features. It’s available here by the way Illustrator CS5 Tutorial.
I received a request from Vera to demonstrate how to recreate her wedding invitations. So in the video below I show you how to use the pen tool, how to figure out what font is used in a graphic and a bunch of other things.
The website I use to analyze fonts is called What the Font. The two sites I use most to get free fonts include 1001 Fonts and Da Font.
I also show you how to turn a blurry Jpeg into an EPS file and review everything not covered in the other tutorials in this Illustrator CS5 tutorial.
Leave any questions or comments below.
Here I continue to explain Object Oriented Programming with PHP. If you missed the first part definitely watch that video tutorial first Object Oriented Programming with PHP.
Here I’ll cover the following topics:
If you have any questions, leave them below. All of the code follows the video.
All the Code from the Video
<html>
<head>
<title><?php echo “Object Oriented Programming”;?></title>
</head>
<body>
<?php
# Inheritance is done when you create a new class from another, thus borrowing the data
# and methods that can be found there.
class Animal
{
private $name; # Private variables are only accessed by class methods, but not subclasses
private $favFood = “meat”;
# A static attributes value is shared by all objects of the class
# You refer to static attribute like this self::$numOfAnimals, not with $this
public static $numOfAnimals = 0;
# Constructor and Deconstructor
public function __construct($name=”No Name”)
{
echo “__construct was called”. “<br />”;
$this->setName($name);
self::$numOfAnimals++;
}
public function __destruct()
{
echo “__destruct was called”. “<br />”;
}
# Get and Set Methods – final is used to keep methods from being overwritten
final public function getName()
{
return $this->name;
}
final public function setName($sentName)
{
$this->age = $sentName;
}
# Animal Default Functions
public function makeNoise()
{
echo “Grrrr”. “<br />”;
}
public function favFood()
{
echo “My favorite food is ” . $this->favFood . “<br />”;
}
public function move()
{
echo “Walk around”. “<br />”;
}
}
class Dog extends Animal
{
# If I didn’t create a new constructor the parent would be called
public function __construct($name=”No Name”)
{
parent::__construct($name); # How to call the parent constructor
# Animal::__construct($name); this would also call the parent constructor
}
public function __destruct()
{
echo “__destruct was called”. “<br />”;
}
# Dog Default Functions Overwrites Class Function
public function makeNoise()
{
Animal::makeNoise(); # How to call the original class method
echo “Bark, Bark”. “<br />”;
}
}
#function animalStuff(
$grover = new Dog(“Grover”); # Create an object grover of class Dog
$paul = new Dog(“Paul”);
$grover->makeNoise(); # Call the makeNoise() method for the grover object
$grover->favFood();
$grover->move();
echo Animal::$numOfAnimals. “<br />”; # Prints out the number of objects created
?>
</body>
</html>
Ever since I posted How to Find WikiLeaks, I’ve received many requests for the WikiLeaks Insurance File. I have the insurance file, but since it is encrypted you may prefer to download The WikiLeaks Site Archive. It contains all of the information currently available on the WikiLeaks site.
Here is a link to the file that doesn’t require a torrent client, but does require Java to be installed WikiLeaks Insurance File.
I was able to locate the WikiLeaks Insurance file at 3 torrent sites so far. Here are links to them:
In this PHP video tutorial I cover Object Oriented Programming with PHP. I specifically go over the following topics:
All of the code from the tutorial is available after the video. Use it in anyway that you like. I’ll continue covering OOP with PHP in the next video tutorial in this series.
If you have any questions leave them below.
All the Code from the Video
<html>
<head>
<title><?php echo “Object Oriented Programming”;?></title>
</head>
<body>
<?php
# Encapsulation lets you hide the code behind an interface so you can protect the code
# and so your user need not understand the code to use it
# A class is a blueprint you use to create objects
# Objects contain the data (attributes) and actions (methods) needed to perform its tasks
# Inheritance is done when you create a new class from another, thus borrowing the data
# and methods that can be found there.
# Polymorphism allows a class to perform differently based on how it is being used.
# Polymorphism can be used to a certain extent with PHP in that you can use common
# method and attribute names for similar classes
# Any use of this is a reference to a specific object and that objects attributes and methods
class Animal
{
public $name; # Public variables can be accessed directly by anyone
private $age; # Private variables are only accessed by class methods, but not subclasses
protected $money; # Protected is like private except can be accessed by inherited classes
const POUNDID = 12345; # A constants value can never change
# A static attributes value is shared by all objects of the class
# You refer to static attribute like this self::$numOfAnimals, not with $this
private static $numOfAnimals = 0;
public function __construct($age)
{
echo “__construct was called”. “<br />”;
$this->setAge($age);
}
public function __destruct()
{
echo “__destruct was called”. “<br />”;
}
# __set can be used to perform error checking before assigning values to private attribs
function __set($attribName, $attribValue)
{
echo “__set was called for “. $attribName. “<br />”;
$this->$attribName = $attribValue;
}
# __get can be used to perform error checking before returning values from private attribs
function __get($attribName)
{
echo “__get was called for “. $attribName. “<br />”;
return $this->$attribName;
}
public function getAge()
{
return $this->age;
}
public function setAge($sentAge)
{
$this->age = $sentAge;
}
}
$dog = new Animal(8); # Create an object dog of class Animal
$dog->name = “Grover”; # Assign a value to the public attribute name
$dogName = $dog->name; # Retreive value from public attribute name
$dog->setAge(8); # Call the setAge() method for the dog object
$dog->age = 9; # Try to set a private attribute that makes a call to __set
echo $dog->age. “<br />”; # Try to get a private attribute that makes a call to __get
echo “The dogs name is ” . $dogName . “<br />”;
echo “The dogs age is ” . $dog->getAge() . “<br />”;
echo “The pounds ID number is “. $dog::POUNDID. “<br />”;
?>
</body>
</html>
Here I show you how to use many string manipulation methods in PHP. Also, I finish showing you how to use regular expressions.
You should watch the previous 2 PHP Regular Expressions video tutorials before you continue on to this one. They are avaialable here PHP Regular Expressions & PHP Regular Expressions Pt 2
I specifically cover the following PHP Methods in this tutorial: