Query Custom Post Type posts by Keyword/url slug

You can use the name parameter in your arguments ex:

<?php 
$args = array(
  'post_type' => 'product',
  'posts_per_page' => 12,
  'name' => 'slug'
);

but this will only match the post with that same slug.

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)