sql_parse()

by: Christian Dechery

April 2, 2001

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)";

Comment and Contribute

0 Comments (click to add your comment)

Your comment has been submitted and is pending approval.

Author:

Christian Dechery

Comment:

Name/nickname:
Email:

Comment:

(Maximum characters: 1200). You have characters left.