public static function Helper::db__prepare_param in Anti Spam by CleanTalk 9.1.x

Same name and namespace in other branches

1. 8.4 src/lib/Cleantalk/Common/Helper.php \Cleantalk\Common\Helper::db__prepare_param()

Escapes MySQL params

Parameters

string|int $param:

string $quotes:

Return value

int|string

File

src/lib/Cleantalk/Common/Helper.php, line 1224

Class

Helper

CleanTalk Helper class. Compatible with any CMS.

Namespace

Cleantalk\Common

Code

public static function db__prepare_param($param, $quotes = '\'') {
  if (is_array($param)) {
    foreach ($param as &$par) {
      $par = self::db__prepare_param($par);
    }
  }
  switch (true) {
    case is_numeric($param):
      $param = intval($param);
      break;
    case is_string($param) && strtolower($param) == 'null':
      $param = 'NULL';
      break;
    case is_string($param):
      global $wpdb;
      $param = $quotes . $wpdb
        ->_real_escape($param) . $quotes;
      break;
  }
  return $param;
}