- $r = q("UPDATE `session`
- SET `data` = '%s'
- WHERE `data` != '%s' AND `sid` = '%s'",
- dbesc($data), dbesc($data), dbesc($id));
-
- $r = q("UPDATE `session`
- SET `expire` = '%s'
- WHERE `expire` != '%s' AND `sid` = '%s'",
- dbesc($expire), dbesc($expire), dbesc($id));
- } else
- $r = q("INSERT INTO `session`
- SET `sid` = '%s', `expire` = '%s', `data` = '%s'",
- dbesc($id), dbesc($default_expire), dbesc($data));
+ $fields = ['data' => $data, 'expire' => $expire];
+ $condition = ["`sid` = ? AND (`data` != ? OR `expire` != ?)", $id, $data, $expire];
+ dba::update('session', $fields, $condition);
+ } else {
+ $fields = ['sid' => $id, 'expire' => $default_expire, 'data' => $data];
+ dba::insert('session', $fields);
+ }