phpMyEdit
instant MySQL table editor and code generator
Ondrej Jombik
Doug Hockinson
Copyright © 2002, 2003, 2004
Platon Software Development Group
Table of Contents
1.
Introduction
1.1.
Overview
1.2.
Features
1.3.
Requirements
2.
Installation
2.1.
Getting started
2.2.
Table selection
2.3.
ID selection
2.4.
Result script
3.
General options
3.1.
Database connection
3.2.
Unique key
3.3.
Common options
3.4.
Permission options
3.5.
Sorting
3.6.
Navigation
3.7.
Filters
3.8.
Triggers
3.9.
Logging user actions
3.10.
Languages
3.11.
CGI variables
3.12.
CSS classes policy
4.
Fields options
4.1.
Definition overview
4.2.
Basic options
4.3.
Booleans
4.4.
Input restrictions
4.5.
Output control
4.6.
URL linking
4.7.
SQL expressions
4.8.
TABs feature
4.9.
Options variability
5.
Extensions
5.1.
Overview
5.2.
phpMyEdit-slide
5.3.
phpMyEdit-report
5.4.
phpMyEdit-htmlarea
5.5.
phpMyEdit-calpopup
6.
Other information
6.1.
Authors and homepage
6.2.
License
6.3.
Support and feedback
6.4.
Mailinglist
6.5.
CVS access
List of Examples
3-1.
Database connection options
3-2.
Unique key definition
3-3.
Unique key type definition
3-4.
Setting up the page name
3-5.
Displayed records
3-6.
Multiple selections option
3-7.
Special page elements
3-8.
Images URL
3-9.
Turning off default execution
3-10.
Full permissions
3-11.
Full permissions without delete
3-12.
Read only permissions
3-13.
Sort field option
3-14.
Multiple sort fields
3-15.
Navigation possibilities
3-16.
Filter examples
3-17.
Select triggers
3-18.
Insert triggers
3-19.
Update triggers
3-20.
Delete triggers
3-21.
Logging
3-22.
Log table schema
3-23.
Languages selection
3-24.
CGI variables appending
3-25.
CGI variables overwriting
3-26.
Persistent CGI variables
3-27.
CSS class name schema
3-28.
CSS class name examples
4-1.
Basic field definition
4-2.
Field name examples
4-3.
Field guidance
4-4.
Filter selections
4-5.
Field display options
4-6.
Other display options
4-7.
Field CSS customization
4-8.
Required fields
4-9.
Field sorting
4-10.
Stripping tags
4-11.
Field escaping
4-12.
Simple input restriction
4-13.
Table lookup restriction
4-14.
Advanced table lookup
4-15.
Complex table lookup example
4-16.
Input restriction using additional values
4-17.
Cell attribute example
4-18.
Input field size
4-19.
Field sizes
4-20.
Textarea field height & width
4-21.
Character length limit
4-22.
Wrapping
4-23.
Print mask field definition
4-24.
Date mask field definitions
4-25.
Simple URL examples
4-26.
URL target example
4-27.
URL display example
4-28.
URL prefix and postfix
4-29.
Read SQL expressions
4-30.
Write SQL expressions
4-31.
Storing
NULL
instead of empty string
4-32.
Storing password's MD5 hash
4-33.
TAB definition
4-34.
Display options below the first TAB
4-35.
Turning TAB feature off
4-36.
Init without options variability
4-37.
Init with options variability
5-1.
htmlArea extension enabling
5-2.
htmlArea field enabling
5-3.
CalPopup javascript
5-4.
CalPopup javascript
5-5.
CalPopup extension enabling
5-6.
CalPopup field enabling
5-7.
CalPopup advanced field
Next
Introduction