Steps To Make Online Photo Gallery #2
Photo Gallery CSS Static Effects
CSS effects static photo gallery is a photo gallery are arranged in sequence in a single window with a static order. In this chapter will discuss :
- The process of setting up the database and tables
- Making the simple photo gallery
- Making the zoom effect photo gallery
- Making the rotation effect photo gallery
- Making the balloon photo gallery
- Making the photo gallery zoom and rotation
Setting Up Database
Before making a gallery of photos, you need to set up a database to store data necessary data.
Creating Database
Start the web browser of your server, then typing the URL http://localhost/phpmyadmin to enter the phpMyAdmin page. Once entered into the page PhpMyAdmin, click the SQL tab and then type the following code to create a database with the name "gallery". click the GO button after gallery manufacture complete SQL code.
CREATE DATABASE gallery;
Picture creating database gallery
If the database is successfully created it will show the name of the gallery on the left side panel.
Picture database manufacture successfully
Create Table
Tables are used to store text data in a database which will be called using PHP code. In this chapter will be made tables under the name "foto" in the database that have been made.
To create the table, type the following code in SQL tab. PhpMyAdmin page. after completion you type, click the GO button.
CREATE TABLE 'gallery'.'foto' (
'nama' VARCHAR (225) NOT NULL,
'kategori' VARCHAR (15) NOT NULL,
'lokasi' VARCHAR (225) NOT NULL,
PRIMARY KEY ('nama')
)
ENGINE=InnoDB;
'nama' VARCHAR (225) NOT NULL,
'kategori' VARCHAR (15) NOT NULL,
'lokasi' VARCHAR (225) NOT NULL,
PRIMARY KEY ('nama')
)
ENGINE=InnoDB;
Picture create table
If the table is successfully created it will appear as shown below :
Picture table successfully
COMMENTS