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
How To Exclude Subpages from Navigation
Dec 24, 2022

How to exclude subpages from navigation - useful for a news or blog link in your main navigation where you don't want all the subpages to appear in a drop down menu.

How Can I Change The Maximum Size Of Uploaded files
Dec 13, 2022

This tutorial explains how to update your php settings.

Updating Concrete Themes from Version 8 to Version 9
Nov 24, 2022

This tutorial covers commonly encountered issues when upgrading a Concrete CMS theme from version 8 to version 9

Transferring ownership of an add-on and a theme
Nov 15, 2022
By katzueno.

If you encounter a Concrete CMS add-on or theme that you love but not being maintained, you may want to ask the author to help or take over the add-on or theme. Here is the quick step-by-step guide of how to transfer the ownership.

How to update Add-Ons if not on the Update Add-Ons Menu item
Jul 4, 2022

How to manually download an add-on and update it when your site's core versions isn't considered compatible with the add-on version.

Generate a report with author information and form summaries in Concrete CMS.
May 9, 2022

In Concrete CMS, you can use a form to initiate contact between logged-in users and then create helpful reports. After form submissions are collected, they can be searched, sorted, and exported as a spreadsheet. This tutorial will detail how to add author information to a report using the advanced search.

Was this information useful?
Thank you for your feedback.