PHP simple : PHP tutorial, MySQL tutorial
PHP Tutorial - Free PHP Script

Home | Tutorials | PHP & MySQL Resources | Web Tools
Introduction & Get Start
Using Form
PHP
PHP Tags
PHP Variables
PHP Control Structures
MySQL
Create Database & Table
Database Connection
Insert Record
Select Record
Update Record
Delete Record

MySQL : Create Database and Table

Normally, to manage MySQL Database you need to do it on command Line as DOS command. Now, many MySQL management programs has been developed by many programmers and the best one is phpMyadmin. 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.

This tutorial you'll learn how to create database, create table include export(backup) MySQL database.

phpMyAdmin Installation

Put phpMyAdmin folder where you keep php files. You can rename this folder to an easy name. For this example I use " phpmyadmin". To use this program you can do like this;

http://localhost/phpmyadmin or http://127.0.0.1/phpmyadmin and this is the welcome page.

phpmyadmin


Create Database

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 database


Create Table

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)

create table


Create Database and Table by SQL command

import sql

You can create table by run SQL query for example, put this code in the form and click "Go"

CREATE TABLE `phonebook` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`tel` varchar(65) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

or browse from text file (read export database for creating text file (.sql))


Export Database

export database

In tab Export. You can export your database in many format like

  • SQL (text file .sql)
  • Latex
  • Microsoft Exel 2000
  • Microsoft Word 2000
  • CVS for MS Exel
  • CVS
  • XML

Steps

  1. Select table you want to export or select all table.
  2. Select file format
  3. Select save as file(if you want to save as a file if not select it'll show you only Sql query)
  4. Select compression
    - None
    - zipped (.zip)
    - gzipped (.gzip)

Make a Number Format
In this tutorial we'll make number format like 0001, 0002, 0003 in stead of 1, 2 ,3. It's very easy to do this for your counter, category or product ID. etc.
Send Email to Multiple Persons
You can send email to mutiple persons in one time. This tutorial shows you in 1 file with a normal form. When you submit, this file will be sent an email immediately to the target emails from your database.


PHPsimple.net
[email protected]