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

: (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
 */

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

/**
 * MS SQL 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_mssql_result extends CI_DB_result {

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

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

	/**
	 * Number of fields in the result set
	 *
	 * @access	public
	 * @return	integer
	 */
	function num_fields()
	{
		return @mssql_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 = mssql_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 = mssql_fetch_field($this->result_id))
		{
			$F				= new stdClass();
			$F->name		= $field->name;
			$F->type		= $field->type;
			$F->max_length	= $field->max_length;
			$F->primary_key = 0;
			$F->default		= '';

			$retval[] = $F;
		}

		return $retval;
	}

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

	/**
	 * Free the result
	 *
	 * @return	null
	 */
	function free_result()
	{
		if (is_resource($this->result_id))
		{
			mssql_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 mssql_data_seek($this->result_id, $n);
	}

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

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

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

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

}


/* End of file mssql_result.php */
/* Location: ./system/database/drivers/mssql/mssql_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	* MS SQL 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_mssql_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 @mssql_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 @mssql_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 = mssql_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 = mssql_fetch_field($this->result_id))
88	{
89	$F = new stdClass();
90	$F->name = $field->name;
91	$F->type = $field->type;
92	$F->max_length = $field->max_length;
93	$F->primary_key = 0;
94	$F->default = '';
95
96	$retval[] = $F;
97	}
98
99	return $retval;
100	}
101
102	// --------------------------------------------------------------------
103
104	/**
105	* Free the result
106	*
107	* @return null
108	*/
109	function free_result()
110	{
111	if (is_resource($this->result_id))
112	{
113	mssql_free_result($this->result_id);
114	$this->result_id = FALSE;
115	}
116	}
117
118	// --------------------------------------------------------------------
119
120	/**
121	* Data Seek
122	*
123	* Moves the internal pointer to the desired offset. We call
124	* this internally before fetching results to make sure the
125	* result set starts at zero
126	*
127	* @access private
128	* @return array
129	*/
130	function _data_seek($n = 0)
131	{
132	return mssql_data_seek($this->result_id, $n);
133	}
134
135	// --------------------------------------------------------------------
136
137	/**
138	* Result - associative array
139	*
140	* Returns the result set as an array
141	*
142	* @access private
143	* @return array
144	*/
145	function _fetch_assoc()
146	{
147	return mssql_fetch_assoc($this->result_id);
148	}
149
150	// --------------------------------------------------------------------
151
152	/**
153	* Result - object
154	*
155	* Returns the result set as an object
156	*
157	* @access private
158	* @return object
159	*/
160	function _fetch_object()
161	{
162	return mssql_fetch_object($this->result_id);
163	}
164
165	}
166
167
168	/* End of file mssql_result.php */
169	/* Location: ./system/database/drivers/mssql/mssql_result.php */