Pages to Table
3rd Party (Free)Download v1.0.1
EE Version Support
- ExpressionEngine 2
If an item is crossed out, it might be untested, not applicable or incompatible. Contact the developer to be sure.
- Multi Site Manager
- Stand Alone Entry Form
- Low Variables
- Content Elements
- Better Workflow
- jQuery for the Control Panel
Takes your serialized and encoded pages URI and combines the page id and page title in a seperate table to make that information easier to use. This extends the Pages and Structure Module.
Pages to Tables
Pages to Tables takes the custom uri’s that you create with the pages module and places them in to their own database for easier access.
You simply query the table to get the information you need:
$query = $this->EE->db->query(“SELECT * FROM exp_ptt_site_pages”);
The pages module encodes and serializes the pages information which seems to complicate some things, so to make it easier to work with, we came up with this solution. The way the data is store originally is like similar to this:
Which translates to:
Array (  => Array ( [uris] => Array (  => /employment  => /employment/application  => /current-students  => /faculty-staff  => /faculty-staff/central-store  => /faculty-staff/central-store/receiving  => /faculty-staff/central-store/surplus-property  => /faculty-staff/central-store/invoice-audit  => /faculty-staff/central-store/purchasing
All this extension does is make it easier to get the data you would like from a database instead of a serialized and encoded array.
Upload the pages_to_tables folder to your expressionengine third_party folder. After it’s uploaded, browse to your extensions directory and click ‘enable’.
Hooks used: entry_submission_end
After every entry and update, the table is erased and rewritten. This works with the pages module and structure, I haven’t tried anything else.
Download Pages to Table
|EE Support||Downloads||Add-On Version||Release Date|
|Not Specified||Download||1.0.1||Aug 22, 2013|
If the add-on is an extension, and ties into ExpressionEngine's core files, it will use ExpressionEngine hooks. We are listing any hooks the add-on uses for developers to have an easier time locating other add-ons that they can reference for their own work.
This entry was created August 22, 2013, 1:05 pm.
This entry was last updated August 22, 2013, 1:50 pm.
Disclaimer: Information about ExpressionEngine add-ons is provided as a service to you, the user, and every member of the ExpressionEngine community. devot:ee is not responsible if you hose, mangle, wreck, or otherwise destroy your EE website by installing an add-on that you found out about at this site, regardless of its rating, Favorites status, commercial or free status, or general popularity. Caveat EEmptor!
Returns: devot:ee has a 30-day return policy on all commercial add-ons sold through devot-ee.com. If you need to return an add-on, do not go to the developer or the developer's site, but rather visit our returns page at https://devot-ee.com/returns to initiate your return. If you have questions, email firstname.lastname@example.org.
There are no reviews for this add-on yet.
What are you waiting for? Rate it and review it!