WHERE
: LENGTH(nome) > 10
Posted by Felipe Pena on 30/04/2010, 18:40
Posted by Felipe Pena on 19/03/2010, 21:14
Posted by Felipe Pena on 03/03/2010, 20:25
UPDATE tabela SET campo = REPLACE(campo, 'http://www.urlvelha.com.br/uploads/', 'http://www.urlnova.com.br/uploads/') WHERE campo LIKE '%http://www.urlvelha.com.br/uploads/%'
Posted by Felipe Pena on 26/02/2010, 21:32
Posted by Felipe Pena on 26/02/2010, 19:35
function exibeFormPagina($id) { $sql = sprintf("SELECT * FROM pagina WHERE id= %d", $id); $exe = mysql_query($sql); if (mysql_num_rows($exe)) { $dados = mysql_fetch_assoc($exe); return 'O seu id é '. $id; } return ''; }
$id = isset($_GET['id']) ? $_GET['id'] : 0; $texto = exibeFormPagina($id);
Posted by Felipe Pena on 25/02/2010, 23:36
/public\s+(\w+(?:\s*:=\s*[^,]+)?(?:\s*,\s*\w+(?:\s*:=\s*[^,]+)?)*)/
Posted by Felipe Pena on 25/02/2010, 21:17
Posted by Felipe Pena on 25/02/2010, 21:04
preg_match("/public\s+(\w+(?:\s*:=\s*)?[^,]+(?:,\s*\w+(?:\s*:=\s*[^,]+)?)*)/", "public ca:=1,q,e,q:=0", $m); print_r(preg_split("/\s*,\s*/", $m[1]));
Posted by Felipe Pena on 08/12/2009, 12:57
SELECT nome, GROUP_CONCAT(valor_divida SEPARATOR '|') valor_divida FROM tabela GROUP BY nome
Posted by Felipe Pena on 05/12/2009, 15:40
Posted by Felipe Pena on 05/12/2009, 13:24
Posted by Felipe Pena on 05/12/2009, 12:56
<?php class teste { private $_nome; public function __construct($nome) { $this->_nome = $nome; } public function getNome() { return $this->_nome; } } session_start(); if (isset($_SESSION['user'])) { var_dump($_SESSION['user']->getNome()); unset($_SESSION['user']); } else { $_SESSION['user'] = new teste('Felipe'); }
Posted by Felipe Pena on 03/12/2009, 18:09
/([0-9]{2})<img src='http://forum.wmonline.com.br/public/style_emoticons/default/sad.gif' class='bbc_emoticon' alt=':(' />[0-9]{2})/
list($hora, $minutos) = explode(':', $str);
Posted by Felipe Pena on 03/12/2009, 14:06
Posted by Felipe Pena on 02/12/2009, 21:35
EXISTS (SELECT 1 FROM tags WHERE id_foto = fotos.id AND tag = 'TAG')
SELECT * FROM fotos WHERE EXISTS (SELECT 1 FROM tags WHERE id_foto = fotos.id AND FIND_IN_SET(tag, 'TAG1,TAG2'))
Community Forum Software by IP.Board
Licensed to: Webmasters Online