<?php
/*
* @class simplenewsletter
* @author webserveis
* @web www.webserveis.com
* @email webserveis@gmail.com
* @copyright webserveis
* @date 07/02/2012
* @license GPL
* @usage
 
$NewsLetter = new SimpleNewsLetter('localhost','user','password','database');
$NewsLetter->createtable('Newsletter');
echo '';
if ($NewsLetter->addemail('prova@hotmail.com')) echo 'Insert'; else echo 'alredy exist';
echo '';
if ($NewsLetter->delEmail('prova@hotmail.com')) echo 'email eliminado'; else echo 'no se ha encotrado email';
if ($NewsLetter->addemail('prova@hotmail.com')) echo 'Insert'; else echo 'alredy exist';
if ($NewsLetter->addemail('prova@hotmail.com')) echo 'Insert'; else echo 'alredy exist';
if ($NewsLetter->addemail('prova2@hotmail.com')) echo 'Insert'; else echo 'alredy exist';
echo ''.$NewsLetter->listemails();
 
*/
 
class SimpleNewsLetter {
 
   private $DB_Link = '';
   private $DB;
   private $Table = '';
 
   public function __construct($host,$user,$pass,$dbname,$table='Newsletter') {
   /*
   * @call $var = new SimpleNewsLetter(@params);
   * @param string host: host del mysql server
   * @param string user: nom d'usuari del mysql server
   * @param string dbname: nom de la base de dades
   * @param string table: nom de la taula per ingresar els emails, per defecte 'newsletter'
   */
      $this->DB_Link = mysql_connect($host,$user,$pass);
      $this->DB = mysql_select_db($dbname, $this->DB_Link);
      $this->Table = $table;
   }
 
   public function __destruct() {
      mysql_close( $this->DB_Link );
   }
 
   public function createtable($table='Newsletter',$delete=false) {
   /*
   * @call $var->createtable(@params);
   * @param string table: nom de la taula, per defecte 'Newsletter'
   * @param bool delete: si es 'true' eliminara la taula existent, per defecte esta a 'false'
   */
      $this->Table = $table;
      $Sql = '';
      if ($delete) {
         $Sql = 'DROP TABLE IF EXISTS `' . $this->Table . '`;';
         $Result = mysql_query($Sql,$this->DB_Link);
      }
      $Sql = 'CREATE TABLE IF NOT EXISTS `' . $this->Table . '` (`Id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,`Email` VARCHAR( 256 ) NOT NULL ,UNIQUE (`Email`)) ENGINE = MYISAM CHARACTER SET utf8';
      $Result = mysql_query($Sql,$this->DB_Link);
      return $Result;
 
   }
 
   public function listemails($bracket=';') {
   /*
   * @call $var->listemails(@params);
   * @param string bracket: caracter separador entre emails, per defecte ';'
   * @return string: llista els emails
   */
      $ret = '';
      $Sql = 'SELECT Email FROM ' . $this->Table .';';
      $Result = mysql_query($Sql,$this->DB_Link);
      if ($Result)
      while( $row = mysql_fetch_assoc( $Result ) ){
         $ret .= $row['Email'] . $bracket;
      }
      return $ret;
   }
 
   public function addemail($email) {
   /*
   * @call $var->addemial(@params);
   * @param string email: email a insertar
   * @return : 'true' si sha pogut insertar, 'false' si ja existeix
   */
      $Sql = 'INSERT INTO ' . $this->Table . "(Email) VALUES ('" . $email ."') ;";
      $Result = mysql_query($Sql,$this->DB_Link);
      if (mysql_affected_rows($this->DB_Link) >= 1) return true; else return false;
   }
 
   public function delEmail($email) {
   /*
   * @call $var->delEmail(@params);
   * @param string email: email a eliminar
   * @return: 'true' i s'ha pogut eliminar, 'false' si no s'ha trobat en el llistat
   */
      $Sql = 'DELETE FROM ' . $this->Table . " WHERE Email='" . $email . "';";
      $Result = mysql_query($Sql,$this->DB_Link);
      if (mysql_affected_rows($this->DB_Link) >= 1) return true; else return false;
   }
 
}
?>

$NewsLetter = new SimpleNewsLetter('localhost','user','password','database');
$NewsLetter->createtable('Newsletter');
echo '<br />';
if ($NewsLetter->addemail('prova@hotmail.com')) echo 'Insert'; else echo 'alredy exist';
echo '<br />';
if ($NewsLetter->delEmail('prova@hotmail.com')) echo 'email eliminado'; else echo 'no se ha encotrado email';
if ($NewsLetter->addemail('prova@hotmail.com')) echo 'Insert'; else echo 'alredy exist';
if ($NewsLetter->addemail('prova@hotmail.com')) echo 'Insert'; else echo 'alredy exist';
if ($NewsLetter->addemail('prova2@hotmail.com')) echo 'Insert'; else echo 'alredy exist';
echo '<br />'.$NewsLetter->listemails();

function br2nl($string, $line_break=PHP_EOL) {
    $patterns = array("/(<br>|<br \/>|<br\/>)\s*/i","/(\r\n|\r|\n)/");
    $replacements = array(PHP_EOL,$line_break);
    $string = preg_replace($patterns, $replacements, $string);
    return $string;
}

echo br2nl($Texto)

$start = (isset($_GET['num']) && is_numeric($_GET['num']))? (int)$_GET['num']:die("Hacking Attempt!");

function TimeAgoEs($tm,$rcs = 0) {
	/*$tm = timeint
		strtotime("2011/01/14 23:10");
	*/
   $cur_tm = time(); $dif = $cur_tm-$tm;
   $pds = array('segundo','minuto','hora','dia','semana','mes','año','decada');
   $lngh = array(1,60,3600,86400,604800,2630880,31570560,315705600);
   for($v = sizeof($lngh)-1; ($v >= 0)&&(($no = $dif/$lngh[$v])<=1); $v--); if($v < 0) $v = 0; $_tm = $cur_tm-($dif%$lngh[$v]);
   $no = floor($no);
   if ($v == 5) $pds[$v] .='es'; elseif($no <> 1) $pds[$v] .='s'; $x=sprintf("%d %s ",$no,$pds[$v]);
   if(($rcs > 0)&&($v >= 1)&&(($cur_tm-$_tm) > 0)) $x .= TimeAgoEs($_tm, --$rcs);
   return $x;
}

echo TimeAgoEs(strtotime("2012-01-14 23:04:13"),0);
echo TimeAgoEs(strtotime("2012-01-14 23:04:13"),2);

function GetDateES($Fecha) {
   $a[1] = "Enero";$a[2] = "Febrero"; $a[3] = "Marzo"; $a[4] = "Abril"; $a[5] = "Mayo"; $a[6] = "Junio";    $a[7] = "Julio"; $a[8] = "Agosto";
   $a[9] = "Septiembre"; $a[10] = "Octubre"; $a[11] = "Noviembre"; $a[12] = "Diciembre";
   return date("d",strtotime($Fecha)) ." de " . $a[date("n",strtotime($Fecha))] . " de " . date("Y",strtotime($Fecha));
}

$Var_data = GetDateES(date("Y/m/d"));
echo $Var_data;

function SanitizeInputSQL($dirty_input) {
	if (get_magic_quotes_gpc()) $value = stripslashes($dirty_input);
	$value = mysql_real_escape_string($dirty_input);
	return $value;
}

$Var_password = SanitizeInputSQL($_POST['txt_password']);

function SanitizeInputXSS($dirty_input) {
	return htmlspecialchars(rawurldecode(trim($dirty_input)), ENT_QUOTES,'UTF-8');
}

$Var_nombre = SanitizeInputXSS($_POST['txt_nombre']);

function isValidEmailEx($email, $mx = false){   
  if(eregi("^([_a-z0-9-]+)(\.[_a-z0-9-]+)*@([a-z0-9-]+)(\.[a-z0-9-]+)*(\.[a-z]{2,4})$", $email))   
    if($mx){   
      list($username, $domain) = split("@", $email);   
      return getmxrr($domain, $mxrecords);   
    }else  
      return true;   
    else  
  return false;   
}

$Email = 'abc@dominio.com';
if (isValidEmailEx($Email)) echo 'email valido'; else echo 'email incorrecto';
if (isValidEmailEx($Email,true)) echo 'email valido y existente'; else echo 'email incorrecto o valido pero inexistente';

function isValidEmail($email){
	return eregi("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$", $email);
}

$Email = 'abc@dominio.com';
if (isValidEmail($Email)) echo 'email valido'; else echo 'email incorrecto';