- var_dump: documentation ( source)
- serialize: documentation ( source)
- sprintf: documentation ( source)
<?php
$URL = 'bloppety';
$paramArr = array('A' => 'b');
$query = sprintf("
INSERT INTO `spooler`.`tasks`
SET
`url` = '%s',
`serialized_params` = '%s',
`rtlo` = %d,
`product` = 'sharedsignup',
`created` = NOW(),
`next_attempt` = NOW()
",
mysql_real_escape_string($URL),
mysql_real_escape_string(serialize($paramArr)),
$rtlo
);
var_dump($query);