<?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"); } } ?>