Public feed #601715

Mine

public php v1 · immutable
Raw Edit
·published 2007-07-03 17:42 UTC
rendered paste body
<?phptry {	$STMT = $DB->prepare( 		"UPDATE user_avatars 		SET image_type = :image_type,		image =	:image,		image_size = :image_size,		timestamp =	:timestamp		WHERE user_id = :user_id" 	);		$STMT->bindParam( ":user_id", 		$user_id,			PDO::PARAM_INT );	$STMT->bindParam( ":image_type", 	$type,  			PDO::PARAM_STR);	$STMT->bindParam( ":image_size", 	$size,  			PDO::PARAM_INT );	$STMT->bindParam( ":image", 		$avatarFileHandle,  PDO::PARAM_LOB );	$STMT->bindParam( ":timestamp", 	$time,  			PDO::PARAM_INT );			$STMT->execute();} catch (PDOException $e) {	die( $e->getMessage() );}?>