Easy guide for installing WAMP and using phpMyAdmin
PHP'>WAMP (Windows, Apache, MySQL, Php) is very easy to install and you can obtain it from PHP'>WAMP Server home page. It is convenient to install the PHP'>WAMP bundle than to install Php, Apache, MySql as separated modules.
Just follow the next steps:
- Download a copy of PHP'>WAMP from server home page. Launch the wamp5_X.XX.exe to begin the installation. The WAMP5 Setup Wizard will appear and for begin click Next.
- As we are accustomed in the License Agreement select Accept the agreement and click Next.
- In the Select Destination Location screen we can change the default path by choosing Browse. Now click Next.
- Select Start Menu Folder: we will use the default WampServer.
- Select Additional Task: you can check Automatically lunch WAMP5 on startup. If you don’t choose this you can manually start the PHP'>WAMP Server.
- Ready to install: just click install
- Installing: here is the screen that appears with the progress of installation process.
- Now you have to select the default publishing folder or DocumentRoot folder. Any files that are stored here can be access in the Internet by typing the IP address of the machine
- Now comes the screen for selecting the default web browser.
- Finally click Finish to complete the installation.
You can observe that a new icon appeared on the task bar to the left side of the clock. You can choose to start or to stop the server on your computer. To starting the server click Start > All Programs > WampServer > Start WampServer. Click the WAMP5 Server icon in the task bar and select Start All Services.
There are articles in this websites about working with Php or MySQL, so here I choose to present the phpMyAdmin script. PhpMyAdmin is a popular open source software that allow manager-ing MySQL databases in a pleasant visual way. It is a lot easier to query databases using PhpMyAdmin than typing queries in the command line. Why shouldn’t use phpMyAdmin as long as it comes with the PHP'>WAMP packages.
A short description of using phpMyAdmin
After you lunched phpMyAdmin click the SQL menu icon . This will open a new browser window with a menu at the top of the screen. Just click Import Files and now you will have to choose the file for importation (only .sql files) and click Go to complete the import process.
Working with Databases and Tables
Important! Before starting editing a database you have to select a database to work with. In the left side there is a drop menu for this. After selected a database, it will appear a list of tables with detailed information.
The menu allows to perform actions such as: checking the table structure, SQL commands, exporting tables data and structure to files, searching the database, performing queries and operations to databases and dropping the database.
As we seen in the previous image there are action buttons like : browse(for displaying data in the table), search(for searching data in the table), insert(for inserting records in the table), structure(for displaying records in the table), empty(for deleting the table contents) and drop(for deleting the table).
The records column shows the number of individual records within a table. The type column indicates the type of table used. Collation is the language/character set and size indicates the KB of the table.
By clicking any table name it will be displayed the table fields, types, character sets, special attributes, Null (if the field is empty), the default content, extra information, and another set of action buttons. The action button allows handling the data stored in each field of the table. The actions you can do are: changing the structure of the data field, deleting the field, setting the field as a primary key, index the field, make the field unique and adding full text.
You can insert data into the table by clicking the Insert tab. All you have to do is to complete the form and click Go to add a record to the table. As you see it is easiest to complete a form than to type the query “insert into table values(…)” because we might have omitted an apostrophe and trying to fix it might be difficult.
Exporting a Database
Being able to make a backup of your databases is very usefully if we have to move our databases on another server. PhpMyAdmin is usable when it comes to it. Of Course it has limitations of database size ( it’ll do the export even if the database is big but the import part is not like that. Cant import a file without considering the size. That’s because it uses PHP as a processing language and PHP limits the uploaded file size. But anyways, PhpMyAdmin is a great tool and is used probably on each MySql server on this world
So, go to Export Menu and in the export page un-check Add Auto_Increment Value. Check Save As File and type a filename in the template box or let the engine to use the templated name. Click Go for finishing the process.
I thought it’s enough what I said here but if anyone there needs a better, detailed tutorial about using this awesome script I would be happy to publish it. Use our forums if you have any question