PHP Encode email for protected spam program suck your email

Current data is substantial. Those with more than would be in the business or marketing programs, so it is waiting to absorb any email from the web site or forum posts from various sites to be used in a business context. Or even out of our e-mail goes on sale. This will become a spam mail coming into our mail as many Create a nuisance to the owners e-mail. Another method of protection is. Email encryption is broken.

Better get started. I will write in the form of functions PHP. So that you can apply simple.
====================================
<?php
function mailEncode($mailText){
$email = '';
for($i=0; $i $email .= '&#'.ord(substr($mailText,$i,1));
}
return $email;
}

echo mailEncode("bigquery@gmail.com");
?>
====================================

When view source will see bigquery@gmail.com

Encode the e-mail function may be prevented to a certain extent only.

SQL INSERT .. SELECT sql command copy data from table to table

This SQL command may not use frequently. But I think should be have useful for some people, I'm talking about "INSERT INTO ... SELECT", The SQL Command for insert data to table from another data table

The Syntax of this SQL command is:
INSERT INTO "table1" ("column1", "column2")
SELECT "column3", "column4"
FROM "table2"

THE EXAMPLE
If you want to puts data from "Orders" table which is order purchased in 2007 to keep the other one, can create query like follow this:

INSERT INTO Orders2007(order_id, date_purchased, amount)
SELECT order_id, date_purchased, amount
FROM Orders
WHERE Year(date_purchased) = 2007;

That's it will get data which is order purchased in 2007 to "Order2007" table.
This SQL statement is like a copy to some records into another table.