(editor) force string to lowercase before writing to database

mdesign

Can anyone help me out ?
How would be the right syntax for formatting an string to lowercase before writing to database

i have this (shortened)

$db->sql('set names utf8');
$editor = Editor::inst(
$db, 'alle_post',
'alle_post.post_idn' /* Primary Key /
)
->fields(
Field::inst('alle_post.webx_idn'),
Field::inst('alle_post.post_nam'), / this should be lowercase */
);

$editor
->debug(true)
->process($_POST)
->json();

tangerine

Providing a custom formatter would be the logical approach.
https://editor.datatables.net/manual/php/formatters

mdesign

thank tangerine, but could you give me an example please. i don't get it.

colin

This example from this thread shows how to do it on the client (this is to upper case, but you'll get the idea).

This section of the manual shows how to create a formatter that tangerine mentioned on the server,

Colin

mdesign

thx colin, following your js bin example

editor.on( 'preSubmit', function (e, o, action) {
  if(action !== 'remove') {
    post_nam = o.data[Object.keys(o.data)].post_nam;
    o.data[Object.keys(o.data)].post_nam = post_nam.toUpperCase();
  }
});

but get an error:
Uncaught TypeError: Cannot read property 'toUpperCase' of undefine

colin

That would suggest post_nam isn't part of the data. Can you add console.log(o) at the start of the if clause, please, and report back,

Colin

allan

Probably easier to use a PHP for matter here:

Field::inst( 'status' )
    ->setFormatter( function ( $val, $data ) {
            return strtoupper( $val );
    } )

Allan

mdesign

great guys! alan's Solution did it within the lightbox-editing. how can i achieve this also within inline-editing ?

rf1234

The server side PHP code is identical for form editing and inline editing.

mdesign

thx, now it works. this was missing:
editField: 'alle_post.post_nam',