Friday, December 25, 2015

Gold iPhone 5 Deals - iPhone With A New Identity

Introducing “Bling” for your iPhone, iPad and Electronics: Did you ever wonder what would happen if King Midas and Apple got together, what the next iPhone might look like? Now you don’t have to wonder anymore. We’ve brought the decadence of pure gold plating upgrades to your iPhone, iPad, iMac or other electronics. This is not a plastic imitation, but the real thing. Pure GOLD. It’s a rare luxury and a unique service which will make you stand out from the crowd. All of our gold upgrades come with an exclusive lifetime guarantee.It makes for a great, gift too.

Simply fill out the on-line form here a and then pack up your iPhone, iPad, iMac or other item to be transformed into gold, and send us the package via DHL Courier. We’ll confirm your product has arrived safe and sound and within a few days time – we’ll begin the process of transforming your case into gold. Then we’ll pack it back up carefully and return it to your door. We have a few very rare offerings such as this 7-carat diamond studded 22-carat gold finish case. The edges of this are encrusted with the world’s finest VS1 diamonds and the case comes with a polished mirror finish on the back. Luxury Gifts and 24k Gold Plating Services.

This design is strictly limited to just 10 hand-crafted pieces which will make this the 10 most expensive and rarest iPhones in the Universe. If your name isn’t Donald Trump or Bill Gates, then this offer might intrigue you. The Elite Gold iPhone 5 case is less lavish as the iPhone Diamond Elite as this features 24-carat gold plate and no diamonds. Simply elegant, this genuine gold iPhone 5 case will dazzle and amaze your colleagues and friends. As with the Diamond Elite, this too is strictly limited and to just 50 units total.We realise that there are many BlackBerry addicts out there and we have a special Bling upgrade for you, too. Presented for your selection, we offer a “sport” model and a standard gold “bling” upgrade. BlackBerry Porsche Design P’9981:This features black and trims of gold, reminiscing a classic clean, Porsche inspired design. Forged in stainless steel, and plated in 24 ct gold – it is trimmed in black leather for the back. Strictly limited to just (10) units.

BlackBerry Bold 9900 24ct. Gold Edition: A simpler form of pure elegance, this model features the classic gold plate back and front for your BlackBerry. iPad Bling Models (complete iPads):This is the complete iPad, gold finish and all. It comes plated in the finest gold and the back is a polished mirror finish. Your friends will think you dug this up at King Tut’s tomb. The iPad features the ultra-sharp Retain display and a 5 megapixel iSight camera.We offer this in two models, (1) Platinum and (2) Gold.

For more information on Gold iPhone visit us and we help you to find Gold iPhone 5.

Sunday, November 29, 2015


As far as we know, webmasters can expect Google’s Penguin update to make a return before the year is over. It’s possible that this won’t be the case, but based on previous comments from Googlers, it should be.

The SEO and webmaster communities have been waiting for Google to launch a new Penguin refresh for a long time. Google has been promising a new version that will update in real time, so those impacted by it won’t have to wait for Google to push another one to have any hope of recovery. It will instead be constantly updating.

A couple months ago, Google’s John Mueller said he expected Penguin to be here before the end of the year. Google’s Gary Illyes said it was in the “foreseeable future” and that he “hoped” it would be here before the end of the year.

Late last month, Illyes talked about it a little on Twitter with curious parties, tweeting that the update was still not ready for primetime.

He did, however, indicate it was still on track for this year:

Illyes also indicated at the time that it was not too late for Penguin to acknowledge disavow files.

This week, Barry Schwartz at Search Engine Roundtable points to further comments from Illyes on Twitter confirming that the next Penguin will indeed update in real time, and will be an actual update to the algorithm as opposed to a data refresh. He calls it a “huge change”.

Assuming that the update does come before the end of the year, that gives us roughly five weeks, so it should be very soon, but it’s not a given.

It is worth noting (as he does) that Illyes does not actually work on Penguin, even if he’s the one giving the webmaster community the most information about it.

The update will be quite welcome to webmasters waiting for a chance to recover from previous iterations of Penguin, but even more significantly, those impacted by the algorithm in the future won’t have to wait so long to see the fruits of any potential recovery efforts. At least in theory.

Tuesday, November 24, 2015

Why Google Is Hiring an SEO Expert to Do Better in Google Rankings?

Search Engine Optimisation (SEO) has become one of the accepted facts of life when talking about any online business - even if you've got great content and a strong social media presence, nobody can do without the huge waves of 'organic' traffic that comes to us via Google's search engine. Apparently that's the case even when you're Google itself. A fairly innocuous jobs posting on Google's Careers page actually tells us about something important that's happening inside Google's Mountain View office.

The company is hiring a Program Manager, Search Engine Optimisation, and the post notes that Google is looking for someone to "advise, collaborate with, and synthesise feedback from Marketing, Product and Engineering", and to "push for technical SEO best practices." It further states that the employee would need to "keep pace with SEO, search engine and Internet marketing industry trends and developments, and report changes as needed."

There's a sense of absurdity to these statements, since most people in the industry will agree that SEO is driven by, and is a reaction to, Google. The developments in this industry come about when Google makes some change that breaks every site's SEO, and forces them to rethink how they're presenting their content so as to do well at Google's altar.

As the man on the inside, the person that Google hires wouldn't have to keep pace with SEO; but rather would need to know which team was the correct one to sit down and take notes from. Google notes in its post that this employee will have to help drive organic traffic and business growth.

As a Program Manager for Technical SEO, you will work with cross-functional teams across Marketing, Sales, Product Development, Engineering and more to help drive organic traffic and business growth. You will take part in website development and optimization, help shape blog and social strategy, improve website code hygiene and define Web architecture for international websites.

That's particularly interesting, because it means that Google wants the various content based properties that it owns to show up more prominently in search. But Google's Instant Answers feature takes away the need for this - even without bringing into question the authenticity of search results, Google can use this space to display a card from any of its own websites. So, why the sudden interest in bringing 'organic' traffic to its own websites?

There are a couple of possibilities. The first is that Google fears that its search engine will grow less and less important over time - and therefore wants someone who can also help it to optimise to show a good result on sites like Bing. A second - and more likely - possibility is that Google is facing pressure to show that it is not tampering with search results, and favouring its own properties.

Google is facing antitrust charges in the European Union, where companies including Expedia, Yelp, and British price comparison website Foundem say that Google has abused its market power and distorted Web results to favour its own shopping service. The hiring of an SEO manager is a signal that Google will not artificially boost the rankings of its own sites, and regardless of how true it is, will act like a signal flag that promises that the search ranking remains 'honest' with this change.

It's also interesting in that it shows us all that Google is also ready to play the SEO-game and boost its rankings that way. Many people see SEO as a race against Google - as people get better at "gaming" the search giant's results, Google changes the rules of the game starting things over from scratch. Hiring its own SEO executives marks a significant change in this sense.

While hiring an SEO expert India is unlikely to make a difference in any on-going cases, it could well be a hedge against the future, as Google's sites could be optimised to perfection, to ensure that they fare well in any organic search results. Of course, critics could claim that Google's SEO managers will have insider information that makes the exercise moot, so it will be interesting to see how things play out.

Tuesday, September 22, 2015

How to hide/show an element using jQuery

Change the display values onclick open & close button using JavaScript in PHP:-

<script src="js/jquery-1.7.1.min.js"></script>
<script type="text/javascript">
function chngsttsclose()
function chngsttsopen()

    font-size: 1em;
    color: transparent; /* Fix for Firefox */
    border-style: none;
    border-width: 0;
    padding: 0 0 0 16px !important; /* Fix for Internet Explorer */
    text-align: left;
    width: 25px;
    height: 20px;
    line-height: 1 !important;
    overflow: hidden;
    cursor: pointer;

<input type="submit" class='iconButton' style='background:url(images/open.png) no-repeat' id="open" onclick="chngsttsclose(this.value)" name="packstus" />
<input type="submit" class='iconButton' style='background:url(images/close.png) no-repeat; display:none;' id="close" onclick="chngsttsopen(this.value)" name="packstus" />

How to add Delete button confirmation?

Here is the code:-

<form name="abc" action="test.php" method="post">
<input name="Cancel_Booking" onclick="return confirm('Are You Sure?');" value="Cancel Booking" style="background:transparent; color:#0066FF; border:none; cursor:pointer; font-size:14px; font-weight:bold;font-family:font-weight:bold;font-family:Cambria, 'Hoefler Text', 'Liberation Serif', Times, 'Times New Roman', serif" type="submit" />

Tuesday, August 18, 2015

How to Convert a String into Array in PHP?

  • str_split — Convert a string to an array


                 $pid = str_split($arrpid);
                 $pack_id = count($pid);
  • chunk_split() - Split a string into smaller chunks
  • preg_split() - Split string by a regular expression
  • explode() - Split a string by string
  • count_chars() - Return information about characters used in a string
  • str_word_count() - Return information about words used in a string

How to Convert a String into Array & count the size using PHP functions?

Friday, August 14, 2015

How to check a dates of a date range lies in between two dates in PHP & mysql query?

I have a date range like
date from=2011-10-14 & date to=2011-10-20
if I have another date ranges
- 2011-10-11 - 2011-10-15
- 2011-10-11 - 2011-10-21
- 2011-10-15 - 2011-10-21
- 2011-10-15 - 2011-10-19
- 2011-10-21 - 2011-10-26
date_from < ‘2011-10-20’ AND date_to > '2011-10-14’
WHERE date_from >= '2011-10-14’ AND date_to <= '2011-10-20’

How to Return all dates between two dates in an array?

Expected Input:
getDatesFromRange( ‘2010-10-01’, '2010-10-05’ );
Expected Output:
Array( '2010-10-01’, '2010-10-02’, '2010-10-03’, '2010-10-04’, '2010-10-05’ )
function createDateRangeArray($strDateFrom,$strDateTo)
   // takes two dates formatted as YYYY-MM-DD and creates an
   // inclusive array of the dates between the from and to dates.
   // could test validity of dates here but I’m already doing
   // that in the main script
   $iDateFrom=mktime(1,0,0,substr($strDateFrom,5,2),     substr($strDateFrom,8,2),substr($strDateFrom,0,4));
   $iDateTo=mktime(1,0,0,substr($strDateTo,5,2),     substr($strDateTo,8,2),substr($strDateTo,0,4));
   if ($iDateTo>=$iDateFrom)
       array_push($aryRange,date('Y-m-d’,$iDateFrom)); // first entry
       while ($iDateFrom<$iDateTo)
           $iDateFrom+=86400; // add 24 hours
   return $aryRange;

How to Display MySQL Dates in Other Formats using PHP?

How to insert and show dates in different format?
public function input_date($date)
$c_date = explode(“/”,$date);
$form_date = $c_date[2].’-’.$c_date[1].’-’.$c_date[0];

public function show_date($date)
$c_date = explode(“-”,$date);
$form_date = $c_date[2].’/’.$c_date[1].’/’.$c_date[0];
MySQL stores dates in the format YYYY-MM-DD… which is great, it’s consistent and easy to understand—If you happen to be a computer. Unfortunately, this format is rather confusing for humans, especially for humans which may be trying to communicate with individuals who read dates differently. For example, those of us in the US usually record the 10th of May in the year 2015 as 05/10/2015 whereas individuals in other countries often record the same date as 10/05/2015, causing considerable confusion in communication.
So what do we do to solve this? When in doubt, write it out! Here’s how to take a date retrieved from a MySQL database by PHP and convert it to an international human-friendly format.
We’ll first assume that you have retrieved your data into array $myrow. Say the date stored in MySQL is 2015-08-04. Here’s how to display it in various forms. Precede each of these by echo or print, whichever is appropriate for your application. All of these can be modified as needed by using the various formatting characters as described in the PHP.
Desired Text & their relevant Code:-
August 04, 2015
date("F d, Y",strtotime($myrow['date']));

Tuesday, August 04, 2015
date("l, F d, Y",strtotime($myrow['date']));

Aug 04, 2015
date("M d, Y",strtotime($myrow['date']));

04 August 2015
date("d F Y",strtotime($myrow['date']));

04 Aug 2015
date("d M Y",strtotime($myrow['date']));

Tue, 04 Aug 2015
date("D, d M Y",strtotime($myrow['date']));

Tuesday, the 4th of August, 2015
date("l",strtotime($myrow['date'])) . ", the " . date("jS",strtotime($myrow['date'])) . " of " . date("F, Y",strtotime($myrow['date']));

How to find the difference between two dates using php?

Here’s the code snippet to find the difference between two dates:-
$date1 = “2009-01-01 00:00:00”;
$date2 = “2010-03-21 14:34:09”;
$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));
echo $years.“ years, ”.$months.“ months, ”.$days.“ days, ”.$hours.“ hours, ”.$minutes.“ minutes, ”.$seconds.“ seconds”;

PHP - String function explanation

All String Functions in PHP:-
  1. str_replace: How to replace a part of a string with another string
  2. str_ireplace: Case in-sensitive search and replace using array of strings
  3. strlen: How to find length of a string in PHP?
  4. trim: Removing empty space from both sides of a string
  5. strrev: Reversing a string by using strrev function in PHP
  6. Adding two or more strings in PHP
  7. stristr: Searching for a presence of a string inside another string
  8. nl2br: Adding Line breaks inside a string in place of carriage returns
  9. split: Breaking a string to form array using delimiters
  10. substr: Collecting part of a string
  11. substr_count: Counting occurrence of sub string in main string
  12. str_repeat: Repeating a string number of times
  13. strtolower(): function to change alphabets to Lower case
  14. strtoupper(): function to change characters to upper case letters
  15. function to collect part of a string with two landmarks
  16. Random string generator with number and alphabets for password
  17. strcasecmp(): Case insensitive string comparison
  18. strcmp(): Case sensitive string comparison
  19. str_pad(): String pad with specified length
  20. md5 hash of a string: encryption of a string
  21. Separating domain and userid part from an email address using split
  22. htmlspecialchars: Printing html special chars to the page
  23. strip_tags: Removing html tags within a string
  24. ucwords: Converting first letter of every word to UpperCase

MySQL Table of all Countries

The below-linked MySQL script contains the ISO2, ISO3, ISO numerical codes, calling codes, and ccTLDs, as well as the short and long names for the countries shown below. I have endeavored to list all of the countries in the world, but I know I've missed some—any additions or corrections would be welcome! The zip file contains all of the flags shown below.

Note: The short names use only the letters found on a standard US QWERTY keyboard, while the long names use the HTML entities. the ISO codes and UN membership information is accurate as of April 2012. If you are aware of any changes to this data, any changes to the flags, or any errors, please let me know.

April 2012 update: I added ccTLD codes for every country that has them, updated several country names, renumbered some of the country_id OIDs (So if you are already using an earlier version of my country table on your website, do NOT just replace your existing data or you will mess it up!! New users won't have a problem.), eliminated at least one country that no longer exists (Netherlands Antilles), added another country that sort of exists (Kosovo), updated the flag images, and added more calling codes and corrected others. Finally, I also created an add-on script to add country names in Spanish to the script, for those that may need them (it's not part of the main script, click on the link to get the script you need to add them). All data is accurate as of 7 April 2012, as far as I can determine.

January 2012 update: I added calling codes for as many countries as I was able to find. One, Heard Island and McDonald Islands, has no calling code as apparently there are no landline phones there. Data represented by a question mark is included in the table as "NULL" and indicates that I am unaware of whether that data exists, and if it does, what it is. 

-- Table structure for table `country_t`

  `country_id` int(5) NOT NULL AUTO_INCREMENT,
  `iso2` char(2) DEFAULT NULL,
  `short_name` varchar(80) NOT NULL DEFAULT '',
  `long_name` varchar(80) NOT NULL DEFAULT '',
  `iso3` char(3) DEFAULT NULL,
  `numcode` varchar(6) DEFAULT NULL,
  `un_member` varchar(12) DEFAULT NULL,
  `calling_code` varchar(8) DEFAULT NULL,
  `cctld` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`country_id`)

-- Dumping data for table `country_t`

INSERT INTO `country_t` (`country_id`, `iso2`, `short_name`, `long_name`, `iso3`, `numcode`, `un_member`, `calling_code`, `cctld`) VALUES
(1, 'AF', 'Afghanistan', 'Islamic Republic of Afghanistan', 'AFG', '004', 'yes', '93', '.af'),
(2, 'AX', 'Aland Islands', '&Aring;land Islands', 'ALA', '248', 'no', '358', '.ax'),
(3, 'AL', 'Albania', 'Republic of Albania', 'ALB', '008', 'yes', '355', '.al'),
(4, 'DZ', 'Algeria', 'People''s Democratic Republic of Algeria', 'DZA', '012', 'yes', '213', '.dz'),
(5, 'AS', 'American Samoa', 'American Samoa', 'ASM', '016', 'no', '1+684', '.as'),
(6, 'AD', 'Andorra', 'Principality of Andorra', 'AND', '020', 'yes', '376', '.ad'),
(7, 'AO', 'Angola', 'Republic of Angola', 'AGO', '024', 'yes', '244', '.ao'),
(8, 'AI', 'Anguilla', 'Anguilla', 'AIA', '660', 'no', '1+264', '.ai'),
(9, 'AQ', 'Antarctica', 'Antarctica', 'ATA', '010', 'no', '672', '.aq'),
(10, 'AG', 'Antigua and Barbuda', 'Antigua and Barbuda', 'ATG', '028', 'yes', '1+268', '.ag'),
(11, 'AR', 'Argentina', 'Argentine Republic', 'ARG', '032', 'yes', '54', '.ar'),
(12, 'AM', 'Armenia', 'Republic of Armenia', 'ARM', '051', 'yes', '374', '.am'),
(13, 'AW', 'Aruba', 'Aruba', 'ABW', '533', 'no', '297', '.aw'),
(14, 'AU', 'Australia', 'Commonwealth of Australia', 'AUS', '036', 'yes', '61', '.au'),
(15, 'AT', 'Austria', 'Republic of Austria', 'AUT', '040', 'yes', '43', '.at'),
(16, 'AZ', 'Azerbaijan', 'Republic of Azerbaijan', 'AZE', '031', 'yes', '994', '.az'),
(17, 'BS', 'Bahamas', 'Commonwealth of The Bahamas', 'BHS', '044', 'yes', '1+242', '.bs'),
(18, 'BH', 'Bahrain', 'Kingdom of Bahrain', 'BHR', '048', 'yes', '973', '.bh'),
(19, 'BD', 'Bangladesh', 'People''s Republic of Bangladesh', 'BGD', '050', 'yes', '880', '.bd'),
(20, 'BB', 'Barbados', 'Barbados', 'BRB', '052', 'yes', '1+246', '.bb'),
(21, 'BY', 'Belarus', 'Republic of Belarus', 'BLR', '112', 'yes', '375', '.by'),
(22, 'BE', 'Belgium', 'Kingdom of Belgium', 'BEL', '056', 'yes', '32', '.be'),
(23, 'BZ', 'Belize', 'Belize', 'BLZ', '084', 'yes', '501', '.bz'),
(24, 'BJ', 'Benin', 'Republic of Benin', 'BEN', '204', 'yes', '229', '.bj'),
(25, 'BM', 'Bermuda', 'Bermuda Islands', 'BMU', '060', 'no', '1+441', '.bm'),
(26, 'BT', 'Bhutan', 'Kingdom of Bhutan', 'BTN', '064', 'yes', '975', '.bt'),
(27, 'BO', 'Bolivia', 'Plurinational State of Bolivia', 'BOL', '068', 'yes', '591', '.bo'),
(28, 'BQ', 'Bonaire, Sint Eustatius and Saba', 'Bonaire, Sint Eustatius and Saba', 'BES', '535', 'no', '599', '.bq'),
(29, 'BA', 'Bosnia and Herzegovina', 'Bosnia and Herzegovina', 'BIH', '070', 'yes', '387', '.ba'),
(30, 'BW', 'Botswana', 'Republic of Botswana', 'BWA', '072', 'yes', '267', '.bw'),
(31, 'BV', 'Bouvet Island', 'Bouvet Island', 'BVT', '074', 'no', 'NONE', '.bv'),
(32, 'BR', 'Brazil', 'Federative Republic of Brazil', 'BRA', '076', 'yes', '55', '.br'),
(33, 'IO', 'British Indian Ocean Territory', 'British Indian Ocean Territory', 'IOT', '086', 'no', '246', '.io'),
(34, 'BN', 'Brunei', 'Brunei Darussalam', 'BRN', '096', 'yes', '673', '.bn'),
(35, 'BG', 'Bulgaria', 'Republic of Bulgaria', 'BGR', '100', 'yes', '359', '.bg'),
(36, 'BF', 'Burkina Faso', 'Burkina Faso', 'BFA', '854', 'yes', '226', '.bf'),
(37, 'BI', 'Burundi', 'Republic of Burundi', 'BDI', '108', 'yes', '257', '.bi'),
(38, 'KH', 'Cambodia', 'Kingdom of Cambodia', 'KHM', '116', 'yes', '855', '.kh'),
(39, 'CM', 'Cameroon', 'Republic of Cameroon', 'CMR', '120', 'yes', '237', '.cm'),
(40, 'CA', 'Canada', 'Canada', 'CAN', '124', 'yes', '1', '.ca'),
(41, 'CV', 'Cape Verde', 'Republic of Cape Verde', 'CPV', '132', 'yes', '238', '.cv'),
(42, 'KY', 'Cayman Islands', 'The Cayman Islands', 'CYM', '136', 'no', '1+345', '.ky'),
(43, 'CF', 'Central African Republic', 'Central African Republic', 'CAF', '140', 'yes', '236', '.cf'),
(44, 'TD', 'Chad', 'Republic of Chad', 'TCD', '148', 'yes', '235', '.td'),
(45, 'CL', 'Chile', 'Republic of Chile', 'CHL', '152', 'yes', '56', '.cl'),
(46, 'CN', 'China', 'People''s Republic of China', 'CHN', '156', 'yes', '86', '.cn'),
(47, 'CX', 'Christmas Island', 'Christmas Island', 'CXR', '162', 'no', '61', '.cx'),
(48, 'CC', 'Cocos (Keeling) Islands', 'Cocos (Keeling) Islands', 'CCK', '166', 'no', '61', '.cc'),
(49, 'CO', 'Colombia', 'Republic of Colombia', 'COL', '170', 'yes', '57', '.co'),
(50, 'KM', 'Comoros', 'Union of the Comoros', 'COM', '174', 'yes', '269', '.km'),
(51, 'CG', 'Congo', 'Republic of the Congo', 'COG', '178', 'yes', '242', '.cg'),
(52, 'CK', 'Cook Islands', 'Cook Islands', 'COK', '184', 'some', '682', '.ck'),
(53, 'CR', 'Costa Rica', 'Republic of Costa Rica', 'CRI', '188', 'yes', '506', '.cr'),
(54, 'CI', 'Cote d''ivoire (Ivory Coast)', 'Republic of C&ocirc;te D''Ivoire (Ivory Coast)', 'CIV', '384', 'yes', '225', '.ci'),
(55, 'HR', 'Croatia', 'Republic of Croatia', 'HRV', '191', 'yes', '385', '.hr'),
(56, 'CU', 'Cuba', 'Republic of Cuba', 'CUB', '192', 'yes', '53', '.cu'),
(57, 'CW', 'Curacao', 'Cura&ccedil;ao', 'CUW', '531', 'no', '599', '.cw'),
(58, 'CY', 'Cyprus', 'Republic of Cyprus', 'CYP', '196', 'yes', '357', '.cy'),
(59, 'CZ', 'Czech Republic', 'Czech Republic', 'CZE', '203', 'yes', '420', '.cz'),
(60, 'CD', 'Democratic Republic of the Congo', 'Democratic Republic of the Congo', 'COD', '180', 'yes', '243', '.cd'),
(61, 'DK', 'Denmark', 'Kingdom of Denmark', 'DNK', '208', 'yes', '45', '.dk'),
(62, 'DJ', 'Djibouti', 'Republic of Djibouti', 'DJI', '262', 'yes', '253', '.dj'),
(63, 'DM', 'Dominica', 'Commonwealth of Dominica', 'DMA', '212', 'yes', '1+767', '.dm'),
(64, 'DO', 'Dominican Republic', 'Dominican Republic', 'DOM', '214', 'yes', '1+809, 8', '.do'),
(65, 'EC', 'Ecuador', 'Republic of Ecuador', 'ECU', '218', 'yes', '593', '.ec'),
(66, 'EG', 'Egypt', 'Arab Republic of Egypt', 'EGY', '818', 'yes', '20', '.eg'),
(67, 'SV', 'El Salvador', 'Republic of El Salvador', 'SLV', '222', 'yes', '503', '.sv'),
(68, 'GQ', 'Equatorial Guinea', 'Republic of Equatorial Guinea', 'GNQ', '226', 'yes', '240', '.gq'),
(69, 'ER', 'Eritrea', 'State of Eritrea', 'ERI', '232', 'yes', '291', '.er'),
(70, 'EE', 'Estonia', 'Republic of Estonia', 'EST', '233', 'yes', '372', '.ee'),
(71, 'ET', 'Ethiopia', 'Federal Democratic Republic of Ethiopia', 'ETH', '231', 'yes', '251', '.et'),
(72, 'FK', 'Falkland Islands (Malvinas)', 'The Falkland Islands (Malvinas)', 'FLK', '238', 'no', '500', '.fk'),
(73, 'FO', 'Faroe Islands', 'The Faroe Islands', 'FRO', '234', 'no', '298', '.fo'),
(74, 'FJ', 'Fiji', 'Republic of Fiji', 'FJI', '242', 'yes', '679', '.fj'),
(75, 'FI', 'Finland', 'Republic of Finland', 'FIN', '246', 'yes', '358', '.fi'),
(76, 'FR', 'France', 'French Republic', 'FRA', '250', 'yes', '33', '.fr'),
(77, 'GF', 'French Guiana', 'French Guiana', 'GUF', '254', 'no', '594', '.gf'),
(78, 'PF', 'French Polynesia', 'French Polynesia', 'PYF', '258', 'no', '689', '.pf'),
(79, 'TF', 'French Southern Territories', 'French Southern Territories', 'ATF', '260', 'no', NULL, '.tf'),
(80, 'GA', 'Gabon', 'Gabonese Republic', 'GAB', '266', 'yes', '241', '.ga'),
(81, 'GM', 'Gambia', 'Republic of The Gambia', 'GMB', '270', 'yes', '220', '.gm'),
(82, 'GE', 'Georgia', 'Georgia', 'GEO', '268', 'yes', '995', '.ge'),
(83, 'DE', 'Germany', 'Federal Republic of Germany', 'DEU', '276', 'yes', '49', '.de'),
(84, 'GH', 'Ghana', 'Republic of Ghana', 'GHA', '288', 'yes', '233', '.gh'),
(85, 'GI', 'Gibraltar', 'Gibraltar', 'GIB', '292', 'no', '350', '.gi'),
(86, 'GR', 'Greece', 'Hellenic Republic', 'GRC', '300', 'yes', '30', '.gr'),
(87, 'GL', 'Greenland', 'Greenland', 'GRL', '304', 'no', '299', '.gl'),
(88, 'GD', 'Grenada', 'Grenada', 'GRD', '308', 'yes', '1+473', '.gd'),
(89, 'GP', 'Guadaloupe', 'Guadeloupe', 'GLP', '312', 'no', '590', '.gp'),
(90, 'GU', 'Guam', 'Guam', 'GUM', '316', 'no', '1+671', '.gu'),
(91, 'GT', 'Guatemala', 'Republic of Guatemala', 'GTM', '320', 'yes', '502', '.gt'),
(92, 'GG', 'Guernsey', 'Guernsey', 'GGY', '831', 'no', '44', '.gg'),
(93, 'GN', 'Guinea', 'Republic of Guinea', 'GIN', '324', 'yes', '224', '.gn'),
(94, 'GW', 'Guinea-Bissau', 'Republic of Guinea-Bissau', 'GNB', '624', 'yes', '245', '.gw'),
(95, 'GY', 'Guyana', 'Co-operative Republic of Guyana', 'GUY', '328', 'yes', '592', '.gy'),
(96, 'HT', 'Haiti', 'Republic of Haiti', 'HTI', '332', 'yes', '509', '.ht'),
(97, 'HM', 'Heard Island and McDonald Islands', 'Heard Island and McDonald Islands', 'HMD', '334', 'no', 'NONE', '.hm'),
(98, 'HN', 'Honduras', 'Republic of Honduras', 'HND', '340', 'yes', '504', '.hn'),
(99, 'HK', 'Hong Kong', 'Hong Kong', 'HKG', '344', 'no', '852', '.hk'),
(100, 'HU', 'Hungary', 'Hungary', 'HUN', '348', 'yes', '36', '.hu'),
(101, 'IS', 'Iceland', 'Republic of Iceland', 'ISL', '352', 'yes', '354', '.is'),
(102, 'IN', 'India', 'Republic of India', 'IND', '356', 'yes', '91', '.in'),
(103, 'ID', 'Indonesia', 'Republic of Indonesia', 'IDN', '360', 'yes', '62', '.id'),
(104, 'IR', 'Iran', 'Islamic Republic of Iran', 'IRN', '364', 'yes', '98', '.ir'),
(105, 'IQ', 'Iraq', 'Republic of Iraq', 'IRQ', '368', 'yes', '964', '.iq'),
(106, 'IE', 'Ireland', 'Ireland', 'IRL', '372', 'yes', '353', '.ie'),
(107, 'IM', 'Isle of Man', 'Isle of Man', 'IMN', '833', 'no', '44', '.im'),
(108, 'IL', 'Israel', 'State of Israel', 'ISR', '376', 'yes', '972', '.il'),
(109, 'IT', 'Italy', 'Italian Republic', 'ITA', '380', 'yes', '39', '.jm'),
(110, 'JM', 'Jamaica', 'Jamaica', 'JAM', '388', 'yes', '1+876', '.jm'),
(111, 'JP', 'Japan', 'Japan', 'JPN', '392', 'yes', '81', '.jp'),
(112, 'JE', 'Jersey', 'The Bailiwick of Jersey', 'JEY', '832', 'no', '44', '.je'),
(113, 'JO', 'Jordan', 'Hashemite Kingdom of Jordan', 'JOR', '400', 'yes', '962', '.jo'),
(114, 'KZ', 'Kazakhstan', 'Republic of Kazakhstan', 'KAZ', '398', 'yes', '7', '.kz'),
(115, 'KE', 'Kenya', 'Republic of Kenya', 'KEN', '404', 'yes', '254', '.ke'),
(116, 'KI', 'Kiribati', 'Republic of Kiribati', 'KIR', '296', 'yes', '686', '.ki'),
(117, 'XK', 'Kosovo', 'Republic of Kosovo', '---', '---', 'some', '381', ''),
(118, 'KW', 'Kuwait', 'State of Kuwait', 'KWT', '414', 'yes', '965', '.kw'),
(119, 'KG', 'Kyrgyzstan', 'Kyrgyz Republic', 'KGZ', '417', 'yes', '996', '.kg'),
(120, 'LA', 'Laos', 'Lao People''s Democratic Republic', 'LAO', '418', 'yes', '856', '.la'),
(121, 'LV', 'Latvia', 'Republic of Latvia', 'LVA', '428', 'yes', '371', '.lv'),
(122, 'LB', 'Lebanon', 'Republic of Lebanon', 'LBN', '422', 'yes', '961', '.lb'),
(123, 'LS', 'Lesotho', 'Kingdom of Lesotho', 'LSO', '426', 'yes', '266', '.ls'),
(124, 'LR', 'Liberia', 'Republic of Liberia', 'LBR', '430', 'yes', '231', '.lr'),
(125, 'LY', 'Libya', 'Libya', 'LBY', '434', 'yes', '218', '.ly'),
(126, 'LI', 'Liechtenstein', 'Principality of Liechtenstein', 'LIE', '438', 'yes', '423', '.li'),
(127, 'LT', 'Lithuania', 'Republic of Lithuania', 'LTU', '440', 'yes', '370', '.lt'),
(128, 'LU', 'Luxembourg', 'Grand Duchy of Luxembourg', 'LUX', '442', 'yes', '352', '.lu'),
(129, 'MO', 'Macao', 'The Macao Special Administrative Region', 'MAC', '446', 'no', '853', '.mo'),
(130, 'MK', 'Macedonia', 'The Former Yugoslav Republic of Macedonia', 'MKD', '807', 'yes', '389', '.mk'),
(131, 'MG', 'Madagascar', 'Republic of Madagascar', 'MDG', '450', 'yes', '261', '.mg'),
(132, 'MW', 'Malawi', 'Republic of Malawi', 'MWI', '454', 'yes', '265', '.mw'),
(133, 'MY', 'Malaysia', 'Malaysia', 'MYS', '458', 'yes', '60', '.my'),
(134, 'MV', 'Maldives', 'Republic of Maldives', 'MDV', '462', 'yes', '960', '.mv'),
(135, 'ML', 'Mali', 'Republic of Mali', 'MLI', '466', 'yes', '223', '.ml'),
(136, 'MT', 'Malta', 'Republic of Malta', 'MLT', '470', 'yes', '356', '.mt'),
(137, 'MH', 'Marshall Islands', 'Republic of the Marshall Islands', 'MHL', '584', 'yes', '692', '.mh'),
(138, 'MQ', 'Martinique', 'Martinique', 'MTQ', '474', 'no', '596', '.mq'),
(139, 'MR', 'Mauritania', 'Islamic Republic of Mauritania', 'MRT', '478', 'yes', '222', '.mr'),
(140, 'MU', 'Mauritius', 'Republic of Mauritius', 'MUS', '480', 'yes', '230', '.mu'),
(141, 'YT', 'Mayotte', 'Mayotte', 'MYT', '175', 'no', '262', '.yt'),
(142, 'MX', 'Mexico', 'United Mexican States', 'MEX', '484', 'yes', '52', '.mx'),
(143, 'FM', 'Micronesia', 'Federated States of Micronesia', 'FSM', '583', 'yes', '691', '.fm'),
(144, 'MD', 'Moldava', 'Republic of Moldova', 'MDA', '498', 'yes', '373', '.md'),
(145, 'MC', 'Monaco', 'Principality of Monaco', 'MCO', '492', 'yes', '377', '.mc'),
(146, 'MN', 'Mongolia', 'Mongolia', 'MNG', '496', 'yes', '976', '.mn'),
(147, 'ME', 'Montenegro', 'Montenegro', 'MNE', '499', 'yes', '382', '.me'),
(148, 'MS', 'Montserrat', 'Montserrat', 'MSR', '500', 'no', '1+664', '.ms'),
(149, 'MA', 'Morocco', 'Kingdom of Morocco', 'MAR', '504', 'yes', '212', '.ma'),
(150, 'MZ', 'Mozambique', 'Republic of Mozambique', 'MOZ', '508', 'yes', '258', '.mz'),
(151, 'MM', 'Myanmar (Burma)', 'Republic of the Union of Myanmar', 'MMR', '104', 'yes', '95', '.mm'),
(152, 'NA', 'Namibia', 'Republic of Namibia', 'NAM', '516', 'yes', '264', '.na'),
(153, 'NR', 'Nauru', 'Republic of Nauru', 'NRU', '520', 'yes', '674', '.nr'),
(154, 'NP', 'Nepal', 'Federal Democratic Republic of Nepal', 'NPL', '524', 'yes', '977', '.np'),
(155, 'NL', 'Netherlands', 'Kingdom of the Netherlands', 'NLD', '528', 'yes', '31', '.nl'),
(156, 'NC', 'New Caledonia', 'New Caledonia', 'NCL', '540', 'no', '687', '.nc'),
(157, 'NZ', 'New Zealand', 'New Zealand', 'NZL', '554', 'yes', '64', '.nz'),
(158, 'NI', 'Nicaragua', 'Republic of Nicaragua', 'NIC', '558', 'yes', '505', '.ni'),
(159, 'NE', 'Niger', 'Republic of Niger', 'NER', '562', 'yes', '227', '.ne'),
(160, 'NG', 'Nigeria', 'Federal Republic of Nigeria', 'NGA', '566', 'yes', '234', '.ng'),
(161, 'NU', 'Niue', 'Niue', 'NIU', '570', 'some', '683', '.nu'),
(162, 'NF', 'Norfolk Island', 'Norfolk Island', 'NFK', '574', 'no', '672', '.nf'),
(163, 'KP', 'North Korea', 'Democratic People''s Republic of Korea', 'PRK', '408', 'yes', '850', '.kp'),
(164, 'MP', 'Northern Mariana Islands', 'Northern Mariana Islands', 'MNP', '580', 'no', '1+670', '.mp'),
(165, 'NO', 'Norway', 'Kingdom of Norway', 'NOR', '578', 'yes', '47', '.no'),
(166, 'OM', 'Oman', 'Sultanate of Oman', 'OMN', '512', 'yes', '968', '.om'),
(167, 'PK', 'Pakistan', 'Islamic Republic of Pakistan', 'PAK', '586', 'yes', '92', '.pk'),
(168, 'PW', 'Palau', 'Republic of Palau', 'PLW', '585', 'yes', '680', '.pw'),
(169, 'PS', 'Palestine', 'State of Palestine (or Occupied Palestinian Territory)', 'PSE', '275', 'some', '970', '.ps'),
(170, 'PA', 'Panama', 'Republic of Panama', 'PAN', '591', 'yes', '507', '.pa'),
(171, 'PG', 'Papua New Guinea', 'Independent State of Papua New Guinea', 'PNG', '598', 'yes', '675', '.pg'),
(172, 'PY', 'Paraguay', 'Republic of Paraguay', 'PRY', '600', 'yes', '595', '.py'),
(173, 'PE', 'Peru', 'Republic of Peru', 'PER', '604', 'yes', '51', '.pe'),
(174, 'PH', 'Phillipines', 'Republic of the Philippines', 'PHL', '608', 'yes', '63', '.ph'),
(175, 'PN', 'Pitcairn', 'Pitcairn', 'PCN', '612', 'no', 'NONE', '.pn'),
(176, 'PL', 'Poland', 'Republic of Poland', 'POL', '616', 'yes', '48', '.pl'),
(177, 'PT', 'Portugal', 'Portuguese Republic', 'PRT', '620', 'yes', '351', '.pt'),
(178, 'PR', 'Puerto Rico', 'Commonwealth of Puerto Rico', 'PRI', '630', 'no', '1+939', '.pr'),
(179, 'QA', 'Qatar', 'State of Qatar', 'QAT', '634', 'yes', '974', '.qa'),
(180, 'RE', 'Reunion', 'R&eacute;union', 'REU', '638', 'no', '262', '.re'),
(181, 'RO', 'Romania', 'Romania', 'ROU', '642', 'yes', '40', '.ro'),
(182, 'RU', 'Russia', 'Russian Federation', 'RUS', '643', 'yes', '7', '.ru'),
(183, 'RW', 'Rwanda', 'Republic of Rwanda', 'RWA', '646', 'yes', '250', '.rw'),
(184, 'BL', 'Saint Barthelemy', 'Saint Barth&eacute;lemy', 'BLM', '652', 'no', '590', '.bl'),
(185, 'SH', 'Saint Helena', 'Saint Helena, Ascension and Tristan da Cunha', 'SHN', '654', 'no', '290', '.sh'),
(186, 'KN', 'Saint Kitts and Nevis', 'Federation of Saint Christopher and Nevis', 'KNA', '659', 'yes', '1+869', '.kn'),
(187, 'LC', 'Saint Lucia', 'Saint Lucia', 'LCA', '662', 'yes', '1+758', '.lc'),
(188, 'MF', 'Saint Martin', 'Saint Martin', 'MAF', '663', 'no', '590', '.mf'),
(189, 'PM', 'Saint Pierre and Miquelon', 'Saint Pierre and Miquelon', 'SPM', '666', 'no', '508', '.pm'),
(190, 'VC', 'Saint Vincent and the Grenadines', 'Saint Vincent and the Grenadines', 'VCT', '670', 'yes', '1+784', '.vc'),
(191, 'WS', 'Samoa', 'Independent State of Samoa', 'WSM', '882', 'yes', '685', '.ws'),
(192, 'SM', 'San Marino', 'Republic of San Marino', 'SMR', '674', 'yes', '378', '.sm'),
(193, 'ST', 'Sao Tome and Principe', 'Democratic Republic of S&atilde;o Tom&eacute; and Pr&iacute;ncipe', 'STP', '678', 'yes', '239', '.st'),
(194, 'SA', 'Saudi Arabia', 'Kingdom of Saudi Arabia', 'SAU', '682', 'yes', '966', '.sa'),
(195, 'SN', 'Senegal', 'Republic of Senegal', 'SEN', '686', 'yes', '221', '.sn'),
(196, 'RS', 'Serbia', 'Republic of Serbia', 'SRB', '688', 'yes', '381', '.rs'),
(197, 'SC', 'Seychelles', 'Republic of Seychelles', 'SYC', '690', 'yes', '248', '.sc'),
(198, 'SL', 'Sierra Leone', 'Republic of Sierra Leone', 'SLE', '694', 'yes', '232', '.sl'),
(199, 'SG', 'Singapore', 'Republic of Singapore', 'SGP', '702', 'yes', '65', '.sg'),
(200, 'SX', 'Sint Maarten', 'Sint Maarten', 'SXM', '534', 'no', '1+721', '.sx'),
(201, 'SK', 'Slovakia', 'Slovak Republic', 'SVK', '703', 'yes', '421', '.sk'),
(202, 'SI', 'Slovenia', 'Republic of Slovenia', 'SVN', '705', 'yes', '386', '.si'),
(203, 'SB', 'Solomon Islands', 'Solomon Islands', 'SLB', '090', 'yes', '677', '.sb'),
(204, 'SO', 'Somalia', 'Somali Republic', 'SOM', '706', 'yes', '252', '.so'),
(205, 'ZA', 'South Africa', 'Republic of South Africa', 'ZAF', '710', 'yes', '27', '.za'),
(206, 'GS', 'South Georgia and the South Sandwich Islands', 'South Georgia and the South Sandwich Islands', 'SGS', '239', 'no', '500', '.gs'),
(207, 'KR', 'South Korea', 'Republic of Korea', 'KOR', '410', 'yes', '82', '.kr'),
(208, 'SS', 'South Sudan', 'Republic of South Sudan', 'SSD', '728', 'yes', '211', '.ss'),
(209, 'ES', 'Spain', 'Kingdom of Spain', 'ESP', '724', 'yes', '34', '.es'),
(210, 'LK', 'Sri Lanka', 'Democratic Socialist Republic of Sri Lanka', 'LKA', '144', 'yes', '94', '.lk'),
(211, 'SD', 'Sudan', 'Republic of the Sudan', 'SDN', '729', 'yes', '249', '.sd'),
(212, 'SR', 'Suriname', 'Republic of Suriname', 'SUR', '740', 'yes', '597', '.sr'),
(213, 'SJ', 'Svalbard and Jan Mayen', 'Svalbard and Jan Mayen', 'SJM', '744', 'no', '47', '.sj'),
(214, 'SZ', 'Swaziland', 'Kingdom of Swaziland', 'SWZ', '748', 'yes', '268', '.sz'),
(215, 'SE', 'Sweden', 'Kingdom of Sweden', 'SWE', '752', 'yes', '46', '.se'),
(216, 'CH', 'Switzerland', 'Swiss Confederation', 'CHE', '756', 'yes', '41', '.ch'),
(217, 'SY', 'Syria', 'Syrian Arab Republic', 'SYR', '760', 'yes', '963', '.sy'),
(218, 'TW', 'Taiwan', 'Republic of China (Taiwan)', 'TWN', '158', 'former', '886', '.tw'),
(219, 'TJ', 'Tajikistan', 'Republic of Tajikistan', 'TJK', '762', 'yes', '992', '.tj'),
(220, 'TZ', 'Tanzania', 'United Republic of Tanzania', 'TZA', '834', 'yes', '255', '.tz'),
(221, 'TH', 'Thailand', 'Kingdom of Thailand', 'THA', '764', 'yes', '66', '.th'),
(222, 'TL', 'Timor-Leste (East Timor)', 'Democratic Republic of Timor-Leste', 'TLS', '626', 'yes', '670', '.tl'),
(223, 'TG', 'Togo', 'Togolese Republic', 'TGO', '768', 'yes', '228', '.tg'),
(224, 'TK', 'Tokelau', 'Tokelau', 'TKL', '772', 'no', '690', '.tk'),
(225, 'TO', 'Tonga', 'Kingdom of Tonga', 'TON', '776', 'yes', '676', '.to'),
(226, 'TT', 'Trinidad and Tobago', 'Republic of Trinidad and Tobago', 'TTO', '780', 'yes', '1+868', '.tt'),
(227, 'TN', 'Tunisia', 'Republic of Tunisia', 'TUN', '788', 'yes', '216', '.tn'),
(228, 'TR', 'Turkey', 'Republic of Turkey', 'TUR', '792', 'yes', '90', '.tr'),
(229, 'TM', 'Turkmenistan', 'Turkmenistan', 'TKM', '795', 'yes', '993', '.tm'),
(230, 'TC', 'Turks and Caicos Islands', 'Turks and Caicos Islands', 'TCA', '796', 'no', '1+649', '.tc'),
(231, 'TV', 'Tuvalu', 'Tuvalu', 'TUV', '798', 'yes', '688', '.tv'),
(232, 'UG', 'Uganda', 'Republic of Uganda', 'UGA', '800', 'yes', '256', '.ug'),
(233, 'UA', 'Ukraine', 'Ukraine', 'UKR', '804', 'yes', '380', '.ua'),
(234, 'AE', 'United Arab Emirates', 'United Arab Emirates', 'ARE', '784', 'yes', '971', '.ae'),
(235, 'GB', 'United Kingdom', 'United Kingdom of Great Britain and Nothern Ireland', 'GBR', '826', 'yes', '44', '.uk'),
(236, 'US', 'United States', 'United States of America', 'USA', '840', 'yes', '1', '.us'),
(237, 'UM', 'United States Minor Outlying Islands', 'United States Minor Outlying Islands', 'UMI', '581', 'no', 'NONE', 'NONE'),
(238, 'UY', 'Uruguay', 'Eastern Republic of Uruguay', 'URY', '858', 'yes', '598', '.uy'),
(239, 'UZ', 'Uzbekistan', 'Republic of Uzbekistan', 'UZB', '860', 'yes', '998', '.uz'),
(240, 'VU', 'Vanuatu', 'Republic of Vanuatu', 'VUT', '548', 'yes', '678', '.vu'),
(241, 'VA', 'Vatican City', 'State of the Vatican City', 'VAT', '336', 'no', '39', '.va'),
(242, 'VE', 'Venezuela', 'Bolivarian Republic of Venezuela', 'VEN', '862', 'yes', '58', '.ve'),
(243, 'VN', 'Vietnam', 'Socialist Republic of Vietnam', 'VNM', '704', 'yes', '84', '.vn'),
(244, 'VG', 'Virgin Islands, British', 'British Virgin Islands', 'VGB', '092', 'no', '1+284', '.vg'),
(245, 'VI', 'Virgin Islands, US', 'Virgin Islands of the United States', 'VIR', '850', 'no', '1+340', '.vi'),
(246, 'WF', 'Wallis and Futuna', 'Wallis and Futuna', 'WLF', '876', 'no', '681', '.wf'),
(247, 'EH', 'Western Sahara', 'Western Sahara', 'ESH', '732', 'no', '212', '.eh'),
(248, 'YE', 'Yemen', 'Republic of Yemen', 'YEM', '887', 'yes', '967', '.ye'),
(249, 'ZM', 'Zambia', 'Republic of Zambia', 'ZMB', '894', 'yes', '260', '.zm'),
(250, 'ZW', 'Zimbabwe', 'Republic of Zimbabwe', 'ZWE', '716', 'yes', '263', '.zw');

MySQL List of States & PHP Function for Select Box

After the first few 5:00am "ohmigod I need a list of states NOW!" moments that I had when I started coding, I figured I'd dump a generic table and use that for future reference. This is the basic table--it can be modified as needed. It includes Washington DC and the three Armed Forces abbreviations: AA, AE, and AP.

Copy and paste the contents of this box either into your SQL command window if you're using the command line or into the big textbox on the "SQL" tab in phpMyAdmin. 

  `state_id` int(3) NOT NULL auto_increment COMMENT 'PK: Unique Identifier',
  `state_name` varchar(50) NOT NULL default '' COMMENT 'State Name',
  `state_abbr` varchar(10) default NULL COMMENT 'State Abbreviation',
  PRIMARY KEY  (`state_id`)

-- Dumping data for table `state_t`

INSERT INTO `state_t` (`state_id`, `state_name`, `state_abbr`) VALUES
(1, 'Alabama', 'AL'),
(2, 'Alaska', 'AK'),
(3, 'Arizona', 'AZ'),
(4, 'Arkansas', 'AR'),
(5, 'California', 'CA'),
(6, 'Colorado', 'CO'),
(7, 'Connecticut', 'CT'),
(8, 'Delaware', 'DE'),
(9, 'District of Columbia', 'DC'),
(10, 'Florida', 'FL'),
(11, 'Georgia', 'GA'),
(12, 'Hawaii', 'HI'),
(13, 'Idaho', 'ID'),
(14, 'Illinois', 'IL'),
(15, 'Indiana', 'IN'),
(16, 'Iowa', 'IA'),
(17, 'Kansas', 'KS'),
(18, 'Kentucky', 'KY'),
(19, 'Louisiana', 'LA'),
(20, 'Maine', 'ME'),
(21, 'Maryland', 'MD'),
(22, 'Massachusetts', 'MA'),
(23, 'Michigan', 'MI'),
(24, 'Minnesota', 'MN'),
(25, 'Mississippi', 'MS'),
(26, 'Missouri', 'MO'),
(27, 'Montana', 'MT'),
(28, 'Nebraska', 'NE'),
(29, 'Nevada', 'NV'),
(30, 'New Hampshire', 'NH'),
(31, 'New Jersey', 'NJ'),
(32, 'New Mexico', 'NM'),
(33, 'New York', 'NY'),
(34, 'North Carolina', 'NC'),
(35, 'North Dakota', 'ND'),
(36, 'Ohio', 'OH'),
(37, 'Oklahoma', 'OK'),
(38, 'Oregon', 'OR'),
(39, 'Pennsylvania', 'PA'),
(40, 'Rhode Island', 'RI'),
(41, 'South Carolina', 'SC'),
(42, 'South Dakota', 'SD'),
(43, 'Tennessee', 'TN'),
(44, 'Texas', 'TX'),
(45, 'Utah', 'UT'),
(46, 'Vermont', 'VT'),
(47, 'Virginia', 'VA'),
(48, 'Washington', 'WA'),
(49, 'West Virginia', 'WV'),
(50, 'Wisconsin', 'WI'),
(51, 'Wyoming', 'WY'),
(52, 'Armed Forces - Americas', 'AA'),
(53, 'Armed Forces - Europe', 'AE'),
(54, 'Armed Forces - Pacific', 'AP');

Create variables and an array as below. Personally, I place this variable in a file called "settings.php" which I include at the top of every file that references the database in any way.

$dbname = "mydatabase_name";        // Database name
$dbuser = "my_username";            // Database username
$dbpass = "password";               // Database password
$dbhost = "localhost";              // Database host

$dbvariables = Array (              // Array to hold db variables
  "dbhost" => $dbhost,
  "dbuser" => $dbuser,
  "dbpass" => $dbpass,
  "dbname" => $dbname

Place the following function in an appropriate location, I place it in an external file (like the settings.php file) and include it at the top of every file.

function state_select($dbvariables) {
<select name="state">
<option value="">--</option>
   dbConnect($dbvariables);                   // Connect to MySQL
   mysql_select_db($dbvariables['dbname']);   // Select database

   $query = 'SELECT * from `state_t` WHERE 1 ORDER BY `state_name` ASC';
   $result = mysql_query($query) or die(mysql_error());

   while ($x = mysql_fetch_array($result, MYSQL_ASSOC)) {

      $state_id   = $x['state_id'];
      $state_name = $x['state_name'];
<option value="<?php echo $state_id; ?>"><?php echo $state_name; ?></option>

Search Help: Visitors seeking this information might use the following search strings: List of states in MySQL database format, MySQL List of States, MySQL state list, php MySQL list of states, php list state function.

How to Strip Non-Alphanumeric Characters From a String with PHP?

There are often times when non-alphanumeric characters in a string can be troublesome. For example, if you are using a string in order to name a file, you would want to eliminate any characters that are illegal in a filename. The following two commands (you can nest them, if you want) will first strip out all the characters except spaces, then convert the spaces to hyphens (or you can use underscores, etc.). Use only the first, if you wish to keep the spaces.

$my_new_string = preg_replace("/[^a-zA-Z0-9\s]/", "", $original_string);

$my_new_string = str_replace(" ","-",$my_new_string);

How to Make Caps to the first letter automatically in PHP?

I want to make the first letter in a text box to be capital but i have no idea on how i can apply it. e.g sitholimela ----> Sitholimela

I want to apply this to a text box.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "">
  <title>Capitalizing first letter in a textbox</title>
  <script type="text/javascript">
  function capitalize(textboxid, str) {
      // string with alteast one character
      if (str && str.length >= 1)
          var firstChar = str.charAt(0);
          var remainingStr = str.slice(1);
          str = firstChar.toUpperCase() + remainingStr;
      document.getElementById(textboxid).value = str;
  <form name="myform" method="post">
      <input type="text" id="mytextbox" onkeyup="javascript:capitalize(, this.value);">

CSS Code

input[type=text] {
    text-transform: capitalize;

Another Simple Way:-

.cityname{text-transform: capitalize;}

Call this class in input type where you want to Caps your First Letter.

<input type=''text" class="cityname"

How to Get the Last Auto-Incremented Number From MySQL?

When you need to insert data into more than one table at a time in a normalized database with relationships between the tables, you will often need to obtain the record number of the data inserted into the first table before creating your query to insert data into the second table. This can be accomplished with a short series of commands. Use the following code immediately after you make the first query:

/* This query figures out what the last auto-
   incremented number was so that it can be 
   used in the next query or other action.
   This assumes you are using the $link variable
   used in most MySQL examples to store the
   information necessary to connect to your
   database.  */

$result = mysql_query($query, $link);
$row = mysql_fetch_array($result);
// following is the newly created record
$last_id = 0 + $row[0];

How to Get Image Size with PHP?

I include this here because I had to look it up a couple times at first, so I thought it might be useful to others. Often there is a need or desire to display an image which might not always have a consistent size. For example, if you are displaying an image gallery and don't want to take the time to resize all of your images but still want to have code that validates, you need to come up with some way to display the correct size of the image in the <img> tag. PHP provides a nifty function, getimagesize() for this purpose, but the function was written before CSS became the standard, so while it provides HTML-valid code, it does not provide nicely packaged XHTML-valid code.

So, you have two options:
  1. Use the HTML code, life won't end! You can do this by doing the following:
    $myimage = "";
    $size = getimagesize($myimage);
    then use the following in your HTML:
    <img src="/full/path/to/image.jpg" <?php echo $size[3]; ?> />
    which produces:
    <img src="/full/path/to/image.jpg" width="300" height="60" />
    where the width and height match those of your image.
  2. Use this nifty little function instead:
    function imageSize($size) {
     $width = $size[0];
     $height = $size[1];
     print 'style="width:' . $width . 'px;height:' . $height . 'px;"';
    $myimage = "";
    $size = getimagesize($myimage);
    <img src="/full/path/to/image.jpg" <?php imageSize($myimage); ?> />
    which produces:
    <img src="/full/path/to/image.jpg" style="width:300px;height:60px;" />
Don't forget to add the required alt tags!

How To Capitalize First Letter or Each Word of a string Using PHP?

ucwords — Uppercase the first character of each word in a string

string ucwords ( string $str [, string $delimiters = " \t\r\n\f\v" ] )

Returns a string with the first character of each word in str capitalized, if that character is alphabetic.

strtoupper — Make a string uppercase

string strtoupper ( string $string )

Returns string with all alphabetic characters converted to uppercase.

ucfirst — Make a string's first character uppercase

string ucfirst ( string $str )

Returns a string with the first character of str capitalized, if that character is alphabetic.

strtolower — Make a string lowercase

string strtolower ( string $string )

Returns string with all alphabetic characters converted to lowercase.

Related functions:

strtolower() - converts a string to lowercase
lcfirst() - converts the first character of a string to lowercase
ucfirst() - converts the first character of a string to uppercase
ucwords() - converts the first character of each word in a string to uppercase

How to Display MySQL Dates in Other Formats using PHP?

MySQL stores dates in the format YYYY-MM-DD... which is great, it's consistent and easy to understand—If you happen to be a computer. Unfortunately, this format is rather confusing for humans, especially for humans which may be trying to communicate with individuals who read dates differently. For example, those of us in the US usually record the 10th of May in the year 2015 as 05/10/2015 whereas individuals in other countries often record the same date as 10/05/2015, causing considerable confusion in communication.

So what do we do to solve this? When in doubt, write it out! Here's how to take a date retrieved from a MySQL database by PHP and convert it to an international human-friendly format.

We'll first assume that you have retrieved your data into array $myrow. Say the date stored in MySQL is 2015-07-11. Here's how to display it in various forms. Precede each of these by echo or print, whichever is appropriate for your application. All of these can be modified as needed by using the various formatting characters as described in the PHP: date manual.

Desired TextCode
July 11, 2015date("F d, Y",strtotime($myrow['date']));
Saturday, July 11, 2015date("l, F d, Y",strtotime($myrow['date']));
Jul 11, 2015date("M d, Y",strtotime($myrow['date']));
11 July 2015date("d F Y",strtotime($myrow['date']));
11 Jul 2015date("d M Y",strtotime($myrow['date']));
Sat, 11 Jul 2015date("D, d M Y",strtotime($myrow['date']));
Saturday, the 11th of July, 2015date("l",strtotime($myrow['date'])) . ", the " . date("jS",strtotime($myrow['date'])) . " of " . date("F, Y",strtotime($myrow['date']));

Search Help: Visitors seeking this information might use the following search strings: "How do I display MySQL dates in other formats?", "MySQL dates PHP", "MySQL datestamp field", "MySQL datestamp format", "MySQL PHP date format", ""MySQL PHP date conversion", "Convert MySQL date in PHP".