<?php
include_once '../doc-typo3-funcs.php';
$doxygen_vars = array( "title" => "TYPO3 4.0.1: typo3_src-4.0.1/typo3/sysext/adodb/adodb/server.php Source File",
"datetime" => "Sat Dec 2 19:22:26 2006",
"date" => "2 Dec 2006",
"doxygenversion" => "1.4.6",
"projectname" => "TYPO3 4.0.1",
"projectnumber" => "4.0.1"
);
get_header($doxygen_vars);
?>
<!-- Generated by Doxygen 1.4.6 -->
<div class="tabs">
<ul>
<li><a href="main.html"><span>Main Page</span></a></li>
<li><a href="namespaces.html"><span>Namespaces</span></a></li>
<li><a href="classes.html"><span>Classes</span></a></li>
<li id="current"><a href="files.html"><span>Files</span></a></li>
<li><a href="dirs.html"><span>Directories</span></a></li>
<li><a href="pages.html"><span>Related Pages</span></a></li>
<li><a href="examples.html"><span>Examples</span></a></li>
<li>
<form action="search.php" method="get">
<table cellspacing="0" cellpadding="0" border="0">
<tr>
<td><label> <u>S</u>earch for </label></td>
<td><input type="text" name="query" value="" size="20" accesskey="s"/></td>
</tr>
</table>
</form>
</li>
</ul></div>
<div class="nav">
<a class="el" href="dir_c8daf1ad746050abf985cc546c89e248.html">typo3_src-4.0.1</a> » <a class="el" href="dir_18071ae4545d8b3e0364d30c0659c74a.html">typo3</a> » <a class="el" href="dir_57bf1ed8249c1fd5b014486d01bcb27a.html">sysext</a> » <a class="el" href="dir_e81b1679233d44b74aed493d6fe8e943.html">adodb</a> » <a class="el" href="dir_1f526b87ad011e46f671ba6e798564e1.html">adodb</a></div>
<h1>server.php</h1><div class="fragment"><pre class="fragment"><a name="l00001"></a>00001 <?php
<a name="l00002"></a>00002
<a name="l00010"></a>00010 <span class="comment">/* Documentation on usage is at http://php.weblogs.com/adodb_csv</span>
<a name="l00011"></a>00011 <span class="comment"> *</span>
<a name="l00012"></a>00012 <span class="comment"> * Legal query string parameters:</span>
<a name="l00013"></a>00013 <span class="comment"> * </span>
<a name="l00014"></a>00014 <span class="comment"> * sql = holds sql string</span>
<a name="l00015"></a>00015 <span class="comment"> * nrows = number of rows to return </span>
<a name="l00016"></a>00016 <span class="comment"> * offset = skip offset rows of data</span>
<a name="l00017"></a>00017 <span class="comment"> * fetch = $ADODB_FETCH_MODE</span>
<a name="l00018"></a>00018 <span class="comment"> * </span>
<a name="l00019"></a>00019 <span class="comment"> * example:</span>
<a name="l00020"></a>00020 <span class="comment"> *</span>
<a name="l00021"></a>00021 <span class="comment"> * http://localhost/php/server.php?select+*+from+table&nrows=10&offset=2</span>
<a name="l00022"></a>00022 <span class="comment"> */</span>
<a name="l00023"></a>00023
<a name="l00024"></a>00024
<a name="l00025"></a>00025 <span class="comment">/* </span>
<a name="l00026"></a>00026 <span class="comment"> * Define the IP address you want to accept requests from </span>
<a name="l00027"></a>00027 <span class="comment"> * as a security measure. If blank we accept anyone promisciously!</span>
<a name="l00028"></a>00028 <span class="comment"> */</span>
<a name="l00029"></a>00029 $ACCEPTIP = '127.0.0.1';
<a name="l00030"></a>00030
<a name="l00031"></a>00031 <span class="comment">/*</span>
<a name="l00032"></a>00032 <span class="comment"> * Connection parameters</span>
<a name="l00033"></a>00033 <span class="comment"> */</span>
<a name="l00034"></a>00034 $driver = 'mysql';
<a name="l00035"></a>00035 $host = 'localhost'; <span class="comment">// DSN for odbc</span>
<a name="l00036"></a>00036 $uid = 'root';
<a name="l00037"></a>00037 $pwd = 'garbase-it-is';
<a name="l00038"></a>00038 $database = 'test';
<a name="l00039"></a>00039
<a name="l00040"></a>00040 <span class="comment">/*============================ DO NOT MODIFY BELOW HERE =================================*/</span>
<a name="l00041"></a>00041 <span class="comment">// $sep must match csv2rs() in adodb.inc.php</span>
<a name="l00042"></a>00042 $sep = ' :::: ';
<a name="l00043"></a>00043
<a name="l00044"></a>00044 include('./adodb.inc.php');
<a name="l00045"></a>00045 include_once(ADODB_DIR.'/adodb-csvlib.inc.php');
<a name="l00046"></a>00046
<a name="l00047"></a>00047 function err($s)
<a name="l00048"></a>00048 {
<a name="l00049"></a>00049 die('**** '.$s.<span class="charliteral">' '</span>);
<a name="l00050"></a>00050 }
<a name="l00051"></a>00051
<a name="l00052"></a>00052 <span class="comment">// undo stupid magic quotes</span>
<a name="l00053"></a>00053 function undomq(&$m)
<a name="l00054"></a>00054 {
<a name="l00055"></a>00055 <span class="keywordflow">if</span> (get_magic_quotes_gpc()) {
<a name="l00056"></a>00056 <span class="comment">// undo the damage</span>
<a name="l00057"></a>00057 $m = str_replace('\\\\<span class="charliteral">','</span>\\',$m);
<a name="l00058"></a>00058 $m = str_replace(<span class="charliteral">'\"'</span>,<span class="charliteral">'"'</span>,$m);
<a name="l00059"></a>00059 $m = str_replace('\\\'<span class="charliteral">','</span>\'',$m);
<a name="l00060"></a>00060
<a name="l00061"></a>00061 }
<a name="l00062"></a>00062 <span class="keywordflow">return</span> $m;
<a name="l00063"></a>00063 }
<a name="l00064"></a>00064
<a name="l00066"></a>00066
<a name="l00067"></a>00067
<a name="l00068"></a>00068 $remote = $_SERVER[<span class="stringliteral">"REMOTE_ADDR"</span>];
<a name="l00069"></a>00069
<a name="l00070"></a>00070
<a name="l00071"></a>00071 <span class="keywordflow">if</span> (!empty($ACCEPTIP))
<a name="l00072"></a>00072 <span class="keywordflow">if</span> ($remote != '127.0.0.1' && $remote != $ACCEPTIP)
<a name="l00073"></a>00073 err(<span class="stringliteral">"Unauthorised client: '$remote'"</span>);
<a name="l00074"></a>00074
<a name="l00075"></a>00075
<a name="l00076"></a>00076 <span class="keywordflow">if</span> (empty($_REQUEST['sql'])) err('No SQL');
<a name="l00077"></a>00077
<a name="l00078"></a>00078
<a name="l00079"></a>00079 $conn = &ADONewConnection($driver);
<a name="l00080"></a>00080
<a name="l00081"></a>00081 <span class="keywordflow">if</span> (!$conn->Connect($host,$uid,$pwd,$database)) err($conn->ErrorNo(). $sep . $conn->ErrorMsg());
<a name="l00082"></a>00082 $sql = undomq($_REQUEST['sql']);
<a name="l00083"></a>00083
<a name="l00084"></a>00084 <span class="keywordflow">if</span> (isset($_REQUEST['fetch']))
<a name="l00085"></a>00085 $ADODB_FETCH_MODE = $_REQUEST['fetch'];
<a name="l00086"></a>00086
<a name="l00087"></a>00087 <span class="keywordflow">if</span> (isset($_REQUEST['nrows'])) {
<a name="l00088"></a>00088 $nrows = $_REQUEST['nrows'];
<a name="l00089"></a>00089 $offset = isset($_REQUEST['offset']) ? $_REQUEST['offset'] : -1;
<a name="l00090"></a>00090 $rs = $conn->SelectLimit($sql,$nrows,$offset);
<a name="l00091"></a>00091 } <span class="keywordflow">else</span>
<a name="l00092"></a>00092 $rs = $conn->Execute($sql);
<a name="l00093"></a>00093 <span class="keywordflow">if</span> ($rs){
<a name="l00094"></a>00094 <span class="comment">//$rs->timeToLive = 1;</span>
<a name="l00095"></a>00095 echo _rs2serialize($rs,$conn,$sql);
<a name="l00096"></a>00096 $rs->Close();
<a name="l00097"></a>00097 } <span class="keywordflow">else</span>
<a name="l00098"></a>00098 err($conn->ErrorNo(). $sep .$conn->ErrorMsg());
<a name="l00099"></a>00099
<a name="l00100"></a>00100 ?>
</pre></div><?php
include_once '../doc-typo3-funcs.php';
get_footer();
?>