wpdb::escape PHP Method

escape() public method

Use esc_sql() or wpdb::prepare() instead.
See also: wpdb::prepare()
See also: esc_sql()
Deprecation: 3.6.0
Since: 0.71
public escape ( mixed $data ) : mixed
$data mixed
return mixed
    public function escape($data)
    {
        if (func_num_args() === 1 && function_exists('_deprecated_function')) {
            _deprecated_function(__METHOD__, '3.6', 'wpdb::prepare() or esc_sql()');
        }
        if (is_array($data)) {
            foreach ($data as $k => $v) {
                if (is_array($v)) {
                    $data[$k] = $this->escape($v, 'recursive');
                } else {
                    $data[$k] = $this->_weak_escape($v, 'internal');
                }
            }
        } else {
            $data = $this->_weak_escape($data, 'internal');
        }
        return $data;
    }

Usage Example

Example #1
0
 function update($data)
 {
     global $wpdb;
     $version = wpdb::escape($data['version']);
     $reason = wpdb::escape($data['reason']);
     $hits = intval($data['hits']);
     $created_at = date('Y-m-d H:i:s', mktime(0, 0, 0, intval($data['month']), intval($data['day']), intval($data['year'])));
     $wpdb->query("UPDATE {$wpdb->prefix}drainhole_version SET version='{$version}', hits='{$hits}', created_at='{$created_at}', reason='{$reason}' WHERE id='{$this->id}'");
 }
All Usage Examples Of wpdb::escape