A few definitions before diving in (the title is a mouthful): BDD = Behavior Driven Development, which is a more top down approach to Test Driven Development (TDD) Behat = Tool for implementing BDD written in PHP Selenium = open source browser testing tool, which can be used with behat as an addon through the […]
Category Archives: Database
How to Add a Form in a WordPress Post
This is a simple step by step guide to creating a form that will capture data and store it in a mysql database on your server from within a wordpress post Note: the below example is a live, working form on this page Step 1: Create a simple form for a petition, contact request, or […]
Google Maps API Version 3 Geocoding Example
Today I realized that my location markers were not being displayed in all the google maps implementations I had put into place online, and after digging into it (trying to figure out what a code 610 response meant) I realized that I was using version 2 of the google maps api for retrieving latitude and […]
How to Easily Prepare Database Import Using Perl
I’m revisiting this topic because in my last post about translating Excel data into a text file for database import I used a php script and yet still had some manual steps (the one that bugged me most was adding custom line termination characters for multiline data). I mentioned the idea that if I wanted […]
How to Export One Table Structure in Mysql and Infobright
I have a database with tables in it which have over 300 fields each. I wanted to create a new table like the others but I didn’t have the table structure saved in a file. Due to the number of fields it was impractical to copy the screen after executing a “show create table tablename” […]