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
<?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());