?? tmssql.php
字號:
<?phperror_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>";}?><a href=tmssql.php?do=tmssql>mssql</a><a href=tmssql.php?do=tpear>pear</a><a href=tmssql.php?do=tadodb>adodb</a><?phpif (!empty($_GET['do'])) { $do = $_GET['do']; $do();}?>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -