/lenasys/trunk : contents of codeigniter/system/database/drivers/mysql/mysql

: (revision 20.1.1)

To get this branch, use:

bzr branch
http://gegoxaren.bato24.eu/bzr/lenasys/trunk

<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');
/**
 * CodeIgniter
 *
 * An open source application development framework for PHP 5.1.6 or newer
 *
 * @package		CodeIgniter
 * @author		ExpressionEngine Dev Team
 * @copyright	Copyright (c) 2008 - 2011, EllisLab, Inc.
 * @license		http://codeigniter.com/user_guide/license.html
 * @link		http://codeigniter.com
 * @since		Version 1.0
 * @filesource
 */

// --------------------------------------------------------------------

/**
 * MySQL Result Class
 *
 * This class extends the parent result class: CI_DB_result
 *
 * @category	Database
 * @author		ExpressionEngine Dev Team
 * @link		http://codeigniter.com/user_guide/database/
 */
class CI_DB_mysql_result extends CI_DB_result {

	/**
	 * Number of rows in the result set
	 *
	 * @access	public
	 * @return	integer
	 */
	function num_rows()
	{
		return @mysql_num_rows($this->result_id);
	}

	// --------------------------------------------------------------------

	/**
	 * Number of fields in the result set
	 *
	 * @access	public
	 * @return	integer
	 */
	function num_fields()
	{
		return @mysql_num_fields($this->result_id);
	}

	// --------------------------------------------------------------------

	/**
	 * Fetch Field Names
	 *
	 * Generates an array of column names
	 *
	 * @access	public
	 * @return	array
	 */
	function list_fields()
	{
		$field_names = array();
		while ($field = mysql_fetch_field($this->result_id))
		{
			$field_names[] = $field->name;
		}

		return $field_names;
	}

	// --------------------------------------------------------------------

	/**
	 * Field data
	 *
	 * Generates an array of objects containing field meta-data
	 *
	 * @access	public
	 * @return	array
	 */
	function field_data()
	{
		$retval = array();
		while ($field = mysql_fetch_object($this->result_id))
		{
			preg_match('/([a-zA-Z]+)(\(\d+\))?/', $field->Type, $matches);

			$type = (array_key_exists(1, $matches)) ? $matches[1] : NULL;
			$length = (array_key_exists(2, $matches)) ? preg_replace('/[^\d]/', '', $matches[2]) : NULL;

			$F				= new stdClass();
			$F->name		= $field->Field;
			$F->type		= $type;
			$F->default		= $field->Default;
			$F->max_length	= $length;
			$F->primary_key = ( $field->Key == 'PRI' ? 1 : 0 );

			$retval[] = $F;
		}

		return $retval;
	}

	// --------------------------------------------------------------------

	/**
	 * Free the result
	 *
	 * @return	null
	 */
	function free_result()
	{
		if (is_resource($this->result_id))
		{
			mysql_free_result($this->result_id);
			$this->result_id = FALSE;
		}
	}

	// --------------------------------------------------------------------

	/**
	 * Data Seek
	 *
	 * Moves the internal pointer to the desired offset.  We call
	 * this internally before fetching results to make sure the
	 * result set starts at zero
	 *
	 * @access	private
	 * @return	array
	 */
	function _data_seek($n = 0)
	{
		return mysql_data_seek($this->result_id, $n);
	}

	// --------------------------------------------------------------------

	/**
	 * Result - associative array
	 *
	 * Returns the result set as an array
	 *
	 * @access	private
	 * @return	array
	 */
	function _fetch_assoc()
	{
		return mysql_fetch_assoc($this->result_id);
	}

	// --------------------------------------------------------------------

	/**
	 * Result - object
	 *
	 * Returns the result set as an object
	 *
	 * @access	private
	 * @return	object
	 */
	function _fetch_object()
	{
		return mysql_fetch_object($this->result_id);
	}

}


/* End of file mysql_result.php */
/* Location: ./system/database/drivers/mysql/mysql_result.php */

20.1.1 by galaxyAbstractor * Added an simple admin panel to the codeviewer-cmssy stuff	1	<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
	2	/**
	3	* CodeIgniter
	4	*
	5	* An open source application development framework for PHP 5.1.6 or newer
	6	*
	7	* @package CodeIgniter
	8	* @author ExpressionEngine Dev Team
	9	* @copyright Copyright (c) 2008 - 2011, EllisLab, Inc.
	10	* @license http://codeigniter.com/user_guide/license.html
	11	* @link http://codeigniter.com
	12	* @since Version 1.0
	13	* @filesource
	14	*/
	15
	16	// --------------------------------------------------------------------
	17
	18	/**
	19	* MySQL Result Class
	20	*
	21	* This class extends the parent result class: CI_DB_result
	22	*
	23	* @category Database
	24	* @author ExpressionEngine Dev Team
	25	* @link http://codeigniter.com/user_guide/database/
	26	*/
	27	class CI_DB_mysql_result extends CI_DB_result {
	28
	29	/**
	30	* Number of rows in the result set
	31	*
	32	* @access public
	33	* @return integer
	34	*/
	35	function num_rows()
	36	{
	37	return @mysql_num_rows($this->result_id);
	38	}
	39
	40	// --------------------------------------------------------------------
	41
	42	/**
	43	* Number of fields in the result set
	44	*
	45	* @access public
	46	* @return integer
	47	*/
	48	function num_fields()
	49	{
	50	return @mysql_num_fields($this->result_id);
	51	}
	52
	53	// --------------------------------------------------------------------
	54
	55	/**
	56	* Fetch Field Names
	57	*
	58	* Generates an array of column names
	59	*
	60	* @access public
	61	* @return array
	62	*/
	63	function list_fields()
	64	{
65	$field_names = array();
66	while ($field = mysql_fetch_field($this->result_id))
67	{
68	$field_names[] = $field->name;
69	}
70
71	return $field_names;
72	}
73
74	// --------------------------------------------------------------------
75
76	/**
77	* Field data
78	*
79	* Generates an array of objects containing field meta-data
80	*
81	* @access public
82	* @return array
83	*/
84	function field_data()
85	{
86	$retval = array();
87	while ($field = mysql_fetch_object($this->result_id))
88	{
89	preg_match('/([a-zA-Z]+)(\(\d+\))?/', $field->Type, $matches);
90
91	$type = (array_key_exists(1, $matches)) ? $matches[1] : NULL;
92	$length = (array_key_exists(2, $matches)) ? preg_replace('/[^\d]/', '', $matches[2]) : NULL;
93
94	$F = new stdClass();
95	$F->name = $field->Field;
96	$F->type = $type;
97	$F->default = $field->Default;
98	$F->max_length = $length;
99	$F->primary_key = ( $field->Key == 'PRI' ? 1 : 0 );
100
101	$retval[] = $F;
102	}
103
104	return $retval;
105	}
106
107	// --------------------------------------------------------------------
108
109	/**
110	* Free the result
111	*
112	* @return null
113	*/
114	function free_result()
115	{
116	if (is_resource($this->result_id))
117	{
118	mysql_free_result($this->result_id);
119	$this->result_id = FALSE;
120	}
121	}
122
123	// --------------------------------------------------------------------
124
125	/**
126	* Data Seek
127	*
128	* Moves the internal pointer to the desired offset. We call
129	* this internally before fetching results to make sure the
130	* result set starts at zero
131	*
132	* @access private
133	* @return array
134	*/
135	function _data_seek($n = 0)
136	{
137	return mysql_data_seek($this->result_id, $n);
138	}
139
140	// --------------------------------------------------------------------
141
142	/**
143	* Result - associative array
144	*
145	* Returns the result set as an array
146	*
147	* @access private
148	* @return array
149	*/
150	function _fetch_assoc()
151	{
152	return mysql_fetch_assoc($this->result_id);
153	}
154
155	// --------------------------------------------------------------------
156
157	/**
158	* Result - object
159	*
160	* Returns the result set as an object
161	*
162	* @access private
163	* @return object
164	*/
165	function _fetch_object()
166	{
167	return mysql_fetch_object($this->result_id);
168	}
169
170	}
171
172
173	/* End of file mysql_result.php */
174	/* Location: ./system/database/drivers/mysql/mysql_result.php */