Skip to content
Archive of posts tagged Database

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 [...]

Sorting Your MySQL Results Set In PHP Using jQuery (And A More Traditional Approach)

Recently asked at Yahoo! Answers:
Sort ORDER BY links for each COLUMN of MYSQL database in PHP page?
These are the links I am currently using but they are just on the bottom of the page int he middle of no where…
<p>Sort By:</p>
<p><a href=”address.php”>address</a></p>
<p><a href=”email.php”>email</a></p>
<p><a href=”name.php”>name</a></p>
<p><a href=”phone.php”>phone</a></p>
<p><a href=”tvprogram.php”>tvprogram</a></p>
Additional Details
I currently have a form where users input their [...]

Using JavaScript To Perform A Task Traditionally Solved With Server-Side Scripting

Asked recently on Yahoo! Answers:
Does anyone know how to automatically update a birthday list on a web page?
Our web page has a section that displays all staff birthdays for the week. This section is updated manually every Monday morning. Is there a way to have this update done automatically everyday. Must display all birthdays for [...]

Using AJAX To Data Bind A Child Drop Down List Based On The Selected Option Of A Parent Select Control

Recently asked on Yahoo! Answers:
How to generate a submenu on the basis of value in a menu without refreshing the page?
I want to use if else construct to generate a submenu on the basis of value from a textfield in the same form. You can get it in the way that when someone selects a [...]

A MySQL Stored Procedure To Return The Total Years, Months And Days Of All Person Records

Asked recently on Yahoo! Answers:

10 Points…Help MYSQL?
i have a table named ‘Students’ and it has the coulumns ‘Name’,’DateBirth’,’Age’ how do i do to know how many years, months, and days do all the students united have, THANKS

What the questioner wants to do is fairly complicated in MySQL. If we were working with a program, such [...]