PHP Classes

LQueryBU: SQL and PHP business units

Recommend this page to a friend!
     
  Info   Screenshots   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 363 All time: 6,881 This week: 455Up
Version License PHP version Categories
lquerybu 1.0.11GNU Lesser Genera...5.0PHP 5, Databases, Templates
Description 

Author

Xavier Pérez

Light Query Business Unit

Performs SQL and PHP business units, all together, designed to avoid large DAOs, to increase preformance, better visibility and clarity, and improvement of development time.

The unit files may also contain PHP or SQL actions to execute PRE-QUERY, POST-QUERY and POST-RECORD, and PHP or SQL actions for successfull or unsuccessfull queries.

- Format pre-query variables, as conditions, limit, decoding, etc..
- Format post-query records, encoding, attaching subqueries, attaching functionalities, etc...
- Post query actions, successfull or unsuccessfull, SQL and PHP actions, suporting transactionality
- Autoformatting capabilities, titles, sizes, numbers, dates...


Picture of Xavier Pérez
  Performance   Level  
Name: Xavier Pérez is available for providing paid consulting. Contact Xavier Pérez .
Classes: 9 packages by
Country: Spain Spain
Age: ???
All time rank: 132727 in Spain Spain
Week rank: 195 Up7 in Spain Spain Up

Level 4 StarStarStarStar

 Innovation award
Innovation award
Nominee: 1x

Screenshots (7)  
  • Example6_1266012795334.png
  • DumpTrace_1264718951462.png
  • Example1_1264718370295.png
  • Example2-2_1264718403936.png
  • Example2_1264718389336.png
  • Example3_1264718422267.png
  • Example4_1264718432162.png
  Files folder image Files (58)  
File Role Description
Files folder imageLQueryBU (8 files, 3 directories)
Files folder imagewww (13 files, 1 directory)

  Files folder image Files (58)  /  LQueryBU  
File Role Description
Files folder imageexamples_db (1 directory)
Files folder imagequery_units (1 directory)
Files folder imagetemplates (4 files)
  Accessible without login Plain text file config.php Conf. Main config file
  Accessible without login Plain text file database.php Conf. Database configuration
  Plain text file LQueryBU.php Class Main class
  Plain text file LQueryBU_DB.php Class Main DB Wrapper Class
  Plain text file LQueryBU_DBI.php Class Database interface Class
  Plain text file LQueryBU_pi.php Aux. LQuery Loader for Codeginiter or Kohana
  Accessible without login Plain text file MANUAL.txt Doc. Manual
  Plain text file README.txt Doc. Other frameworks install

  Files folder image Files (58)  /  LQueryBU  /  examples_db  
File Role Description
Files folder imageworld_db (1 file)

  Files folder image Files (58)  /  LQueryBU  /  examples_db  /  world_db  
File Role Description
  Plain text file world.sql Data Example database for use in examples

  Files folder image Files (58)  /  LQueryBU  /  query_units  
File Role Description
Files folder imageexamples (2 directories)

  Files folder image Files (58)  /  LQueryBU  /  query_units  /  examples  
File Role Description
Files folder imagefunctions (2 files)
Files folder imageunits (6 files)

  Files folder image Files (58)  /  LQueryBU  /  query_units  /  examples  /  functions  
File Role Description
  Plain text file examplef1.php Example Example function
  Plain text file examplef2.php Example Example function

  Files folder image Files (58)  /  LQueryBU  /  query_units  /  examples  /  units  
File Role Description
  Plain text file getCities.php Example getCities Unit Example
  Plain text file getCity.php Example getCitty Unit Example
  Plain text file getCountries.php Example getCountries Unit Example
  Plain text file getCountryLanguages.php Example getCountryLanguages Unit Example
  Plain text file getCountryList.php Example getCountryList unit example
  Plain text file saveCity.php Example saveCity Unit Example

  Files folder image Files (58)  /  LQueryBU  /  templates  
File Role Description
  Plain text file paginationBar.phtml Example Example6 - pagination template
  Plain text file recordBar.phtml Example Example6 - record template
  Plain text file searchBar.phtml Example Example6 - search template
  Plain text file titleBar.phtml Example Example6 - title template

  Files folder image Files (58)  /  www  
File Role Description
Files folder imageLQueryBU (3 directories)
  Plain text file debugQuery.phtml Example Debugger template
  Plain text file editCity.phtml Example Example 5 - Record edit
  Plain text file example1.phtml Example Example1 template
  Plain text file example2.phtml Example Example2 template
  Plain text file example3.phtml Example Example3 template
  Plain text file example4.phtml Example Example4 template
  Plain text file example5.phtml Example Example 5 template
  Plain text file index.php Class Example index
  Plain text file NavVars.php Aux. Url values check class used in examples
  Plain text file recordBuild.php Example Record builder
  Plain text file recordBuild.phtml Example Example 6 template
  Plain text file rowgrid.phtml Example EditRecord template example
  Plain text file tablegrid.phtml Example TableGrid template Example

  Files folder image Files (58)  /  www  /  LQueryBU  
File Role Description
Files folder imagecss (2 files)
Files folder imageimages (13 files)
Files folder imagejs (2 files)

  Files folder image Files (58)  /  www  /  LQueryBU  /  css  
File Role Description
  Plain text file paginationLightBlue.css Example CSS Light Blue used in example6
  Plain text file recordLightBlue.css Example CSS Light Blue used in example6

  Files folder image Files (58)  /  www  /  LQueryBU  /  images  
File Role Description
  Image file blank.gif Icon Blank 1x1 image
  Image file close.png Icon Close search image
  Image file filter.gif Icon Search Filter image
  Image file first.png Icon Pagination first record
  Image file first_off.png Icon Pagination first record disabled
  Image file last.png Icon Last record image
  Image file last_off.png Icon Last record image disabled
  Image file next.png Icon Next record image
  Image file next_off.png Icon Next record image disabled
  Image file previous.png Icon Previous record image
  Image file previous_off.png Icon Previous record image disabled
  Image file sort_asc.gif Icon Sort ascending image
  Image file sort_desc.gif Icon Sort descending image

  Files folder image Files (58)  /  www  /  LQueryBU  /  js  
File Role Description
  Plain text file lqueryBase.js Example JS Base 64 encode used in Example6
  Plain text file lquerySearch.js Example JS Search used in Example6

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
Downloadlquerybu-2010-02-23.zip 387KB
Downloadlquerybu-2010-02-23.tar.gz
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:363
This week:0
All time:6,881
This week:455Up

  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.