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
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
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
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
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
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 .
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
Test the loading of the module by running:
php -m | grep imagick
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.
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:
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