provisioning Provisioning - Posting customfields to external DB

[Jeronk]

Good day,

 

I require assistance with custom fields,

 

I need to pass 4 custom fields inputs to an external database,

 

array(
            '$params[‘customfields’][‘Username’]',
            '$params[‘customfields’][‘Email’]',
            '$params[‘customfields’][‘Cellphone Number’]',
            '$params[‘customfields’][‘Password’]',            
       );
   

how do I use the above custom fields in a SQL query?

 

Any assistance would be greatly appreciated, thanks.

[steven99]

Would best to use PDO mysql with prepare function so it does sanitation but a simple insert query would be:

Insert into TableNAME ("Username","Email","etc") values($params[‘customfields’][‘Username’], $params[‘customfields’][‘Email’], $params[‘customfields’][‘etc’]);