PHPize Online / SQLize Online  /  SQLtest Online

<?php function uniquedoesexist($dbHandle, $tablename, $fieldname, $value) { $sql = 'SELECT EXISTS(SELECT * FROM `'.$tablename.'` WHERE `'.$fieldname.'` = ? LIMIT 1)'; $stmt = mysqli_prepare($dbHandle, $sql); mysqli_stmt_bind_param($stmt, 's',$value); mysqli_stmt_execute($stmt); mysqli_stmt_bind_result($stmt, $data); mysqli_stmt_fetch($stmt); echo '$sqlResult: ' . $data . PHP_EOL; return $data; } uniquedoesexist($mysqli, 'tbl1', 'val', 'Test1'); uniquedoesexist($mysqli, 'tbl1', 'val', 'Test11');