DZone Snippets: Cornerblue's Code Snippets

PHP: Create a SELECT input field

cornerblue (CornerBLUE, Inc.) — Wed, 19 Sep 2007 08:46:29 GMT

Creates a SELECT input field with an optional parameter to preselect an item



function selectfield($optionsarray, $selected = "") {

  $returnval = "";

  foreach ($optionsarray as $field=>$value) {

    if ($field == $selected) {

      $returnval .= "\n";

    } else {

      $returnval .= "\n";

    }

  }

  

  return $returnval;

}

SQL SERVER: Delete Duplicate Rows with Primary Id

cornerblue (CornerBLUE, Inc.) — Fri, 31 Aug 2007 19:12:09 GMT

Deletes duplicates (leaving one instance) where the table has a primary key. Good for tables with Id, DupColumn, DupColumn...

(This is MS-SQL specific)



DELETE

FROM 	TableName

WHERE 	Id NOT IN

	(SELECT 	MAX(Id)

        FROM   		TableName

        GROUP BY 	DuplicateColumName1, DuplicateColumName2)

PHP: Insert Data Into MySQL Table Using An Array

cornerblue (CornerBLUE, Inc.) — Mon, 23 Jul 2007 22:59:02 GMT

Inserts the values of an array into a table. Also supports specifying if a specific field needs to be encoded using PASSWORD()
Parameters:
Table: Name of table to insert into
Data: array of $field->$value of new data
Password Field: Which field in the data array needs to be surrounded with PASSWORD() (optional)



function mysql_insert_array($table, $data, $password_field = "") {

	foreach ($data as $field=>$value) {

		$fields[] = '`' . $field . '`';

		

		if ($field == $password_field) {

			$values[] = "PASSWORD('" . mysql_real_escape_string($value) . "')";

		} else {

			$values[] = "'" . mysql_real_escape_string($value) . "'";

		}

	}

	$field_list = join(',', $fields);

	$value_list = join(', ', $values);

	

	$query = "INSERT INTO `" . $table . "` (" . $field_list . ") VALUES (" . $value_list . ")";

	

	return $query;

}

PHP: Update MySQL Table Using An Array

cornerblue (CornerBLUE, Inc.) — Thu, 19 Jul 2007 23:25:59 GMT

Parameters:
Table: Name of table to update
Data: array of $field->$value with new values
Id Field: Name of field to use as ID field
Id Value: Value of ID field



function mysql_update_array($table, $data, $id_field, $id_value) {

	foreach ($data as $field=>$value) {

		$fields[] = sprintf("`%s` = '%s'", $field, mysql_real_escape_string($value));

	}

	$field_list = join(',', $fields);

	

	$query = sprintf("UPDATE `%s` SET %s WHERE `%s` = %s", $table, $field_list, $id_field, intval($id_value));

	

	return $query;

}

PHP: Print List of States For A Select Field And Preselect A Value

cornerblue (CornerBLUE, Inc.) — Thu, 19 Jul 2007 23:14:55 GMT

Prints a list of US states for a ";
state_list($_POST['billing_state']);
echo "";

You can also convert this function to return a value instead of directly outputting



function state_list($sel='') {

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

	echo "";

}

PHP: Email All Form Values

cornerblue (CornerBLUE, Inc.) — Thu, 19 Jul 2007 23:09:40 GMT

If you need a very basic contact form and don't want to write extra code for putting the value of each field into the email, you can use this basic email. It works best if you name your form fields something legible, such as First_Name



if (isset($_POST['Submit'])) {

	// Prepare message

	$msg = "Time: " . date("m/d/y g:ia", time()) . "\n";

	foreach ($_POST as $field=>$value) {

		if ($field != "submit") $msg .= $field . ": " . $value . "\n";

	}

	

	if (mail("TOEMAIL", "SUBJECT", $msg, "From: FROM_NAME ")) {

		// Email was sent

	} else {

		// Erro sending email

	}

}

PHP: Pass On Values For A Multi-Page Form

cornerblue (CornerBLUE, Inc.) — Thu, 19 Jul 2007 23:03:48 GMT

While the best way to do this involves saving the data into a database and passing an encrypted reference to the next page, this method will suffice for non-critical uses.



foreach ($_POST as $field=>$value) {

	echo "";

}

C#: Resize An Image While Maintaining Aspect Ratio and Maximum Height

cornerblue (CornerBLUE, Inc.) — Thu, 19 Jul 2007 22:55:39 GMT

// This allows us to resize the image. It prevents skewed images and
// also vertically long images caused by trying to maintain the aspect
// ratio on images who's height is larger than their width



public void ResizeImage(string OriginalFile, string NewFile, int NewWidth, int MaxHeight, bool OnlyResizeIfWider)

{

	System.Drawing.Image FullsizeImage = System.Drawing.Image.FromFile(OriginalFile);



	// Prevent using images internal thumbnail

	FullsizeImage.RotateFlip(System.Drawing.RotateFlipType.Rotate180FlipNone);

	FullsizeImage.RotateFlip(System.Drawing.RotateFlipType.Rotate180FlipNone);



	if (OnlyResizeIfWider)

	{

		if (FullsizeImage.Width <= NewWidth)

		{

			NewWidth = FullsizeImage.Width;

		}

	}



	int NewHeight = FullsizeImage.Height * NewWidth / FullsizeImage.Width;

	if (NewHeight > MaxHeight)

	{

		// Resize with height instead

		NewWidth = FullsizeImage.Width * MaxHeight / FullsizeImage.Height;

		NewHeight = MaxHeight;

	}



	System.Drawing.Image NewImage = FullsizeImage.GetThumbnailImage(NewWidth, NewHeight, null, IntPtr.Zero);



	// Clear handle to original file so that we can overwrite it if necessary

	FullsizeImage.Dispose();



	// Save resized picture

	NewImage.Save(NewFile);

}

C#: Break Long Strings of Text That Don't Contain A Space

cornerblue (CornerBLUE, Inc.) — Thu, 19 Jul 2007 22:51:00 GMT

Long strings of text with no spaces breaks most tables since the browser doesn't know where to start a new line. This function breaks a string after a number of characters so that they can be properly displayed in tables



// Put this at the top

using System.Text.RegularExpressions;

//



public string BreakLongString(string SubjectString, int CharsToBreakAfter)

{

	string Pattern = "\\S{" + CharsToBreakAfter + ",}";

	int Counter = 0;

	bool IsMatching = Regex.IsMatch(SubjectString, Pattern);

	while (IsMatching)

	{



		Counter++;

		string MatchedString = Regex.Match(SubjectString, Pattern).Value;

		SubjectString = SubjectString.Replace(MatchedString.Substring(0, (CharsToBreakAfter - 1)), MatchedString.Substring(0, (CharsToBreakAfter - 1)) + " ");



		// Prevent endless loops

		if (Counter > 20) break;



		// Check if we still have long strings

		IsMatching = Regex.IsMatch(SubjectString, Pattern);

	}



	return SubjectString;

}

C#: Log A Message To A File

cornerblue (CornerBLUE, Inc.) — Thu, 19 Jul 2007 22:46:26 GMT



// Put this at the top

using System.IO;

//



public static void Log(string Message)

{

	File.AppendAllText(HttpContext.Current.Server.MapPath("~") + "/log.txt", DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString() + ": " + Message + Environment.NewLine);

}