WebsiteBaker Support (2.13.x) > General Help & Support

Read data from database with code module.

(1/1)

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: ---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;
--- End code ---

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.

Navigation

[0] Message Index