[binarycloud-cvs-commit] cvs: r2 /binarycloud/user/conf datasources.php /binarycloud/user/mod/query_example QueryExample.php

[alex <bin...@li...>]

alex		Wed Aug 22 11:22:49 2001 EDT

  Modified files:              
    /r2/binarycloud/user/conf	datasources.php 
    /r2/binarycloud/user/mod/query_example	QueryExample.php 
  Log:
  Working QM & QueryExample module
  
Index: r2/binarycloud/user/conf/datasources.php
diff -u r2/binarycloud/user/conf/datasources.php:1.4 r2/binarycloud/user/conf/datasources.php:1.5
--- r2/binarycloud/user/conf/datasources.php:1.4	Mon Aug 20 13:00:14 2001
+++ r2/binarycloud/user/conf/datasources.php	Wed Aug 22 11:22:49 2001
@@ -1,10 +1,10 @@
 <?php
 // {{{ Header 
 /*
- * -File		$Id: datasources.php,v 1.4 2001/08/20 20:00:14 alex Exp $
- * -License		LGPL (http://www.gnu.org/copyleft/lesser.html)
+ * -File	$Id: datasources.php,v 1.5 2001/08/22 18:22:49 alex Exp $
+ * -License	LGPL (http://www.gnu.org/copyleft/lesser.html)
  * -Copyright	2001, The Turing Studio, Inc.
- * -Author		alex black, en...@tu... * 
+ * -Author	alex black, en...@tu...
  */
 // }}}
 // {{{ Datasources
@@ -12,44 +12,35 @@
 global $QueryManager;
 
 $QueryManager->datasources = array(
+// uncomment if you use oci
 	'query_example' => array(
 		'database_name' => 'test',
-		'Type' => "mysql",
-		'Host' => "localhost",  // replace
-		'User' => "root",       // with your
-		'Password' => "sql",    // setup
+		'Type' => "oci",
+		'User' => "r2",
+		'Password' => "testpasswd",
 		'IncludePath' => BC_PATH."/ext/metabase",
 		'Persistent' => true,
-	),
-	'oracle_dev' => array(
-		'database_name' => "binarycloud_db",
-		'Type' => "oci",
-		'User' => "your_user",
-		'Password' => "your_password",
-		'IncludePath' => BC_PATH_BASE."db/",
-		'Persistent' => TRUE,
 		'Options' => array(
-			'SID' => "sidv",
+			'SID' => "DBTRNG",
 			'HOME' => "/u01/oracle/product/8.1.6",
-			'DBAUser' => "system",
-			'DBAPassword' => "sys_passwd",
-			'mcryptkey' => "Kay string. Can be a file.",
-			'mcryptmode' => MCRYPT_MODE_CFB,
-			'mcryptcipher' => MCRYPT_TripleDES,
-			'mcryptiv' => "qwertyui"
+			'DBAUser' => "System",
+			'DBAPassword' => "Systhma",
         	),
 	),
-	'mysql_base' => array(
-	    'database_name' => 'binarycloud',
+// uncomment if you use mysql
+/*
+	'query_example' => array(
+		'database_name' => 'test',
 		'Type' => "mysql",
-		'Host' => "localhost",
-		'User' => "example_user",
-		'Password' => "example_password",
-		'IncludePath' => BC_PATH_BASE."db/",
-		'Persistent' => TRUE
+		'Host' => "localhost",  // replace
+		'User' => "root",       // with your
+		'Password' => "sql",    // setup
+		'IncludePath' => BC_PATH."/ext/metabase",
+		'Persistent' => true,
 	),
+*/
 );
 
 // }}}
 
-?>
\ No newline at end of file
+?>
Index: r2/binarycloud/user/mod/query_example/QueryExample.php
diff -u r2/binarycloud/user/mod/query_example/QueryExample.php:1.2 r2/binarycloud/user/mod/query_example/QueryExample.php:1.3
--- r2/binarycloud/user/mod/query_example/QueryExample.php:1.2	Tue Aug 21 19:02:43 2001
+++ r2/binarycloud/user/mod/query_example/QueryExample.php	Wed Aug 22 11:22:49 2001
@@ -1,7 +1,7 @@
 <?php
 // Header {{{
 /*
- * -File	$Id: QueryExample.php,v 1.2 2001/08/22 02:02:43 alex Exp $
+ * -File	$Id: QueryExample.php,v 1.3 2001/08/22 18:22:49 alex Exp $
  * -License	LGPL (http://www.gnu.org/copyleft/lesser.html)
  * -Copyright	2001, Entity
  * -Author	Andreas Aderhold, a.a...@th...
@@ -29,7 +29,7 @@
 
 		// doing a simple custom SELECT query
 		$query = array(
-			'QUERY' => 'SELECT newsid, news FROM news',
+			'QUERY' => 'SELECT NEWSID, NEWS FROM NEWS',
 			'ARGTYPES' => array('integer','text'),
 		);
 		$this->result = $QueryManager->DoCustomQuery($query, null, true);
@@ -46,21 +46,24 @@
 	 */
 
 	function Output() {
-  	    echo "<table>";
-		echo "<th>NewsId</th>";
-		echo "<th>News</th>";
-		for ($row = 0; $row < count($this->result); $row++) {
-		  printf("<tr valign=\"top\"><td>%s</td><td>%s</td></tr>", 
-				 $this->result[$row]['newsId'], 
-				 $this->result[$row]['news']
-				 );
-	    }
-	  echo "</table>";
+?>
+<table>
+<th>News ID</th>
+<th>News</th>
+<? for ($row = 0; $row < count($this->result); $row++) { ?>
+<tr valign="top">
+<td><? echo $this->result[$row]['NEWSID']; ?></td>
+<td><? echo $this->result[$row]['NEWS']; ?></td>
+</tr>
+<? } ?>
+</table>
+<?
 	}
 
 	// }}}
 	// {{{ Vars
 	var $params;
+	var $result;
 	// }}}
 }
 // }}}