Squidworks Vitals Dashboard for Labtech Software
Download SWVDB here -> SWVDB-0.1
Install instructions are included in the “install.txt” file inside of zip. You will need to have PHP 5.3.27 installed on you Labtech server and can be downloaded at http://php.net
The purpose of the Vitals Dashboard is to get key… 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
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:
