<?php
/*******************************************************************
 * DatabaseTestMsSql.php
 * Copyright (C) 2006 Midnight Coders, LLC
 *
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
 * EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
 * MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
 * NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
 * LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
 * OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
 * WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
 *
 * The software is licensed under the GNU General Public License (GPL)
 * For details, see http://www.gnu.org/licenses/gpl.txt.
 ********************************************************************/

    class DatabaseTestMsSql
    {
      public function getCustomers($rowsToGet)
      {
          if($rowsToGet > -1)
            return $this->executeSql("select top $rowsToGet * from customers");
          
          return $this->getCustomersTable();
      }
    
      public function getCustomersMultiTable()
      {
         $resultSet = $this->execute("select top 10 * from customers");
         
         $resultArr = array();
         
         while($row = mssql_fetch_object($resultArr))
            $resultArr[] = $row;
         
         return array($resultArr,$resultArr);
         
      }
    
      public function executeSql($sql)
      {

		$server="MSSQLSERVER";
		$username="sa";
		$password="go";

		$sqlconnect=mssql_connect($server, $username, $password);

		mssql_select_db('Northwind');
		
		return mssql_query($sql);       
     }
     
     public function getCustomersTable()
     {
          return $this->executeSql("select top 10 * from customers");          
     }
     
    }
?>