andreia

<?php
$str = '13++56-461.79/27--14-abc';

$filter              = filter_var($str,FILTER_SANITIZE_NUMBER_INT);
$onlyDigitsFilterVar = str_replace(array('+', '-'), '', $filter);

$onlyDigitsRegexp1   = preg_replace('/[^\d]/', '', $str);
$onlyDigitsRegexp2   = preg_replace('/[^[:digit:]]/', '', $str); // http://www.php.net/manual/en/regexp.reference.character-classes.php

var_dump($filter);              // string(19) "13++56-4617927--14-"

andreia

SELECT TABLE_NAME FROM USER_TAB_COLUMNS 
WHERE COLUMN_NAME = 'ID' 

andreia

decode(trim(col),NULL,NULL,col) is NULL

-- http://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements005.htm 

-- Do not use null to represent a value of zero, because they are not equivalent.

-- Note: Oracle Database currently treats a character value with a length of zero as null. 
-- However, this may not continue to be true in future releases, and Oracle recommends that 
-- you do not treat empty strings the same as nulls.

andreia

<?php
$qs = Doctrine_Query::create()
      ->from('MyTable1 m')
      ->leftJoin('m.MyTable2 p');

$res = $qs->execute();
$qs->free();

andreia

<?php
$this->getUser()->shutdown(); 

andreia

select woeid from geo.places where text="brasília, df, brazil"

andreia

$ curl -u user:pass -d status='Hello from shell' http://twitter.com/statuses/update.xml

andreia

$ echo cmd | at 5am next year

andreia

<?php
// http://uk.php.net/manual/en/filter.filters.php

// validate
// http://uk.php.net/manual/en/filter.filters.validate.php
$var = filter_var($email, FILTER_VALIDATE_EMAIL);
$var = filter_var($code, FILTER_VALIDATE_INT); 

// sanitize
// http://uk.php.net/manual/en/filter.filters.sanitize.php

andreia

$ symfony plugin:install -r 0.9.3 sfFormI18nNumberPlugin