PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
Copy Clear
Copy Format Clear
<?php $pdo->query("create table a (a int)"); $pdo->query("insert into a values (1),(11),(20)"); $searchQuery = 1; $searchQueryString = strval($searchQuery); $searchQueryFinal = "%$searchQueryString%"; echo $searchQueryString; $SearchQuerySQL = "SELECT * FROM a WHERE a LIKE ? "; $SearchQuerySTMT = $pdo->prepare($SearchQuerySQL); $SearchQuerySTMT->execute([$searchQueryFinal]); print_r($SearchQuerySTMT->fetchAll());
Show:  
Copy Clear