[PHP] 수집된 데이터 중 최신 데이터를 확인하기 위한 웹 소스 코드

 

	function MakeDataTable($DataArray, $fieldNames){
		$ColumnNumber = sizeof($DataArray);
		$RowNumber = sizeof($DataArray[0]);
		
		//echo "[ColumnNumber]".$ColumnNumber."<br>";
		//echo "[RowNumber]".$RowNumber."<br>";

		echo "<table>";
		echo "<tr>";
		foreach($fieldNames as $fieldName){
			echo "<th>".$fieldName."</th>";
		}
		echo "</tr>";

		foreach($DataArray as $Data1){
			echo "<tr>";
			foreach($fieldNames as $fieldName){
				echo "<td>".$Data1[$fieldName]."</td>";
			}
			echo "</tr>";
		}
		echo "</table>";
	}

필드명(Fieldname, Column name)을 가져오기 위한 소스 코드

	public function GetFieldNames($conn){
		
		$fieldNames = array();
		$query1 = "DESC ".$this->TABLENAME;
		$res1 = mysqli_query($conn, $query1);
		while($res11 = mysqli_fetch_array($res1)){
			$fieldNames[] = $res11[0];
		}
		
		return $fieldNames;
	}