- implode: documentation ( source)
- printf: documentation ( source)
<?php
$insertColumns = ['method', 'uri', 'headers','message','customer_advert_ref', 'advert_id', 'organisation_id', 'body', 'type', 'ip'];
printf(
'INSERT INTO `Requests` (`%s`) VALUES (`:%s`);',
implode('`, `', $insertColumns),
implode('`, :`', $insertColumns)
);