PHP Classes

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

Recommend this page to a friend!
     
  Info   Example   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 51%Total: 496 All time: 5,852 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
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 (4)  
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

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
Downloadmysql-accordion-2014-08-26.zip 3KB
Downloadmysql-accordion-2014-08-26.tar.gz 2KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:496
This week:0
All time:5,852
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:2521
 
very interested package my dear Fellow ;)
10 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.