Version: 1.0

Type: Function

Category: Databases

License: GNU General Public License

Description: small but usefull function to parse a var to be valid in a sql query-string.



function sql_parse($field,$is_string=0)
{
	if(strlen(trim($field))==0)
		return "null";
	if($is_string)
	{
		$field=chop($field);
		$field=str_replace("'","''",$field);
		$field="'".$field."'";
	}
	return trim($field);
}

// so a query would look like this
// $id=sql_parse($id); $name=sql_parse($name); $phone_number=sql_parse($phone_number);
// $query = "insert into table1(id,name,phone_number) values ($id,$name,$phone_number)";