PHP Classes

File: locations.sql

Recommend this page to a friend!
  Classes of Manuel Lemos   PHP Forms Class with HTML Generator and JavaScript Validation   locations.sql   Download  
File: locations.sql
Role: Auxiliary data
Content type: text/plain
Description: Locations MySQL database schema dump for the linked select inputs example
Class: PHP Forms Class with HTML Generator and JavaScript Validation
HTML forms generation and validation.
Author: By
Last change: Used a MySQL dump for more recent servers.
Date: 6 years ago
Size: 2,012 bytes
 

Contents

Class file image Download
-- MySQL dump 10.13 -- -- Host: localhost Database: locations -- ------------------------------------------------------ -- Server version 5.6.37-log -- -- Table structure for table `continents` -- DROP TABLE IF EXISTS `continents`; CREATE TABLE `continents` ( `code` char(2) NOT NULL DEFAULT '', `name` char(16) NOT NULL DEFAULT '', PRIMARY KEY (`code`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `continents` -- INSERT INTO `continents` VALUES ('na','North America'),('eu','Europe'),('sa','South America'),('as','Asia'),('oc','Oceania'); -- -- Table structure for table `countries` -- DROP TABLE IF EXISTS `countries`; CREATE TABLE `countries` ( `code` char(2) NOT NULL DEFAULT '', `name` char(16) NOT NULL DEFAULT '', `continent` char(2) NOT NULL DEFAULT '', PRIMARY KEY (`code`,`continent`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `countries` -- INSERT INTO `countries` VALUES ('us','United States','na'),('ca','Canada','na'),('pt','Portugal','eu'),('de','Germany','eu'),('br','Brazil','sa'),('ar','Argentina','sa'),('jp','Japan','as'),('kr','Korea','as'),('au','Australia','oc'),('nz','New Zeland','oc'); -- -- Table structure for table `locations` -- DROP TABLE IF EXISTS `locations`; CREATE TABLE `locations` ( `code` char(2) NOT NULL DEFAULT '', `name` char(16) NOT NULL DEFAULT '', `country` char(2) NOT NULL DEFAULT '', PRIMARY KEY (`code`,`country`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `locations` -- INSERT INTO `locations` VALUES ('ny','New York','us'),('la','Los Angeles','us'),('to','Toronto','ca'),('mo','Montr','ca'),('li','Lisbon','pt'),('av','Aveiro','pt'),('fr','Frankfurt','de'),('be','Berlin','de'),('sa','S','br'),('ri','Rio de Janeiro','br'),('bu','Buenos Aires','ar'),('ma','Mar del Plata','ar'),('to','Tokio','jp'),('os','Osaka','jp'),('se','Seoul','ky'),('yo','Yosu','kr'),('sy','Sydney','au'),('me','Melbourne','au'),('we','Wellington','nz'),('au','Auckland','nz');