mysqlrecordset.php

实现flash的饼图投票

<?php
// original section of writeRecordSet method JC
// this makes it easy for developers edit results with touching the more important parts of the PHP Gateway JC
// maybe use different methods to format recordset different ways depending on something??? JC
class mysqlRecordSet
{
	var $initialData = array();
	var $columnNames = array();

	function mysqlRecordSet($d)
	{
		// grab all of the rows
		while ($line = mysql_fetch_row($d)) {
			// decode each value ready for encoding when it goes through serialization
			foreach($line as $key => $value) {
				//$line[$key] = utf8_decode($value);
				$line[$key] = $value;
			}
			// add each row to the initial data array
			$this->initialData[] = $line;
		}	
		// grab the number of fields
		$fieldcount = mysql_num_fields($d);
		// loop over all of the fields
		for($i=0; $i<$fieldcount; $i++)	{
			// decode each field name ready for encoding when it goes through serialization
			// and save each field name into the array
			//$this->columnNames[$i] = utf8_decode(mysql_field_name($d, $i));
			$this->columnNames[$i] = mysql_field_name($d, $i);
		}
		$this->numRows = mysql_num_rows($d);
	}
}
?>