Skip to content

Instantly share code, notes, and snippets.

@mathiasgrimm
Last active August 29, 2015 14:15
Show Gist options
  • Save mathiasgrimm/6d524862cf7ef0fa7f15 to your computer and use it in GitHub Desktop.
Save mathiasgrimm/6d524862cf7ef0fa7f15 to your computer and use it in GitHub Desktop.
and (
id like ?
or title like ?
or location like ?
or description like ?
or company_name like ?
or company_url like ?
)
";
$bind = [$q, $q, $q, $q, $q, $q];
//////////////////////////////////////
and (
id like :q
or title like :q
or location like :q
or description like :q
or company_name like :q
or company_url like :q
)
";
$bind = [':q' => $q];
//////////////////////////////////////
and (
id like :id
or title like :title
or location like :location
or description like :desciption
or company_name like :company_name
or company_url like :company_url
)
";
$bind = [
':id' => $id,
':title' => $title,
......
];
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment