Skip to content
Archive of posts tagged SQL

Calculating The Bearing And Compass Rose Direction Between Two Latitude / Longitude Coordinates In PHP

A comment recently made to my blog post, “Getting All ZIP Codes In A Given Radius From A Known Point / ZIP Code Via PHP And MySQL“:

Does any one know how to work out the bearing from one set of coordinates to another.
For example, if the calculated bearing was 90 (degrees) the using if statements [...]

Working With The Authorize.net Customer Information Manager (CIM), Part 1: Overview

I’m going to spend several posts discussing authorize.net’s Customer Information Manager, a Web service for storing and retrieving personally identifiable information about the people who place credit card orders on your Web site.
Today, I’m focusing solely on an overview of CIM: What it is, how it works, why it works that way, and approaches to [...]

Free Books, Just For The Asking

I’m clearing my bookshelves and have four books that I was planning to trash (since the local library doesn’t want them). Then I thought, what the heck, give ‘em away on the blog.
So, forthwith, I have the following four books available:
Associated Press Stylebook and Libel Manual (1998 Edition): This is a reference book used [...]

How I Code On This Blog: Elegance Vs. Transparency

My recent comment exchange with Scriptar has prodded me to post an explanation of how I code on this blog.
I view the code I post here as having two priorities: elegance and transparency, weighted slightly more toward elegance.
What I mean is that most importantly, the code I post should be as simple, compact and [...]

Parent – Child Select Lists Revisited: Multiple Parent – Child Select Lists Via PHP, MySQL And jQuery

A while ago, I promised to answer Brian’s request for a demonstration of how to make multiple parent / child select lists — in other words, starting from one drop down / select list, having two or more child lists, each of which, in turn, may act as a parent to another list.
Multiple parent-child select [...]

A Simple Page Click Count System Using PHP And MySQL

Recently asked on Yahoo! Answers:

Click Counter in Dreamweaver?
I am looking to create a hit counter so I can have the top ten clicked stories on my website. I have a separate field for the count but i need the code to update the field +1.
This isn’t something you can do with Dreamweaver’s built-in behaviors; you’re [...]