13 in a dozen db class

Access MySQL servers and display queries in tables

This class could be utilized to gain entrance to Mysql database servers and show question brings about Html tables.

It can create database associations with a given Mysql host, recover server database qualified information, execute Sql questions, recover the embedded identifier by the final Insert question, get the amount of effected lines by an inquiry, get the amount of returned lines by an inquiry, get the amount of sections in a question effect set, recover question come about columns into shows or objects.

The class can additionally create Html tables to presentation inquiry result information or metadata about the question consequence sections.

 

Advertisements

Show pagination links for MySQL query results

This class could be utilized to show pagination connects for Mysql inquiry results.

It can take a given Mysql question and check the aggregate number of the outcomes so it can verify the Limit statement parameters to inquiry and show the present inquiry results page range.

The class can likewise create route connections to skim the different pages of the inquiry effects.

Download Files

Split MySQL query results in multiple pages

This is a modest class that might be utilized to part Mysql question brings about different pages. It takes as parameters a Sql question and the breaking point of records to show for every page.

The class can execute the question recovering just the lines that are for the present page. It can likewise create connections to peruse the pages on which the question effects are shown.

Download Files

Generate dynamically expandible hierarchic menu with Html

This class might be utilized to produce Html hierarchic menus that could be progressively stretched and given way upon client connection.

It utilizes settled unordered Html records within consolidation of Javascript produced by the class to assemble the menu components. In the event that Javascript is debilitated, the menu will show in unfolded structure.

The records are shown utilizing Css styles to modify the menu presentation.

A different class is supplied to cross the index framework and assembles a menu to go on the server record framework.

Download Files Here

Generate XHTML calendar for a given month or year

Dynamic Calendar is a class that produces timetables for a given month or year as a Html tables (Xhtml-Valid).

This class is dependent upon the Php local date capacities (default) and backs alternatively the Adodb Date Library. Underpinned dates (on frameworks utilizing a 32-bit marked number Unix time_t):

-Using Php local date capacities: 1902 -2037 (Unix) and 1971 -2037 (Windows)

-Using Adodb Date Library: 100 -3000 and later on both Unix and Windows

The generated calendars can:

– Be generated in plain format (without any links)
– Optionally have navigation controls
– Optionally have a date picker control
– Optionally have linkable days (url or javascript)
– Optionally have event days (layout) with event links
– Optionally have ‘event content’ with links and own layout
– Support different GMT zones for the current date calculation
– Support month and day names depending on your language
– The presentation may be configured using CSS
– Do not require Javascript to be displayed or navigated (server side)
– Can be generated with just 2 or 3 lines of code

Download Files Here