Advanced Search

evCleanSQL | cleans a SQL query

/ Published in: PHP
Save to your folder(s)
warning! not tested, I'm not an expert on this field

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. // name:      	evCleanSQL
  2. // version:	v0.1
  3. // description:	limpia un string para una consulta SQL
  4.  
  5. function evCleanSQL( $sql ) {
  6.  
  7.     // si magic quotes está en ON
  8. 	if ( get_magic_quotes_gpc() ) :
  9. 		$sql = stripslashes( $sql );
  10. 	endif;
  11.  
  12. 	// Si PHP > 4.3.0
  13. 	if ( function_exists( "mysql_real_escape_string" ) ) :
  14. 		$cleanSql = mysql_real_escape_string( $sql );
  15. 	else :
  16. 		// si PHP version > 4.3.0
  17. 		$cleanSql = addslashes( $sql  );
  18. 	endif;
  19.  
  20. 	return $cleanSql;
  21. }

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.