mkaplan

PHP5 google maps example (mysql)

Aug 13th, 2011
162
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.08 KB | None | 0 0
  1. CREATE DATABASE testgooglemaps;
  2.  
  3. USE testgooglemaps
  4.  
  5. CREATE TABLE IF NOT EXISTS `poi_example` (
  6.  `id` int(11) NOT NULL AUTO_INCREMENT,
  7.  `name` text NOT NULL,
  8.  `desc` text NOT NULL,
  9.  `lat` text NOT NULL,
  10.  `lon` text NOT NULL,
  11.  `complete` bool,
  12.  PRIMARY KEY (`id`)
  13. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
  14.  
  15.  
  16. INSERT INTO `poi_example` (`id`, `name`, `desc`, `lat`, `lon`, complete) VALUES
  17. (1, '100 Club', 'Oxford Street, London  W1<br/>3 Nov 2010 : Buster Shuffle<br/>', '51.514980', '-0.144328', 1),
  18. (2, '93 Feet East', '150 Brick Lane, London  E1 6RU<br/>7 Dec 2010 : Jenny &amp; Johnny<br/>', '51.521710', '-0.071737', 1),
  19. (3, 'Adelphi Theatre', 'The Strand, London  WC2E 7NA<br/>11 Oct 2010 : Love Never Dies', '51.511010', '-0.120140',0),
  20. (4, 'Albany, The', '240 Gt. Portland Street, London  W1W 5QU', '51.521620', '-0.143394',0),
  21. (5, 'Aldwych Theatre', 'Aldwych, London  WC2B 4DF<br/>11 Oct 2010 : Dirty Dancing', '51.513170', '-0.117503',1),
  22. (6, 'Alexandra Palace', 'Wood Green, London  N22<br/>30 Oct 2010 : Lynx All-Nighter', '51.596490', '-0.109514',1);
Add Comment
Please, Sign In to add comment