@ 2013-08-20T15:32:06Z <?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
));
}
Enable javascript to submit You have javascript disabled. You will not be able to edit any code.
Output for 8.0.0 - 8.0.30 , 8.1.0 - 8.1.28 , 8.2.0 - 8.2.18 , 8.3.0 - 8.3.6 Fatal error: Uncaught Error: Class "mysqli" not found in /in/oMUS4:7
Stack trace:
#0 {main}
thrown in /in/oMUS4 on line 7
Process exited with code 255 . Output for 7.0.0 - 7.0.33 , 7.1.0 - 7.1.33 , 7.2.0 - 7.2.33 , 7.3.0 - 7.3.33 , 7.4.0 - 7.4.33 Fatal error: Uncaught Error: Class 'mysqli' not found in /in/oMUS4:7
Stack trace:
#0 {main}
thrown in /in/oMUS4 on line 7
Process exited with code 255 . Output for 5.0.0 - 5.0.5 , 5.1.0 - 5.1.6 , 5.2.0 - 5.2.17 , 5.3.0 - 5.3.29 , 5.4.0 - 5.4.45 , 5.5.0 - 5.5.38 , 5.6.0 - 5.6.40 Fatal error: Class 'mysqli' not found in /in/oMUS4 on line 7
Process exited with code 255 . Output for 4.3.2 - 4.3.11 , 4.4.0 - 4.4.9 Fatal error: Cannot instantiate non-existent class: mysqli in /in/oMUS4 on line 7
Process exited with code 255 . Output for 4.3.0 - 4.3.1 Fatal error: Cannot instantiate non-existent class: mysqli in /in/oMUS4 on line 7
preferences:dark mode live preview
312.66 ms | 401 KiB | 457 Q