diff options
Diffstat (limited to 'trunk/adodb5/tests/tmssql.php')
| -rw-r--r-- | trunk/adodb5/tests/tmssql.php | 80 |
1 files changed, 0 insertions, 80 deletions
diff --git a/trunk/adodb5/tests/tmssql.php b/trunk/adodb5/tests/tmssql.php deleted file mode 100644 index 67c11db1..00000000 --- a/trunk/adodb5/tests/tmssql.php +++ /dev/null @@ -1,80 +0,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(); - } -} -?>
\ No newline at end of file |
