/include/adodb/tests/tmssql.php
PHP | 80 lines | 65 code | 14 blank | 1 comment | 6 complexity | 3d7a43b2eb78e4442b082da5a04e42b7 MD5 | raw file
Possible License(s): LGPL-2.1, GPL-2.0, BSD-3-Clause, LGPL-2.0, CC-BY-SA-3.0, AGPL-1.0
- <?php
- error_reporting(E_ALL);
- ini_set('mssql.datetimeconvert',0);
- function tmssql()
- {
- print "<h3>mssql</h3>";
- $db = mssql_connect('JAGUAR\vsdotnet','adodb','natsoft') or die('No Connection');
- mssql_select_db('northwind',$db);
-
- $rs = mssql_query('select getdate() as date',$db);
- $o = mssql_fetch_row($rs);
- print_r($o);
- mssql_free_result($rs);
-
- print "<p>Delete</p>"; flush();
- $rs2 = mssql_query('delete from adoxyz',$db);
- $p = mssql_num_rows($rs2);
- mssql_free_result($rs2);
- }
- function tpear()
- {
- include_once('DB.php');
- print "<h3>PEAR</h3>";
- $username = 'adodb';
- $password = 'natsoft';
- $hostname = 'JAGUAR\vsdotnet';
- $databasename = 'northwind';
-
- $dsn = "mssql://$username:$password@$hostname/$databasename";
- $conn = &DB::connect($dsn);
- print "date=".$conn->GetOne('select getdate()')."<br>";
- @$conn->query('create table tester (id integer)');
- print "<p>Delete</p>"; flush();
- $rs = $conn->query('delete from tester');
- print "date=".$conn->GetOne('select getdate()')."<br>";
- }
- function tadodb()
- {
- include_once('../adodb.inc.php');
- print "<h3>ADOdb</h3>";
- $conn = NewADOConnection('mssql');
- $conn->Connect('JAGUAR\vsdotnet','adodb','natsoft','northwind');
- // $conn->debug=1;
- print "date=".$conn->GetOne('select getdate()')."<br>";
- $conn->Execute('create table tester (id integer)');
- print "<p>Delete</p>"; flush();
- $rs = $conn->Execute('delete from tester');
- print "date=".$conn->GetOne('select getdate()')."<br>";
- }
- $ACCEPTIP = '127.0.0.1';
- $remote = $_SERVER["REMOTE_ADDR"];
- if (!empty($ACCEPTIP))
- if ($remote != '127.0.0.1' && $remote != $ACCEPTIP)
- die("Unauthorised client: '$remote'");
-
- ?>
- <a href=tmssql.php?do=tmssql>mssql</a>
- <a href=tmssql.php?do=tpear>pear</a>
- <a href=tmssql.php?do=tadodb>adodb</a>
- <?php
- if (!empty($_GET['do'])) {
- $do = $_GET['do'];
- switch($do) {
- case 'tpear':
- case 'tadodb':
- case 'tmssql':
- $do();
- }
- }
- ?>