[PHPVortex-Commit] phpvortex/doc/html/__filesource fsource_Vortex_DB_DB_MSSQL.class.php.html, NONE,
Brought to you by:
nop144666
Update of /cvsroot/phpvortex/phpvortex/doc/html/__filesource In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv28570/doc/html/__filesource Modified Files: fsource_Vortex_DB_DB_Base.class.php.html fsource_Vortex_DB_DB_MySQL.class.php.html fsource_Vortex_DB_FT_Base.class.php.html fsource_Vortex_DB_FT_Hidden.class.php.html fsource_Vortex_DB_FT_List.class.php.html fsource_Vortex_DB_FT_ListArray.class.php.html fsource_Vortex_DB_FT_PKey.class.php.html fsource_Vortex_DB_FT_Text.class.php.html fsource_Vortex_DB_RS_Base.class.php.html fsource_Vortex_DB_RS_MySQL.class.php.html fsource_Vortex_DB_TB_Base.class.php.html fsource_Vortex_Debug_d_footer.php.html fsource_Vortex_Debug_d_header.php.html fsource_Vortex_Debug_debug.php.html fsource_Vortex_Debug_testSEC_EditTest.class.php.html fsource_Vortex_Debug_testTB_Test.class.php.html fsource_Vortex_Debug_testtest_conf.php.html fsource_Vortex_Debug_testvortex_test.php.html fsource_Vortex_Debug_testvortex_test_app.php.html fsource_Vortex_Debug_testvortex_test_page.php.html fsource_Vortex_Page_SEC_Base.class.php.html fsource_Vortex_Page_SEC_Edit.class.php.html fsource_Vortex_Page_SEC_Form.class.php.html fsource_Vortex_Page_SEC_Header.class.php.html fsource_Vortex_Page_SEC_Include.class.php.html fsource_Vortex_Page_SEC_List.class.php.html fsource_Vortex_Page_SEC_ListNavigator.class.php.html fsource_Vortex_Page_SEC_Page.class.php.html fsource_Vortex_Page_SEC_Static.class.php.html fsource_Vortex_Util_APP_Base.class.php.html fsource_Vortex_Util_URL.class.php.html fsource_Vortex_Util_confconf.php.html fsource_Vortex_Util_conflang_en.php.html fsource_Vortex_Util_conflang_pt_br.php.html fsource_Vortex__testindex.php.html Added Files: fsource_Vortex_DB_DB_MSSQL.class.php.html fsource_Vortex_DB_DB_PostgreSQL.class.php.html fsource_Vortex_DB_FT_DateTime.class.php.html fsource_Vortex_DB_FT_File.class.php.html fsource_Vortex_DB_FT_Password.class.php.html fsource_Vortex_DB_RS_MSSQL.class.php.html fsource_Vortex_DB_RS_PostgreSQL.class.php.html fsource_Vortex_Debug_testindex.php.html Log Message: Updated documentation Index: fsource_Vortex_DB_FT_ListArray.class.php.html =================================================================== RCS file: /cvsroot/phpvortex/phpvortex/doc/html/__filesource/fsource_Vortex_DB_FT_ListArray.class.php.html,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** fsource_Vortex_DB_FT_ListArray.class.php.html 5 Nov 2004 16:19:07 -0000 1.1 --- fsource_Vortex_DB_FT_ListArray.class.php.html 11 Aug 2006 19:21:21 -0000 1.2 *************** *** 24,29 **** <li><a name="a11"></a> </li> <li><a name="a12"></a><span class="src-doc">/** Require the base class */</span></li> ! <li><a name="a12"></a> </li> ! <li><a name="a13"></a><span class="src-inc">require_once</span><span class="src-sym">(</span><span class="src-str">'FT_Base.class.php'</span><span class="src-sym">)</span><span class="src-sym">;</span></li> <li><a name="a14"></a> </li> <li><a name="a15"></a><span class="src-doc">/**</span></li> --- 24,28 ---- <li><a name="a11"></a> </li> <li><a name="a12"></a><span class="src-doc">/** Require the base class */</span></li> ! <li><a name="a13"></a><span class="src-sym">(</span><span class="src-str">'FT_Base.class.php'</span><span class="src-sym">)</span><span class="src-sym">;</span></li> <li><a name="a14"></a> </li> <li><a name="a15"></a><span class="src-doc">/**</span></li> *************** *** 56,60 **** <li><a name="a42"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$value </span><span class="src-doc">Value to load the control with.</span></li> <li><a name="a43"></a><span class="src-doc"> */</span></li> ! <li><a name="a44"></a> <span class="src-key">function </span><a href="../Vortex/DB/FT_ListArray.html#methodShowForm">ShowForm</a><span class="src-sym">(</span><span class="src-var">$value</span><span class="src-sym">)</span></li> <li><a name="a45"></a> <span class="src-sym">{</span></li> <li><a name="a46"></a> <span class="src-key">global </span><span class="src-var">$vortex_msgs</span><span class="src-sym">;</span></li> --- 55,59 ---- <li><a name="a42"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$value </span><span class="src-doc">Value to load the control with.</span></li> <li><a name="a43"></a><span class="src-doc"> */</span></li> ! <li><a name="a44"></a> <span class="src-key">function </span><a href="../Vortex/DB/FT_ListArray.html#methodShowForm">ShowForm</a><span class="src-sym">(</span><span class="src-var">$value</span><span class="src-sym">, </span><span class="src-var">$origin </span>= <span class="src-id">FT_OR_DB</span><span class="src-sym">)</span></li> <li><a name="a45"></a> <span class="src-sym">{</span></li> <li><a name="a46"></a> <span class="src-key">global </span><span class="src-var">$vortex_msgs</span><span class="src-sym">;</span></li> *************** *** 68,84 **** <li><a name="a54"></a></span><span class="src-str"> <span class="src-sym">}</span></span></li> <li><a name="a55"></a> </li> ! <li><a name="a56"></a></span><span class="src-str"> /**</span></li> ! <li><a name="a57"></a></span><span class="src-str"> * Output the field as plain text.</span></li> ! <li><a name="a58"></a></span><span class="src-str"> *</span></li> ! <li><a name="a59"></a></span><span class="src-str"> * @param string $value Value to load the control with.</span></li> ! <li><a name="a60"></a></span><span class="src-str"> */</span></li> ! <li><a name="a61"></a></span><span class="src-str"> <span class="src-key">function</span> <span class="src-id">ShowPlain</span><span class="src-sym">(</span><span class="src-var">$value</span><span class="src-sym">)</span></span></li> <li><a name="a62"></a></span><span class="src-str"> <span class="src-sym">{</span></span></li> <li><a name="a63"></a></span><span class="src-str"> echo <span class="src-var">$this</span></span><span class="src-sym">-></span><a href="../Vortex/DB/FT_ListArray.html#var$list_array">list_array</a><span class="src-sym">[</span><span class="src-var">$value</span><span class="src-sym">]</span><span class="src-sym">;</span></li> <li><a name="a64"></a> </span><span class="src-str"><span class="src-sym">}</span></span></li> <li><a name="a65"></a> </li> ! <li><a name="a66"></a></span><span class="src-str"> /**</span></li> ! <li><a name="a67"></a></span><span class="src-str"> * Output the field consistency testing in JavaScript.</span></li> ! <li><a name="a68"></a></span><span class="src-str"> */</span></li> <li><a name="a69"></a></span><span class="src-str"> <span class="src-key">function</span> <span class="src-id">JSConsist</span><span class="src-sym">(</span><span class="src-sym">)</span></span></li> <li><a name="a70"></a></span><span class="src-str"> <span class="src-sym">{</span></span></li> --- 67,83 ---- <li><a name="a54"></a></span><span class="src-str"> <span class="src-sym">}</span></span></li> <li><a name="a55"></a> </li> ! <li><a name="a56"></a></span><span class="src-str"> <span class="src-comm">/**</span></span></li> ! <li><a name="a57"></a></span><span class="src-str"><span class="src-comm"> * Output the field as plain text.</span></span></li> ! <li><a name="a58"></a></span><span class="src-str"><span class="src-comm"> *</span></span></li> ! <li><a name="a59"></a></span><span class="src-str"><span class="src-comm"> * @param string $value Value to load the control with.</span></span></li> ! <li><a name="a60"></a></span><span class="src-str"><span class="src-comm"> */</span></span></li> ! <li><a name="a61"></a></span><span class="src-str"> <span class="src-key">function</span> <span class="src-id">ShowPlain</span><span class="src-sym">(</span><span class="src-var">$value</span><span class="src-sym">,</span> <span class="src-var">$origin</span> = <span class="src-id">FT_OR_DB</span><span class="src-sym">)</span></span></li> <li><a name="a62"></a></span><span class="src-str"> <span class="src-sym">{</span></span></li> <li><a name="a63"></a></span><span class="src-str"> echo <span class="src-var">$this</span></span><span class="src-sym">-></span><a href="../Vortex/DB/FT_ListArray.html#var$list_array">list_array</a><span class="src-sym">[</span><span class="src-var">$value</span><span class="src-sym">]</span><span class="src-sym">;</span></li> <li><a name="a64"></a> </span><span class="src-str"><span class="src-sym">}</span></span></li> <li><a name="a65"></a> </li> ! <li><a name="a66"></a></span><span class="src-str"> <span class="src-comm">/**</span></span></li> ! <li><a name="a67"></a></span><span class="src-str"><span class="src-comm"> * Output the field consistency testing in JavaScript.</span></span></li> ! <li><a name="a68"></a></span><span class="src-str"><span class="src-comm"> */</span></span></li> <li><a name="a69"></a></span><span class="src-str"> <span class="src-key">function</span> <span class="src-id">JSConsist</span><span class="src-sym">(</span><span class="src-sym">)</span></span></li> <li><a name="a70"></a></span><span class="src-str"> <span class="src-sym">{</span></span></li> *************** *** 90,99 **** <li><a name="a76"></a></span><span class="src-str"> <span class="src-sym">}</span></span></li> <li><a name="a77"></a> </li> ! <li><a name="a78"></a></span><span class="src-str"> /**</span></li> ! <li><a name="a79"></a></span><span class="src-str"> * Test the field consistency.</span></li> ! <li><a name="a80"></a></span><span class="src-str"> *</span></li> ! <li><a name="a81"></a></span><span class="src-str"> * @param string $field The data from the field to be tested.</span></li> ! <li><a name="a82"></a></span><span class="src-str"> * @return bool Returns TRUE if the field is consistent, FALSE otherwise.</span></li> ! <li><a name="a83"></a></span><span class="src-str"> */</span></li> <li><a name="a84"></a></span><span class="src-str"> <span class="src-key">function</span> <span class="src-id">ConsistTest</span><span class="src-sym">(</span><span class="src-sym">&</span><span class="src-var">$field</span><span class="src-sym">)</span></span></li> <li><a name="a85"></a></span><span class="src-str"> <span class="src-sym">{</span></span></li> --- 89,98 ---- <li><a name="a76"></a></span><span class="src-str"> <span class="src-sym">}</span></span></li> <li><a name="a77"></a> </li> ! <li><a name="a78"></a></span><span class="src-str"> <span class="src-comm">/**</span></span></li> ! <li><a name="a79"></a></span><span class="src-str"><span class="src-comm"> * Test the field consistency.</span></span></li> ! <li><a name="a80"></a></span><span class="src-str"><span class="src-comm"> *</span></span></li> ! <li><a name="a81"></a></span><span class="src-str"><span class="src-comm"> * @param string $field The data from the field to be tested.</span></span></li> ! <li><a name="a82"></a></span><span class="src-str"><span class="src-comm"> * @return bool Returns TRUE if the field is consistent, FALSE otherwise.</span></span></li> ! <li><a name="a83"></a></span><span class="src-str"><span class="src-comm"> */</span></span></li> <li><a name="a84"></a></span><span class="src-str"> <span class="src-key">function</span> <span class="src-id">ConsistTest</span><span class="src-sym">(</span><span class="src-sym">&</span><span class="src-var">$field</span><span class="src-sym">)</span></span></li> <li><a name="a85"></a></span><span class="src-str"> <span class="src-sym">{</span></span></li> *************** *** 102,111 **** <li><a name="a88"></a> </span><span class="src-str"><span class="src-sym">}</span></span></li> <li><a name="a89"></a> </li> ! <li><a name="a90"></a></span><span class="src-str"> /**</span></li> ! <li><a name="a91"></a></span><span class="src-str"> * Format the field for database insertion.</span></li> ! <li><a name="a92"></a></span><span class="src-str"> *</span></li> ! <li><a name="a93"></a></span><span class="src-str"> * @param string $field The data from the field to be formated.</span></li> ! <li><a name="a94"></a></span><span class="src-str"> * @return string Returns the formated field.</span></li> ! <li><a name="a95"></a></span><span class="src-str"> */</span></li> <li><a name="a96"></a></span><span class="src-str"> <span class="src-key">function</span> <span class="src-id">ConsistFormat</span><span class="src-sym">(</span><span class="src-sym">&</span><span class="src-var">$field</span><span class="src-sym">)</span></span></li> <li><a name="a97"></a></span><span class="src-str"> <span class="src-sym">{</span></span></li> --- 101,110 ---- <li><a name="a88"></a> </span><span class="src-str"><span class="src-sym">}</span></span></li> <li><a name="a89"></a> </li> ! <li><a name="a90"></a></span><span class="src-str"> <span class="src-comm">/**</span></span></li> ! <li><a name="a91"></a></span><span class="src-str"><span class="src-comm"> * Format the field for database insertion.</span></span></li> ! <li><a name="a92"></a></span><span class="src-str"><span class="src-comm"> *</span></span></li> ! <li><a name="a93"></a></span><span class="src-str"><span class="src-comm"> * @param string $field The data from the field to be formated.</span></span></li> ! <li><a name="a94"></a></span><span class="src-str"><span class="src-comm"> * @return string Returns the formated field.</span></span></li> ! <li><a name="a95"></a></span><span class="src-str"><span class="src-comm"> */</span></span></li> <li><a name="a96"></a></span><span class="src-str"> <span class="src-key">function</span> <span class="src-id">ConsistFormat</span><span class="src-sym">(</span><span class="src-sym">&</span><span class="src-var">$field</span><span class="src-sym">)</span></span></li> <li><a name="a97"></a></span><span class="src-str"> <span class="src-sym">{</span></span></li> *************** *** 117,121 **** </div> <p class="notes" id="credit"> ! Documentation generated on Fri, 5 Nov 2004 14:12:07 -0300 by <a href="http://www.phpdoc.org" target="_blank">phpDocumentor 1.3.0RC3</a> </p> </body> --- 116,120 ---- </div> <p class="notes" id="credit"> ! Documentation generated on Fri, 11 Aug 2006 16:21:54 -0300 by <a href="http://www.phpdoc.org" target="_blank">phpDocumentor 1.3.0RC5</a> </p> </body> --- NEW FILE: fsource_Vortex_DB_RS_MSSQL.class.php.html --- <?xml version="1.0" encoding="iso-8859-1"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <!-- template designed by Marco Von Ballmoos --> <title>File Source for RS_MSSQL.class.php</title> <link rel="stylesheet" href="../media/stylesheet.css" /> <meta http-equiv='Content-Type' content='text/html; charset=iso-8859-1'/> </head> <body> <h1>Source for file RS_MSSQL.class.php</h1> <p>Documentation is available at <a href="../Vortex/DB/_RS_MSSQL_class_php.html">RS_MSSQL.class.php</a></p> <div class="src-code"> <pre><ol><li><a name="a1"></a><span class="src-php"><?php</span></li> <li><a name="a2"></a><span class="src-doc">/**</span></li> <li><a name="a3"></a><span class="src-doc"> * File for class RS_MSSQL.</span></li> <li><a name="a4"></a><span class="src-doc"> *</span></li> <li><a name="a5"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@package</span><span class="src-doc"> Vortex</span></li> <li><a name="a6"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@subpackage</span><span class="src-doc"> DB</span></li> <li><a name="a7"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@author</span><span class="src-doc"> Thiago Ramon Gonçalves Montoya</span></li> <li><a name="a8"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@copyright</span><span class="src-doc"> Copyright 2004, Thiago Ramon Gonçalves Montoya</span></li> <li><a name="a9"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@license</span><span class="src-doc"> http://opensource.org/licenses/lgpl-license.php GNU Lesser General Public License</span></li> <li><a name="a10"></a><span class="src-doc"> */</span></li> <li><a name="a11"></a> </li> <li><a name="a12"></a><span class="src-doc">/** Require the base class */</span></li> <li><a name="a13"></a><span class="src-sym">(</span><span class="src-str">'RS_Base.class.php'</span><span class="src-sym">)</span><span class="src-sym">;</span></li> <li><a name="a14"></a> </li> <li><a name="a15"></a><span class="src-doc">/**</span></li> <li><a name="a16"></a><span class="src-doc"> * Class for MS SQL Server RecordSets.</span></li> <li><a name="a17"></a><span class="src-doc"> *</span></li> <li><a name="a18"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@package</span><span class="src-doc"> Vortex</span></li> <li><a name="a19"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@subpackage</span><span class="src-doc"> DB</span></li> <li><a name="a20"></a><span class="src-doc"> */</span></li> <li><a name="a21"></a><span class="src-key">class </span><a href="../Vortex/DB/RS_MSSQL.html">RS_MSSQL</a> <span class="src-key">extends </span><a href="../Vortex/DB/RS_Base.html#methodRS_Base">RS_Base</a></li> <li><a name="a22"></a><span class="src-sym">{</span></li> <li><a name="a23"></a> <span class="src-doc">/**</span></li> <li><a name="a24"></a><span class="src-doc"> * Get the count of rows in the RecordSet.</span></li> <li><a name="a25"></a><span class="src-doc"> *</span></li> <li><a name="a26"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">int </span><span class="src-doc">Returns the number of rows in the RecordSet.</span></li> <li><a name="a27"></a><span class="src-doc"> */</span></li> <li><a name="a28"></a> <span class="src-key">function </span><a href="../Vortex/DB/RS_MSSQL.html#methodRowCount">RowCount</a><span class="src-sym">(</span><span class="src-sym">)</span></li> <li><a name="a29"></a> <span class="src-sym">{</span></li> <li><a name="a30"></a> <span class="src-key">return </span><a href="http://www.php.net/mssql_num_rows">mssql_num_rows</a><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/RS_Base.html#var$result">result</a><span class="src-sym">)</span><span class="src-sym">;</span></li> <li><a name="a31"></a> <span class="src-sym">}</span></li> <li><a name="a32"></a> </li> <li><a name="a33"></a> <span class="src-doc">/**</span></li> <li><a name="a34"></a><span class="src-doc"> * Get a row from the RecordSet.</span></li> <li><a name="a35"></a><span class="src-doc"> *</span></li> <li><a name="a36"></a><span class="src-doc"> * Case $row is set, return that row, case else, return the next row.</span></li> <li><a name="a37"></a><span class="src-doc"> *</span></li> <li><a name="a38"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">int </span><span class="src-doc-var">$row </span><span class="src-doc">Row to return, defaults to next.</span></li> <li><a name="a39"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">int </span><span class="src-doc-var">$type </span><span class="src-doc">Type of array to return (RS_ROW_NUM | RS_ROW_ASSOC | RS_ROW_BOTH).</span></li> <li><a name="a40"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">array </span><span class="src-doc">Returns the row from the RecordSet, or FALSE if EOF.</span></li> <li><a name="a41"></a><span class="src-doc"> */</span></li> <li><a name="a42"></a> <span class="src-key">function </span><a href="../Vortex/DB/RS_MSSQL.html#methodRow">Row</a><span class="src-sym">(</span><span class="src-var">$row </span>= -<span class="src-num">1</span><span class="src-sym">, </span><span class="src-var">$type </span>= <span class="src-id">RS_ROW_ASSOC</span><span class="src-sym">)</span></li> <li><a name="a43"></a> <span class="src-sym">{</span></li> <li><a name="a44"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$row </span>!= -<span class="src-num">1</span><span class="src-sym">) </span><span class="src-sym">{</span></li> <li><a name="a45"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-sym">!</span><a href="http://www.php.net/mssql_data_seek">mssql_data_seek</a><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/RS_Base.html#var$result">result</a><span class="src-sym">, </span><span class="src-var">$row</span><span class="src-sym">)) </span><span class="src-key">return </span><span class="src-id">FALSE</span><span class="src-sym">;</span></li> <li><a name="a46"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/RS_Base.html#var$row">row</a> = <span class="src-var">$row</span><span class="src-sym">;</span></li> <li><a name="a47"></a> <span class="src-sym">}</span></li> <li><a name="a48"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/RS_Base.html#var$row">row</a>++<span class="src-sym">;</span></li> <li><a name="a49"></a> <span class="src-key">switch </span><span class="src-sym">(</span><span class="src-var">$type</span><span class="src-sym">) </span><span class="src-sym">{</span></li> <li><a name="a50"></a> <span class="src-key">case </span><span class="src-id"><a href="../Vortex/DB/_RS_Base_class_php.html#defineRS_ROW_NUM">RS_ROW_NUM</a></span>:</li> <li><a name="a51"></a> <span class="src-key">return </span><a href="http://www.php.net/mssql_fetch_row">mssql_fetch_row</a><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/RS_Base.html#var$result">result</a><span class="src-sym">)</span><span class="src-sym">;</span></li> <li><a name="a52"></a> <span class="src-key">break</span><span class="src-sym">;</span></li> <li><a name="a53"></a> <span class="src-key">case </span><span class="src-id"><a href="../Vortex/DB/_RS_Base_class_php.html#defineRS_ROW_ASSOC">RS_ROW_ASSOC</a></span>:</li> <li><a name="a54"></a> <span class="src-key">return </span><a href="http://www.php.net/mssql_fetch_assoc">mssql_fetch_assoc</a><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/RS_Base.html#var$result">result</a><span class="src-sym">)</span><span class="src-sym">;</span></li> <li><a name="a55"></a> <span class="src-key">break</span><span class="src-sym">;</span></li> <li><a name="a56"></a> <span class="src-key">case </span><span class="src-id"><a href="../Vortex/DB/_RS_Base_class_php.html#defineRS_ROW_BOTH">RS_ROW_BOTH</a></span>:</li> <li><a name="a57"></a> <span class="src-key">return </span><a href="http://www.php.net/mssql_fetch_array">mssql_fetch_array</a><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/RS_Base.html#var$result">result</a><span class="src-sym">)</span><span class="src-sym">;</span></li> <li><a name="a58"></a> <span class="src-key">break</span><span class="src-sym">;</span></li> <li><a name="a59"></a> <span class="src-sym">}</span></li> <li><a name="a60"></a> <span class="src-key">return </span><span class="src-id">FALSE</span><span class="src-sym">;</span></li> <li><a name="a61"></a> <span class="src-sym">}</span></li> <li><a name="a62"></a> </li> <li><a name="a63"></a> <span class="src-doc">/**</span></li> <li><a name="a64"></a><span class="src-doc"> * Go to a row int the RecordSet.</span></li> <li><a name="a65"></a><span class="src-doc"> *</span></li> <li><a name="a66"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">int </span><span class="src-doc-var">$row </span><span class="src-doc">Row to go to.</span></li> <li><a name="a67"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">bool </span><span class="src-doc">Returns TRUE on success, FALSE if failed.</span></li> <li><a name="a68"></a><span class="src-doc"> */</span></li> <li><a name="a69"></a> <span class="src-key">function </span><a href="../Vortex/DB/RS_MSSQL.html#methodSetRow">SetRow</a><span class="src-sym">(</span><span class="src-var">$row </span>= <span class="src-num">0</span><span class="src-sym">)</span></li> <li><a name="a70"></a> <span class="src-sym">{</span></li> <li><a name="a71"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-sym">!</span><a href="http://www.php.net/mssql_num_rows">mssql_num_rows</a><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/RS_Base.html#var$result">result</a><span class="src-sym">)) </span><span class="src-key">return </span><span class="src-id">FALSE</span><span class="src-sym">;</span></li> <li><a name="a72"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-sym">!</span><a href="http://www.php.net/mssql_data_seek">mssql_data_seek</a><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/RS_Base.html#var$result">result</a><span class="src-sym">, </span><span class="src-var">$row</span><span class="src-sym">)) </span><span class="src-key">return </span><span class="src-id">FALSE</span><span class="src-sym">;</span></li> <li><a name="a73"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/RS_Base.html#var$row">row</a> = <span class="src-var">$row</span><span class="src-sym">;</span></li> <li><a name="a74"></a> <span class="src-key">return </span><span class="src-id">TRUE</span><span class="src-sym">;</span></li> <li><a name="a75"></a> <span class="src-sym">}</span></li> <li><a name="a76"></a> </li> <li><a name="a77"></a> <span class="src-doc">/**</span></li> <li><a name="a78"></a><span class="src-doc"> * Get all rows from the RecordSet.</span></li> <li><a name="a79"></a><span class="src-doc"> *</span></li> <li><a name="a80"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">int </span><span class="src-doc-var">$type </span><span class="src-doc">Type of array to return (RS_ROW_NUM | RS_ROW_ASSOC | RS_ROW_BOTH).</span></li> <li><a name="a81"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">array </span><span class="src-doc">Returns all the rows from the RecordSet.</span></li> <li><a name="a82"></a><span class="src-doc"> */</span></li> <li><a name="a83"></a> <span class="src-key">function </span><a href="../Vortex/DB/RS_MSSQL.html#methodAll">All</a><span class="src-sym">(</span><span class="src-var">$type </span>= <span class="src-id">RS_ROW_ASSOC</span><span class="src-sym">)</span></li> <li><a name="a84"></a> <span class="src-sym">{</span></li> <li><a name="a85"></a> <span class="src-var">$rows </span>= <span class="src-key">array</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li> <li><a name="a86"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/RS_MSSQL.html#methodSetRow">SetRow</a><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li> <li><a name="a87"></a> <span class="src-key">while </span><span class="src-sym">(</span><span class="src-var">$row </span>= <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/RS_MSSQL.html#methodRow">Row</a><span class="src-sym">(</span>-<span class="src-num">1</span><span class="src-sym">, </span><span class="src-var">$type</span><span class="src-sym">)) </span><span class="src-var">$rows</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-var">$row</span><span class="src-sym">;</span></li> <li><a name="a88"></a> <span class="src-key">return </span><span class="src-var">$rows</span><span class="src-sym">;</span></li> <li><a name="a89"></a> <span class="src-sym">}</span></li> <li><a name="a90"></a> </li> <li><a name="a91"></a> <span class="src-doc">/**</span></li> <li><a name="a92"></a><span class="src-doc"> * Get the last auto-generated ID from the RecordSet.</span></li> <li><a name="a93"></a><span class="src-doc"> *</span></li> <li><a name="a94"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">int </span><span class="src-doc">Returns the last auto-generated ID from the RecordSet.</span></li> <li><a name="a95"></a><span class="src-doc"> */</span></li> <li><a name="a96"></a> <span class="src-key">function </span><a href="../Vortex/DB/RS_MSSQL.html#methodLastId">LastId</a><span class="src-sym">(</span><span class="src-sym">)</span></li> <li><a name="a97"></a> <span class="src-sym">{</span></li> <li><a name="a98"></a> <span class="src-var">$tmp </span>= <a href="http://www.php.net/mssql_query">mssql_query</a><span class="src-sym">(</span><span class="src-str">"SELECT @@IDENTITY"</span><span class="src-sym">, </span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/RS_Base.html#var$db">db</a><span class="src-sym">-></span><span class="src-id">link</span><span class="src-sym">)</span><span class="src-sym">;</span></li> <li><a name="a99"></a> <span class="src-var">$id </span>= <a href="http://www.php.net/mssql_result">mssql_result</a><span class="src-sym">(</span><span class="src-var">$tmp</span><span class="src-sym">, </span><span class="src-num">0</span><span class="src-sym">, </span><span class="src-num">0</span><span class="src-sym">)</span><span class="src-sym">;</span></li> <li><a name="a100"></a> <a href="http://www.php.net/mssql_free_result">mssql_free_result</a><span class="src-sym">(</span><span class="src-var">$tmp</span><span class="src-sym">)</span><span class="src-sym">;</span></li> <li><a name="a101"></a> <span class="src-key">return </span><span class="src-var">$id</span><span class="src-sym">;</span></li> <li><a name="a102"></a> <span class="src-sym">}</span></li> <li><a name="a103"></a> </li> <li><a name="a104"></a> <span class="src-doc">/**</span></li> <li><a name="a105"></a><span class="src-doc"> * Close the RecordSet and free the memory.</span></li> <li><a name="a106"></a><span class="src-doc"> *</span></li> <li><a name="a107"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">bool </span><span class="src-doc">Returns TRUE if the RecordSet was closed, FALSE if it failed.</span></li> <li><a name="a108"></a><span class="src-doc"> */</span></li> <li><a name="a109"></a> <span class="src-key">function </span><a href="../Vortex/DB/RS_MSSQL.html#methodClose">Close</a><span class="src-sym">(</span><span class="src-sym">)</span></li> <li><a name="a110"></a> <span class="src-sym">{</span></li> <li><a name="a111"></a> <span class="src-key">return </span><a href="http://www.php.net/mssql_free_result">mssql_free_result</a><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/RS_Base.html#var$result">result</a><span class="src-sym">)</span><span class="src-sym">;</span></li> <li><a name="a112"></a> <span class="src-sym">}</span></li> <li><a name="a113"></a><span class="src-sym">}</span></li> <li><a name="a114"></a> </li> <li><a name="a115"></a><span class="src-php">?></span></li> </ol></pre> </div> <p class="notes" id="credit"> Documentation generated on Fri, 11 Aug 2006 16:21:58 -0300 by <a href="http://www.phpdoc.org" target="_blank">phpDocumentor 1.3.0RC5</a> </p> </body> </html> --- NEW FILE: fsource_Vortex_DB_DB_MSSQL.class.php.html --- <?xml version="1.0" encoding="iso-8859-1"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <!-- template designed by Marco Von Ballmoos --> <title>File Source for DB_MSSQL.class.php</title> <link rel="stylesheet" href="../media/stylesheet.css" /> <meta http-equiv='Content-Type' content='text/html; charset=iso-8859-1'/> </head> <body> <h1>Source for file DB_MSSQL.class.php</h1> <p>Documentation is available at <a href="../Vortex/DB/_DB_MSSQL_class_php.html">DB_MSSQL.class.php</a></p> <div class="src-code"> <pre><ol><li><a name="a1"></a><span class="src-php"><?php</span></li> <li><a name="a2"></a><span class="src-doc">/**</span></li> <li><a name="a3"></a><span class="src-doc"> * File for class DB_MSSQL.</span></li> <li><a name="a4"></a><span class="src-doc"> *</span></li> <li><a name="a5"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@package</span><span class="src-doc"> Vortex</span></li> <li><a name="a6"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@subpackage</span><span class="src-doc"> DB</span></li> <li><a name="a7"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@author</span><span class="src-doc"> Thiago Ramon Gonçalves Montoya</span></li> <li><a name="a8"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@copyright</span><span class="src-doc"> Copyright 2004, Thiago Ramon Gonçalves Montoya</span></li> <li><a name="a9"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@license</span><span class="src-doc"> http://opensource.org/licenses/lgpl-license.php GNU Lesser General Public License</span></li> <li><a name="a10"></a><span class="src-doc"> */</span></li> <li><a name="a11"></a> </li> <li><a name="a12"></a><span class="src-doc">/** Require the base class */</span></li> <li><a name="a13"></a><span class="src-sym">(</span><span class="src-str">'DB_Base.class.php'</span><span class="src-sym">)</span><span class="src-sym">;</span></li> <li><a name="a14"></a> </li> <li><a name="a15"></a><span class="src-doc">/** Require the RecordSet class header. */</span></li> <li><a name="a16"></a><span class="src-sym">(</span><span class="src-str">'RS_MSSQL.class.php'</span><span class="src-sym">)</span><span class="src-sym">;</span></li> <li><a name="a17"></a> </li> <li><a name="a18"></a><span class="src-doc">/**</span></li> <li><a name="a19"></a><span class="src-doc"> * Class for MS SQL Server database connection.</span></li> <li><a name="a20"></a><span class="src-doc"> *</span></li> <li><a name="a21"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@package</span><span class="src-doc"> Vortex</span></li> <li><a name="a22"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@subpackage</span><span class="src-doc"> DB</span></li> <li><a name="a23"></a><span class="src-doc"> */</span></li> <li><a name="a24"></a><span class="src-key">class </span><a href="../Vortex/DB/DB_MSSQL.html">DB_MSSQL</a> <span class="src-key">extends </span><a href="../Vortex/DB/DB_Base.html#methodDB_Base">DB_Base</a></li> <li><a name="a25"></a><span class="src-sym">{</span></li> <li><a name="a26"></a> <span class="src-doc">/**</span></li> <li><a name="a27"></a><span class="src-doc"> * Open a new connection to the database if not already connected.</span></li> <li><a name="a28"></a><span class="src-doc"> *</span></li> <li><a name="a29"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">bool </span><span class="src-doc-var">$persist </span><span class="src-doc">Open a persistent connection?</span></li> <li><a name="a30"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">bool </span><span class="src-doc">Returns TRUE if the connection was successfully established, FALSE if an error occurred.</span></li> <li><a name="a31"></a><span class="src-doc"> */</span></li> <li><a name="a32"></a> <span class="src-key">function </span><a href="../Vortex/DB/DB_MSSQL.html#methodConnect">Connect</a><span class="src-sym">(</span><span class="src-var">$persist</span>=<span class="src-id">FALSE</span><span class="src-sym">)</span></li> <li><a name="a33"></a> <span class="src-sym">{</span></li> <li><a name="a34"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-sym">!</span><a href="http://www.php.net/is_null">is_null</a><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/DB_Base.html#var$link">link</a><span class="src-sym">)) </span><span class="src-key">return </span><span class="src-id">FALSE</span><span class="src-sym">;</span></li> <li><a name="a35"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$persist</span><span class="src-sym">) </span><span class="src-sym">{</span></li> <li><a name="a36"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/DB_Base.html#var$link">link</a> = <a href="http://www.php.net/mssql_pconnect">mssql_pconnect</a><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/DB_Base.html#var$server">server</a><span class="src-sym">, </span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/DB_Base.html#var$user">user</a><span class="src-sym">, </span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/DB_Base.html#var$pw">pw</a><span class="src-sym">)</span><span class="src-sym">;</span></li> <li><a name="a37"></a> <span class="src-sym">} </span><span class="src-key">else </span><span class="src-sym">{</span></li> <li><a name="a38"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/DB_Base.html#var$link">link</a> = <a href="http://www.php.net/mssql_connect">mssql_connect</a><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/DB_Base.html#var$server">server</a><span class="src-sym">, </span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/DB_Base.html#var$user">user</a><span class="src-sym">, </span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/DB_Base.html#var$pw">pw</a><span class="src-sym">)</span><span class="src-sym">;</span></li> <li><a name="a39"></a> <span class="src-sym">}</span></li> <li><a name="a40"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/DB_Base.html#var$link">link</a> !== <span class="src-id">FALSE</span><span class="src-sym">) </span><span class="src-sym">{</span></li> <li><a name="a41"></a> <span class="src-key">if </span><span class="src-sym">(</span><a href="http://www.php.net/mssql_select_db">mssql_select_db</a><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/DB_Base.html#var$db">db</a><span class="src-sym">, </span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/DB_Base.html#var$link">link</a><span class="src-sym">)) </span><span class="src-sym">{</span></li> <li><a name="a42"></a> <span class="src-key">return </span><span class="src-id">TRUE</span><span class="src-sym">;</span></li> <li><a name="a43"></a> <span class="src-sym">}</span></li> <li><a name="a44"></a> <a href="http://www.php.net/mssql_close">mssql_close</a><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/DB_Base.html#var$link">link</a><span class="src-sym">)</span><span class="src-sym">;</span></li> <li><a name="a45"></a> <span class="src-sym">}</span></li> <li><a name="a46"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/DB_Base.html#var$link">link</a> = <span class="src-id">NULL</span><span class="src-sym">;</span></li> <li><a name="a47"></a> <span class="src-key">return </span><span class="src-id">FALSE</span><span class="src-sym">;</span></li> <li><a name="a48"></a> <span class="src-sym">}</span></li> <li><a name="a49"></a> </li> <li><a name="a50"></a> <span class="src-doc">/**</span></li> <li><a name="a51"></a><span class="src-doc"> * Execute a query at the database.</span></li> <li><a name="a52"></a><span class="src-doc"> *</span></li> <li><a name="a53"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$sql </span><span class="src-doc">Query to run.</span></li> <li><a name="a54"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">RS_Base </span><span class="src-doc">Returns a RecordSet object if there is a result to the query or TRUE if it was successfull, FALSE if a error occurred.</span></li> <li><a name="a55"></a><span class="src-doc"> */</span></li> <li><a name="a56"></a> <span class="src-key">function </span><span class="src-sym">&</span><a href="../Vortex/DB/DB_MSSQL.html#methodQuery">Query</a><span class="src-sym">(</span><span class="src-var">$sql</span><span class="src-sym">)</span></li> <li><a name="a57"></a> <span class="src-sym">{</span></li> <li><a name="a58"></a> <span class="src-var">$rs </span>= <a href="http://www.php.net/mssql_query">mssql_query</a><span class="src-sym">(</span><span class="src-var">$sql</span><span class="src-sym">,</span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/DB_Base.html#var$link">link</a><span class="src-sym">)</span><span class="src-sym">;</span></li> <li><a name="a59"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$rs </span>=== <span class="src-id">FALSE</span><span class="src-sym">) </span><span class="src-sym">{</span></li> <li><a name="a60"></a> <span class="src-key">return </span><span class="src-id">FALSE</span><span class="src-sym">;</span></li> <li><a name="a61"></a> <span class="src-sym">}</span></li> <li><a name="a62"></a> <span class="src-key">return </span><span class="src-key">new </span><span class="src-id"><a href="../Vortex/DB/RS_MSSQL.html">RS_MSSQL</a></span><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">, </span><span class="src-var">$rs</span><span class="src-sym">)</span><span class="src-sym">;</span></li> <li><a name="a63"></a> <span class="src-sym">}</span></li> <li><a name="a64"></a> </li> <li><a name="a65"></a> <span class="src-doc">/**</span></li> <li><a name="a66"></a><span class="src-doc"> * Close the connection to the database if still connected.</span></li> <li><a name="a67"></a><span class="src-doc"> *</span></li> <li><a name="a68"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">bool </span><span class="src-doc">Returns TRUE if the connection was closed, FALSE if it failed.</span></li> <li><a name="a69"></a><span class="src-doc"> */</span></li> <li><a name="a70"></a> <span class="src-key">function </span><a href="../Vortex/DB/DB_MSSQL.html#methodClose">Close</a><span class="src-sym">(</span><span class="src-sym">)</span></li> <li><a name="a71"></a> <span class="src-sym">{</span></li> <li><a name="a72"></a> <span class="src-key">if </span><span class="src-sym">(</span><a href="http://www.php.net/mssql_close">mssql_close</a><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/DB_Base.html#var$link">link</a><span class="src-sym">)) </span><span class="src-sym">{</span></li> <li><a name="a73"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/DB_Base.html#var$link">link</a> = <span class="src-id">NULL</span><span class="src-sym">;</span></li> <li><a name="a74"></a> <span class="src-key">return </span><span class="src-id">TRUE</span><span class="src-sym">;</span></li> <li><a name="a75"></a> <span class="src-sym">}</span></li> <li><a name="a76"></a> <span class="src-key">return </span><span class="src-id">FALSE</span><span class="src-sym">;</span></li> <li><a name="a77"></a> <span class="src-sym">}</span></li> <li><a name="a78"></a> </li> <li><a name="a79"></a> <span class="src-doc">/**</span></li> <li><a name="a80"></a><span class="src-doc"> * Transactions: Begin a new transaction.</span></li> <li><a name="a81"></a><span class="src-doc"> *</span></li> <li><a name="a82"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">bool </span><span class="src-doc">Returns TRUE if the new transaction began, FALSE if it failed.</span></li> <li><a name="a83"></a><span class="src-doc"> */</span></li> <li><a name="a84"></a> <span class="src-key">function </span><a href="../Vortex/DB/DB_MSSQL.html#methodBegin">Begin</a><span class="src-sym">(</span><span class="src-sym">)</span></li> <li><a name="a85"></a> <span class="src-sym">{</span></li> <li><a name="a86"></a> <span class="src-key">return </span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/DB_MSSQL.html#methodQuery">Query</a><span class="src-sym">(</span><span class="src-str">'BEGIN TRANSACTION'</span><span class="src-sym">)</span><span class="src-sym">;</span></li> <li><a name="a87"></a> <span class="src-sym">}</span></li> <li><a name="a88"></a> </li> <li><a name="a89"></a> <span class="src-doc">/**</span></li> <li><a name="a90"></a><span class="src-doc"> * Transactions: Commit a transaction.</span></li> <li><a name="a91"></a><span class="src-doc"> *</span></li> <li><a name="a92"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">bool </span><span class="src-doc">Returns TRUE if the transaction was commited, FALSE if it failed.</span></li> <li><a name="a93"></a><span class="src-doc"> */</span></li> <li><a name="a94"></a> <span class="src-key">function </span><a href="../Vortex/DB/DB_MSSQL.html#methodCommit">Commit</a><span class="src-sym">(</span><span class="src-sym">)</span></li> <li><a name="a95"></a> <span class="src-sym">{</span></li> <li><a name="a96"></a> <span class="src-key">return </span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/DB_MSSQL.html#methodQuery">Query</a><span class="src-sym">(</span><span class="src-str">'COMMIT TRANSACTION'</span><span class="src-sym">)</span><span class="src-sym">;</span></li> <li><a name="a97"></a> <span class="src-sym">}</span></li> <li><a name="a98"></a> </li> <li><a name="a99"></a> <span class="src-doc">/**</span></li> <li><a name="a100"></a><span class="src-doc"> * Transactions: Rollback a transaction.</span></li> <li><a name="a101"></a><span class="src-doc"> *</span></li> <li><a name="a102"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">bool </span><span class="src-doc">Returns TRUE if the transaction was cancelled, FALSE if it failed.</span></li> <li><a name="a103"></a><span class="src-doc"> */</span></li> <li><a name="a104"></a> <span class="src-key">function </span><a href="../Vortex/DB/DB_MSSQL.html#methodRollback">Rollback</a><span class="src-sym">(</span><span class="src-sym">)</span></li> <li><a name="a105"></a> <span class="src-sym">{</span></li> <li><a name="a106"></a> <span class="src-key">return </span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/DB_MSSQL.html#methodQuery">Query</a><span class="src-sym">(</span><span class="src-str">'ROLLBACK TRANSACTION'</span><span class="src-sym">)</span><span class="src-sym">;</span></li> <li><a name="a107"></a> <span class="src-sym">}</span></li> <li><a name="a108"></a> </li> <li><a name="a109"></a> <span class="src-doc">/**</span></li> <li><a name="a110"></a><span class="src-doc"> * Process a string for safe use in a database insertion.</span></li> <li><a name="a111"></a><span class="src-doc"> *</span></li> <li><a name="a112"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$data </span><span class="src-doc">The string to be processed.</span></li> <li><a name="a113"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">string </span><span class="src-doc">Returns the processed string.</span></li> <li><a name="a114"></a><span class="src-doc"> */</span></li> <li><a name="a115"></a> <span class="src-key">function </span><a href="../Vortex/DB/DB_MSSQL.html#methodAddSlashes">AddSlashes</a><span class="src-sym">(</span><span class="src-var">$data</span><span class="src-sym">)</span></li> <li><a name="a116"></a> <span class="src-sym">{</span></li> <li><a name="a117"></a> <span class="src-key">return </span><a href="http://www.php.net/addslashes">addslashes</a><span class="src-sym">(</span><span class="src-var">$data</span><span class="src-sym">)</span><span class="src-sym">;</span></li> <li><a name="a118"></a> <span class="src-sym">}</span></li> <li><a name="a119"></a><span class="src-sym">}</span></li> <li><a name="a120"></a><span class="src-php">?></span></li> </ol></pre> </div> <p class="notes" id="credit"> Documentation generated on Fri, 11 Aug 2006 16:21:48 -0300 by <a href="http://www.phpdoc.org" target="_blank">phpDocumentor 1.3.0RC5</a> </p> </body> </html> Index: fsource_Vortex_DB_TB_Base.class.php.html =================================================================== RCS file: /cvsroot/phpvortex/phpvortex/doc/html/__filesource/fsource_Vortex_DB_TB_Base.class.php.html,v retrieving revision 1.7 retrieving revision 1.8 diff -C2 -d -r1.7 -r1.8 *** fsource_Vortex_DB_TB_Base.class.php.html 5 Nov 2004 16:13:41 -0000 1.7 --- fsource_Vortex_DB_TB_Base.class.php.html 11 Aug 2006 19:21:21 -0000 1.8 *************** *** 24,29 **** <li><a name="a11"></a> </li> <li><a name="a12"></a><span class="src-doc">/** Require the global configuration file for access to the localized messages */</span></li> ! <li><a name="a12"></a> </li> ! <li><a name="a13"></a><span class="src-inc">require_once</span><span class="src-sym">(</span><span class="src-str">'conf/conf.php'</span><span class="src-sym">)</span><span class="src-sym">;</span></li> <li><a name="a14"></a> </li> <li><a name="a15"></a><span class="src-doc">/**</span></li> --- 24,28 ---- <li><a name="a11"></a> </li> <li><a name="a12"></a><span class="src-doc">/** Require the global configuration file for access to the localized messages */</span></li> ! <li><a name="a13"></a><span class="src-sym">(</span><span class="src-str">'conf/conf.php'</span><span class="src-sym">)</span><span class="src-sym">;</span></li> <li><a name="a14"></a> </li> <li><a name="a15"></a><span class="src-doc">/**</span></li> *************** *** 106,416 **** <li><a name="a92"></a> </li> <li><a name="a93"></a> <span class="src-doc">/**</span></li> ! <li><a name="a94"></a><span class="src-doc"> * Constructor: Init the object, and define the table's fields and relationships.</span></li> ! <li><a name="a95"></a><span class="src-doc"> *</span></li> ! <li><a name="a96"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">DB_Base </span><span class="src-doc-var">$db </span><span class="src-doc">Database where the table is.</span></li> ! <li><a name="a97"></a><span class="src-doc"> */</span></li> ! <li><a name="a98"></a> <span class="src-key">function </span><a href="../Vortex/DB/TB_Base.html#methodTB_Base">TB_Base</a><span class="src-sym">(</span><span class="src-sym">&</span><span class="src-var">$db</span><span class="src-sym">)</span></li> ! <li><a name="a99"></a> <span class="src-sym">{</span></li> ! <li><a name="a100"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/TB_Base.html#var$db">db</a> =<span class="src-sym">& </span><span class="src-var">$db</span><span class="src-sym">;</span></li> ! <li><a name="a101"></a> <a href="http://www.php.net/is_null">is_null</a><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/TB_Base.html#var$name_db">name_db</a><span class="src-sym">) </span><span class="src-key">and </span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/TB_Base.html#var$name_db">name_db</a> = <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/TB_Base.html#var$name">name</a><span class="src-sym">;</span></li> ! <li><a name="a102"></a> <a href="http://www.php.net/is_null">is_null</a><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/TB_Base.html#var$label">label</a><span class="src-sym">) </span><span class="src-key">and </span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/TB_Base.html#var$label">label</a> = <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/TB_Base.html#var$name">name</a><span class="src-sym">;</span></li> ! <li><a name="a103"></a> <span class="src-sym">}</span></li> ! <li><a name="a104"></a> </li> ! <li><a name="a105"></a> <span class="src-doc">/**</span></li> ! <li><a name="a106"></a><span class="src-doc"> * Get the last error message.</span></li> ! <li><a name="a107"></a><span class="src-doc"> *</span></li> ! <li><a name="a108"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">string </span><span class="src-doc">Returns the last error message, or FALSE if no error.</span></li> ! <li><a name="a109"></a><span class="src-doc"> */</span></li> ! <li><a name="a110"></a> <span class="src-key">function </span><a href="../Vortex/DB/TB_Base.html#methodError">Error</a><span class="src-sym">(</span><span class="src-sym">)</span></li> ! <li><a name="a111"></a> <span class="src-sym">{</span></li> ! <li><a name="a112"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/TB_Base.html#var$error">error</a> == <span class="src-id"><a href="../Vortex/Util/_conf_conf_php.html#defineTB_ERR_OK">TB_ERR_OK</a></span><span class="src-sym">) </span><span class="src-key">return </span><span class="src-id">FALSE</span><span class="src-sym">;</span></li> ! <li><a name="a113"></a> <span class="src-key">return </span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/TB_Base.html#var$error">error</a><span class="src-sym">;</span></li> ! <li><a name="a114"></a> <span class="src-sym">}</span></li> ! <li><a name="a115"></a> </li> ! <li><a name="a116"></a> <span class="src-doc">/**</span></li> ! <li><a name="a117"></a><span class="src-doc"> * Set the internal buffer to a record to show/edit, or a blank one.</span></li> ! <li><a name="a118"></a><span class="src-doc"> *</span></li> ! <li><a name="a119"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">array </span><span class="src-doc-var">$data </span><span class="src-doc">Array containing the data to seek as 'field' => 'value'.</span></li> ! <li><a name="a120"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">bool </span><span class="src-doc-var">$pkonly </span><span class="src-doc">Use only the pkey's in the search?</span></li> ! <li><a name="a121"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">bool </span><span class="src-doc">Returns TRUE on success, FALSE on error.</span></li> ! <li><a name="a122"></a><span class="src-doc"> */</span></li> ! <li><a name="a123"></a> <span class="src-key">function </span><a href="../Vortex/DB/TB_Base.html#methodSeek">Seek</a><span class="src-sym">(</span><span class="src-var">$data </span>= <span class="src-id">NULL</span><span class="src-sym">, </span><span class="src-var">$pkonly </span>= <span class="src-id">TRUE</span><span class="src-sym">)</span></li> ! <li><a name="a124"></a> <span class="src-sym">{</span></li> ! <li><a name="a125"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-key">empty</span><span class="src-sym">(</span><span class="src-var">$data</span><span class="src-sym">)) </span><span class="src-sym">{</span></li> ! <li><a name="a126"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/TB_Base.html#var$data">data</a> = <span class="src-key">array</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li> ! <li><a name="a127"></a> <span class="src-key">return </span><span class="src-id">TRUE</span><span class="src-sym">;</span></li> ! <li><a name="a128"></a> <span class="src-sym">}</span></li> ! <li><a name="a129"></a> <span class="src-var">$where </span>= <span class="src-str">''</span><span class="src-sym">;</span></li> ! <li><a name="a130"></a> <span class="src-key">foreach </span><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Vortex/DB/TB_Base.html#var$fields">fields</a> <span class="src-key">as </span><span class="src-var">$field</span><span class="src-sym">) </span><span class="src-key">if </span><span class="src-sym">(</span><span class="src-sym">!</span><span class="src-var">$pkonly </span>|| <span class="src-var">$field</span><span class="src-sym">-></span><span class="src-id">pkey</span><span class="src-sym">) </span><span class="src-sym">{</span></li> ! <li><a name="a131"></a> <span class="src-key">if </span><span class="src-sym">(</span>isset<span class="src-sym">(</span><span class="src-var">$data</span><span class="src-sym">[</span><span class="src-var">$field</span><span class="src-sym">-></span><span class="src-id">name_form</span><span class="src-sym">]</span><span class="src-sym">)) </span><span class="src-var">$where </span>.= <span class="src-sym">(</span><a href="http://www.php.net/strlen">strlen</a><span class="src-sym">(</span><span class="src-var">$where</span><span class="src-sym">)</span>?<span class="src-str">' AND '</span>:<span class="src-str">''</span><span class="src-sym">)</span>.<span class="src-var">$field</span><span class="src-sym">-></span><span class="src-id">Where</span><span class="src-sym">(</span><span class="src-va... [truncated message content] |