->whereAdd() (Previous) (Next) ->limit()
View this page in Last updated: Sun, 29 Jun 2008
English | Dutch | French | German | Hungarian | Japanese | Polish | Russian | Spanish | Plain HTML

->escape()

->escape() -- Escape a string for use with Like queries

Synopsis

void $DB_DataObject->escape (string $value)

Description

Similar to Pear DB's quote it will escape a value, without the quotes, so it can be used with a LIKE query.

Parameter

  • string $value - the string you want to escape

Note

This function can not be called statically.

Example

Example 39-1. Escaping a LIKE string


<?php
$person = new DataObjects_Person;
$person->whereAdd("name LIKE '%" . $person->escape("o'brian") . "%'");
$person->find();
?>

Example 39-2. Sample SQL

SELECT * FROM PERSON WHERE name LIKE '%o\'brian%'
->whereAdd() (Previous) (Next) ->limit()
Download Documentation Last updated: Sun, 29 Jun 2008
Do you think that something on this page is wrong? Please file a bug report or add a note.
User Notes:
There are no user contributed notes for this page.