强大的通用php数据库操作类

------------------------------------------------------------------------------- Top - Requirements - Introduction - Installation - Setup script - Configuration Transformations - FAQ - Developers - Credits - Translators ------------------------------------------------------------------------------- phpMyAdmin 2.8.0.3 Documentation * SourceForge phpMyAdmin project page [ http://www.phpmyadmin.net/ ] * Local documents: + Version history: ChangeLog + General notes: README + License: LICENSE * Documentation version: $Id: Documentation.html,v 2.205.2.11.2.9 2006/04/06 12:40:28 lem9 Exp $ Requirements * PHP + You need PHP 4.1.0 or newer, with session support (*) + You need GD2 support in PHP to display inline thumbnails of JPEGs ("image/jpeg: inline") with their original aspect ratio + You need PHP 4.3.0 or newer to use the "text/plain: external" MIME-based transformation * MySQL 3.23.32 or newer (details); * Not really a requirement but a strong suggestion: if you are using the "cookie" authentication method, having the mcrypt PHP extension on your web server accelerates not only the login phase but every other action that you do in phpMyAdmin. * a web-browser (doh!). Introduction phpMyAdmin can manage a whole MySQL server (needs a super-user) as well as a single database. To accomplish the latter you'll need a properly set up MySQL user who can read/write only the desired database. It's up to you to look up the appropriate part in the MySQL manual. Currently phpMyAdmin can: * easily browse through databases and tables * create, copy, rename, alter and drop databases * create, copy, rename, alter and drop tables * do table maintenance * add, edit and drop fields * execute any SQL-statement, even multiple queries * create, alter and drop indexes * load text files into tables * create (*) and read dumps of tables or databases * export (*) data to SQL, CSV, XML, Word, Excel, PDF and Latex formats * administer multiple servers * manage MySQL users and privileges * check server settings and runtime information with configuration hints * check referential integrity in MyISAM tables * using Query-by-example (QBE), create complex queries automatically connecting required tables * create PDF graphics of your Database layout * search globally in a database or a subset of it * transform stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link * support InnoDB tables and foreign keys (see FAQ 3.6) * support mysqli, the improved MySQL extension (see FAQ 1.17) * communicate in 50 different languages (*) phpMyAdmin can compress (Zip, GZip -RFC 1952- or Bzip2 formats) dumps and CSV exports if you use PHP4 >= 4.0.4 with Zlib support (--with-zlib) and/or Bzip2 support (--with-bz2). Installation NOTE: phpMyAdmin does not apply any special security methods to the MySQL database server. It is still the system administrator's job to grant permissions on the MySQL databases properly. phpMyAdmin's "Privileges" page can be used for this. Warning for Mac users:if you are on a MacOS version before OS X, StuffIt unstuffs with Mac formats. So you'll have to resave as in BBEdit to Unix style ALL phpMyAdmin scripts before uploading them to your server, as PHP seems not to like Mac-style end of lines character ("\r"). Quick Install 1. Untar or unzip the distribution (be sure to unzip the subdirectories): tar -xzvf phpMyAdmin_x.x.x.tar.gz in your webserver's document root. If you don't have direct access to your document root, put the files in a directory on your local machine, and, after step 3, transfer the directory on your web server using, for example, ftp. 2. Ensure that all the scripts have the appropriate owner (if PHP is running in safe mode, having some scripts with an owner different from the owner of other scripts will be a problem). See FAQ 4.2 and FAQ 1.26 for suggestions. 3. Create the file config.inc.php in the main (top-level) directory (the one that contains index.php). You can use setup script provided in distribution (scripts/setup.php) to create basics of config file. See Setup chapter for details. If you don't like setup or want to fine tune resulting configuration, open (or create in case of starting from scratch) config.inc.php in your favorite editor and fill in there values for host, user, password and authentication mode to fit your environment. Look at libraries/config.default.php how these fields should be defined. Here, "host" means the MySQL server. Have a look at Configuration section for an explanation of all values. Please also read the remaining of this Installation section for information about authentication modes and the linked-tables infrastructure. 4. If you are using the auth_type configuration directive, it is suggested that you protect the phpMyAdmin installation directory, for example with HTTP?AUTH in a .htaccess file. See the multi?user sub?section of this FAQ for additional information, especially FAQ 4.4. 5. Open the file <www.your-host.com>/<your-install-dir>/index.php in your browser. phpMyAdmin should now display a welcome screen and your databases, or a login dialog if using HTTP or cookie authentication mode. 6. You should deny access to the libraries subfolder in your webserver configuration. For Apache you can use supplied .htaccess file in that folder, for other webservers, you should configure this yourself. Such configuration prevents from possible path exposure and cross side scripting vulnerabilities that might happen to be found in that code. Setup script usage Since 2.8.0 phpMyAdmin comes with a setup script that can help you with creating configuration. This script is located in scripts folder: scripts/ setup.php. Its usage is quite simple. You follow the dialogs and this script prepares in memory the configuration directives. You then have two choices for saving the configuration file: 1. Download it to your local workstation, then upload (for example with ftp) to your main phpMyAdmin directory. In this case, you don't have to prepare a special config directory, so no further actions are necessary. 2. Save the file to your webserver into config directory. For saving file on webserver, or loading previous configuration you have to create config directory in phpMyAdmin's top level directory and make it writable to web server. For loading previous configuration, place it there (and make sure it has write permissions for webserver). On a Linux/UNIX server you can use the following commands: cd phpMyAdmin mkdir config # create directory for saving chmod o+rw config # give it world writable permissions # if you want to edit existing configuration: cp config.inc.php config/ # copy current configuration chmod o+w config/config.inc.php # give it world writable permissions On a Windows system, create a config in the main phpMyAdmin directory and ensure that your web server has read/write access to it. FAQ 1.26 can help you about this. If you already have an existing config.inc.php in your main directory, copy it to the newly created config directory. Then you can open scripts/setup.php in your browser and perform setup. After saving your configuration move generated configuration to top level directory and delete created config directory. Do not forget to remove world write permissions on config.inc.php! Please note that it does not allow to configure everything, so for some additional features you still need to manually edit the configuration file. Linked-tables infrastructure For a whole set of new features (bookmarks, comments, SQL-history, PDF-generation, field contents transformation, etc.) you nee