database | Ardamis

Archive for posts tagged ‘database’

A PHP MySQL snippet for looking up names

A PHP snippet and MySQL query for an Ajax autocompleter lookup of people names by either “Firstname Lastname” or “Lastname, Firstname” from a single input field.

Posted on 16 October 2011 by Oliver Baty with tags coding, database, javascript, mysql, php, programming, web app and categorized Nonsense, Web Site Dev
No Comments »

A cache-friendly method for reducing WordPress comment spam

A safe-for-cached-pages method of filtering out spam comments by requiring at least some time to have passed between the time the page is loaded and the form is submitted.

Posted on 27 August 2011 and last updated on 22 January 2012 by Oliver Baty with tags application, blogging, coding, comment spam, database, javascript, php, programming, security, spam, templates, themes, web app, WordPress, xhtml and categorized Nonsense, Tutorials, Web Site Dev, WordPress
2 Comments »

Jealous of The Social Network

A short list of my programming accomplishments.

Posted on 12 June 2011 by Oliver Baty with tags Apache, application, coding, database, downloads, javascript, mysql, php, programming, web app, WordPress, xhtml and categorized Nonsense, Web Site Dev
No Comments »

Online tools for testing web page performance

A collection of online tools for measuring the performance of web pages, including time to first byte.

Posted on 10 April 2011 and last updated on 20 July 2011 by Oliver Baty with tags blogging, coding, database, javascript, mysql, network, php, programming, web app and categorized Tutorials, Web Site Dev
No Comments »

A chart illustrating the reduction in comment spam at ardamis.com

A screenshot of the Akismet stats graph showing the number of spam comments at ardamis.com identified by Akismet before and after my anti-spam system was implemented.

Posted on 18 January 2011 by Oliver Baty with tags 500 error, Apache, blogging, comment spam, database, mysql, spam, WordPress and categorized Web Site Dev
No Comments »

Protecting multiple downloads using unique URLs

A PHP script for protecting multiple downloads by the use of unique URLs. The actual file on the server is not discoverable and each URL will only be valid for a certain period of time and number of uses.

Posted on 26 June 2009 and last updated on 11 August 2010 by Oliver Baty with tags coding, database, mysql, php, programming, security, web app and categorized Web Site Dev
39 Comments »

Minifi.de – Another URL shortening service

Minifi.de is a URL shortening service like tinyurl.com, bit.ly, and is.gd. You enter a long URL and it returns a shorter one.

Posted on 7 April 2009 and last updated on 29 May 2009 by Oliver Baty with tags application, coding, database, javascript, mysql, php, programming, Twitter, web app and categorized Web Site Dev
No Comments »

Protecting a download using a unique URL

A PHP script to protect a download by generating a unique link. Each time you visit a page, a unique link is created that can be shared. The link will expire after a certain amount of time or number of uses. With some work, this could be integrated with your Paypal “thank you” page.

Posted on 11 June 2008 and last updated on 4 July 2010 by Oliver Baty with tags coding, database, downloads, mysql, php, programming and categorized Web Site Dev
55 Comments »

A PHP script for testing a MySQL database connection

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

Posted on 26 May 2008 and last updated on 14 May 2011 by Oliver Baty with tags coding, database, mysql, php, programming and categorized Web Site Dev
47 Comments »

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.

Posted on 6 April 2008 and last updated on 29 May 2009 by Oliver Baty with tags database, mysql, php, programming, web app, xhtml and categorized Web Site Dev
12 Comments »