|
|
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
|
|
|
|
|
|
|
| |
Test php mail function on your localhost
When you code php mail function you can't test it on your localhost you have to upload and test it on your hosting but now you can test php mail function on your localhost using Argosft mail server. |
|
|
|
|
