PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table tbl1 ( id int, val varchar(64) ); insert into tbl1 values (1, 'Test1');
Copy Clear
Copy Format Clear
<?php $sql = "SELECT EXISTS(SELECT * FROM `tbl1` WHERE `val` = ? LIMIT 1)"; $stmt = mysqli_prepare($mysqli, $sql); mysqli_stmt_bind_param($stmt, "s", $value); $sqlResult = mysqli_stmt_execute($stmt); echo '$sqlResult: ' . $sqlResult . $br;
Show:  
Copy Clear