Outputting Results from mysql_fetch

@Phill_PaffordAug 01.2008 — #I use something like this.

Input for this would be like:

[code=php]
 $columns = "fname, lname";
 
 // OR
 
 $columns = "t1.fname AS fname, t2.lname AS lname";
 [/code]

This function builds the table header if you need it

[code=php]
 /************************************************
 * Function Name: 	buildTableHeader
 * parameters:		$columns
 * returns:		$tableHeader
 * **********************************************
 * This function is used to build the table
 * header information
 * **********************************************
 * Updated By: 
 * Date: 
 * Changes: 
 * **********************************************
 * Notes: $column = the fields needed in the
 * query, SELECT * does not work with this.
 * Must be in CSV format like: 
 * SELECT fname, lname FROM etc...
 * Can also use this
 * SELECT t1.fname AS fname, t2.lname AS lname 
 * FROM etc...
 ************************************************/
 
 function buildTableHeader($columns)
 {
 $colString = $columns;
 $colDelimiter   = '.';
 $pos = strpos($colString, $colDelimiter);
 
   if ($pos === false)
   {
   $columnField = explode(",", $columns);
 
   for($ii = 0; $ii < count($columnField); $ii++)
   {
   // String to upper case
   $tmp = strtoupper($columnField[$ii]);
 
   $tableHeader .= "<th>$tmp</th>";
   }
   }
   else
   {
   $splitColumn = explode(",", $columns);
 
   for($i = 0; $i < count($splitColumn); $i++)
   {
   $columnField = explode(".", $splitColumn[$i]);
 
   for($ii = 0; $ii < count($columnField); $ii++)
   {
   $colString2 = $columnField[$ii];
   $colDelimiter2   = 'AS';
   $pos2 = strpos($colString2, $colDelimiter2);
 
   if ( $pos2 == true )
   {
   $splitAsColumn = explode(" ", $columnField[$ii]);
 
   for($iii = 0; $iii < count($splitAsColumn); $iii++)
   {
   if ( $iii == 2 )
   {
   $tmp = strtoupper($splitAsColumn[$iii]);
   $tableHeader .= "<th>$tmp</th>";
   }
   }
   }
   else
   {
   if (  $ii == 1 )
   {
   // String to upper case
   $tmp = strtoupper($columnField[$ii]);
 
   $tableHeader .= "<th>$tmp</th>";
   }
   }
   }
   }
   }
   return $tableHeader;
 }
 [/code]

parameters for this function are:

[code=php]
 $rs; // Query results
 $tableHeader; // from function above
 $elseMsg = "NO Records Found"; // Display something if no records are returned
 [/code]

This function uses the table header as a parm

[code=php]
 /************************************************
 * Function Name: 	buildOutputFromQuery
 * Author:		Phill Pafford
 * parameters:		$rs, $tableHeader, $elseMsg
 * returns:		$bOutput
 * **********************************************
 * Functionality
 * **********************************************
 * This function is used to build the table
 * information
 * **********************************************
 * Updates
 * **********************************************
 * Updated By: 
 * Date: 
 * Changes: 
 * **********************************************
 * Notes
 * **********************************************
 *
 ************************************************/
 
 function buildOutputFromQuery($rs, $tableHeader, $elseMsg) {
 global $anyRecords;
 
   // Build the table to house the query results
   $bOutput  = '<table cellspacing="0" cellpadding="0" width="80%">';
   $bOutput .= '<tr>';
 
   // Add the table header info
   $bOutput .= $tableHeader;
   $bOutput .= '</tr>';
 
   if(count($rs) >= 1)
   {
   $anyRecords = count($rs);
 
   foreach ($rs as $row)
   {
   $bOutput .= '<tr>';
 
   foreach($row as $column)
   {
   $bOutput .= '<td>' . $column . '</td>';
   }
 
   $bOutput .= '</tr>';
   }
   }
   else
   {
   $bOutput .= '<span class="titleRed">' . $elseMsg . '</span><br/>';
   $anyRecords = 0;
   }
 
   $bOutput .= '</table>';
 
   // Return the query results in HTML format
   return $bOutput;
 }
 [/code]

to see the results

[code=php]
 echo $bOutput;
 [/code]

any tips to improve this are welcome.

@sc908authorAug 01.2008 — #Wow soo many codes for what seems a simple thing :eek:

theres like no simple/easy way to spilt the output of the fetch array into like different parts this way i can do something like echo part1 and echo part2

@LuboxAug 01.2008 — #I think you need a counter inside the loop where you echo the results using table cells. Each time it reaches 3, you echo a </tr> and reset the counter.

@Phill_PaffordAug 04.2008 — #code is write once use many times, aka a function :-)

Outputting Results from mysql_fetch_array

4 Comments(s) _↴

Also in #PHP _↴

Success!

Social

Version

Outputting Results from mysql_fetch_array

4 Comments(s) ↴

Also in #PHP ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

4 Comments(s) _↴

Also in #PHP _↴