Tutorial:Creating mySQL database, table using phpMyAdmin

[Nitro]

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 Server statement, manage keys on fields, manage privileges,export data into various formats
Dowload Here:
www. phpeasystep.com/downloadsview.php?id=2

Installation:

- Put phpMyAdmin folder where you keep php file


1.
Create database using phpMyAdmin

www. phpeasystep.com/imgs/mysql_create_db.gif

<TABLE cellSpacing=5 cellPadding=0 width="100%" border=0><TBODY><TR><TD>To create new database use this form, type database name then click "Create" button. In this example I create database name "test_create_DB". </TD></TR><TR><TD>
2.



</TD></TR></TBODY></TABLE>
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)

Result after created table on database



3
Create table by runing SQL Server query
SQL Page



<TABLE cellSpacing=5 cellPadding=0 width="100%" border=0><TBODY><TR><TD>1. You can create table by run SQL Server query for example, put this code in the form and click "Go"

CREATE TABLE `web_members` (
`id` int(4) NOT NULL auto_increment,
`name` varchar(65) NOT NULL default '',
`lastname` varchar(65) NOT NULL default '',
`email` 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))



</TD></TR><TR><TD></TD></TR></TBODY></TABLE>
4
Export database




In tab Export. You can export your database in many format like
- SQL Server (text file .sql)
- Latex
- Microsoft Exel 2000
- Microsoft Word 2000
- CVS for MS Exel
- CVS
- XML

Step
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 Server query)
4. Select compression
- None
- zipped (.zip)
- gzipped (.gzip)

Goodluck!

[la_musicata]

Hi,

I've copied your code and made the changes I needed to make. Thank you so very much!!! you write very clearly, something almost no one does on the net.

Though there are three things left for me to figure out now:

1. I've tried to change the name of the table from "web_members" to "track_orders" and it gave me an SQL error note.

2. I don't know what values I should enter in the fields that suppose to be numbers, like phone- I guess it's different than VARCHAR.

3. How do I make the connection now between the database fields (name1, name2, address, city, state, country, phone, e-mail, skype, messanger, track_choice) and the form I've made (a combination of HTML and PHP- if you want I can paste the code I've made here, so you can see what I've done).

Plus- if you know how it's done, or you can send me a link to a tutorial about it- I need a code that will create a pop-up saying "Thank you" to the costumer as he presses the "send" button, and send an automatic personal e-mail to the costumer with the content we want to send him.

Anything of the above will be a great help.
Great thanks in advance.

Shir
Tel Aviv, Israel