Login   Register  
PHP Classes

Browse Edit: Browse and edit MySQL results like MS Access

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us

  Author Author  
Picture of Peter Rosomoff
Name: Peter Rosomoff <e-mail contact>
Packages: 1 Browse all classes by Peter Rosomoff Browse all classes by
Country: United States United States - PHP jobs in United States
Age: ???
All time rank: 23827 in United States United States
Week rank: 946 Down99 in United States United States Down
Innovation award
Innovation award
Nominee: 1x

Winner: 1x

  Detailed description   Download Download .zip .tar.gz  
This class displays results of sql statements in a browseable and editable format akin to a excel or Access. Easy, editable displays of columnar data.

Version 4.1 adds database abstraction via the PEAR DB class and in-class filtering methods. Please review the README. Including Multiple table SQL statements and identical field names has required some important modifications. The following features are included:

Columns have headers that allow sort order to be changed by clicking on them
Display may be editable or read only
SelectBox (drop down list)
Hideable columns
Editable title bar and footer allowing any html
Line numbers (optional)
Column title aliases
Validate entries withjavascript
Paging (optional)
Alternating row colors (optional)
Table formatting
Action columns for buttons, links and javascript
Javacript action on select radiobutton or checkbox
Sort order will reverse if column header is clicked again
Date or DateTime column format with drop down lists for Year, Month, Day, and Hour, Minute with complete integration to MySQL
Radio button or Checkbox select column
(NEW V3) script defined function columns
(NEW V3) dynamic selectBox values (this a read-only column)
(NEW V3) script defined column sequence
(NEW V3) row pre-selection
(NEW V3) sorting arrow path customization
(NEW V3) set character code
(NEW V3) adustable column and text input window size
(NEW V4) checkboxi, stores data as 1 and 0
(NEW V4) Alternate text on mouse hover on column headers
(NEW V4) Customizable background color for disabled fields
(NEW V4) In Class filtering function with <CTRL> click on column headers

  Classes of Peter Rosomoff  >  Browse Edit  >  Download Download .zip .tar.gz  >  Support forum Support forum (7)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: Browse Edit
Base name: browse_edit
Description: Browse and edit MySQL results like MS Access
Version: -
PHP version: -
License: GNU General Public License (GPL)
All time users: 9212 users
All time rank: 143
Week users: 2 users
Week rank: 1141 Down
  Groups   Screenshots Screenshots   Freshmeat project  
  Rate classes User ratings   Applications   Related links   Files Files  

Group folder image HTML HTML generation and processing View top rated classes
Group folder image Databases Database management, accessing and searching View top rated classes

  Files folder image Screenshots  
Multiple Tables
File Role Description
Accessible without login Image file multiTableSS.JPG Screen Multiple Tables
Accessible without login Image file searchSS.jpg Screen Searchable Display

  Innovation Award  
PHP Programming Innovation award winner
April 2004

Prize: One downloadable copy of PHPEd by NuSphere
Listing and editing information stored in databases is a very common use of Web based applications. Often there are pages for listing information and pages for editing, adding and deleting that information.

This packages provides a solution that attempts to provide an integrated interface for either listing and editing information stored in MySQL databases.

The attempt to provide a very similar way to access database information to what is provided by desktop database access applications like MS Access reflects an intention to make Web applications almost as practical as desktop applications.

Manuel Lemos

  Freshmeat project  
Project record: browse_edit
Popularity score: 30.72
Vitality score: 1.0

  User ratings  
RatingsUtility Consistency Documentation Examples Tests Videos Overall Rank
All time: Good (91.5%) Good (87.1%) Good (80.9%) Good (86.0%) - - Sufficient (71.2%) 165
Month: Not yet rated by the users

  Applications that use this class  
No application links were specified for this class.
Add link image If you know an application of this package, send a message to the author to add a link here.

  Related links  
Link Description
SortOrderArrowDown Graphic for sort order direction
SortOrderArrowUp Graphic arrows for sortorder direction

  Files folder image Files  
File Role Description
HTML file Readme.html Doc. Documentation
Plain text file simplest.php Example Simplest use of BrowseEdit
Image file arrow_plain_down.gif Icon Down arrow for column header
Image file arrow_plain_up.gif Icon Up arrow for column header
Plain text file BrowseEdit.php Class Class and helper functions
Plain text file complexInput.php Example Shows complex display/input features
Plain text file dbFunctions.inc Aux. PEAR DB helper functions
Plain text file example.sql Data Database for use with examples
Plain text file fileView.php Example Upload and view file from list
Plain text file formatFeatures.php Example Shows formatting features
Plain text file multiTable.php Example Shows multiple table display and update
Plain text file search.php Example Shows a searchable display
Plain text file simpleInputTypes.php Example Shows simple input/display features
Plain text file twoForm.php Example Shows a dual form display
Plain text file viewfile.php Example File viewing fileView.php

Download Download all files: browse_edit.tar.gz browse_edit.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.