Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Get the page-url (made with page-module) with entry ID?

September 03, 2012 4:07am

Subscribe [1]

#1 / Sep 03, 2012 4:07am

Sander @ Silo
5 posts

I’ve been searching for this quite a while now. In my head it sounds extremely easy, but I just can’t seem to get it done.

For a couple of reasons (the structure of the menu is quite complicated) I’m using PHP to create a menu. I get the values from the DB directly. For now I have the list of titles I need to show with the corresponding Entry ID’s. All these ID’s have been made with the Pages Module and have their own URL. I just want to know how I can get these URLS?

I can’t seem to find them in the DB either..? Am I just missing something simple, or am I doing something that can’t be done that easily?

Any help/tips greatly appreciated!
#2 / Sep 05, 2012 12:27pm

Dan Decker
7338 posts

Hi Sander @ Silo,

The information you seek is in exp_sites under the site_pages column.

You need to know that the pages are stored as a base64 encoded serialized PHP array. You’ll need to decode then unserialize the array to make use of it.

Hope that helps!

Cheers,