LabTech Vitals Dashboard

On April 16, 2014, in Projects, by Cubert aka (Cube Dweller)

Today we release the next round for the Squidworks Labtech Vitals Dashboard.

The Labtech Vitals Dashboard is a set of web pages that query the local Labtech MySql database and provides visual widgets of important data on the main display of the Labtech Support Console. We currently have 17 different widgets with 10 of them having detail views.

To install the Dashboard you will need to download and install… Continue reading

Tagged with:
 

How-to: Setup Ubuntu and PHP to use MSSQL Microsoft SQL Server

On July 21, 2011, in How-to, by Cubert aka (Cube Dweller)

It is easier to get PHP on Ubuntu to connect to MSSQL than it is to get PHP on Windows.

 

I would not normally believe such a thing until I tried to setup a pre-existing install of PHP on Windows missing any MSSQL extensions. Looking through Google to find information was less than quick and I found myself wanting to go back to my old faithful Ubuntu server… Continue reading

Tagged with:
 

PHP preg_match hostname and domain from FQDN

On February 11, 2010, in How-to, Scripting, by Cubert aka (Cube Dweller)

How to get the hostname and the domain name from FQDN in PHP

This sound easy right? So easy that you would think it would be all over the internet as an example on how to parse host names from domain names. Wrong…. I spent a hour one day looking everywhere and all I found was parsing a URL. Well my needs go deeper I need to do a Continue reading

Tagged with:
 

PHP Pagination with timestamp / timeline display

On February 3, 2010, in How-to, Scripting, by Cubert aka (Cube Dweller)

Pagination with a timestamp as the center value

We provide a way to scroll page to page of data and show the time stamp of when the data was collected as part of the page navigations.

Here we setup the first query and findout how many pages we have.

$sql = “SELECT COUNT(*) FROM table where name = ‘” . $name . “‘ and type = ‘” Continue reading

Tagged with:
 

HOW-to: PHP Multiple Select List Box quick and easy..

On December 30, 2009, in How-to, Scripting, by Cubert aka (Cube Dweller)

Sometimes you find that it requires a little looping to get data from a form when using PHP and Multiple select list boxes. Here is a quick and easy way to loop through select data sent from a form in html. We also show you here how to use a Array of data to create the options. This is great if your doing a database query and need to use Continue reading

Tagged with:
 

ELGG Plugin : My Online Friends Messenger

On November 15, 2009, in Projects, Scripting, by Cubert aka (Cube Dweller)

Here is a plugin for ELGG community web framework created to popout from side of browser and show your active friends by name and picture. Each online friend listed is hyperlinked back the the email composer with that friends ID pre posted. The plugin show users as active (5 minutes) and inactive (10 minutes) variations .

myfriends-1.0.tar

Tagged with:
 

Howto Install ImageMagick and PHP imagick extension on CentOS 5

On November 12, 2009, in How-to, by Cubert aka (Cube Dweller)

Howto install imagemagick and PHP imagick extension on Linux CentOS 5 LAMP server. It is pretty simple really

yum install ImageMagick.i386
yum install ImageMagick-devel.i386
pecl install imagick

After the installation, create an inclusion file in your /etc/php.d directory for imagick.so module and then restart apache daemon:

echo “extension=imagick.so” > /etc/php.d/imagick.ini
/etc/init.d/httpd restart

Test the loading of the module by running:

php -m | grep imagick

Tagged with:
 

Howto: MySQL Full Text Search in PHP

On November 6, 2009, in How-to, Scripting, by Cubert aka (Cube Dweller)

This tutorial is intended for Text Searching using MySQL (http://www.MySQL.com/) and PHP (http://www.php.net) and will focus on the Full-text capabilities presented by MySQL.

Synopsis

We run a website that hosts web blogs, we have a database that contains blog posts. We might create a table in our database using a statement like this:

CREATE TABLE blogs (body TEXT, title VARCHAR(250), id INT NOT NULL auto_increment, PRIMARY KEY(id);
 
Tagged with:
 

Remove CRLF from windows PHP files.

On October 20, 2009, in How-to, Scripting, by Cubert aka (Cube Dweller)

I have had a few guys ask me, Shannon I have a Windows guy developing web aps in PHP but I run them on a Linux (LAMP) system. Some times the code seems to fail and I find the files populated with Carrage Return Line Feed or better seen while looking at a windows file on a linux system in a text editor ( ^M ). This has been know Continue reading

Tagged with: