Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
a.mdb	1.96 MB	-rwxr-xr-x
benchmark.php	2.03 KB	-rwxr-xr-x
client.php	3.99 KB	-rwxr-xr-x
pdo.php	1.73 KB	-rwxr-xr-x
test-active-record.php	2.28 KB	-rwxr-xr-x
test-active-recs2.php	1.39 KB	-rwxr-xr-x
test-datadict.php	7.44 KB	-rwxr-xr-x
test-perf.php	909 B	-rwxr-xr-x
test-pgblob.php	1.99 KB	-rwxr-xr-x
test-php5.php	2.48 KB	-rwxr-xr-x
test-xmlschema.php	1.28 KB	-rwxr-xr-x
test.php	54.17 KB	-rwxr-xr-x
test2.php	573 B	-rwxr-xr-x
test3.php	896 B	-rwxr-xr-x
test4.php	4.56 KB	-rwxr-xr-x
test5.php	1.35 KB	-rwxr-xr-x
test_rs_array.php	679 B	-rwxr-xr-x
testcache.php	806 B	-rwxr-xr-x
testdatabases.inc.php	17.49 KB	-rwxr-xr-x
testgenid.php	731 B	-rwxr-xr-x
testmssql.php	1.99 KB	-rwxr-xr-x
testoci8.php	2.31 KB	-rwxr-xr-x
testoci8cursor.php	2.9 KB	-rwxr-xr-x
testpaging.php	2.26 KB	-rwxr-xr-x
testpear.php	873 B	-rwxr-xr-x
testsessions.php	2.08 KB	-rwxr-xr-x
time.php	520 B	-rwxr-xr-x
tmssql.php	1.84 KB	-rwxr-xr-x
xmlschema-mssql.xml	832 B	-rwxr-xr-x
xmlschema.xml	961 B	-rwxr-xr-x

Code Editor : tmssql.php

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

${this.title}

Code Editor : tmssql.php