Escape the value with addcslashes:

$orConstraints = [];
$orConstraints[] = $query->like('productname',  '%' . addcslashes($name, '_%') . '%');
$orConstraints[] = $query->like('tradename','%' . addcslashes($name, '_%') . '%');