logo
g Text Version
Beauty & Self
Books & Music
Career
Computers
Education
Family
Food & Wine
Health & Fitness
Hobbies & Crafts
Home & Garden
Money
News & Politics
Relationships
Religion & Spirituality
Sports
Travel & Culture
TV & Movies

dailyclick
Bored? Games!
Nutrition
Postcards
Take a Quiz
Rate My Photo

new
European Travel
Action Movies
Bible Basics
Houseplants
Romance Movies
Creativity
Family Travel


dailyclick
All times in EST

Low Carb: 8:00 PM

Full Schedule
g
g PHP Site

BellaOnline's PHP Editor

g

An Introduction to phpMyAdmin for Databases

Guest Author - Diane Cipollo

Once you are ready to use a database in your PHP programs, you have a few options available to you for creating and working with databases. You can write your own PHP program that will set up the database and its tables or you can use a previously written program that will do this work for you. There are several prewritten applications that you can use, but the one I will use in the next few tutorials is phpMyAdmin.

The reason that I have chosen to use this program is that it is available on most hosting servers and, in case your web hosting company doesn't have it, you can download a free copy from phpMyAdmin.net and upload it to your website. Yes, I said it was free. It is an open source program written in PHP and offered free under the GPL License. The latest version supports PHP 5 and MySQLR 4.1 and 5.0.

So what can this program do for you? It works via a web browser to act as a communication interface for creating and editing databases and database tables. All you need to do is enter the information into the web form and the program will execute the SQl statements for you. Below is a list of the most common jobs.
  1. Database - Create and drop (remove)

  2. Tables - Create, alter and drop

  3. Table Fields - Add, edit and delete

  4. SQL Statements - Execute SQL statements such as the dump (export) statement for easily making a backup of your database.




This site needs an editor - click to learn more!

Add An+Introduction+to+phpMyAdmin+for+Databases to Twitter Add An+Introduction+to+phpMyAdmin+for+Databases to Facebook Add An+Introduction+to+phpMyAdmin+for+Databases to MySpace Add An+Introduction+to+phpMyAdmin+for+Databases to Del.icio.us Digg An+Introduction+to+phpMyAdmin+for+Databases Add An+Introduction+to+phpMyAdmin+for+Databases to Yahoo My Web Add An+Introduction+to+phpMyAdmin+for+Databases to Google Bookmarks Add An+Introduction+to+phpMyAdmin+for+Databases to Stumbleupon Add An+Introduction+to+phpMyAdmin+for+Databases to Reddit




RSS | Related Articles | Editor's Picks Articles | Top Ten Articles | Previous Features | Site Map


For FREE email updates, subscribe to the PHP Newsletter


Past Issues


print
Printer Friendly
bookmark
Bookmark
tell friend
Tell a Friend
forum
Forum
email
Email Editor


Content copyright © 2014 by Diane Cipollo. All rights reserved.
This content was written by Diane Cipollo. If you wish to use this content in any manner, you need written permission. Contact BellaOnline Administration for details.

g


g features
Archives | Site Map

forum
Forum
email
Contact

Past Issues
memberscenter


vote
Poetry
Daily
Weekly
Monthly
Less than Monthly



BellaOnline on Facebook
g


| About BellaOnline | Privacy Policy | Advertising | Become an Editor |
Website copyright © 2014 Minerva WebWorks LLC. All rights reserved.


BellaOnline Editor