Archive for posts tagged ‘mysql’

A PHP script for testing a MySQL database connection

A simple web page that you can use for testing a MySQL database connection.

Read more...

Resolving transaction concurrency issues in a PHP+MySQL multi-user environment

Here’s how I’m implementing my solution to the lost update concurrency issue by comparing timestamps generated when a record is saved and accessed.

Read more...

How to Geolocate Visitors Using an IP-to-Country Database

In this post, I’ll illustrate how to use the IP-to-Country database available from http://ip-to-country.webhosting.info/ to identify the real-world geographic location of visitors to a web page (geolocate) based on their IP addresses. Once you know where a visitor is physically located, you can do all sorts of nifty things, such as send them location-aware content [...]

Read more...