All PHP Tutorials
Ad Management
Counter
Email System
Forum and Guestbook
File Upload
Image Manipulation
Login / Members / Password
Pagination
Encode Script
Refresh / Redirection
Miscellaneous
All MySQL Tutorials
Create, Manage Database using phpMyAdmin
Connect to Database
Insert Data
Select Data
Edit Database
Update Database
Delete Database
Order Results
Forums
Home > MySQL Tutorials
Managing MySQL database with phpMyAdmin
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

phpMyAdmin home

Create database using phpMyAdmin
Create new database form

mysql create database

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

mysql create table

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



PAGE 1 | 2
Random Tutorial
 
Get the width and height of an image using a function in PHP
PHP provides a function to get the width and height of an image. The getimagesize() function will determine the size of image file including flash file(swf). 
 
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. 
Advertisement
 
   
Hosted by Hostgator
© PHPeasystep.com 2005-2008