Tag Archives: script

Quick And Easy Music Command Generator In PHP

Posted on May 18, 2016 by robert

I won’t go in to the convoluted reason why I needed to write this script, but I will tell you that I recently used it to convert over 540 music files (using FFMPEG) from wma to mp3. You see, when … Continue reading →

Posted in PHP | Tagged , , , , , | Leave a comment

MySQL Difference Between Dates In Days, Hours, Minutes

Posted on April 1, 2016 by robert

I was researching how to make a JavaScript countdown timer for a personal webpage, because that’s the only way to go if you want interactivity (client-side scripting at its best), and I thought, ‘how can I do this in MySQL?’ … Continue reading →

Posted in MySQL | Tagged , , , | Leave a comment

Working With XML/XSLT, JSON, And PHP

Posted on July 7, 2015 by robert

So, this tale, which for your sake I will attempt to make brief, is typical of my experiences in web development. As one of my old bosses used to say (and I’m paraphrasing), “if there’s a hard way to do … Continue reading →

Posted in PHP | Tagged , , , , , , , , , , , , , , | Leave a comment

Arrival At Pluto

Posted on June 13, 2015 by robert

New Horizons is scheduled to arrive at the PLANET Pluto (don’t give me any of that dwarf or minor crap) on: select DATE_ADD(date(‘2015-06-02’), INTERVAL 42 DAY) as ‘Arrival at Pluto’; Kind of sad that I thought it would be easier … Continue reading →

Posted in MySQL | Tagged , , , , , | Leave a comment

Having Conversations With Javascript

Posted on April 20, 2015 by robert

Have you ever wanted wanted to animate inanimate objects? I think we all have. Well, that’s a lot of work. A cheat that you can employ, however, is relatively easy with javascript and or jquery. No, I’m not talking about … Continue reading →

Posted in jQuery | Tagged , , , | Leave a comment

Graphing With Flot

Posted on March 3, 2015 by robert

I was working on one of my personal projects, graphing data with PHP, when I ran into a wall. Sure, with PHP, you can get all your data (in the words of some famous poet: database, oh database, how do … Continue reading →

Posted in Computer Stuff, jQuery | Tagged , , , , , | Leave a comment

Install A Linux Web Server On Your Windows 7 PC With Vagrant

Posted on February 2, 2015 by robert

First, I’d like to reference an excellent video tutorial that I used for my initial foray into the Vagrant world. Click here to see that tutorial. Disclaimer: This blog entry does not necessarily follow safe computer/networking procedures. Use this only … Continue reading →

Posted in Computer Stuff, MySQL, PHP | Tagged , , , , , , | Leave a comment

MySQL Query Using Derived Temp Table And Left Join Against Self

Posted on January 8, 2015 by robert

An example (for a personal project) where I’m using a derived temp table (designated ‘x’) and a table joined against itself, used to find the max timestamp. Thanks, Martin! select tt.*, fkid, max(fldTimeStamp) as `maxTimeStamp`, (count(*)-1) as `calcCount` from tbl_todo … Continue reading →

Posted in MySQL | Tagged , , | Leave a comment

Towns In Connecticut – Highlighting Mapped Regions Of An Image With jQuery

Posted on November 22, 2014 by robert

Having lived most of my adult life in another part of the country, I am often at a loss when towns/cities are mentioned (say, for instance, in a job posting). Until recently, the only solution was to google or mapquest … Continue reading →

Posted in jQuery, PHP | Tagged , , , , | Leave a comment

Auto Image Display With PHP And JQuery

Posted on September 9, 2014 by robert

This script will automatically display all the .jpg images in a given folder. The beauty of this script is that it needs no database access. The information for the caption (and alt) are in the images themselves. Easy modifications that … Continue reading →

Posted in Computer Stuff, PHP | Tagged , , , , , , | Leave a comment