PHP Classes

PHP jQuery UI MySQL Accordion: Show master detail MySQL records using accordion

Recommend this page to a friend!
     
  Info   View files Example   View files View files (4)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 51%Total: 496 All time: 5,847 This week: 455Up
Version License PHP version Categories
mysql-accordion 1Artistic License3.0HTML, PHP 5, Databases
Description 

Author

Neda Divbandi

This class can show master detail MySQL records using accordion.

It queries a given MySQL master table to retrieve a list of records to be viewed in detail using a second query to a detail record table.

The class generates HTML with JavaScript using jQuery UI components to display the master record results using accordion components to expand and view detail table records.

Innovation Award
PHP Programming Innovation award nominee
September 2014
Number 3

Prize: One downloadable copy of PhpED Professional		 Often applications need to display listings of records retrieved from databases that have more detailed information in related records.

This class can display MySQL master-detail records using jQuery accordion to expand detail views.

Manuel Lemos
Picture of Neda Divbandi
Name: Neda Divbandi <contact>
Classes: 2 packages by
Country: Iran Iran
Age: ???
All time rank: 250541 in Iran Iran
Week rank: 360 Up7 in Iran Iran Up
Innovation award
Innovation award
Nominee: 1x

Example

<?php
  include 'class.uiFeatures.php';




   
if(isset($_POST['gettmasterName'])){
           $ui = new uiFeatures('localhost', 'root', '', 'onlineexam');
    $result=$ui->createAccordian(
        array('table' => $_POST['gettmasterName'], 'title' => $_POST['gettmasterField'], 'PK' => $_POST['gettmasterpk'])
       ,array('table' => $_POST['gettdetailName'], 'title' => $_POST['gettdetailField'], 'FK' => $_POST['gettdetailFK']));
    echo $result;
          
}


?>


  Files folder image Files  
File Role Description
Accessible without login HTML file accordion.html Output html example
Accessible without login Plain text file ajax.php Example ajax File
Plain text file class.uiFeatures.php Class class main source
Accessible without login Plain text file index.php Aux. index page

Downloadmysql-accordion-2014-08-26.zip 3KB
Downloadmysql-accordion-2014-08-26.tar.gz
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:496
This week:0
All time:5,847
This week:455Up
User Ratings User Comments (1)
 All time
Utility:75%StarStarStarStar
Consistency:66%StarStarStarStar
Documentation:-
Examples:75%StarStarStarStar
Tests:-
Videos:-
Overall:51%StarStarStar
Rank:2502
 
very interested package my dear Fellow ;)
9 years ago (pooya sabramooz)		70%StarStarStarStar
 

  Applications that use this package  
No pages of applications that use this class were specified.

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