PHP MysqliDB::mysqli_result_to_html_table Examples

Example #1

File: MysqliDB.php Project: neslonso/sf

	/**
	 * Recupera datos en diversos formatos
	 * @param  string $query Consulta SQL a ejecutar
	 * @param  string $tipo  Tipo de resultado deseado (mysqli_result | var | obj | arrVars | arrArrs | arrObjs | num_rows | html_table)
	 * @return mixed mysqli_result | string | object | array | integer
	 */
	private function get_data($query,$tipo="mysqli_result") {
		$qResult=$this->query($query);
		switch ($tipo) {
			case "mysqli_result":
				$result=$qResult;
			case "var":
				$row=$qResult->fetch_array();
				$result=$row[0];
				break;
			case "obj":
				$result=$qResult->fetch_object();
				break;
			case "arrVars":
				$result=array();
				while ($row=$qResult->fetch_array(MYSQLI_ASSOC)) {
					array_push($result,$row[0]);
				}
				break;
			case "arrArrs":
				//$result=$qResult->fetch_all(MYSQLI_BOTH);//<- Según el manual esta disponible a partir de PHP 5.3.0 pero probé en dl333 con PHP 5.3.3 y undefined method mysqli_result::fetch_all(), quiza porque Available only with mysqlnd (nd=native driver)
				$result=array();
				while ($row=$qResult->fetch_array(MYSQLI_ASSOC)) {
					array_push($result,$row);
				}
				break;
			case "arrObjs":
				$result=array();
				while ($row=$qResult->fetch_object()) {
					array_push($result,$row);
				}
				break;
			case "num_rows":
				$result=$qResult->num_rows;
				break;
			case "html_table":
				$result=MysqliDB::mysqli_result_to_html_table($qResult);
				break;
		}
		$qResult->free();
		return $result;
	}