Display Products [Ordered] of Particular Designer after login

This will be your query

$designers= $rows['name'].' ('.$rows['id'].')';
$userbasedorder = $user_home->runQuery("SELECT * FROM order_details WHERE Designer=:designer");
$userbasedorder->execute(array(":designer"=>$designers));