cheat sheet for meekro DB

references: http://www.meekro.com/docs.php

Placeholder Variables

%sstring

%iinteger

%ddecimal/double

%ttimestamp (can be instance of DateTime or string accepted by strtotime)

%?any data type (including arrays) -- will automatically do the right thing

%sssearch string (string surrounded with % for use with LIKE)

%bbackticks (can be dangerous with user-supplied data -- BE CAREFUL)

%lliteral (no escaping or parsing of any kind -- BE CAREFUL)

%lslist of strings (array)

%lilist of integers

%ldlist of decimals/doubles

%ltlist of timestamps

%lblist of backticks (can be dangerous with user-supplied data -- BE CAREFUL)

%lllist of literals (no escaping or parsing of any kind -- BE CAREFUL)