Read data from database with code module.

[netraam]

Hello everyone,

Is it possible to read data from the websitabaker database with the code module?
And if it is so, does someone have an example how to do it?

Thanks in advance
Maarten

[crnogorac081]

Write what you need from database ?

[sternchen8875]

take a look into the droplets and use echo (for a output) instead of return

for example this droplet for the last modified date from this page

Code: [Select]

global $database, $wb;
$retVal = ' ';
if (PAGE_ID > 0) {
    $query = $database->query("SELECT max(modified_when) FROM ".TABLE_PREFIX."pages");
    $mod_details = $query->fetchRow();
    $retVal = "This site was last modified on ".date("d/m/Y", $mod_details[0])." at ".date("H:i", $mod_details[0]).".";
}
echo $retVal;

[sternchen8875]

additional info

it is not possible, to work with a code-combination between PHP && HTML or with other words: you cannot use the open PHP-Tag <?php and the endtag ?> in this code module

if you need a mixed code, use the Code² module -> https://addon.WebsiteBaker.org/pages/en/browse-add-ons.php?id=0C49DE21

this code²-Module is a stand-alone-module, it's not needed, to uninstall the WB-intern Code-Module, to use the Code²-Module

[netraam]

It works,
Thanks for the info.