<?php
	$user = "root";
	$password = "";
	$name = "%o%";
	try{
		$conn = new PDO('mysql:host=localhost;dbname=test_db',$user,$password);
		$query = "SELECT * FROM `test_table` WHERE `name` like :name";
		$stmt = $conn->prepare($query);
		$stmt->bindParam(':name',$name);
		$stmt->execute();
		$stmt->setFetchMode(PDO::FETCH_ASSOC);
		$data = $stmt->fetchALl();
		echo "<pre>";
		var_dump($data);
		echo "</pre>";
	}
	catch(PDOException $e){
		echo "Error in PDO: ".$e->getMessage()."<br>";
		die();
	}
?>