Introduction

Content Construction

Often have to lay out with joomla data in a database.
The most important case is when you want to redo a site written in native code (like php) where all items are in the database.
At other times, when you need to make a site that has so many products and their relevant technical data sheets, normally you create a new article, you paginate creating table with technical data, the photo aligned to the right, the description in an orange box etc. ... and then he does a great job of copying and pasting, a number equal to the product list, so that you have the right layout on all pages and from there you start to change your photo, description, technical data, etc. ...
While the ideal would be to create a single php page that is based on product id on the database to retrieve the data and then he lays out, in order to avoid redundancy (for example, write fifty times the html code to create the orange frame to the description ) and to save time that would have failed to change long sheets of hundreds of products!
Pager helps you do just that!
Whether you are the expert database management, and you do not know anything about SQL
By clicking the "documentation", below, you can see a video showing the component to work!
In practice you will have a text editor, such as for the creation of articles, where you can create a layout that is the same for all products.
In the right column you will have a tool to select or tables that will be exposed and filter the results with SELECT, LIMIT, ORDER, GROUP etc. ...
But how do I say that in the orange that I created in the editor there must be the column "description"? Simple, with the following syntax: [COL] description [/ COL]
(In html would look like something like: [COL] description [/ COL] )
Also we can make a JOIN between the various tables, so you can show such as the table "products" and related table "accessories" connected to the previous by a unique id.
If we make a JOIN problems may arise ... for example if a product has five accessories, Pager will show five times the description of the product spaced from the descriptions of the accessories.
So if in our layout there are two blocks, one for the product and one for the accessories must enclose the block of the product inside the tag [LIMIT], for example: [LIMIT] .... ... [/ LIMIT] ..... .
Pager also allows you to write custom SQL queries, making it virtually limitless!
If you have any doubts, questions, improvements or malfunction, do not hesitate to contact me!


Often have to lay out with joomla data in a database.
The most important case is when you want to redo a site written in native code (like php) where all items are in the database.
At other times, when you need to make a site that has so many products and their relevant technical data sheets, normally you create a new article, you paginate creating table with technical data, the photo aligned to the right, the description in an orange box etc. ... and then he does a great job of copying and pasting, a number equal to the product list, so that you have the right layout on all pages and from there you start to change your photo, description, technical data, etc. ...
While the ideal would be to create a single php page that is based on product id on the database to retrieve the data and then he lays out, in order to avoid redundancy (for example, write fifty times the html code to create the orange frame to the description ) and to save time that would have failed to change long sheets of hundreds of products!
Pager helps you do just that!
Whether you are the expert database management, and you do not know anything about SQL
By clicking the "documentation", below, you can see a video showing the component to work!
In practice you will have a text editor, such as for the creation of articles, where you can create a layout that is the same for all products.
In the right column you will have a tool to select or tables that will be exposed and filter the results with SELECT, LIMIT, ORDER, GROUP etc. ...
But how do I say that in the orange that I created in the editor there must be the column "description"? Simple, with the following syntax: [COL] description [/ COL]
(In html would look like something like: [COL] description [/ COL] )
Also we can make a JOIN between the various tables, so you can show such as the table "products" and related table "accessories" connected to the previous by a unique id.
If we make a JOIN problems may arise ... for example if a product has five accessories, Pager will show five times the description of the product spaced from the descriptions of the accessories.
So if in our layout there are two blocks, one for the product and one for the accessories must enclose the block of the product inside the tag [LIMIT], for example: [LIMIT] .... ... [/ LIMIT] ..... .
Pager also allows you to write custom SQL queries, making it virtually limitless!
If you have any doubts, questions, improvements or malfunction, do not hesitate to contact me!

Notice Board for Community builder
Free

Notice Board for Community builder

By Iacopo Guarneri
Community Builder extensions
Notice board is a plugin for Community builder that allows to add a personal message-board for each user (as a bulletin board) (from version 2.0 and the module can be operated without Community Builder). Notice board allows you to create your own post on your message-board, moreover, going on other members profiles, you can see what they wrote. Another feature of Notice board is the opportunity to...
Article Tool
Free

Article Tool

By Iacopo Guarneri
Articles Sharing
Article tool is a plugin for Joomla that allows you to add functions its your articles and K2 article. Among the possibilities that the plugin offers we can choose to show on each item buttons to print, download (PRO version), share and send email to the article. Article tools can show two different buttons for social sharing (facebook, twitter, linkedin, pinterest, google plus), the classic one a...
JCode
Free

JCode

By Iacopo Guarneri
Coding & Scripts Integration
Jcode is an extension that allows you to enter in Joomla any kind of code (html, javascript, css, php, ajax and joomla API) ! There are already many extensions that allow the insertion of codes into our articles but they have an “unnatural” approach in relation to programming concept; in fact they force the programmer to work within the backend. This limit exists because the various extension...
Photogallery for CB
Free

Photogallery for CB

By Iacopo Guarneri
Community Builder extensions
Photo gallery for Community Builder is an extension to allow each user to have and manage a personal image gallery. The front end has a nice and very intuitive interface, moreover, pointing the mouse on the icon there is a brief description about the function of the button. Photo gallery for Community Builder is organized by categories, user must first create a folder where images can be uploaded....
votes
Free

votes

By Iacopo Guarneri
Polls
Free Votes is an extension that will allow you to create massive surveys. A regular survey allows you to create a question with several answers so that users can select just one of these. With Free Votes you can create several questions combinable with various answers where users can give a rating to each answer! If for example you want to know about a certain topic, from one to ten, what users th...
Select to social
Paid download

Select to social

By Iacopo Guarneri
Social Share
Select to social lets you share pages and texts on your site easily and quickly. Whenever you select a text with the mouse Select to social creates a pop-up with icons (customizable by backend) of the most popular social networks. Selecting some of these icons, such as Twitter could share not only the current page but also the selected text. Among the icons available we twitter, facebook, google p...
Backup Database
Paid download

Backup Database

By Iacopo Guarneri
Site Security
Database backup is a simple but very useful extension. It often happens to make backups of the entire site, it means saving database and files on the server. Saving files on the server do not require many steps, once the computer has a properly configured FTP client: it is sufficient to connect and download. In some cases, saving a database requires several steps: * access to the site that offers...
JExport
Paid download

JExport

By Iacopo Guarneri
Data Import & Export
JExport is a component for Joomla that allows you to export the pages of the site in html. The export can be very long for large sites also must have privileges to create symlink, and change the maxnestinglevel and maxexecutiontime. Jexport can become very handy on those sites that do not have php installed, or the version is very old, or when the site is a landing page or page display so that doe...
Article Pager
Paid download

Article Pager

By Iacopo Guarneri
Coding & Scripts Integration
You often have to create pages in joomla conceptually similar, with a graphic layout same for all content. Take for example a section "book review" in our website. All pages will have for example the cover image at the top right, title, description, author, review, number of pages, price, publisher etc ... all laid out with certain fonts, certain colors, provisions etc .. . If this site it will ha...
Mobile content Slideshow
Paid download

Mobile content Slideshow

By Iacopo Guarneri
Slideshow
Mobile content Slideshow, is a module for joomla that allows you to have a slideshow of content that shrinks and displays it on mobile devices. The module fits into a Slideshow the latest articles of a category (you can choose from the backend) where they will be displayed title, the first characters of the content and background as the first image of the article. As in all the slideshows will be...
Mobile menu
Paid download

Mobile menu

By Iacopo Guarneri
Mobile Display
Mobile menu is a joomla module that allows a navigation for mobile devices with a few clicks. The use of this extension is very simple, just install it and turn it into a normal module and already work. Also the mobile menu, to facilitate the use, has few configurations, we can choose the color of the icon (black or white) and the resolution that the monitor will have to enable mobile viewing. Mob...
Map for K2
Paid download

Map for K2

By Iacopo Guarneri
K2 extensions
Map for K2 is a handy plugin for k2. In the backend of k2'll have to create two custom field of type text, relative to the city and the other for the address. Just then install the plugin in the backend and show him the names of these two fields. In the frontend if we open a view of k2 with the list of items, where within them will be shown the city and address, we will see next to a map of marker...
Search for K2
Free

Search for K2

By Iacopo Guarneri
K2 extensions
Search for K2 is a plugin for k2 very simple and intuitive to use. Search for K2 need to do a search of the articles in the frontend of k2. Once installed, the plugin will have to specify the custom form created in k2, which will be shown in the frontend into the search form. Once you activate the plugin in the frontend we can go into a view of k2 with a list of items, we will see at the top of th...
Secret text for kunena
Paid download

Secret text for kunena

By Iacopo Guarneri
Kunena extensions
Secret text for Kunena plugin is a simple to use with a single configuration. Basically you just need to install it. Secret text editor to insert Kunena button a padlock. Pressing this button will insert the tag in the user's post [secret]. The words contained within the tag secret text will be visible only to specific groups of users, you will be able to determine from the backend. Only users wit...
K2 for Cb
Paid download

K2 for Cb

By Iacopo Guarneri
Community Builder extensions
K2 for cb is a plugin for Community builder really easy to use. Once installed in the panel of community builder can edit the graphics settings for cb and k2 indicate the id of the category of k2 which will be included in the articles. For the category of k2 is advisable to create a new one, where we give permissions to users to create and edit their own articles. In this way the frontend, the pro...
Html 5 player
Paid download

Html 5 player

By Iacopo Guarneri
Multimedia Players
HTML 5 player is an audio and video player completely native, which does not use plagin as additional work in html 5. HTML 5 player is a plug-in with a very simple syntax to use just write [html5audio source="url"] or [html5video source="url"], where instead of url we can put one or more video separated by commas. The need to put more video is for compatibility, because every browser has the audio...
Profile Ranking for Community Builder
Paid download

Profile Ranking for Community Builder

By Iacopo Guarneri
Community Builder extensions
Profile Ranking for CB allows you to enter in each community profile builder two buttons and counters. These buttons resemble graphically the "like" and "do not like" social network, and have the same use. In fact, with the Profile Ranking for CB we can express our preference on a profile by voting positively or negatively the profile of a user. Each user can express a preference for maximum user,...
Forum Translator
Paid download

Forum Translator

By Iacopo Guarneri
Kunena extensions
Forum translator is a module that works with Kunena. This is a form so simple that it does not have configurations in the backend, just place it, activate it and use it. Forum translator also in the frontend is very simple for the user, it presents only a drop down menu where the user selects the language in which to read the post and within seconds everything will be translated. The technology us...
Search Source
Paid download

Search Source

By Iacopo Guarneri
Development
Search Source is a very useful tool for joomla administrators. Very useful to search through / inside / within the files on the server. Search Source is a backend extension with only one text field and two checkboxes. This extension allows to run a search within the site, both on the server files visible through an FTP client as well as on the database. Search Source will not run a simple search b...
We hate spam
Paid download

We hate spam

By Iacopo Guarneri
Site Security
We hate spam has finally managed to eliminate spam from my website. How does it work? simple! we hate spam blocking the spammer faster than I can to register! we hate spam is a plugin that is activated when the user registration and connects to the largest online database of collecting email addresses and ip of spammers. As soon as a user tries to register with the site we hate spam checks if the...

Pager

Version:
1.0
Developer:
Iacopo Guarneri
Last updated:
Jul 10 2023
8 months ago
Date added:
Nov 19 2014
License:
GPLv2 or later
Type:
Paid download
Includes:
c
Compatibility:
J3
Download

Uses Joomla! Update System