DZone Snippets: php code

PHP clean string for mysql

mvidberg () — Fri, 17 Feb 2006 09:48:15 GMT

// Function to clean up a string before using it in a mysql query



function clean_for_mysql($string,$max_length) {        

  $in_string = ltrim($string);       

  $in_string = rtrim($in_string);

  if (round($max_length) < 1) {  

    $max_length = 131072; // 128K

  }

  if (strlen($in_string) > $max_length) {

    $new_string = substr($in_string,0,$max_length);

  }

  $new_string = mysql_real_escape_string($new_string);

  return $new_string;

}

PHP filename bad character filter

mvidberg () — Fri, 17 Feb 2006 09:43:55 GMT

// Function to filter out bad characters in a given filename



function replace_bad_filename_chars($filename) {

  $filtered_filename = "";



  $patterns = array(

    "/\s/", # Whitespace

    "/\&/", # Ampersand

    "/\+/"  # Plus

  );

  $replacements = array(

    "_",   # Whitespace

    "and", # Ampersand

    "plus" # Plus

  );

  

  $filename = preg_replace($patterns,$replacements,$filename);

  for ($i=0;$i    $current_char = substr($filename,$i,1);

    if (ctype_alnum($current_char) == TRUE || $current_char == "_" || $current_char == ".") {

      $filtered_filename .= $current_char;

    }

  }     

        

  return $filtered_filename;

}

PHP dollar format

mvidberg () — Fri, 17 Feb 2006 09:38:48 GMT

// Function to return amount in the format $#.##



function dollar_format($amount) {

  $new_amount = "\$".sprintf("%.2f",$amount);

  return $new_amount;

}

PHP email validation function

mvidberg () — Fri, 17 Feb 2006 09:31:03 GMT

// Simple function to check if an given email adddress is valid



function is_valid_email($email) {

  $result = TRUE;

  if(!eregi("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,4})$", $email)) {

    $result = FALSE;

  }

  return $result;

}