PHP Classes

DBNavigator: Browse and edit data stored in a MySQL database

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 57%Total: 6,762 All time: 300 This week: 131Up
Version License PHP version Categories
dbnavigator 1.0.0GNU General Publi...4.3Databases, Content management, AJAX
Description 

Author

Michele Castellucci

This package can be used to browse and edit data stored in a MySQL database.

It generates an AJAX Web based interface to edit, insert, search rows of MySQL database tables.

It can be used to update and delete multiple records at once. It may also prevent editing or deleting records by simultaneous users.

Each database table record to be edited can be bound to given form inputs. The main class can generate Javascript for browser side validation and also perform server side validation.

The class can handle submission of data in the form of files. Uploaded files are copied to specific folders, if the uploaded files not exist already.

The class and also list and search for records to be edited or deleted. Search fields support AJAX based auto-complete suggestions. Search results can be saved to CSV files or XML files for Excel/OpenOffice.

Search results are displayed with pagination links in tables with different colors or CSS styles for different rows. Search result columns can be linked to other pages.

Picture of Michele Castellucci
Name: Michele Castellucci <contact>
Classes: 4 packages by
Country: Italy Italy
Age: 40
All time rank: 2067 in Italy Italy
Week rank: 195 Up8 in Italy Italy Down

  Files folder image Files (55)  
File Role Description
Accessible without login Plain text file DBNavigator.php Class Main class
Accessible without login Plain text file DBNavigator.js Data Javascript class reflecting main PHP class for Ajax use
Accessible without login Plain text file autosuggest.js Data Javascript class for (google) suggest system
Accessible without login Plain text file zxml.js Data Create ajax connection
Accessible without login Plain text file HTMLForm.php Aux. Generate HTML forms
Plain text file PageNavigator.php Class Elements paginator
Plain text file functions.inc.php Aux. Some functions
Accessible without login Plain text file verimage.php Aux. Generate a CAPTCHA image
HTML file Adv_TextArea.html Doc.
Accessible without login HTML file DBNavigator.html Doc. Documentation of the class in ENGLISH / Italian, generated with PHPDoc!
HTML file HTMLPostProcessor.html Doc.
Plain text file important_changeme...7-11-18_version.txt Doc.
HTML file PageNavigator.html Doc.
HTML file TextEditorContainer.html Doc.
Plain text file Adv_TextArea.php Class
Image file asc_off.gif Data
Image file asc_on.gif Data
Image file camera_off.gif Data
Image file camera_on.gif Data
Accessible without login Image file csv.gif Icon Download CSV button image
Image file delete.png Icon Delete button image
Image file desc_off.gif Data
Image file desc_on.gif Data
Image file detail.gif Icon image for example script
Image file down.gif Data
Accessible without login Image file edit.png Icon Edit button image
Accessible without login Image file editMany.gif Icon Edit button image
Image file empty.gif Data
Accessible without login Plain text file example_full.php Example Example to demonstrate major features
Accessible without login Plain text file example_only_form.php Example Example to demonstrate minor features
Accessible without login Image file excel_xml.gif Icon Excel xml download icon image
Image file female.gif Data
Image file full.gif Data
Image file headerTD.jpg Icon Image needed by the example script
Plain text file HTMLForm.html Doc.
Plain text file HTMLPostProcessor.php Class
Accessible without login Image file loading.gif Icon Loading image
Image file male.gif Data
Accessible without login Image file new.gif Icon Insert button image
Accessible without login Image file next.gif Icon Next button
Image file prev.gif Icon Previous button
Accessible without login Image file print.gif Icon Print button
Accessible without login Image file puntini_orizz.png Icon Arrow
Image file small_users_1_photo_1.jpg Photo
Image file small_users_2_photo_1.jpg Photo
Image file small_users_4_attachment.jpg Photo
Plain text file style.css Data CSS for example script
Image file tab.gif Icon
Accessible without login Plain text file tables_for_DBNavigator_example.sql Data SQL dump for example
Accessible without login Image file TD.jpg Icon Image needed by the example script
Plain text file TextEditorContainer.php Class
Image file up.gif Data
Image file users_1_photo_1.jpg Photo
Image file users_2_photo_1.jpg Photo
Image file users_4_attachment.jpg Photo

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloaddbnavigator-2009-09-25.zip 350KB
Downloaddbnavigator-2009-09-25.tar.gz 337KB
Install with ComposerInstall with Composer
Needed packages  
Class DownloadWhy it is needed Dependency
HTMLForm Download .zip .tar.gz Class generate all his forms by HTMLForm Required
PageNavigator - generate navigation for listings Download .zip .tar.gz Class manage results pagination by PageNavigator Required
 Version Control Unique User Downloads Download Rankings  
 0%
Total:6,762
This week:0
All time:300
This week:131Up
User Ratings User Comments (2)
 All time
Utility:75%StarStarStarStar
Consistency:73%StarStarStarStar
Documentation:60%StarStarStarStar
Examples:66%StarStarStarStar
Tests:-
Videos:-
Overall:57%StarStarStar
Rank:1636
 
thanks
14 years ago (rajeshkumar)		80%StarStarStarStarStar
No English documentation, Cyrillic does not work in autosuggest.
16 years ago (Ivan On.)		47%StarStarStar
 

  Applications that use this package  
Registration to the site (also used strongly for CMS)
Browsing news list (also used strongly for CMS)
Registration to the site (also used strongly for CMS)
Search and browsing houses list (also used strongly for CMS)
Registration to the site newsletter (also used strongly for CMS)
Browsing for source code (also used for links,users,articles, on site registration page. also used strongly for CMS)
Browsing books catalogue (also used for CMS and shopping cart but it's in a reserved area)
Registration to the site (also used strongly for CMS)
Browsing articles list (also used for events and strongly for CMS)

Add link image If you know an application of this package, send a message to the author to add a link here.