MootMoot-php is a project mainly written in JAVASCRIPT and PHP, it's free.
Mootools/PHP/MySQL gallery
Mootools gallery by Julien Pellet http://julienpellet.com
contact @ julienpellet.com
-- Serveur: localhost -- Généré le : Ven 05 Août 2011 à 10:13 -- Version du serveur: 5.1.49 -- Version de PHP: 5.3.3-7
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /; /!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /; /!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /; /!40101 SET NAMES utf8 /;
electronq001
DROP DATABASE electronq001
;
CREATE DATABASE electronq001
DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE electronq001
;
gallery
DROP TABLE IF EXISTS gallery
;
CREATE TABLE IF NOT EXISTS gallery
(
gallery_id
int(11) NOT NULL AUTO_INCREMENT,
name
varchar(250) COLLATE utf8_unicode_ci NOT NULL,
dir
varchar(250) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (gallery_id
)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10 ;
gallery
INSERT INTO gallery
(gallery_id
, name
, dir
) VALUES
(9, 'WELLINGTON', 'wellington'),
(6, 'nature', 'nature'),
(7, 'portraits', 'portraits'),
(8, 'Fine Art', 'fine_art');
picture
DROP TABLE IF EXISTS picture
;
CREATE TABLE IF NOT EXISTS picture
(
picture_id
int(11) NOT NULL AUTO_INCREMENT,
dpublication
int(11) NOT NULL,
file
varchar(200) COLLATE utf8_unicode_ci NOT NULL,
caption
text COLLATE utf8_unicode_ci NOT NULL,
gallery_id
int(11) NOT NULL,
PRIMARY KEY (picture_id
)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=119 ;
picture
INSERT INTO picture
(picture_id
, dpublication
, file
, caption
, gallery_id
) VALUES
(28, 0, 'dsc_4601.jpg', 'The photographer Eye - Self portrait - Photography by Julien Pellet', 8),
(108, 0, 'DSC_1127_topaz.jpg', 'Lake Wakatipu - Queenstown - Otago - New Zealand. Photography by Julien Pellet', 6),
(107, 0, 'DSC_8200.JPG', 'Taranaki reflection, Pouakai Circuit, Egmont National Park, New Zealand. Photography by Julien Pellet', 6),
(106, 0, 'DSC_2705_topaz.jpg', 'Moeraki Boulders - New Zealand East Cost. Photography by Julien Pellet', 6),
(105, 0, '1DSC_2523.jpg', 'Study of a dead urchin. Bretagne, France. Photography by Julien Pellet', 8),
(104, 0, 'DSC_8645.JPG', 'Les quais de l isere, Grenoble France. Photography by Julien Pellet', 8),
(103, 0, 'DSC_8655.jpg', 'General Practitioners on Willis Street - Wellington - New Zealand. Photograph by Julien Pellet', 8),
(102, 0, 'DSC_7444_topaz.jpg', 'Tongariro crossing - Tongariro National Park - New Zealand. Photography by Julien Pellet', 7),
(101, 0, 'DSC_7512.JPG', 'Tongariro Alpine Crossing - New Zealand National Park', 6),
(100, 0, 'dsc_5482.jpg', 'Universes in universe - Oil and water macro - Photography by Julien Pellet', 8),
(99, 0, 'sky tower from albert park.jpg', 'Sky tower - Albert park - Auckland. Photography by Julien Pellet', 8),
(98, 0, 'DSC_5479_3.jpg', 'Clemence - Photography by Julien Pellet', 7),
(97, 0, 'DSC_1218.JPG', 'Brother Teodoro, from the Holy family congregation, in front of a Stellina cask, in the Kario distillery, Belley France. Photography by Julien Pellet', 7),
(96, 0, 'DSC_3020.jpg', 'Servranckx - Grenoble museum - France. Photography by Julien Pellet', 8),
(95, 0, 'DSC_6785_topaz.jpg', 'Rotorua Champagne Pool - New Zealand. Photography by Julien Pellet', 6),
(94, 0, 'DSC_3436.jpg', 'Boiling water - Jacques Honvault style. Photography by Julien Pellet', 8),
(93, 0, 'dsc_8952.jpg', 'Steps on pavement. Grenoble - France. Photography by Julien Pellet', 8),
(92, 0, 'DSC_3609.JPG', 'Drink and drive ? Grenoble, France. Photography by Julien Pellet', 8),
(91, 0, 'DSC_5324_REPRO.jpg', 'Lacs Roberts - Chamrousse - Isere - Belledonne - Grenoble - France. Photography by Julien Pellet', 6),
(90, 0, 'DSC_9801.jpg', 'Untitled - Grenoble France. Photography by Julien Pellet', 7),
(89, 0, 'DSC_6212_1280.JPG', 'Maori Marae - Waitangi - New Zealand. Photography by Julien Pellet', 8),
(88, 0, 'DSC_6221_1280.JPG', 'Maori Canoe - Waitangi - New Zealand. Photography by Julien Pellet', 8),
(87, 0, 'DSC_6250.JPG', 'Port waimoto - New Zealand. Photography by Julien Pellet', 6),
(86, 0, 'DSC_6158_1280.JPG', 'Cape Reinga - New Zealand - Photography by Julien Pellet', 6),
(81, 0, 'clemence.jpg', 'Clemence - Grenoble France - Photography by Julien Pellet', 7),
(82, 0, 'DSC_4014_2.jpg', 'Self portrait and guitar, Abandoned warehouse, Rue Mozart, Grenoble France. Photography by Julien Pellet', 7),
(83, 0, 'dsc_0078.jpg', 'Journee de l allaitement, Grenoble France. Photography by Julien Pellet', 7),
(84, 0, 'DSC_2342_2.jpg', 'Long exposure on lake Hauroko - Self portrait - New Zealand - South Island. Photography by Julien Pellet', 6),
(85, 0, 'DSC_8010_topaz.jpg', 'Taranaki volcano by night, New Plymouth, New Zealand. Photography by Julien Pellet', 6),
(116, 0, 'DSC_5571_topaz_highkey_800.jpg', 'Te papa museum, Wellington, New Zealand. Photography by Julien Pellet', 9),
(115, 0, 'DSC_8615.jpg', 'Water front, steam crane, Wellington, New Zealand. Photography by Julien Pellet', 9),
(114, 0, 'DSC_8655.jpg', 'General Practitioners on Willis Street, Wellington New Zealand. Photography by Julien Pellet', 9),
(113, 0, 'DSC_5520_2_800px_sepia.JPG', 'Civic center, Wellington New Zealand. Photography by Julien Pellet', 9),
(111, 0, 'DSC_5136_800.jpg', 'Waterfront sculpture, Wellington, New Zealand. Photography by Julien Pellet', 9),
(112, 0, 'DSC_5368_800.JPG', 'Sculpture on Lambton Quay, Wellington, New Zealand. Photography by Julien Pellet', 9),
(117, 0, 'DSC_6550.JPG', 'Cosmic shop in Cuba Street, Wellington, New Zealand. Photography by Julien Pellet', 9),
(118, 0, 'DSC_7568_2.JPG', 'Tongariro national park, New Zealand', 6);
CREATE ALGORITHM=UNDEFINED DEFINER=root
@localhost
SQL SECURITY DEFINER VIEW v_gallery_picture
AS select p
.picture_id
AS picture_id
,p
.file
AS file
,p
.caption
AS caption
,p
.dpublication
AS dpublication
,g
.name
AS gallery_name
,g
.dir
AS dir
from (gallery
g
join picture
p
) where (p
.gallery_id
= g
.gallery_id
);