📄 client.php
字号:
<html><body bgcolor=white><?php/** * V4.50 6 July 2004 (c) 2001-2002 John Lim (jlim#natsoft.com.my). All rights reserved. * Released under both BSD license and Lesser GPL library license. Whenever there is any discrepancy between the two licenses, the BSD license will take precedence. * * set tabs to 8 */ // documentation on usage is at http://php.weblogs.com/adodb_csv echo PHP_VERSION,'<br>'; var_dump(parse_url('odbc_mssql://userserver/')); die(); include('../adodb.inc.php');include('../tohtml.inc.php'); function &send2server($url,$sql) { $url .= '?sql='.urlencode($sql); print "<p>$url</p>"; $rs = csv2rs($url,$err); if ($err) print $err; return $rs; } function print_pre($s) { print "<pre>";print_r($s);print "</pre>"; }$serverURL = 'http://localhost/php/phplens/adodb/server.php';$testhttp = false;$sql1 = "insertz into products (productname) values ('testprod 1')";$sql2 = "insert into products (productname) values ('testprod 1')";$sql3 = "insert into products (productname) values ('testprod 2')";$sql4 = "delete from products where productid>80";$sql5 = 'select * from products'; if ($testhttp) { print "<a href=#c>Client Driver Tests</a><p>"; print "<h3>Test Error</h3>"; $rs = send2server($serverURL,$sql1); print_pre($rs); print "<hr />"; print "<h3>Test Insert</h3>"; $rs = send2server($serverURL,$sql2); print_pre($rs); print "<hr />"; print "<h3>Test Insert2</h3>"; $rs = send2server($serverURL,$sql3); print_pre($rs); print "<hr />"; print "<h3>Test Delete</h3>"; $rs = send2server($serverURL,$sql4); print_pre($rs); print "<hr />"; print "<h3>Test Select</h3>"; $rs = send2server($serverURL,$sql5); if ($rs) rs2html($rs); print "<hr />";}print "<a name=c><h1>CLIENT Driver Tests</h1>";$conn = ADONewConnection('csv');$conn->Connect($serverURL);$conn->debug = true;print "<h3>Bad SQL</h3>";$rs = $conn->Execute($sql1);print "<h3>Insert SQL 1</h3>";$rs = $conn->Execute($sql2);print "<h3>Insert SQL 2</h3>";$rs = $conn->Execute($sql3);print "<h3>Select SQL</h3>";$rs = $conn->Execute($sql5);if ($rs) rs2html($rs);print "<h3>Delete SQL</h3>";$rs = $conn->Execute($sql4);print "<h3>Select SQL</h3>";$rs = $conn->Execute($sql5);if ($rs) rs2html($rs);/* EXPECTED RESULTS FOR HTTP TEST:Test Inserthttp://localhost/php/adodb/server.php?sql=insert+into+products+%28productname%29+values+%28%27testprod%27%29adorecordset Object( [dataProvider] => native [fields] => [blobSize] => 64 [canSeek] => [EOF] => 1 [emptyTimeStamp] => [emptyDate] => [debug] => [timeToLive] => 0 [bind] => [_numOfRows] => -1 [_numOfFields] => 0 [_queryID] => 1 [_currentRow] => -1 [_closed] => [_inited] => [sql] => insert into products (productname) values ('testprod') [affectedrows] => 1 [insertid] => 81)--------------------------------------------------------------------------------Test Insert2http://localhost/php/adodb/server.php?sql=insert+into+products+%28productname%29+values+%28%27testprod%27%29adorecordset Object( [dataProvider] => native [fields] => [blobSize] => 64 [canSeek] => [EOF] => 1 [emptyTimeStamp] => [emptyDate] => [debug] => [timeToLive] => 0 [bind] => [_numOfRows] => -1 [_numOfFields] => 0 [_queryID] => 1 [_currentRow] => -1 [_closed] => [_inited] => [sql] => insert into products (productname) values ('testprod') [affectedrows] => 1 [insertid] => 82)--------------------------------------------------------------------------------Test Deletehttp://localhost/php/adodb/server.php?sql=delete+from+products+where+productid%3E80adorecordset Object( [dataProvider] => native [fields] => [blobSize] => 64 [canSeek] => [EOF] => 1 [emptyTimeStamp] => [emptyDate] => [debug] => [timeToLive] => 0 [bind] => [_numOfRows] => -1 [_numOfFields] => 0 [_queryID] => 1 [_currentRow] => -1 [_closed] => [_inited] => [sql] => delete from products where productid>80 [affectedrows] => 2 [insertid] => 0)[more stuff deleted] . . .*/?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -