Sometimes you may need to populate a table (usually a temporary or new table) from data of another table (usually huge table).
Here’s is the statement that you may use
INSERT INTO “table1” (“column1”, “column2”, …)
SELECT “column3”, “column4”, …FROM “table2”
I got this error message in my application
Error with database: Table ‘table_name’ is marked as crashed and should be repaired
Went to the net and look for the solution. The simplest one is to click on the “Repair Database” button provided in cpanel
Easiest way to generate a unique number is by combining all the date and time.
The code is as follow
$unique = date(“YmdHis”); //will generate yyyymmddhhmmss
If you want to update multiple records, usually you will have to do a loop and generate multiple SQL statement like this
UPDATE table_name SET fieldname = value1 WHERE fieldname = field_id1;
UPDATE table_name SET fieldname = value2 WHERE fieldname = field_id2;
UPDATE table_name SET fieldname = value3 WHERE fieldname = field_id3;
But to save some resource (perhaps), you can also update multiple records in just one single MySQL statement
UPDATE table_name
SET fieldname = CASE value_id
WHEN value_id1 THEN ‘value1’
WHEN value_id2 THEN ‘value2’
WHEN value_id3 THEN ‘value3’
END
WHERE value_id IN (value_id1,value_id2,value_id3)
This PHP code can be used to check whether email is valid or not by ILoveJackDaniel. It is a bit lengthy compared to other script, but this one is more comprehensive.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 | function check_email_address($email) { // First, we check that there's one @ symbol, // and that the lengths are right. if (!ereg("^[^@]{1,64}@[^@]{1,255}$", $email)) { // Email invalid because wrong number of characters // in one section or wrong number of @ symbols. return false; } // Split it into sections to make life easier $email_array = explode("@", $email); $local_array = explode(".", $email_array[0]); for ($i = 0; $i < sizeof($local_array); $i++) { if (!ereg("^(([A-Za-z0-9!#$%&'*+/=?^_`{|}~-][A-Za-z0-9!#$%& ↪'*+/=?^_`{|}~\.-]{0,63})|(\"[^(\\|\")]{0,62}\"))$", $local_array[$i])) { return false; } } // Check if domain is IP. If not, // it should be valid domain name if (!ereg("^\[?[0-9\.]+\]?$", $email_array[1])) { $domain_array = explode(".", $email_array[1]); if (sizeof($domain_array) < 2) { return false; // Not enough parts to domain } for ($i = 0; $i < sizeof($domain_array); $i++) { if (!ereg("^(([A-Za-z0-9][A-Za-z0-9-]{0,61}[A-Za-z0-9])| ↪([A-Za-z0-9]+))$", $domain_array[$i])) { return false; } } } return true; } |
I’ve been doing data cleansing of one of my project. Then there was a need to find some abbreviation to be replaced by the real words.
Here I did with mysql statement.
update property set town = replace(town,’tmn’,’taman’)
In general:
update TABLENAME set FIELDNAME = replace (FIELDNAME, searchstr, replacestr)
I always want to do a very fast application development. This can only be done with what we call a “framework”. I have been doing a lot of research on popular PHP framework but not yet decided which one to use.
Some of them are cakephp, codeigniter, symphony and rapyd.
After using it for some time will plan to come out with own framework for better control and easy modification on the code.
I’ve been looking for WP plugin to add source code in blog posting. I want to share my code sample via the blog. At last I found this WP-Syntax plugin.
Here how a source code will look like
1 2 3 | <?php echo "Hello World!"; ?> |
You need to add <pre lang=”php” line=”1″> tag before and </pre> tag after the source code. The parameter line=1 is to show the line number
Sometimes maybe you need to get a domain name from a URL string. Here is the code
1 2 3 4 5 6 7 8 9 10 11 12 | function GetDomain($url) { $nowww = ereg_replace(’www.’,”,$url); $domain = parse_url($nowww); if(!empty($domain["host"])) { return $domain["host"]; } else { return $domain["path"]; } } |
