Sunday, December 2, 2012

YII: Fetch rows using msql In clause 


$criteria = new CDbCriteria; 

$criteria->addInCondition("model_id", $_POST['autoId']); 

$Model= Model::model()->findAll($criteria);
Posted by at No comments:
Labels:

YII: Getting the Base URL 


<?php echo getBaseUrl(true) ?>
Posted by at No comments:
Labels:

Sunday, November 25, 2012

Add range in YII sql condition

$criteria->addBetweenCondition('expiry_date', ''.$this->date_first.'', ''.$this->date_last.'');
Posted by at No comments:

Sunday, November 18, 2012

list of countries states and provinces

http://purpleslinky.com/trivia/quizzes/list-of-world-countries-counties-states-provinces-currencies/
Posted by at No comments:

List of countries in sql format

INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AF','AFGHANISTAN','Afghanistan','AFG','004');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AL','ALBANIA','Albania','ALB','008');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('DZ','ALGERIA','Algeria','DZA','012');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AS','AMERICAN SAMOA','American Samoa','ASM','016');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AD','ANDORRA','Andorra','AND','020');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AO','ANGOLA','Angola','AGO','024');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AI','ANGUILLA','Anguilla','AIA','660');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AQ','ANTARCTICA','Antarctica','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AG','ANTIGUA AND BARBUDA','Antigua and Barbuda','ATG','028');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AR','ARGENTINA','Argentina','ARG','032');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AM','ARMENIA','Armenia','ARM','051');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AW','ARUBA','Aruba','ABW','533');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AU','AUSTRALIA','Australia','AUS','036');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AT','AUSTRIA','Austria','AUT','040');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AZ','AZERBAIJAN','Azerbaijan','AZE','031');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BS','BAHAMAS','Bahamas','BHS','044');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BH','BAHRAIN','Bahrain','BHR','048');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BD','BANGLADESH','Bangladesh','BGD','050');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BB','BARBADOS','Barbados','BRB','052');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BY','BELARUS','Belarus','BLR','112');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BE','BELGIUM','Belgium','BEL','056');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BZ','BELIZE','Belize','BLZ','084');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BJ','BENIN','Benin','BEN','204');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BM','BERMUDA','Bermuda','BMU','060');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BT','BHUTAN','Bhutan','BTN','064');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BO','BOLIVIA','Bolivia','BOL','068');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BA','BOSNIA AND HERZEGOVINA','Bosnia and Herzegovina','BIH','070');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BW','BOTSWANA','Botswana','BWA','072');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BV','BOUVET ISLAND','Bouvet Island','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BR','BRAZIL','Brazil','BRA','076');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('IO','BRITISH INDIAN OCEAN TERRITORY','British Indian Ocean Territory','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BN','BRUNEI DARUSSALAM','Brunei Darussalam','BRN','096');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BG','BULGARIA','Bulgaria','BGR','100');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BF','BURKINA FASO','Burkina Faso','BFA','854');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BI','BURUNDI','Burundi','BDI','108');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('KH','CAMBODIA','Cambodia','KHM','116');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CM','CAMEROON','Cameroon','CMR','120');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CA','CANADA','Canada','CAN','124');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CV','CAPE VERDE','Cape Verde','CPV','132');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('KY','CAYMAN ISLANDS','Cayman Islands','CYM','136');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CF','CENTRAL AFRICAN REPUBLIC','Central African Republic','CAF','140');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TD','CHAD','Chad','TCD','148');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CL','CHILE','Chile','CHL','152');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CN','CHINA','China','CHN','156');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CX','CHRISTMAS ISLAND','Christmas Island','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CC','COCOS (KEELING) ISLANDS','Cocos (Keeling) Islands','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CO','COLOMBIA','Colombia','COL','170');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('KM','COMOROS','Comoros','COM','174');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CG','CONGO','Congo','COG','178');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CD','CONGO, THE DEMOCRATIC REPUBLIC OF THE','Congo, the Democratic Republic of the','COD','180');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CK','COOK ISLANDS','Cook Islands','COK','184');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CR','COSTA RICA','Costa Rica','CRI','188');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CI','COTE D\'IVOIRE','Cote D\'Ivoire','CIV','384');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('HR','CROATIA','Croatia','HRV','191');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CU','CUBA','Cuba','CUB','192');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CY','CYPRUS','Cyprus','CYP','196');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CZ','CZECH REPUBLIC','Czech Republic','CZE','203');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('DK','DENMARK','Denmark','DNK','208');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('DJ','DJIBOUTI','Djibouti','DJI','262');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('DM','DOMINICA','Dominica','DMA','212');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('DO','DOMINICAN REPUBLIC','Dominican Republic','DOM','214');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('EC','ECUADOR','Ecuador','ECU','218');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('EG','EGYPT','Egypt','EGY','818');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SV','EL SALVADOR','El Salvador','SLV','222');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GQ','EQUATORIAL GUINEA','Equatorial Guinea','GNQ','226');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('ER','ERITREA','Eritrea','ERI','232');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('EE','ESTONIA','Estonia','EST','233');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('ET','ETHIOPIA','Ethiopia','ETH','231');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('FK','FALKLAND ISLANDS (MALVINAS)','Falkland Islands (Malvinas)','FLK','238');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('FO','FAROE ISLANDS','Faroe Islands','FRO','234');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('FJ','FIJI','Fiji','FJI','242');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('FI','FINLAND','Finland','FIN','246');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('FR','FRANCE','France','FRA','250');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GF','FRENCH GUIANA','French Guiana','GUF','254');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PF','FRENCH POLYNESIA','French Polynesia','PYF','258');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TF','FRENCH SOUTHERN TERRITORIES','French Southern Territories','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GA','GABON','Gabon','GAB','266');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GM','GAMBIA','Gambia','GMB','270');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GE','GEORGIA','Georgia','GEO','268');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('DE','GERMANY','Germany','DEU','276');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GH','GHANA','Ghana','GHA','288');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GI','GIBRALTAR','Gibraltar','GIB','292');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GR','GREECE','Greece','GRC','300');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GL','GREENLAND','Greenland','GRL','304');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GD','GRENADA','Grenada','GRD','308');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GP','GUADELOUPE','Guadeloupe','GLP','312');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GU','GUAM','Guam','GUM','316');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GT','GUATEMALA','Guatemala','GTM','320');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GN','GUINEA','Guinea','GIN','324');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GW','GUINEA-BISSAU','Guinea-Bissau','GNB','624');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GY','GUYANA','Guyana','GUY','328');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('HT','HAITI','Haiti','HTI','332');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('HM','HEARD ISLAND AND MCDONALD ISLANDS','Heard Island and Mcdonald Islands','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('VA','HOLY SEE (VATICAN CITY STATE)','Holy See (Vatican City State)','VAT','336');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('HN','HONDURAS','Honduras','HND','340');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('HK','HONG KONG','Hong Kong','HKG','344');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('HU','HUNGARY','Hungary','HUN','348');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('IS','ICELAND','Iceland','ISL','352');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('IN','INDIA','India','IND','356');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('ID','INDONESIA','Indonesia','IDN','360');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('IR','IRAN, ISLAMIC REPUBLIC OF','Iran, Islamic Republic of','IRN','364');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('IQ','IRAQ','Iraq','IRQ','368');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('IE','IRELAND','Ireland','IRL','372');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('IL','ISRAEL','Israel','ISR','376');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('IT','ITALY','Italy','ITA','380');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('JM','JAMAICA','Jamaica','JAM','388');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('JP','JAPAN','Japan','JPN','392');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('JO','JORDAN','Jordan','JOR','400');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('KZ','KAZAKHSTAN','Kazakhstan','KAZ','398');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('KE','KENYA','Kenya','KEN','404');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('KI','KIRIBATI','Kiribati','KIR','296');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('KP','KOREA, DEMOCRATIC PEOPLE\'S REPUBLIC OF','Korea, Democratic People\'s Republic of','PRK','408');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('KR','KOREA, REPUBLIC OF','Korea, Republic of','KOR','410');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('KW','KUWAIT','Kuwait','KWT','414');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('KG','KYRGYZSTAN','Kyrgyzstan','KGZ','417');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('LA','LAO PEOPLE\'S DEMOCRATIC REPUBLIC','Lao People\'s Democratic Republic','LAO','418');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('LV','LATVIA','Latvia','LVA','428');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('LB','LEBANON','Lebanon','LBN','422');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('LS','LESOTHO','Lesotho','LSO','426');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('LR','LIBERIA','Liberia','LBR','430');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('LY','LIBYAN ARAB JAMAHIRIYA','Libyan Arab Jamahiriya','LBY','434');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('LI','LIECHTENSTEIN','Liechtenstein','LIE','438');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('LT','LITHUANIA','Lithuania','LTU','440');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('LU','LUXEMBOURG','Luxembourg','LUX','442');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MO','MACAO','Macao','MAC','446');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MK','MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF','Macedonia, the Former Yugoslav Republic of','MKD','807');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MG','MADAGASCAR','Madagascar','MDG','450');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MW','MALAWI','Malawi','MWI','454');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MY','MALAYSIA','Malaysia','MYS','458');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MV','MALDIVES','Maldives','MDV','462');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('ML','MALI','Mali','MLI','466');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MT','MALTA','Malta','MLT','470');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MH','MARSHALL ISLANDS','Marshall Islands','MHL','584');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MQ','MARTINIQUE','Martinique','MTQ','474');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MR','MAURITANIA','Mauritania','MRT','478');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MU','MAURITIUS','Mauritius','MUS','480');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('YT','MAYOTTE','Mayotte','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MX','MEXICO','Mexico','MEX','484');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('FM','MICRONESIA, FEDERATED STATES OF','Micronesia, Federated States of','FSM','583');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MD','MOLDOVA, REPUBLIC OF','Moldova, Republic of','MDA','498');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MC','MONACO','Monaco','MCO','492');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MN','MONGOLIA','Mongolia','MNG','496');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MS','MONTSERRAT','Montserrat','MSR','500');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MA','MOROCCO','Morocco','MAR','504');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MZ','MOZAMBIQUE','Mozambique','MOZ','508');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MM','MYANMAR','Myanmar','MMR','104');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('NA','NAMIBIA','Namibia','NAM','516');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('NR','NAURU','Nauru','NRU','520');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('NP','NEPAL','Nepal','NPL','524');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('NL','NETHERLANDS','Netherlands','NLD','528');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AN','NETHERLANDS ANTILLES','Netherlands Antilles','ANT','530');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('NC','NEW CALEDONIA','New Caledonia','NCL','540');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('NZ','NEW ZEALAND','New Zealand','NZL','554');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('NI','NICARAGUA','Nicaragua','NIC','558');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('NE','NIGER','Niger','NER','562');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('NG','NIGERIA','Nigeria','NGA','566');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('NU','NIUE','Niue','NIU','570');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('NF','NORFOLK ISLAND','Norfolk Island','NFK','574');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MP','NORTHERN MARIANA ISLANDS','Northern Mariana Islands','MNP','580');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('NO','NORWAY','Norway','NOR','578');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('OM','OMAN','Oman','OMN','512');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PK','PAKISTAN','Pakistan','PAK','586');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PW','PALAU','Palau','PLW','585');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PS','PALESTINIAN TERRITORY, OCCUPIED','Palestinian Territory, Occupied','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PA','PANAMA','Panama','PAN','591');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PG','PAPUA NEW GUINEA','Papua New Guinea','PNG','598');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PY','PARAGUAY','Paraguay','PRY','600');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PE','PERU','Peru','PER','604');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PH','PHILIPPINES','Philippines','PHL','608');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PN','PITCAIRN','Pitcairn','PCN','612');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PL','POLAND','Poland','POL','616');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PT','PORTUGAL','Portugal','PRT','620');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PR','PUERTO RICO','Puerto Rico','PRI','630');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('QA','QATAR','Qatar','QAT','634');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('RE','REUNION','Reunion','REU','638');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('RO','ROMANIA','Romania','ROM','642');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('RU','RUSSIAN FEDERATION','Russian Federation','RUS','643');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('RW','RWANDA','Rwanda','RWA','646');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SH','SAINT HELENA','Saint Helena','SHN','654');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('KN','SAINT KITTS AND NEVIS','Saint Kitts and Nevis','KNA','659');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('LC','SAINT LUCIA','Saint Lucia','LCA','662');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PM','SAINT PIERRE AND MIQUELON','Saint Pierre and Miquelon','SPM','666');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('VC','SAINT VINCENT AND THE GRENADINES','Saint Vincent and the Grenadines','VCT','670');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('WS','SAMOA','Samoa','WSM','882');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SM','SAN MARINO','San Marino','SMR','674');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('ST','SAO TOME AND PRINCIPE','Sao Tome and Principe','STP','678');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SA','SAUDI ARABIA','Saudi Arabia','SAU','682');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SN','SENEGAL','Senegal','SEN','686');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CS','SERBIA AND MONTENEGRO','Serbia and Montenegro','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SC','SEYCHELLES','Seychelles','SYC','690');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SL','SIERRA LEONE','Sierra Leone','SLE','694');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SG','SINGAPORE','Singapore','SGP','702');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SK','SLOVAKIA','Slovakia','SVK','703');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SI','SLOVENIA','Slovenia','SVN','705');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SB','SOLOMON ISLANDS','Solomon Islands','SLB','090');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SO','SOMALIA','Somalia','SOM','706');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('ZA','SOUTH AFRICA','South Africa','ZAF','710');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GS','SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS','South Georgia and the South Sandwich Islands','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('ES','SPAIN','Spain','ESP','724');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('LK','SRI LANKA','Sri Lanka','LKA','144');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SD','SUDAN','Sudan','SDN','736');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SR','SURINAME','Suriname','SUR','740');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SJ','SVALBARD AND JAN MAYEN','Svalbard and Jan Mayen','SJM','744');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SZ','SWAZILAND','Swaziland','SWZ','748');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SE','SWEDEN','Sweden','SWE','752');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CH','SWITZERLAND','Switzerland','CHE','756');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SY','SYRIAN ARAB REPUBLIC','Syrian Arab Republic','SYR','760');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TW','TAIWAN, PROVINCE OF CHINA','Taiwan, Province of China','TWN','158');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TJ','TAJIKISTAN','Tajikistan','TJK','762');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TZ','TANZANIA, UNITED REPUBLIC OF','Tanzania, United Republic of','TZA','834');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TH','THAILAND','Thailand','THA','764');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TL','TIMOR-LESTE','Timor-Leste','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TG','TOGO','Togo','TGO','768');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TK','TOKELAU','Tokelau','TKL','772');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TO','TONGA','Tonga','TON','776');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TT','TRINIDAD AND TOBAGO','Trinidad and Tobago','TTO','780');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TN','TUNISIA','Tunisia','TUN','788');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TR','TURKEY','Turkey','TUR','792');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TM','TURKMENISTAN','Turkmenistan','TKM','795');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TC','TURKS AND CAICOS ISLANDS','Turks and Caicos Islands','TCA','796');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TV','TUVALU','Tuvalu','TUV','798');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('UG','UGANDA','Uganda','UGA','800');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('UA','UKRAINE','Ukraine','UKR','804');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AE','UNITED ARAB EMIRATES','United Arab Emirates','ARE','784');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GB','UNITED KINGDOM','United Kingdom','GBR','826');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('US','UNITED STATES','United States','USA','840');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('UM','UNITED STATES MINOR OUTLYING ISLANDS','United States Minor Outlying Islands','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('UY','URUGUAY','Uruguay','URY','858');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('UZ','UZBEKISTAN','Uzbekistan','UZB','860');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('VU','VANUATU','Vanuatu','VUT','548');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('VE','VENEZUELA','Venezuela','VEN','862');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('VN','VIET NAM','Viet Nam','VNM','704');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('VG','VIRGIN ISLANDS, BRITISH','Virgin Islands, British','VGB','092');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('VI','VIRGIN ISLANDS, U.S.','Virgin Islands, U.s.','VIR','850');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('WF','WALLIS AND FUTUNA','Wallis and Futuna','WLF','876');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('EH','WESTERN SAHARA','Western Sahara','ESH','732');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('YE','YEMEN','Yemen','YEM','887');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('ZM','ZAMBIA','Zambia','ZMB','894');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('ZW','ZIMBABWE','Zimbabwe','ZWE','716');
Posted by at No comments:

Wednesday, November 7, 2012

How to put the pointer at the last character in text box


   $(function() {
$.fn.selectRange = function(start, end) {
return this.each(function() {
var self = this;
if (self.setSelectionRange) {
self.focus();
self.setSelectionRange(start, end);
} else if (self.createTextRange) {
var range = self.createTextRange();
range.collapse(true);
range.moveEnd('character', end);
range.moveStart('character', start);
range.select();
}
});
};
var slen = $('#loginEmail').val().length;

$('#loginEmail').selectRange(slen, slen+1);
    });
Posted by at No comments:

Sunday, September 30, 2012

Ceating Page Cache 


<?php
/**
* @Author: Rbernal
* @ 11-13-09
* @ page caching
*/

class PageCache{
    
    /**
     * @ path where we save or cache files
     */
    private $cache_path;
    
    /**
     * @ page information basename and the dir
     */
    private $page_info;
    
    /**
     * @ file content to be saved on a as cache files
     */
    private $page_content;
    
    
    /**
     * @ file content to be saved on a as cache files
     */
    public $use_cache = true;
    
    
    /**
     * @ constructor
     */
    public function __construct( $base_path = '/' )
    {
        $this->cache_path = $base_path;
        $this->getPageInfo();
        $this->createDirectory();
    }
    
    
    /**
     * @ set page information
     */
    private function getPageInfo()
    {   
        $this-> page_info = pathinfo( $_SERVER['REQUEST_URI'] );
        $this-> page_info['dirname'] = substr($this-> page_info['dirname'],1).'/';
    }
    
    
    /**
     * @ create directory if Directory does not exist
     */
    private function createDirectory()
    {
        $this->cache_path = $this->cache_path.$this-> page_info['dirname'];
        if( !file_exists($this->cache_path)  ){  
            mkdir($this->cache_path, 0777, true);
        }
        
    }
    
    
    /**
     * @start reading the page for caching
     */
    public function startCache()
    {
        ob_start();
    }
    
    
    /**
     * @limit the output buffer and save
     */
    public function endCache()
    {
        $this->page_content = ob_get_contents();
        $this->saveCache();
    }
    
    
    /**
     * @remove output buffer
     */
    private function clean()
    {
        ob_clean();
    }
    
    
    /**
     * @save cache file if not exist
     */
    private function saveCache()
    {
        $file = $this->cache_path.md5($_SERVER['REQUEST_URI']);
        if( !file_exists($file) &&  $this -> use_cache )
        {  
             file_put_contents($file, $this->page_content);
        }
        
    }
    
}
?>
Posted by at No comments:

Tuesday, August 28, 2012

Format code snips for blog

To make keep the formatting of my code spinets that I just copied from my editor i use this tool 1. http://www.manoli.net/csharpformat/ It automatically convert your snippet into html friendly format
Posted by at No comments:

Calculate date and time diff in PHP 

public function  calculateDateDiff($date1,$date2)
    {
            $string_diff = array();
            $diff = abs(strtotime($date2) - strtotime($date1));
            $years   = floor($diff / (365*60*60*24));
            $months  = floor(($diff - $years * 365*60*60*24) / (30*60*60*24));
            $days    = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24)/ (60*60*24));
            $hours   = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24 - $days*60*60*24)/ (60*60));
            $minutes  = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24 - $days*60*60*24 - $hours*60*60)/ 60);
            $seconds = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24 - $days*60*60*24 - $hours*60*60 - $minutes*60));
            if($years >=1 ){
                $string_diff[]= $years.' Year'.(($years>1)?'s':'');
            }
            if($months >=1 ){
                $string_diff[]= $months.' Month'.(($months>1)?'s':'');
            }
            if($days >=1 ){
                $string_diff[]= $days.' Day'.(($days>1)?'s':'');
            }
            if($hours >=1 ){
                $string_diff[]= $hours.' Hour'.(($hours>1)?'s':'');
            }
            if($minutes >=1 ){
                $string_diff[]= $minutes.' Minute'.(($minutes>1)?'s':'');
            }
            return implode (',', $string_diff);
    }
Posted by at No comments:

Monday, August 27, 2012

SVN - Display modified files only and revert

To display only the  modified files we need to use svn st with grep:
svn st | grep 'M '

now to revert only all those modified, we can do this
svn st | grep ' M' | awk '{print $2}' | xargs svn revert

you can also use this to delete or move those file by simply changing the last  arguments


Posted by at No comments:

Wednesday, August 22, 2012

Find string in all included files in PHP

Some times when debugging we find some variables or string, but when tons of php code is included its big problem. Here's how I search string or variable in all included files.
$file_included = get_included_files();

foreach($file_included as $val) {
    if(preg_match('/YOUR STRING HERE/',file_get_contents($val))){  
       echo $val.'
';
    }
}
You simply need to include that on the footer of your page
Posted by at 2 comments:

Saturday, August 18, 2012

how to clean array values

one of the fastest way is to use array map ex. $a = array('a',' b','c '); $b = array_map('trim',$a); or you can create your own function and use that as first parameter when calling array map
Posted by at No comments:

Ronaldo Bernal

Hi, I'm Ronaldo Bernal a web developer for some time :). I'll be posting here some interesting code I've done. So hope you enjoy it
Posted by at No comments:
Subscribe to: Posts (Atom)