|
|
Creating database, table and managing MySQL database using phpMyAdmin |
| phpMyAdmin is a tool for managing MySQL database and free of charge, it's a web base tool. This tutorial you'll learn how to create database, create table include export(backup) MySQL database. |
|
|
 |
| Overview |
|
phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, manage privileges,export data into various formats
Dowload Here
Installation
- Put phpMyAdmin folder where you keep php file |
phpMyAdmin
|
|
|
|
 |
Create database using phpMyAdmin |
|
Create new database form
|
| 1. To create new database use this form, type database name then click "Create" button. In this example I create database name "test_create_DB". |
| |
|
|
|
 |
Create table |
|
Create table form
|
1. After created database. this form'll be display. Enter the name of table and number of field. In this example, I create table name "web_members" for store my web members and it have 4 fields (id, name, lastname, email) |
Result after created table on database
|
|
|
|
|
|
|
| |
PHP Redirection script
Learn how to redirect in this tutorial, you can use header(); function in php or use meta to redirect to a new page you want or redirect to other website. |
|
|
|
|
