|
|
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
|
|
|
|
|
|
|
| |
Verifying email address
When users sign up to join your website you may want to verify their email address by sending confirmation link to their email address. You'll learn how to do this in this tutorial. |
|
|
|
|
