* safe_query_inputs();

        *

        * This function helps you secure your query inputs

        * before sending them to the database.

        *

        * Usage:

        * $safeInputs = safe_query_inputs('input1','input2','input3');

        *

        * @return array

        */

       public function safe_query_inputs() {

              $inputs = func_get_args();

              $output = array();

              foreach ( $inputs as $key => $input ) {

 

                     // Remove slashes if magic_quotes is enabled

                     if ( get_magic_quotes_gpc() ) {

                            $output[$key] = stripslashes( $input );

                     }

 

                     // If $input is null, replace it with MySQL's keyword NULL

                     if (is_null( $input )) {

                            $output[$key] = 'NULL';

                     }

 

                     // Convert booleans to 1 or 0

                     elseif ( is_bool($input) ) {

                            $output[$key] = ( $input ) ? 1 : 0;

                     }

 

                     // If $input is numeric and contains decimals, replace the

                     // comma with period

                     elseif ( is_numeric( $input ) && ( strpos( ',' , $input ) ) ) {

                            $output[$key] = str_replace( ',' , '.' , $input);

                     }

 

                     // If $input is a normal string run it trough real_escape_string(),

                     // and optionaly htmlentities();

                     elseif ( !is_numeric( $input ) ) {

                            #$output[$key] = htmlentities( $input );

                            $output[$key] = mysql_real_escape_string( $input );

                     }

              }

              return $output;

       }