Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
create table tbl1 (
id int,
val varchar(64)
);
insert into tbl1 values (1, 'Test1');
select exists(select * from tbl1 where val = 'Test1');
<?php
function uniquedoesexist($dbHandle, $tablename, $fieldname, $value) {
$sql = '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_store_result($stmt);
$found = mysqli_stmt_num_rows($stmt);
echo "SqlResult for $value: " . $found . PHP_EOL;
return $found;
}
uniquedoesexist($mysqli, 'tbl1', 'val', 'Test1');
uniquedoesexist($mysqli, 'tbl1', 'val', 'Test11');