[binarycloud-cvs-commit] cvs: r2 /binarycloud/user/mod/query_example QueryExample.php schema.sql schema.xml

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

alex		Mon Aug 20 14:08:52 2001 EDT

  Added files:                 
    /r2/binarycloud/user/mod/query_example	QueryExample.php schema.sql 
                                          	schema.xml 
  Log:
  Andreas' Query Mod.
  
  

Index: r2/binarycloud/user/mod/query_example/QueryExample.php
+++ r2/binarycloud/user/mod/query_example/QueryExample.php
<?php
// Header {{{
/*
 * -File		$Id: QueryExample.php,v 1.1 2001/08/20 21:08:52 alex Exp $
 * -License		LGPL (http://www.gnu.org/copyleft/lesser.html)
 * -Copyright	2001, Entity
 * -Author		Andreas Aderhold, a.a...@th...
 */

// {{{ class QueryExample
/**
 * This is the QueryExample class
 * 
 */

class QueryExample {

	// {{{ method QueryExample($_params)
	/**
	 * This method
	 * 
	 * @access	public
	 */

	function QueryExample($_params) {
		$this->params = $_params;

		global $QueryManager;

		// doing a simple custom SELECT query
		$query = array(
			'QUERY' => 'SELECT newsId, news FROM news',
			'ARGTYPES' => array('integer','text'),
		);
		$this->result = $QueryManager->DoCustomQuery($query, null, true);
		return true;
	}

	// }}}
	// {{{ method Output()
	/**
	 * This method is responsible for output.
	 * Uhhrg, thats only a quick hack to demonstrate QueryManager.
	 * 
	 * @access	public
	 */

	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>";
	}

	// }}}
	// {{{ Vars
	var $params;
	// }}}
}
// }}}
?>

Index: r2/binarycloud/user/mod/query_example/schema.sql
+++ r2/binarycloud/user/mod/query_example/schema.sql
-- You have to insert these in database test
--
-- Table structure for table `news`
--
CREATE TABLE news (
  newsId int(11) default NULL,
  news text
) TYPE=MyISAM;

--
-- Dumping data for table `news`
--
INSERT INTO news (newsId, news) VALUES ( '1', 'Hey, Congratualtions. Querymanager is working. You are reading a database record from the query_example. See user.mod.query_example for details.');  

Index: r2/binarycloud/user/mod/query_example/schema.xml
+++ r2/binarycloud/user/mod/query_example/schema.xml
<?xml version="1.0" encoding="ISO-8859-1"?>
<database>
  <name>test</name>
  <create>0</create>
  <table>
    <name>news</name>
    <declaration>
      <field>
        <name>newsId</name>
        <type>integer</type>
      </field>
     <field>
        <name>news</name>
        <type>text</type>
      </field>
    </declaration>
    <initialization>
      <insert>
        <field>
          <name>newsId</name>
          <value>1</value>
        </field>
        <field>
          <name>news</name>
          <value>Hey, Congratualtions. Querymanager is working. You are reading a database record from the query_example. See user.mod.query_example for details..</value>
        </field>
      </insert>
    </initialization>
  </table>
</database>