floor($decimal*100)/100

November 19, 2009

Remove all select options with JavaScript

Category: Blog,JavaScript, Tags: JavaScript, khadlock at 1:23 pm

Here’s a quick function to remove all select options using JavaScript.

function RemoveAllOptions(selector)
{
     while(selector.hasChildNodes()) selector.removeChild(selector.childNodes[0]);
}

SELECT * FROM table WHERE (LEFT(columnname,1) REGEXP '[0-9]')

SELECT * FROM table WHERE (LEFT(columnname,1) REGEXP '[a-z]')

November 15, 2009

Using the IN statement to retrieve multiple results from a subquery

Category: Blog,MySQL, Tags: mysql, khadlock at 8:20 pm

Use the IN statement to retrieve multiple results from a subquery.

SELECT * FROM table WHERE id IN ( SELECT DISTINCT id FROM table WHERE id=1 )

SELECT * FROM table WHERE columnname LIKE 'A%'

November 13, 2009

Convert GET and POST to objects

Category: Blog,PHP, Tags: Forms, PHP, khadlock at 1:51 pm

Here’s a quick way to convert GET and POST arrays to objects with PHP:

$get = (object)$_GET;
echo $get->sample;

$post = (object)$_POST;
echo $post->sample;

In this case the “sample” property would be an array key.

Setting the label “for” attribute with JavaScript

Category: Blog,HTML,JavaScript, Tags: HTML, JavaScript, khadlock at 10:53 am

Sometimes JavaScript offers unique names for element attributes, for example, CSS properties with words that are normally separated with dashes are camel case in JavaScript. The label element’s “for” attribute is no exception, in fact it’s probably the most unique one I’ve stumbled across, which is why I thought it was important to share. When you set the label “for” attribute with JavaScript you have to set it as “htmlFor” and of course give it the same value as the input element’s id that you are tying it to.

November 5, 2009

Twitter’s API whitelist

Category: Blog,BlogToTweet,Twitter, Tags: BlogToTweet, Twitter, khadlock at 2:27 pm

One of our product’s BlogToTweet.com has been approved for the Twitter API whitelist, meaning any rate limits no longer apply to authenticated requests made through BlogToTweet. This was never an issue, but our user base is quickly growing, so we were proactive in achieving whitelist status to prevent any problems from creeping up for our users. If you use the Twitter API and are wondering how to get approved for the Twitter API whitelist, visit http://twitter.com/help/request_whitelisting To learn more about BlogToTweet you can visit our product page at http://www.studiosedition.com/product/BlogToTweet

exec("gunzip Filename.gz", $results);

November 2, 2009

Remove empty array values in PHP

Category: Blog,PHP, Tags: PHP, khadlock at 7:51 pm

Here’s a super easy way to remove empty values from an array in PHP:

$a = array_diff($a, array(""));

In a recent project we were reading in a text file and creating an array based on each new line, so we used the same method to remove any new lines that were empty.

$a = array_diff($a, array("\n"));