PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
Copy Clear
Copy Format Clear
<?php $dbh=$pdo; $dbh->query("create table tbl_name (title varchar(255))"); $dbh->query("insert into tbl_name values ('somestring')"); $somestring = 'somestring'; $sql = 'SELECT * FROM tbl_name WHERE title Like ":needle"'; $prep = $dbh->prepare($sql); $ret = $prep->execute(array(':needle' => '%'.$somestring.'%')); echo json_encode($prep->fetch()));
Show:  
Copy Clear