Hi there,
I was wondering, is there any way to pull data from an external database and display the content of the fields in a CP ?
Or do i have to use own .php scripts to solve this ?
Pulling data from external database ?
Pulling data from external database ?
"I have a rude thought every 5 seconds. Thank God i'm a slow typer"
- Oliver Georgi
- Site Admin
- Posts: 9892
- Joined: Fri 3. Oct 2003, 22:22
- Contact:
Re: Pulling data from external database ?
In general it is better to use custom a script based on phpwcms's framework features. I implement complex applications via frontend init/render by using functions like
Code: Select all
$mydata = _dbGet('mytable', '*', 'id='.$myid, 'fieldToBeGroupedBy', 'fieldToBeSortedBy', 10);
Re: Pulling data from external database ?
Thank you for your reply Oliver.
Until now i actually used external scripts to pull data into the CP.
But if i do understand you creect, it would be possible to create my own CP with de required fileds allready included ?
If that is right, i will give it a try for sure.
Until now i actually used external scripts to pull data into the CP.
But if i do understand you creect, it would be possible to create my own CP with de required fileds allready included ?
If that is right, i will give it a try for sure.
"I have a rude thought every 5 seconds. Thank God i'm a slow typer"
- Oliver Georgi
- Site Admin
- Posts: 9892
- Joined: Fri 3. Oct 2003, 22:22
- Contact:
Re: Pulling data from external database ?
Yes, you can write your own module which integrates functionality very close into phpwcms including search support, content part. Or use just frontend render script to inject the phpwcms rendering process by using existing functions, db connection and so on.