http://www.inkplant.com/code/ PHP, MySQL, Ajax, and HTML tutorials, code snippets, and examples to help solve a wide variety of programming questions. Thu, 18 Aug 2011 12:55:27 -0400 en http://www.inkplant.com/code/mysql-sort-without-the-and-a.php http://www.inkplant.com/code/mysql-sort-without-the-and-a.php#comments Thu, 18 Aug 2011 08:30:00 -0400 Shows you how to sort MySQL results by title, ignoring indefinite and definite articles (a, an, the). http://www.inkplant.com/code/mysql-sort-without-the-and-a.php Robert James Reese MySQL PHP http://www.inkplant.com/code/php-resize-image-function.php http://www.inkplant.com/code/php-resize-image-function.php#comments Thu, 04 Aug 2011 19:00:00 -0400 Easy PHP functions that let you resize images automatically using PHP. One keeps the same aspect ratio by cropping. Another function allows you to set a max width or height and shrink to fit. Or you can force to specific dimensions. http://www.inkplant.com/code/php-resize-image-function.php Robert James Reese PHP Images http://www.inkplant.com/code/form-helper.php http://www.inkplant.com/code/form-helper.php#comments Fri, 08 Jul 2011 08:14:00 -0400 Helper for generating and processing HTML forms with PHP. Includes functions for easy creation of text input, dropdowns, radio buttons, checkboxes, hidden fields, date dropdowns, and more. http://www.inkplant.com/code/form-helper.php Robert James Reese PHP HTML http://www.inkplant.com/code/get-twitter-posts-by-hashtag.php http://www.inkplant.com/code/get-twitter-posts-by-hashtag.php#comments Tue, 31 May 2011 08:54:00 -0400 A quick and easy PHP function that uses Twitter's Search API to return recent Tweets with a specific hashtag. http://www.inkplant.com/code/get-twitter-posts-by-hashtag.php Robert James Reese PHP Twitter http://www.inkplant.com/code/different-types-of-intelligence.php http://www.inkplant.com/code/different-types-of-intelligence.php#comments Mon, 30 May 2011 11:54:00 -0400 A random question (what are the odds of getting a four of a kind dealt in a 6 card hand) led to a mini-exploration into the different kinds of logic that people use to solve problems. Includes code on how I figured out the answer. http://www.inkplant.com/code/different-types-of-intelligence.php Robert James Reese PHP http://www.inkplant.com/code/delete-google-apps-account.php http://www.inkplant.com/code/delete-google-apps-account.php#comments Tue, 24 May 2011 09:22:00 -0400 This is a quick guide explaining how to cancel an entire free or premium Google Apps domain. It took me a while to figure out how to shut my testing one down, so I figured I'd share the knowledge. http://www.inkplant.com/code/delete-google-apps-account.php Robert James Reese Email Google Apps http://www.inkplant.com/code/website-screenshots-with-php.php http://www.inkplant.com/code/website-screenshots-with-php.php#comments Fri, 13 May 2011 08:45:00 -0400 Tutorial and code showing how to use PHP's built-in imagegrabwindow function to take a screenshot of a website and then crop, resize, and save it as a JPEG image. http://www.inkplant.com/code/website-screenshots-with-php.php Robert James Reese PHP Windows http://www.inkplant.com/code/linux-email-forwarding.php http://www.inkplant.com/code/linux-email-forwarding.php#comments Thu, 12 May 2011 07:32:00 -0400 A few tips on setting up email forwarding on your Linux (or UNIX) box. Includes instructions on how to forward to multiple email addresses from one account. http://www.inkplant.com/code/linux-email-forwarding.php Robert James Reese Linux VI Editor Email http://www.inkplant.com/code/calculate-the-distance-between-two-points.php http://www.inkplant.com/code/calculate-the-distance-between-two-points.php#comments Tue, 26 Apr 2011 08:47:00 -0400 A simple, easy-to-understand PHP function that calculates the distance between two sets of latitude and longitude coordinates in miles, km, feet, and meters. http://www.inkplant.com/code/calculate-the-distance-between-two-points.php Robert James Reese PHP Maps http://www.inkplant.com/code/how-to-create-a-symbolic-link-in-windows-vista.php http://www.inkplant.com/code/how-to-create-a-symbolic-link-in-windows-vista.php#comments Fri, 22 Apr 2011 08:37:00 -0400 Quick step-by-step instructions explaining how to create shortcuts to another directory in your file system using mklink when using Windows Vista. http://www.inkplant.com/code/how-to-create-a-symbolic-link-in-windows-vista.php Robert James Reese PHP Windows XAMPP Command Prompt http://www.inkplant.com/code/shorten-urls-with-bitly-api.php http://www.inkplant.com/code/shorten-urls-with-bitly-api.php#comments Sat, 19 Mar 2011 15:28:00 -0400 A quick, easy-to-use PHP function that takes your long URL's and converts them into something short and ready to post on Twitter, etc. Just plug in your bit.ly username and API Key and you're ready to go. http://www.inkplant.com/code/shorten-urls-with-bitly-api.php Robert James Reese PHP http://www.inkplant.com/code/convert-mysql-table-to-utf8.php http://www.inkplant.com/code/convert-mysql-table-to-utf8.php#comments Sun, 13 Mar 2011 13:56:00 -0400 A PHP function (with lots of comments) that converts a MySQL table and its data to UTF-8. It updates the collation of the table itself and of each text-based column. Additionally, it goes through each row and updates existing data automatically. http://www.inkplant.com/code/convert-mysql-table-to-utf8.php Robert James Reese MySQL PHP HTML http://www.inkplant.com/code/state-latitudes-longitudes.php http://www.inkplant.com/code/state-latitudes-longitudes.php#comments Wed, 09 Mar 2011 16:39:00 -0500 A list of the center latitude and longitude for all fifty of the United States (generated by taking the average latitude and longitude from each zip code within the state). In both HTML table and MySQL format. http://www.inkplant.com/code/state-latitudes-longitudes.php Robert James Reese MySQL Data Dumps Maps http://www.inkplant.com/code/count-textarea-characters-with-javascript.php http://www.inkplant.com/code/count-textarea-characters-with-javascript.php#comments Sat, 26 Feb 2011 09:32:00 -0500 Simple code that allows you to count how many characters have been typed into a textbox (or any other text element) and then displays the remaining amount of characters in a specified element. Works great for Twitter forms and the 140 character max. http://www.inkplant.com/code/count-textarea-characters-with-javascript.php Robert James Reese HTML JavaScript http://www.inkplant.com/code/blog-ping.php http://www.inkplant.com/code/blog-ping.php#comments Sat, 29 Jan 2011 17:42:00 -0500 An up-to-date list of blog ping endpoints. Also, a tool to construct your XML-RPC request to send to them. http://www.inkplant.com/code/blog-ping.php Robert James Reese PHP Blogging XML http://www.inkplant.com/code/mysql-sum-and-group-by.php http://www.inkplant.com/code/mysql-sum-and-group-by.php#comments Sat, 08 Jan 2011 12:47:00 -0500 An experiment that shows how MySQL calculates a combination of SUM and GROUP BY clauses in the same query. http://www.inkplant.com/code/mysql-sum-and-group-by.php Robert James Reese MySQL http://www.inkplant.com/code/https-robots.php http://www.inkplant.com/code/https-robots.php#comments Fri, 03 Dec 2010 08:46:00 -0500 If you allow search engine crawlers to index both HTTP and HTTPS versions of your site, you can run into some serious SEO issues. This quick guide explains how to stop that from happening with .htaccess, PHP, and robots.txt. http://www.inkplant.com/code/https-robots.php Robert James Reese PHP .htaccess SEO robots.txt http://www.inkplant.com/code/hexdec-converter.php http://www.inkplant.com/code/hexdec-converter.php#comments Tue, 23 Nov 2010 07:44:00 -0500 The PHP functions you need to go from RGB values to a hexadecimal string and visa versa. http://www.inkplant.com/code/hexdec-converter.php Robert James Reese PHP CSS HTML http://www.inkplant.com/code/mysql-vertical-sort.php http://www.inkplant.com/code/mysql-vertical-sort.php#comments Thu, 07 Oct 2010 14:45:00 -0400 PHP code to display results from a MySQL query sorted vertically (rather than horizontally) in a table. Very simple and allows for custom number of columns. http://www.inkplant.com/code/mysql-vertical-sort.php Robert James Reese MySQL PHP HTML http://www.inkplant.com/code/ajax-tutorial.php http://www.inkplant.com/code/ajax-tutorial.php#comments Sat, 18 Sep 2010 12:00:00 -0400 A simple crash course on Ajax that will get you started in a matter of minutes. Includes an easy to follow example with multiple Ajax calls from one page. http://www.inkplant.com/code/ajax-tutorial.php Robert James Reese PHP Ajax JavaScript