Database API and Security

I’m working on a controller that queries a table based on the value in a route parameter Example route path: path: ‘/path/{parameter}’ Controller: public function myFunction($parameter) { $connection = \Drupal::database(); $query = $connection->select(‘my_custom_table’, ‘mct’); $query->condition(‘mct.col’, $parameter, ‘=’); … $result = $query->execute(); $records = $result->fetchAll(); Is there any sanitization that should occur in this circumstance or…

How Update item on the second page in WebForm wizard Drupal 8

I am starting to work with webform in drupal 8 and I need to show values on the second page of the webform wizard, I have reviewed several solutions but I cannot do it. I tried using $ form_state-> setValue function webform_certificadoemail_webform_element_alter(array &$element, FormStateInterface $form_state, array $context) { if ($form_state->get(‘current_page’) == ‘preview’) { $value_entered =…

mysqltuner wants me to set join_buffer_size > 256.0M?

I have a 16GB dedicated server running 1 wordpress and 1 magento site! For the last month I have been trying to get mysql optimized! [root@server ~]# ./mysqltuner.pl MySQLTuner 1.7.19 – Major Hayden Bug reports, feature requests, and downloads at http://mysqltuner.com/ Run with ‘–help’ for additional options and output filtering [–] Skipped version check for…