5.7 database insert/update

This tutorial is over a year old and may not apply to your version of Concrete CMS.
Nov 26, 2014
By ConcreteCMS for

insert:

$db = Loader::db();
$db->Execute(
   'INSERT INTO btArticles VALUES(?, ?, ?)',
    array(
         NULL,
         $newPage->getCollectionID(),
         $content
     )
);

update:

$db = Loader::db();
$table = 'table-name';
$data = array(
    'name' => 'John Smith',
    'phone' => '+17867867564',
);
$db->update($table, $data, array('id' => 17);
Recent Tutorials
Reusing the same Express entity in multiple associations
Apr 11, 2024
By myq.

How to create and manage multiple associations in Express

Express Form Styling
Apr 11, 2024
By myq.

Different ways to style Express forms

Setting addon/theme version compatibility in the marketplace
Jan 9, 2024

For developers worn out with setting the latest addon or theme version manually across too many core versions, here is a JavaScript bookmarklet to do it for you.

How to get the locale of a page
Jan 8, 2024
By wtfdesign.

Now, why don't we just have a getLocale() method on Page objects beats me, but here's how you work around it

Using a Redis Server
Jun 16, 2023
By mlocati.

How to configure Concrete to use one or more Redis servers to persist the cache.

Using the Concrete Migration Tool Addon
Apr 27, 2023

How to use the Concrete CMS Migration Tool

Improvements?

Let us know by posting here.