All pastes #898189 Raw Edit

Mine

public text v1 · immutable
·published 2008-02-10 03:48 UTC
rendered paste body
// example input:
// addClothing(2,64,"White","total=25&Youth_S=5&Adult_S=5&Adult_M=10&Adult_XXL=5","These need to have the blue design printed on them");

// $itemId and $clothingType are both integers
// $color, $qty, and $notes are strings


function addClothing($itemId,$clothingType,$color,$qty,$notes){
	$itemId = (int) $itemId;
	$clothingType = (int) $clothingType;
	$color = mysql_real_escape_string($color);
	$qty = mysql_real_escape_string($qty);
	$notes = mysql_real_escape_string($notes);
	$sql = "INSERT INTO orders_clothing (item_id,clothing_type,clothing_color,clothing_qty,clothing_notes)
				VALUES ($itemId,$clothingType,'$color','$qty','$notes')";a
	$result = mysql_query($sql) or die('Error in function addClothing: ' . mysql_error());
	return;
}