title: How to solve "Call to undefined function AES_ENCRYPT" MySQL data array
body: <p>I am trying to add AES_ENCRYPT to Joomla component. </p>
  
  <p>Original MySQL is this (without encryption):</p>
  
  <pre><code>$db = JFactory::getDbo();
  // datetime
  $date_publish = date('Y-m-d H:i:s');
  
  $query = $db-&gt;getQuery(true);
  // Insert columns.
  $columns = array('category_name', 'category_description', 'status', 'created_date');
  $values = array(
      $db-&gt;quote($name), 
      $db-&gt;quote($description), 
      $db-&gt;quote($status) , 
      $db-&gt;quote($date_publish)
  );
  
  // Prepare the insert query.
  $query-&gt;insert($db-&gt;quoteName('#__group_categories'))
          -&gt;columns($db-&gt;quoteName($columns))
          -&gt;values(implode(',', $values));
  
  $db-&gt;setQuery($query);
  $db-&gt;execute();
  </code></pre>
  
  <p>I have modified it with <strong>AES_ENCRYPT</strong>: </p>
  
  <pre><code>$values = array(
      AES_ENCRYPT($db-&gt;quote($name), '12345'), 
      $db-&gt;quote($description), 
      $db-&gt;quote($status) , 
      $db-&gt;quote($date_publish)
  );
  </code></pre>
  
  <p>But when run the code: It was given this error: (Fatal error: Call to undefined function AES_ENCRYPT())</p>
  
  <p>can someone please help me, thank you...</p>