PHP Classes

File: sample.php

Recommend this page to a friend!
  Classes of Kostas Aitsidis   TMSSQLDatabase   sample.php   Download  
File: sample.php
Role: Example script
Content type: text/plain
Description: Sample usage class TMSSQLDatabase
Class: TMSSQLDatabase
MS SQL Server Database connection
Author: By
Last change: 1
Date: 20 years ago
Size: 719 bytes


Class file image Download
require 'TMSSQLDatabase.php';
$mis = new TMSSQLDatabase("ITSRV","quest","asdas0902edsas022","ITS");
$mis->run_query("Select * from EliteUser.INI");

    if (
$mis->RecordCount== 0) {
"Table is Empty ";
    elseif (
$mis->RecordCount> 0) {
$fPage = 0;
$pages = ($mis->RecordCount/$rowsPerPage);
$nav= new TNavigator( $pages,$rowsPerPage,'/its/itm/itms.php');
# Fields to view
$catalogFields = array (ABBREVIATION =>"Item Code", NAME =>"Item Description");
$mis->ViewPage("Item Catalog",$catalogFields,$_GET['page'],$rowsPerPage);