<?php
$clientNumber = '100';
$supportNumber = '22123322';
$countryCode = 'GB';
$db = new mysqli('dbmaster', 'user', 'pass', 'dbname');
$existingResult = $db->query(sprintf(
"SELECT `id` FROM `calls_queue` WHERE `client_number` = '%s' AND `support_number` = '%s' AND `status` = 0",
$clientNumber,
$supportNumber
));
if ($existingResult && $existingResult->num_rows) {
$call = $existingResult->fetch_assoc();
$result = $db->query(sprintf("UPDATE `calls_queue` SET `calls` = `calls` + 1 WHERE `id` = %d", $call['id']));
} else {
$result = $db->query(sprintf(
"INSERT INTO `calls_queue` (`client_number`, `support_number`, `country_code`, `calls`) VALUES ('%s', '%s', '%s', 1)",
$clientNumber, $supportNumber, $countryCode
));
}
preferences:
53.07 ms | 402 KiB | 5 Q