PHP Classes
elePHPant
Icontem

Browse Edit: Browse and edit MySQL results like MS Access

Recommend this page to a friend!
  Info   Screenshots Screenshots   View files View files (15)   DownloadInstall with Composer Download .zip   Reputation   Support forum (7)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2006-07-12 (10 years ago) RSS 2.0 feedStarStarStarStar 71%Total: 9,300 All time: 157 This week: 1,113Down
Version License Categories
browse_edit 1.0.0GNU General Publi...HTML, Databases
Description Author

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)
CheckBox
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
TextArea
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) MULTIPLE TABLE SELECT,UPDATE,DELETE
(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


Innovation Award
PHP Programming Innovation award winner
April 2004
Winner


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
Picture of Peter Rosomoff
Name: Peter Rosomoff <contact>
Classes: 1 package by
Country: United States United States
Innovation award
Innovation award
Nominee: 1x

Winner: 1x

Screenshots  
  • searchSS.jpg
  • multiTableSS.JPG
  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

 Version Control Unique User Downloads Download Rankings  
 0%
Total:9,300
This week:0
All time:157
This week:1,113Down
User Ratings User Comments (2)
 All time
Utility:91%StarStarStarStarStar
Consistency:87%StarStarStarStarStar
Documentation:80%StarStarStarStarStar
Examples:86%StarStarStarStarStar
Tests:-
Videos:-
Overall:71%StarStarStarStar
Rank:263
 
no DB.
8 years ago (allnet4u)
45%StarStarStar
Very useful utility, saved me quite a lot of time.
8 years ago (Terry Woods)
75%StarStarStarStar